确认master和slave上是否开启have_dynamic_loading master master@root@(none) 10:54:58gt;show variables like
确认master和slave上是否开启have_dynamic_loading
master
master@root@(none) 10:54:58>show variables like 'have_dynamic_loading';
+----------------------+-------+
| variable_name | value |
+----------------------+-------+
| have_dynamic_loading | yes |
+----------------------+-------+
master@root@(none) 10:54:58>show variables like 'have_dynamic_loading';
+----------------------+-------+
| variable_name        | value |
+----------------------+-------+
| have_dynamic_loading | yes  |
+----------------------+-------+slave
slave@root@test 10:47:52>show variables like 'have_dynamic_loading';
+----------------------+-------+
| variable_name | value |
+----------------------+-------+
| have_dynamic_loading | yes |
+----------------------+-------+
slave@root@test 10:47:52>show variables like 'have_dynamic_loading';
+----------------------+-------+
| variable_name        | value |
+----------------------+-------+
| have_dynamic_loading | yes  |
+----------------------+-------+
使用root在master上安装半同步插件
master@root@(none) 10:58:14>
master@root@(none) 10:58:14>install plugin rpl_semi_sync_master soname 'semisync_master.so';
query ok, 0 rows affected (0.01 sec)
master@root@(none) 10:58:22>show plugins;
+--------------------------+--------+--------------------+--------------------+---------+
| name | status | type | library | license |
+--------------------------+--------+--------------------+--------------------+---------+
| binlog | active | storage engine | null | gpl |
| mysql_native_password | active | authentication | null | gpl |
| mysql_old_password | active | authentication | null | gpl |
| mrg_myisam | active | storage engine | null | gpl |
| csv | active | storage engine | null | gpl |
| memory | active | storage engine | null | gpl |
| myisam | active | storage engine | null | gpl |
| innodb | active | storage engine | null | gpl |
| innodb_trx | active | information schema | null | gpl |
| innodb_locks | active | information schema | null | gpl |
| innodb_lock_waits | active | information schema | null | gpl |
| innodb_cmp | active | information schema | null | gpl |
| innodb_cmp_reset | active | information schema | null | gpl |
| innodb_cmpmem | active | information schema | null | gpl |
| innodb_cmpmem_reset | active | information schema | null | gpl |
| innodb_buffer_page | active | information schema | null | gpl |
| innodb_buffer_page_lru | active | information schema | null | gpl |
| innodb_buffer_pool_stats | active | information schema | null | gpl |
| blackhole | active | storage engine | null | gpl |
| archive | active | storage engine | null | gpl |
| federated | active | storage engine | null | gpl |
| performance_schema | active | storage engine | null | gpl |
| partition | active | storage engine | null | gpl |
| rpl_semi_sync_master | active | replication | semisync_master.so | gpl |
+--------------------------+--------+--------------------+--------------------+---------+
master@root@(none) 10:58:14>
master@root@(none) 10:58:14>install plugin rpl_semi_sync_master soname 'semisync_master.so';
query ok, 0 rows affected (0.01 sec)
master@root@(none) 10:58:22>show plugins;
+--------------------------+--------+--------------------+--------------------+---------+
| name                    | status | type              | library            | license |
+--------------------------+--------+--------------------+--------------------+---------+
| binlog                  | active | storage engine    | null              | gpl    |
| mysql_native_password    | active | authentication    | null              | gpl    |
| mysql_old_password      | active | authentication    | null              | gpl    |
| mrg_myisam              | active | storage engine    | null              | gpl    |
| csv                      | active | storage engine    | null              | gpl    |
| memory                  | active | storage engine    | null              | gpl    |
| myisam                  | active | storage engine    | null              | gpl    |
| innodb                  | active | storage engine    | null              | gpl    |
| innodb_trx              | active | information schema | null              | gpl    |
| innodb_locks            | active | information schema | null              | gpl    |
| innodb_lock_waits        | active | information schema | null              | gpl    |
| innodb_cmp              | active | information schema | null              | gpl    |
| innodb_cmp_reset        | active | information schema | null              | gpl    |
| innodb_cmpmem            | active | information schema | null              | gpl    |
| innodb_cmpmem_reset      | active | information schema | null              | gpl    |
| innodb_buffer_page      | active | information schema | null              | gpl    |
| innodb_buffer_page_lru  | active | information schema | null              | gpl    |
| innodb_buffer_pool_stats | active | information schema | null              | gpl    |
| blackhole                | active | storage engine    | null              | gpl    |
| archive                  | active | storage engine    | null              | gpl    |
| federated                | active | storage engine    | null              | gpl    |
| performance_schema      | active | storage engine    | null              | gpl    |
| partition                | active | storage engine    | null              | gpl    |
| rpl_semi_sync_master    | active | replication        | semisync_master.so | gpl    |
+--------------------------+--------+--------------------+--------------------+---------+
使用root在slave上安装半同步插件
slave@root@test 10:55:18>install plugin rpl_semi_sync_slave soname 'semisync_slave.so';
query ok, 0 rows affected (0.01 sec)