include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. [connection master] [connection slave] RESET REPLICA ALL; CHANGE REPLICATION SOURCE TO SOURCE_HOST="127.0.0.1"; include/assert.inc ["Assert that the host was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=0; include/assert.inc ["Assert that auto position set correctly"] CHANGE REPLICATION SOURCE TO GET_SOURCE_PUBLIC_KEY=1; include/assert.inc ["Assert that the 'get public key' was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_BIND="eth4n"; include/assert.inc ["Assert that the bind was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS="zstd"; include/assert.inc ["Assert that the connect retry was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY=10000; include/assert.inc ["Assert that the connect retry was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_DELAY=101010; include/assert.inc ["Assert that the delay was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=2; include/assert.inc ["Assert that the heartbeat period was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_LOG_FILE="binlog.000001"; Warnings: Warning 3023 CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file. include/assert.inc ["Assert that the log file was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_LOG_POS=200; include/assert.inc ["Assert that the log position was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_PASSWORD="secret"; Warnings: Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. include/assert.inc ["Assert that the password was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_PORT=3306; include/assert.inc ["Assert that the port was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_PUBLIC_KEY_PATH="/path/to/source/key"; include/assert.inc ["Assert that the source public key path was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT=101; include/assert.inc ["Assert that the retry count was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL=1; include/assert.inc ["Assert that the SSL was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL_CA="ca"; include/assert.inc ["Assert that the SSL CA file was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL_CAPATH="/path/to/ca"; include/assert.inc ["Assert that the SSL CA path was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL_CIPHER="cipher_foo"; include/assert.inc ["Assert that the SSL cipher was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL_CERT="cert"; include/assert.inc ["Assert that the SSL cert was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL_CRL="crl_list"; include/assert.inc ["Assert that the SSL CRL was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL_CRLPATH="/path/to/crl"; include/assert.inc ["Assert that the SSL CRL path was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL_KEY="key"; include/assert.inc ["Assert that the SSL key was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_SSL_VERIFY_SERVER_CERT=1; include/assert.inc ["Assert that the SSL verify server cert was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_TLS_CIPHERSUITES="foo"; include/assert.inc ["Assert that the TLS Ciphersuites was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_TLS_VERSION="TLSv1.2"; include/assert.inc ["Assert that the TLS version was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_USER="luis"; Warnings: Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. include/assert.inc ["Assert that the user was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL=14; include/assert.inc ["Assert that the ZSTD compression level was set correctly"] CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=1; include/assert.inc ["Assert that auto position set correctly"] RESET REPLICA ALL; CHANGE MASTER TO MASTER_HOST="127.0.0.1", MASTER_USER="luis"; Warnings: Warning 1287 'CHANGE MASTER' is deprecated and will be removed in a future release. Please use CHANGE REPLICATION SOURCE instead Warning 1287 'MASTER_HOST' is deprecated and will be removed in a future release. Please use SOURCE_HOST instead Warning 1287 'MASTER_USER' is deprecated and will be removed in a future release. Please use SOURCE_USER instead Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. CHANGE REPLICATION SOURCE TO MASTER_HOST="127.0.0.1"; Warnings: Warning 1287 'MASTER_HOST' is deprecated and will be removed in a future release. Please use SOURCE_HOST instead CHANGE REPLICATION SOURCE TO MASTER_AUTO_POSITION=0; Warnings: Warning 1287 'MASTER_AUTO_POSITION' is deprecated and will be removed in a future release. Please use SOURCE_AUTO_POSITION instead CHANGE REPLICATION SOURCE TO GET_MASTER_PUBLIC_KEY=1; Warnings: Warning 1287 'GET_MASTER_PUBLIC_KEY' is deprecated and will be removed in a future release. Please use GET_SOURCE_PUBLIC_KEY instead CHANGE REPLICATION SOURCE TO MASTER_BIND="eth4n"; Warnings: Warning 1287 'MASTER_BIND' is deprecated and will be removed in a future release. Please use SOURCE_BIND instead CHANGE REPLICATION SOURCE TO MASTER_COMPRESSION_ALGORITHMS="zstd"; Warnings: Warning 1287 'MASTER_COMPRESSION_ALGORITHM' is deprecated and will be removed in a future release. Please use SOURCE_COMPRESSION_ALGORITHM instead CHANGE REPLICATION SOURCE TO MASTER_CONNECT_RETRY=10000; Warnings: Warning 1287 'MASTER_CONNECT_RETRY' is deprecated and will be removed in a future release. Please use SOURCE_CONNECT_RETRY instead CHANGE REPLICATION SOURCE TO MASTER_DELAY=101010; Warnings: Warning 1287 'MASTER_DELAY' is deprecated and will be removed in a future release. Please use SOURCE_DELAY instead CHANGE REPLICATION SOURCE TO MASTER_HEARTBEAT_PERIOD=2; Warnings: Warning 1287 'MASTER_HEARTBEAT_PERIOD' is deprecated and will be removed in a future release. Please use SOURCE_HEARTBEAT_PERIOD instead CHANGE REPLICATION SOURCE TO MASTER_LOG_FILE="binlog.000001"; Warnings: Warning 1287 'MASTER_LOG_FILE' is deprecated and will be removed in a future release. Please use SOURCE_LOG_FILE instead Warning 3023 CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file. CHANGE REPLICATION SOURCE TO MASTER_LOG_POS=200; Warnings: Warning 1287 'MASTER_LOG_POS' is deprecated and will be removed in a future release. Please use SOURCE_LOG_POS instead CHANGE REPLICATION SOURCE TO MASTER_PASSWORD="secret"; Warnings: Warning 1287 'MASTER_PASSWORD' is deprecated and will be removed in a future release. Please use SOURCE_PASSWORD instead Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. CHANGE REPLICATION SOURCE TO MASTER_PORT=3306; Warnings: Warning 1287 'MASTER_PORT' is deprecated and will be removed in a future release. Please use SOURCE_PORT instead CHANGE REPLICATION SOURCE TO MASTER_PUBLIC_KEY_PATH="/path/to/source/key"; Warnings: Warning 1287 'MASTER_PUBLIC_KEY_PATH' is deprecated and will be removed in a future release. Please use SOURCE_PUBLIC_KEY_PATH instead CHANGE REPLICATION SOURCE TO MASTER_RETRY_COUNT=101; Warnings: Warning 1287 'MASTER_RETRY_COUNT' is deprecated and will be removed in a future release. Please use SOURCE_RETRY_COUNT instead CHANGE REPLICATION SOURCE TO MASTER_SSL=1; Warnings: Warning 1287 'MASTER_SSL' is deprecated and will be removed in a future release. Please use SOURCE_SSL instead CHANGE REPLICATION SOURCE TO MASTER_SSL_CA="ca"; Warnings: Warning 1287 'MASTER_SSL_CA' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CA instead CHANGE REPLICATION SOURCE TO MASTER_SSL_CAPATH="/path/to/ca"; Warnings: Warning 1287 'MASTER_SSL_CAPATH' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CAPATH instead CHANGE REPLICATION SOURCE TO MASTER_SSL_CIPHER="cipher_foo"; Warnings: Warning 1287 'MASTER_SSL_CIPHER' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CIPHER instead CHANGE REPLICATION SOURCE TO MASTER_SSL_CERT="cert"; Warnings: Warning 1287 'MASTER_SSL_CERT' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CERT instead CHANGE REPLICATION SOURCE TO MASTER_SSL_CRL="crl_list"; Warnings: Warning 1287 'MASTER_SSL_CRL' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CRL instead CHANGE REPLICATION SOURCE TO MASTER_SSL_CRLPATH="/path/to/crl"; Warnings: Warning 1287 'MASTER_SSL_CRLPATH' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CRLPATH instead CHANGE REPLICATION SOURCE TO MASTER_SSL_KEY="key"; Warnings: Warning 1287 'MASTER_SSL_KEY' is deprecated and will be removed in a future release. Please use SOURCE_SSL_KEY instead CHANGE REPLICATION SOURCE TO MASTER_SSL_VERIFY_SERVER_CERT=1; Warnings: Warning 1287 'MASTER_SSL_VERIFY_SERVER_CERT' is deprecated and will be removed in a future release. Please use SOURCE_SSL_VERIFY_SERVER_CERT instead CHANGE REPLICATION SOURCE TO MASTER_TLS_CIPHERSUITES="foo"; Warnings: Warning 1287 'MASTER_TLS_CIPHERSUITES' is deprecated and will be removed in a future release. Please use SOURCE_TLS_CIPHERSUITES instead CHANGE REPLICATION SOURCE TO MASTER_TLS_VERSION="TLSv1.2"; Warnings: Warning 1287 'MASTER_TLS_VERSION' is deprecated and will be removed in a future release. Please use SOURCE_TLS_VERSION instead CHANGE REPLICATION SOURCE TO MASTER_USER="luis"; Warnings: Warning 1287 'MASTER_USER' is deprecated and will be removed in a future release. Please use SOURCE_USER instead Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. CHANGE REPLICATION SOURCE TO MASTER_ZSTD_COMPRESSION_LEVEL=14; Warnings: Warning 1287 'MASTER_ZSTD_COMPRESSION_LEVEL' is deprecated and will be removed in a future release. Please use SOURCE_ZSTD_COMPRESSION_LEVEL instead CHANGE REPLICATION SOURCE TO MASTER_AUTO_POSITION=1; Warnings: Warning 1287 'MASTER_AUTO_POSITION' is deprecated and will be removed in a future release. Please use SOURCE_AUTO_POSITION instead RESET REPLICA ALL; CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT,SOURCE_USER='root'; Warnings: Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. include/start_slave.inc [connection master] include/rpl_end.inc