373 lines
20 KiB
Plaintext
373 lines
20 KiB
Plaintext
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 master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection master]
|
|
call mtr.add_suppression("Slave I/O: The slave I/O thread stops because a fatal error is encountered when it tried to SET @master_binlog_checksum");
|
|
call mtr.add_suppression("The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
|
|
|
|
*** Preparing ***
|
|
include/sync_slave_sql_with_master.inc
|
|
include/stop_slave.inc
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
SET @restore_slave_net_timeout=@@global.slave_net_timeout;
|
|
RESET MASTER;
|
|
SET @restore_slave_net_timeout=@@global.slave_net_timeout;
|
|
SET @restore_event_scheduler=@@global.event_scheduler;
|
|
|
|
*** Default value ***
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root';
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
slave_net_timeout/slave_heartbeat_timeout=2.0000
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
|
|
*** Reset slave affect ***
|
|
SET @@global.slave_net_timeout=30;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=5;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
5.000
|
|
|
|
*** Default value if slave_net_timeout changed ***
|
|
SET @@global.slave_net_timeout=50;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
25.000
|
|
SET @@global.slave_net_timeout=@restore_slave_net_timeout;
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
|
|
*** Warning if updated slave_net_timeout < slave_heartbeat_timeout ***
|
|
SET @@global.slave_net_timeout=FLOOR(SLAVE_HEARTBEAT_TIMEOUT)-1;
|
|
Warnings:
|
|
Warning 1704 The requested value for the heartbeat period exceeds the value of `slave_net_timeout' seconds. A sensible value for the period should be less than the timeout.
|
|
SET @@global.slave_net_timeout=@restore_slave_net_timeout;
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
|
|
*** Warning if updated slave_heartbeat_timeout > slave_net_timeout ***
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=SLAVE_NET_TIMEOUT;
|
|
Warnings:
|
|
Warning #### The requested value for the heartbeat period exceeds the value of `slave_net_timeout' seconds. A sensible value for the period should be less than the timeout.
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
|
|
*** CHANGE MASTER statement only updates slave_heartbeat_period ***
|
|
SET @@global.slave_net_timeout=20;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=5;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
SHOW VARIABLES LIKE 'slave_net_timeout';
|
|
Variable_name Value
|
|
slave_net_timeout 20
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
5.000
|
|
SET @@global.slave_net_timeout=2*@@global.slave_net_timeout;
|
|
SHOW VARIABLES LIKE 'slave_net_timeout';
|
|
Variable_name Value
|
|
slave_net_timeout 40
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
5.000
|
|
SET @@global.slave_net_timeout=@restore_slave_net_timeout;
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
|
|
*** Update slave_net_timeout on master ***
|
|
SET @@global.slave_net_timeout=500;
|
|
SET @@global.slave_net_timeout=200;
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
include/start_slave.inc
|
|
include/sync_slave_sql_with_master.inc
|
|
SHOW VARIABLES LIKE 'slave_net_timeout';
|
|
Variable_name Value
|
|
slave_net_timeout 200
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
100.000
|
|
SET @@global.slave_net_timeout=@restore_slave_net_timeout;
|
|
Warnings:
|
|
Warning 1704 The requested value for the heartbeat period exceeds the value of `slave_net_timeout' seconds. A sensible value for the period should be less than the timeout.
|
|
include/stop_slave.inc
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
SET @@global.slave_net_timeout=@restore_slave_net_timeout;
|
|
|
|
*** Start/stop slave ***
|
|
SET @@global.slave_net_timeout=100;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=20;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
include/start_slave.inc
|
|
include/sync_slave_sql_with_master.inc
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
20.000
|
|
include/stop_slave.inc
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
20.000
|
|
|
|
*** Reload slave ***
|
|
SET @@global.slave_net_timeout=50;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=30;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
include/rpl_restart_server.inc [server_number=2]
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
30.000
|
|
SET @restore_slave_net_timeout=@@global.slave_net_timeout;
|
|
|
|
*** Disable heartbeat ***
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=0;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
0.000
|
|
select count_received_heartbeats from performance_schema.replication_connection_status;
|
|
count_received_heartbeats
|
|
0
|
|
include/start_slave.inc
|
|
include/sync_slave_sql_with_master.inc
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
0.000
|
|
select count_received_heartbeats from performance_schema.replication_connection_status;
|
|
count_received_heartbeats
|
|
0
|
|
include/stop_slave.inc
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
0.000
|
|
select count_received_heartbeats from performance_schema.replication_connection_status;
|
|
count_received_heartbeats
|
|
0
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
SELECT SLAVE_HEARTBEAT_TIMEOUT = 0 AS Result;
|
|
Result
|
|
1
|
|
|
|
*** Min slave_heartbeat_timeout ***
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=0.001;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
0.001
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=0.0009;
|
|
Warnings:
|
|
Warning #### The requested value for the heartbeat period is less than 1 millisecond. The value is reset to 0, meaning that heartbeating will effectively be disabled.
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
0.000
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
|
|
*** Max slave_heartbeat_timeout ***
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=4294967;
|
|
Warnings:
|
|
Warning #### The requested value for the heartbeat period exceeds the value of `slave_net_timeout' seconds. A sensible value for the period should be less than the timeout.
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
select heartbeat_interval from performance_schema.replication_connection_configuration;
|
|
heartbeat_interval
|
|
4294967.000
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=4294968;
|
|
ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds).
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=8589935;
|
|
ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds).
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=4294967296;
|
|
ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds).
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
|
|
*** Misc incorrect values ***
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD='-1';
|
|
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''-1'' at line 1
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD='123abc';
|
|
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''123abc'' at line 1
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD='';
|
|
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
|
|
*** Running slave ***
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD= 3.0;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
SELECT unix_timestamp() into @time_0;
|
|
include/start_slave.inc
|
|
include/sync_slave_sql_with_master.inc
|
|
SELECT unix_timestamp() into @time_1;
|
|
Heartbeat event received
|
|
|
|
*** Stopped slave ***
|
|
include/stop_slave.inc
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD= 0.1;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
Number of received heartbeat events while slave stopped: 0
|
|
|
|
*** Started slave ***
|
|
include/start_slave.inc
|
|
Heartbeat event received
|
|
|
|
*** Stopped IO thread ***
|
|
include/stop_slave_io.inc
|
|
Number of received heartbeat events while io thread stopped: 0
|
|
|
|
*** Started IO thread ***
|
|
START SLAVE IO_THREAD;
|
|
include/wait_for_slave_io_to_start.inc
|
|
Heartbeat event received
|
|
|
|
*** Stopped SQL thread ***
|
|
include/stop_slave_sql.inc
|
|
Heartbeat events are received while sql thread stopped (1 means 'yes'): 1
|
|
|
|
*** Started SQL thread ***
|
|
START SLAVE SQL_THREAD;
|
|
include/wait_for_slave_sql_to_start.inc
|
|
Heartbeat event received
|
|
|
|
*** Stopped SQL thread by error ***
|
|
CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10), c LONGTEXT);
|
|
include/sync_slave_sql_with_master.inc
|
|
INSERT INTO t1 VALUES (1, 'on slave', NULL);
|
|
INSERT INTO t1 VALUES (1, 'on master', NULL);
|
|
call mtr.add_suppression("Slave SQL.*Duplicate entry .1. for key .PRIMARY.. on query.* Error_code: MY-001062");
|
|
call mtr.add_suppression("Slave SQL.*Request to stop slave SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
|
|
Heartbeat events are received while sql thread stopped (1 means 'yes'): 1
|
|
include/stop_slave_io.inc
|
|
DELETE FROM t1;
|
|
include/start_slave.inc
|
|
include/sync_slave_sql_with_master.inc
|
|
DROP TABLE t1;
|
|
|
|
include/sync_slave_sql_with_master.inc
|
|
*** Flush logs on slave ***
|
|
include/rpl_reset.inc
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=0.5;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
include/start_slave.inc
|
|
include/assert.inc [Should receive at least one heartbeat event while running FLUSH LOGS for 10 seconds]
|
|
|
|
*** Compressed protocol ***
|
|
SET @@global.slave_compressed_protocol=1;
|
|
include/stop_slave.inc
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
SET @@global.slave_compressed_protocol=1;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=0.1;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
include/start_slave.inc
|
|
Heartbeat event received
|
|
SET @@global.slave_compressed_protocol=0;
|
|
SET @@global.slave_compressed_protocol=0;
|
|
|
|
*** Reset master ***
|
|
STOP SLAVE;
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=0.1;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
include/start_slave.inc
|
|
RESET MASTER;
|
|
include/sync_slave_sql_with_master.inc
|
|
Heartbeat events are received after reset of master (1 means 'yes'): 1
|
|
|
|
*** Reload master ***
|
|
STOP SLAVE;
|
|
RESET SLAVE;
|
|
RESET MASTER;
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=MASTER_PORT, MASTER_USER='root', MASTER_CONNECT_RETRY=20, MASTER_HEARTBEAT_PERIOD=0.1;
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
include/start_slave.inc
|
|
Heartbeat event received
|
|
include/rpl_restart_server.inc [server_number=1]
|
|
include/wait_for_slave_io_to_start.inc
|
|
Heartbeat event received
|
|
|
|
*** Circular replication ***
|
|
include/rpl_reset.inc
|
|
include/stop_slave.inc
|
|
include/rpl_change_topology.inc [new topology=1->2->1]
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=1;
|
|
include/start_slave.inc
|
|
CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10));
|
|
INSERT INTO t1 VALUES(1, 'on master');
|
|
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=0.1;
|
|
include/start_slave.inc
|
|
INSERT INTO t1 VALUES(2, 'on slave');
|
|
include/sync_slave_sql_with_master.inc
|
|
SELECT * FROM t1 ORDER BY a;
|
|
a b
|
|
1 on master
|
|
2 on slave
|
|
SELECT * FROM t1 ORDER BY a;
|
|
a b
|
|
1 on master
|
|
2 on slave
|
|
Heartbeat event received on master
|
|
Heartbeat event received on slave
|
|
*** Clean up ***
|
|
DROP TABLE t1;
|
|
SET @@global.slave_net_timeout=@restore_slave_net_timeout;
|
|
include/rpl_end.inc
|