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-features-differing-tables.html
Important Whether you use statement-based or row-based replication, the replica's copy of the table cannot contain more columns than the source's copy if you wish to employ attribute promotion. Important Replication between columns using different ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
To be able to safely configure the replication mode of an online server it is important to understand some key concepts of replication. The valid values for gtid_mode are as follows and in this order: OFF OFF_PERMISSIVE ON_PERMISSIVE ON It is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
In MySQL 5.7, auto.cnf has only a single [auto] section containing a single server_uuid setting and value; the file's contents appear similar to what is shown here: [auto] server_uuid=8a94f357-aab4-11df-86ab-c80aa9429562 Important The auto.cnf file ... The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html
Important A statement that is still permitted at this stage is not yet actually executed. Important For statement-based logging, an exception is made in the rules just given for the CREATE DATABASE, ALTER DATABASE, and DROP DATABASE statements.
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging format. If you want to be sure that your replication filters always operate in the same way ... If you ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
Important Some factors outside the control of replication can have an impact on the replication recovery process and the overall state of replication after the recovery process. Setting sync_relay_log=1 is particularly important for a multi-threaded ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
Important In MySQL 5.7.11, the default --early-plugin-load value is the name of the keyring_file plugin library file, causing that plugin to be loaded by default. When you start the mysqld server, you can specify program options using any of the ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
Important START SLAVE sends an acknowledgment to the user after all the replication threads have started. Important The password that you set using START SLAVE is masked when it is written to MySQL Server’s logs, Performance Schema tables, and ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
CSV tables let you import or dump data in CSV format, to exchange data with scripts and applications that read and write that same format. Because CSV tables are not indexed, you typically keep the data in InnoDB tables during normal operation, and ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
NDB Table Storage Requirements Important NDB tables use 4-byte alignment; all NDB data storage is done in multiples of 4 bytes. For details about internal representation of temporal values, see MySQL Internals: Important Algorithms and Structures.