PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
This section describes how channels can be used in a replication topology, and the impact they have on single-source replication. This is because the server IDs of replicas must be unique in a replication topology. When you do this on a multi-source ... In MySQL multi-source replication, a replica opens multiple replication channels, one for each replication source ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-shutdowns.html
This can cause the replica not to be able to replicate when the source comes back up. Setting sync_binlog=1 in the source's my.cnf file helps to minimize this problem because it causes the source to flush its binary log more frequently. With this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-triggers.html
It is sufficient to switch to statement-based replication only for those statements where you want this effect, and to use row-based replication the rest of the time. To avoid this problem, upgrade the replicas first, then upgrade the source. The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto.html
This section describes how to set up a MySQL server to use binary log file position based replication. You need this information when configuring the replica so that the replica knows where in the binary log to start executing events. If you do not ...There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
This section discusses what semisynchronous replication is and how it works. Failover from source to replica in this case might result in failover to a server that is missing transactions relative to the source. If your goal is to implement a ... In ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html
One way to improve the performance of the replication process is to create a deeper replication structure that enables the source to replicate to only one replica, and for the remaining replicas to connect to this primary replica for their ... As ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation.html
Check the notes and hints at the end of this section for Solaris specific notes that you may need before or after installation. (By default mounting is done without this option.) Failing to do so causes a significant drop in performance when using ... Note MySQL 5.7 supports Solaris 11 (Update 3 and ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine instead. This provides a consistent and secure environment, and routines can ensure that each operation is properly logged. A ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
System variables: version_tokens_session Command-Line Format --version-tokens-session=value System Variable version_tokens_session Scope Global, Session Dynamic Yes Type String Default Value NULL The session value of this variable specifies the ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
You should also read the OS-specific section in this manual for problems that may be unique to your environment. This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables ... If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe ...