mysql 5.6 半同步主从安装

一 配置完成主从

二 安装和配置插件

     1 master:

        命令帮助:

        mysql> help install

        Name: 'INSTALL PLUGIN'

        Description:

        Syntax:

        INSTALL PLUGIN plugin_name SONAME 'shared_library_name'

        1) 插件安装：

        mysql> install plugin rpl_semi_sync_master SONAME 'semisync_master.so';

        Query OK, 0 rows affected (0.88 sec)

        mysql> show variables like '%semi%';

        +------------------------------------+-------+

        | Variable_name                      | Value |

        +------------------------------------+-------+

        | rpl_semi_sync_master_enabled       | OFF   |

        | rpl_semi_sync_master_timeout       | 10000 |     单位：毫秒，默认为10秒

        | rpl_semi_sync_master_trace_level   | 32    |

        | rpl_semi_sync_master_wait_no_slave | ON    |

        +------------------------------------+-------+

        4 rows in set (0.01 sec)

        2) 启动插件和设置参数

        mysql> set global rpl_semi_sync_master_enabled=1;

        Query OK, 0 rows affected (0.00 sec)

        mysql> set global rpl_semi_sync_master_timeout=2000;

        Query OK, 0 rows affected (0.00 sec)

        mysql> show variables like '%semi%';

        +------------------------------------+-------+

        | Variable_name                      | Value |

        +------------------------------------+-------+

        | rpl_semi_sync_master_enabled       | ON    |

        | rpl_semi_sync_master_timeout       | 2000  |

        | rpl_semi_sync_master_trace_level   | 32    |

        | rpl_semi_sync_master_wait_no_slave | ON    |

        +------------------------------------+-------+

          4 rows in set (0.00 sec)

     2 slave:

          1) 安装插件

          mysql> install plugin rpl_semi_sync_slave soname 'semisync_slave.so';

          Query OK, 0 rows affected (0.30 sec)

          mysql> show variables like '%semi%';

          +---------------------------------+-------+

          | Variable_name                   | Value |

          +---------------------------------+-------+

          | rpl_semi_sync_slave_enabled     | OFF   |

          | rpl_semi_sync_slave_trace_level | 32    |

          +---------------------------------+-------+

          2 rows in set (0.00 sec)

          2) 启动插件

          mysql> set global rpl_semi_sync_slave_enabled=1;

          Query OK, 0 rows affected (0.00 sec)

          mysql> stop slave IO_thread;

          Query OK, 0 rows affected (0.82 sec)

          mysql> start slave IO_thread;

          Query OK, 0 rows affected (0.00 sec)

三 检查配置和验证

     mysql> show global status like '%semi%';

     +--------------------------------------------+-------+

     | Variable_name                              | Value |

     +--------------------------------------------+-------+

     | Rpl_semi_sync_master_clients               | 1     |         显示半同步的slave的数量

     | Rpl_semi_sync_master_net_avg_wait_time     | 0     |

     | Rpl_semi_sync_master_net_wait_time         | 0     |

     | Rpl_semi_sync_master_net_waits             | 0     |

     | Rpl_semi_sync_master_no_times              | 0     |

     | Rpl_semi_sync_master_no_tx                 | 0     |

     | Rpl_semi_sync_master_status                | ON    |

     | Rpl_semi_sync_master_timefunc_failures     | 0     |

     | Rpl_semi_sync_master_tx_avg_wait_time      | 0     |

     | Rpl_semi_sync_master_tx_wait_time          | 0     |

     | Rpl_semi_sync_master_tx_waits              | 0     |

     | Rpl_semi_sync_master_wait_pos_backtraverse | 0     |

     | Rpl_semi_sync_master_wait_sessions         | 0     |

     | Rpl_semi_sync_master_yes_tx                | 0     |

     +--------------------------------------------+-------+

     14 rows in set (0.01 sec)

四 卸载插件

mysql> help uninstall

Name: 'UNINSTALL PLUGIN'

Description:

Syntax:

UNINSTALL PLUGIN plugin_name

注意：
一旦某次等待超时，会自动降级为异步；

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28572479/viewspace-2134195/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28572479/viewspace-2134195/