PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
SQL_Remaining_Delay: When Slave_SQL_Running_State is Waiting until MASTER_DELAY seconds after master executed event, this field contains an integer indicating the number of seconds left of the delay. MySQL 5.7 supports delayed replication such that ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or replication. (Bug #11754117, Bug #45670) This ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, subject to the following exceptions: When using statement-based replication prior to MySQL 5.7.1, AUTO_INCREMENT columns in tables on the replica must match the same columns on the source; that is, AUTO_INCREMENT columns must be replicated to AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html
In particular, if the time_zone system variable is set to the value SYSTEM, indicating that the server time zone is the same as the system time zone, this can cause the source and replica to apply different time zones. By default, source and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-monitoring.html
This enables you to write complex queries based on Channel_Name as a key. By default, if the FOR CHANNEL channel clause is not used, this statement shows the replica status for all channels with one row per channel. 16.1.5.8.1 Monitoring Channels ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source.html
This is because the server IDs of replicas must be unique in a replication topology. When you do this on a multi-source replica, each channel on the replica has the specified number of applier threads, plus a coordinator thread to manage them. This ... MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
If you use this approach, make sure you monitor the replication process to ensure that the time taken to run the backup does not affect the replica's ability to keep up with events from the source. For an example of how to configure this scenario, ... 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 4.5.4, “mysqldump — A Database Backup ...
https://dev.mysql.com/doc/refman/5.7/en/replication.html
In this environment, all writes and updates must take place on the replication source server. This model can improve the performance of writes (since the source is dedicated to updates), while dramatically increasing read speed across an increasing ... Replication enables data from one MySQL database server (the source) to be copied to one or more MySQL database servers (the ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
To set a variable permanently, you can set it in a startup file or by using the interface provided by your system for this purpose. To do so, use this syntax: SET USER=your_name The syntax on Unix depends on your shell. To do this, set the value of ... Environment variables can be set at the command prompt to affect the current invocation of your command processor, or set permanently to affect future ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER privilege for the table associated with the trigger. This is a TIMESTAMP(2) value (with a ...row ...
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html
If the server was started with the --skip-show-database option, you cannot use this statement at all unless you have the SHOW DATABASES privilege. MySQL implements databases as directories in the data directory, so this statement simply lists ...