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-howto-additionalslaves.html
After copying, delete the auto.cnf file from the copy of the data directory on the new replica, so that the new replica is started with a different generated server UUID. You can add another replica to an existing replication configuration without ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/replication-rbr-usage.html
Another method to filter out changes on some replicas is to use a WHERE clause that includes the relation @@server_id <> id_value clause with UPDATE and DELETE statements. MySQL uses statement-based logging (SBL), row-based logging (RBL) or ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
If you have data that must be synchronized to the replicas before replication starts, you have a number of choices: Synchronize all the data to each replica, and delete the databases, tables, or both that you do not want to keep. There may be ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
For a server where binary logging is enabled (log_bin is ON), RESET MASTER deletes all existing binary log files and resets the binary log index file, resetting the server to its state before binary logging was started. RESET MASTER Warning Use ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
(This capability can be disabled with the --skip-symbolic-links option.) This is especially important if you run mysqld as root, because anyone that has write access to the server's data directory then could delete any file in the system! See ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Queries, in the form of SELECT statements, perform all the lookup ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
Using LOCK IN SHARE MODE sets a shared lock that permits other transactions to read the examined rows but not to update or delete them. SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
Trailing spaces are automatically deleted from SET member values in the table definition when a table is created. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...