| 1 |
include/rpl_init.inc [topology=1->2,1->3] |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
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. |
| 5 |
Warnings: |
| 6 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 7 |
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. |
| 8 |
CALL mtr.add_suppression(".*Got an error reading communication packets.*"); |
| 9 |
# |
| 10 |
# Semisync master's status should be OFF if |
| 11 |
# rpl_semi_sync_source_wait_no_replica is set to 0 at starting server. |
| 12 |
# |
| 13 |
include/assert.inc [Semisync master is off] |
| 14 |
CREATE TABLE t1(c1 INT); |
| 15 |
include/assert.inc [rpl_semi_sync_source_tx_waits should be 0] |
| 16 |
# |
| 17 |
# Semisync's status should still be OFF, because there is only one slave |
| 18 |
# |
| 19 |
[connection server_2] |
| 20 |
include/install_semisync_replica.inc |
| 21 |
[connection server_1] |
| 22 |
include/assert.inc [ should be 2] |
| 23 |
INSERT INTO t1 VALUES(1); |
| 24 |
include/assert.inc [Semisync master is off] |
| 25 |
# |
| 26 |
# Verify 'SET GLOBAL rpl_semi_sync_source_enabled= ON' sets semisync |
| 27 |
# master's status correctly when there are enough semisync slaves. |
| 28 |
# |
| 29 |
[connection server_3] |
| 30 |
include/install_semisync_replica.inc |
| 31 |
[connection server_1] |
| 32 |
SET GLOBAL rpl_semi_sync_source_enabled= OFF; |
| 33 |
include/assert.inc [Semisync master is off] |
| 34 |
SET GLOBAL rpl_semi_sync_source_enabled= ON; |
| 35 |
include/assert.inc [Semisync master is on] |
| 36 |
DROP TABLE t1; |
| 37 |
# |
| 38 |
# Verify ack_receiver thread is created |
| 39 |
# |
| 40 |
include/assert.inc [ack receiver thread is created;] |
| 41 |
CREATE TABLE t1(c1 INT); |
| 42 |
include/rpl_sync.inc |
| 43 |
# |
| 44 |
# Verify semisync replication works well |
| 45 |
# |
| 46 |
[connection server_1] |
| 47 |
include/assert.inc [Semisync master is on] |
| 48 |
DROP TABLE t1; |
| 49 |
include/rpl_sync.inc |
| 50 |
[connection server_2] |
| 51 |
include/uninstall_semisync_replica.inc |
| 52 |
[connection server_3] |
| 53 |
include/uninstall_semisync_replica.inc |
| 54 |
include/rpl_end.inc |