Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging format. If you want to be sure that your replication filters always operate in the same way ... If you ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
Important Some factors outside the control of replication can have an impact on the replication recovery process and the overall state of replication after the recovery process. Setting sync_relay_log=1 is particularly important for a multi-threaded ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
The following sections describe aspects of resource group use in MySQL: Resource Group Elements Resource Group Attributes Resource Group Management Resource Group Replication Resource Group Restrictions Important On some platforms or MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
Important In MySQL 8.4, caching_sha2_password is the default authentication plugin rather than mysql_native_password (deprecated). Important To connect to the server using an account that authenticates with the sha256_password plugin, you must use ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
Important START REPLICA sends an acknowledgment to the user after all the replication threads have started. Important The password that you set using START REPLICA is masked when it is written to MySQL Server’s logs, Performance Schema tables, and ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
CSV tables let you import or dump data in CSV format, to exchange data with scripts and applications that read and write that same format. Because CSV tables are not indexed, you typically keep the data in InnoDB tables during normal operation, and ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
NDB Table Storage Requirements Important NDB tables use 4-byte alignment; all NDB data storage is done in multiples of 4 bytes. For details about internal representation of temporal values, see MySQL Internals: Important Algorithms and Structures.
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
It is important that threads that do not report back to the thread pool do not prevent other statements from executing and thus cause the thread pool to become deadlocked. The thread pool consists of a number of thread groups, each of which manages ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your dump files. There are two steps to upgrading each individual mysqld: Import the data dictionary. This section ...