Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
If there are no bugs in your replication setup and client programs, and no bugs in MySQL itself, an error that stops replication should never occur. This section explains the server options and system variables that apply to replica servers and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. If you cannot tell from ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication topology. Replication filters can be global or specific to a channel, enabling you to configure ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
For new source/replica replication setups where there are currently no tables on the source, avoid specifying the engine type when creating new tables. It does not matter for the replication process whether the original table on the source and the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
Figure 19.1 Using Replication to Improve Performance During Scale-Out If the part of your code that is responsible for database access has been properly abstracted/modularized, converting it to run with a replicated setup should be very smooth and ... You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
The innodb_flush_log_at_trx_commit=1 setting mentioned in the list below is a key setting for a replication setup that uses InnoDB with transactions. In order for replication to be resilient to unexpected halts of the server (sometimes described as ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions.html
For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 19.4.1, “Using Replication for Backups”. Replication can be used in many different environments for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-upgrade.html
For example, you cannot use MySQL X.Y.1, MySQL X.Y.2, and MySQL X.Y.3 concurrently in such a setup, although you could use any two of these releases together. When you upgrade servers that participate in a replication topology, you need to take ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect security. These include ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
In replication setups, it can be useful to enable read_only on replica servers to ensure that replicas accept updates only from the source server and not from clients. The MySQL server maintains many system variables that affect its operation. Most ...