配置mysql半同步，前提是已经有master和slave环境。MySQL半同步配置Master配置安装semisync_master插件mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';Query OK, 0 rows affected (0.02 sec)mysql>show plugins
Master主服务器IP:192.168.1.202 Slave从服务器IP:192.168.1.203Master配置设置server-id、启用bin-log二进制日志vim /etc/my.cnf[mysqld]log_bin = master_binserver-id = 1innodb_file_per_table = ONskip_name_resolve = ON添加sla
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm rpm -ivh mysql-community-release-el7-5.noarch.rpmyum install mysql-community-serverservice mysqld s
卸载已经安装过的旧版本mysqlrpm -e mysql rpm -e --nodeps mysql yum remove mysql安装MySql安装mysql依赖包yum -y install make gcc-c++ cmake bison-devel
mysql日常维护
Windows下恢复root用户
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
