Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-functions.html
Provided that mysqldump was run with --set-gtid-purged set to ON or AUTO (the default), the output contains a SET @@GLOBAL.gtid_purged statement which adds the gtid_executed set from server2 to the gtid_purged set on server1. This section provides ...
https://dev.mysql.com/doc/refman/9.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/9.7/en/replication-mode-change-online-enable-gtids.html
This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous transactions. To start using the GTID protocol so that you can later perform automatic failover, execute ...This procedure does not require taking the server offline and is suited to use in ...
https://dev.mysql.com/doc/refman/9.7/en/restart.html
If auto-reconnect is enabled, the connection is reestablished after the server restarts. One use for RESTART is when it is not possible or convenient to gain command-line access to the MySQL server on the server host to restart it. For example, SET ...
https://dev.mysql.com/doc/refman/9.7/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/9.7/en/show-replicas.html
Replica_UUID: The globally unique ID of this replica, as generated on the replica and found in the replica's auto.cnf file. SHOW REPLICAS Displays a list of replicas currently registered with the source. SHOW REPLICAS should be executed on a server ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/config-file-parameters.html
# [mysqld] innodb_data_file_path=ibdata1:12M:autoextend innodb_page_size=16384 innodb_checksum_algorithm=crc32 innodb_buffer_pool_filename=ib_buffer_pool innodb_undo_tablespaces=2 All file paths contained in the generated backup-my.cnf are relative ... You can specify mysqlbackup options either on the command line or as configuration parameters inside a configuration ...
https://dev.mysql.com/doc/mysql-router/9.7/en/router-read-write-splitting-statements.html
The following statements are not supported if access_mode=auto: Any statement which is not read-only or read-write. The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-production-instances.html
When dba.configureInstance() is issued against the MySQL instance which MySQL Shell is currently running on, in other words the local instance, it attempts to automatically configure the instance. When dba.configureInstance() is issued against a ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/creating-a-replicaset.html
InnoDB ReplicaSet replicationAllowedHost When creating an InnoDB ReplicaSet, if you have security requirements that want all accounts created automatically by AdminAPI to have strict authentication requirements, you can set a value for the ... Once ...