Search Results
https://dev.mysql.com/doc/refman/8.4/en/downgrading.html
Notes Make sure you understand the MySQL release model for MySQL long-term support (LTS) and Innovation releases before proceeding with a downgrade. A replication topology is downgraded by following the rolling downgrade scheme described at Section ...Monthly Rapid Updates (MRUs) and hot fixes also count as releases in this ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-instances.html
The first step is to deploy at least three instances of MySQL Server, this procedure demonstrates using multiple hosts for the instances, named s1, s2, and s3. It is assumed that MySQL Server is installed on each host (see Chapter 2, Installing ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
For answers to frequently asked questions about the change buffer, see Section A.16, “MySQL 8.4 FAQ: InnoDB Change Buffer”. Consider increasing innodb_change_buffer_max_size on a MySQL server with heavy insert, update, and delete activity, where ...Figure 17.3 Change Buffer Unlike clustered indexes, secondary indexes are usually nonunique, and inserts into secondary indexes happen in a relatively random ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
InnoDB Crash Recovery To recover from an unexpected MySQL server exit, the only requirement is to restart the MySQL server. In most situations, even if the MySQL server was killed unexpectedly in the middle of heavy activity, the recovery process ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
Please note the following: If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the table might be updated by the server during the packing process. If the mysqld server was invoked with ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-oci-marketplace-connecting.html
This section describes the various connection methods for connecting to the deployed MySQL server on the OCI Compute Instance. To find the temporary root password created for the root user, run the following command: sudo grep 'temporary password' ...For more information on MySQL Shell connections, see MySQL Shell ...Connecting with SSH This section gives ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-managed-table.html
The asynchronous connection failover mechanism fails over the connection if another available server on the source list has a higher priority (weight) setting. For a managed group, a source’s weight is assigned depending on whether it is a primary ... This table holds configuration information used by the replica's asynchronous connection failover mechanism to handle managed groups, including Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
It is also recommended that you restart both the source and replica MySQL servers, to ensure that the new value takes complete (global) effect on each of them. When a replication source server shuts down and restarts, its MEMORY tables become empty. This generated event is identifiable by a comment in the binary log, and if GTIDs are in use on the server, it has a GTID ...To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
If you upgrade servers in a replication topology that use a version earlier than MySQL 5.7, upgrade the replicas first and then upgrade the source. If an upgraded replication source server still has old replicas using MySQL versions that do not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source.html
This is because the server IDs of replicas must be unique in a replication topology. Multi-source replication in MySQL 8.4 enables a replica to receive transactions from multiple immediate sources in parallel. You might choose to implement ...In a ...