Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-primary-secondary-replication.html
Traditional MySQL Replication provides a simple source to replica approach to replication. Figure 20.1 MySQL Asynchronous Replication There is also semisynchronous replication, which adds one synchronization step to the protocol. This means that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Hole punching size is the NTFS compression unit, which is 16 times the NTFS cluster size. Before downgrading to an earlier version of MySQL that does not support page compression, uncompress the tables that use the page compression feature. InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-build-configuration.html
\ -DDISABLE_PSI_STAGE=1 \ -DDISABLE_PSI_STATEMENT=1 For more information, see the descriptions of the DISABLE_PSI_XXX CMake options in Section 2.8.7, “MySQL Source-Configuration Options”. If you install MySQL over a previous installation that ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. Suppose that clients named user1 and user2 each connect one time from hosta and hostb. They differ in that, for grant tables, the host ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-cluster-tables.html
Table 29.3 Performance Schema NDB Tables Table Name Description ndb_sync_excluded_objects NDB objects which cannot be synchronized ndb_sync_pending_objects NDB objects waiting for synchronization Automatic synchronization in NDB attempts to detect ... The following table shows all Performance Schema tables relating to the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
For example, if a mutex is instrumented in the server source but the server cannot allocate memory for the instrumentation at runtime, it increments Performance_schema_mutex_classes_lost. Other mutexes have an instance per connection, or per page in ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/8.4/en/platform-support.html
MySQL platform support evolves over time; please refer to https://www.mysql.com/support/supportedplatforms/database.html for the latest updates.
https://dev.mysql.com/doc/refman/8.4/en/precision-math.html
For example, MySQL treats a number such as .0001 as an exact value rather than as an approximation, and summing it 10,000 times produces a result of exactly 1, not a value that is merely “close” to 1. MySQL provides support for precision math: ...Precision math is based on these two features: SQL modes that control how strict the server is about accepting or rejecting invalid ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-key-rotation.html
When binary log encryption is enabled, you can rotate the binary log master key at any time while the server is running by issuing ALTER INSTANCE ROTATE BINLOG MASTER KEY. When you rotate the binary log master key manually, MySQL Server takes the ...You can rotate the binary log master key on a regular basis to comply with your organization's security policy, and also if you suspect that the current or any of the previous binary log master keys might have been ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
Many users have lost time by not doing this soon enough after encountering problems. If the source has a firewall or IP filtering configuration, ensure that the network port being used for MySQL is not being filtered. If you decide that the replica ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...