| 1 |
SET SESSION slave_parallel_mode= none; |
| 2 |
ERROR HY000: Variable 'slave_parallel_mode' is a GLOBAL variable and should be set with SET GLOBAL |
| 3 |
SELECT @@slave_parallel_mode; |
| 4 |
@@slave_parallel_mode |
| 5 |
minimal |
| 6 |
SELECT @@m1.slave_parallel_mode; |
| 7 |
@@m1.slave_parallel_mode |
| 8 |
NULL |
| 9 |
Warnings: |
| 10 |
Warning 1617 There is no master connection 'm1' |
| 11 |
Warning 1617 There is no master connection 'm1' |
| 12 |
CHANGE MASTER TO master_host='127.0.0.1', master_port=3310, master_user='root'; |
| 13 |
SELECT @@``.slave_parallel_mode; |
| 14 |
@@``.slave_parallel_mode |
| 15 |
minimal |
| 16 |
SELECT @@slave_parallel_mode; |
| 17 |
@@slave_parallel_mode |
| 18 |
minimal |
| 19 |
Parallel_Mode = 'minimal' |
| 20 |
SELECT @@m2.slave_parallel_mode; |
| 21 |
@@m2.slave_parallel_mode |
| 22 |
NULL |
| 23 |
Warnings: |
| 24 |
Warning 1617 There is no master connection 'm2' |
| 25 |
Warning 1617 There is no master connection 'm2' |
| 26 |
SET GLOBAL m2.slave_parallel_mode = none; |
| 27 |
Warnings: |
| 28 |
Warning 1617 There is no master connection 'm2' |
| 29 |
CHANGE MASTER 'm1' TO master_host='127.0.0.1', master_port=3311, master_user='root'; |
| 30 |
SELECT @@m1.slave_parallel_mode; |
| 31 |
@@m1.slave_parallel_mode |
| 32 |
optimistic |
| 33 |
Parallel_Mode = 'minimal' |
| 34 |
SET GLOBAL m1.slave_parallel_mode= conservative; |
| 35 |
Parallel_Mode = 'minimal' |
| 36 |
SET default_master_connection= 'm1'; |
| 37 |
SELECT @@slave_parallel_mode; |
| 38 |
@@slave_parallel_mode |
| 39 |
conservative |
| 40 |
SET GLOBAL slave_parallel_mode= aggressive; |
| 41 |
SELECT @@slave_parallel_mode; |
| 42 |
@@slave_parallel_mode |
| 43 |
aggressive |
| 44 |
Parallel_Mode = 'aggressive' |
| 45 |
SET default_master_connection= ''; |
| 46 |
SELECT @@slave_parallel_mode; |
| 47 |
@@slave_parallel_mode |
| 48 |
minimal |
| 49 |
RESET SLAVE ALL; |
| 50 |
RESET SLAVE 'm1' ALL; |