mysql-fabric安装搭建手册.docxVIP

Mysql-Fabric安装手册Fabric简介环境说明IP安装软件作用192.168.201.133FABRIC,MYSQL5.6FABRIC节点192.168.201.134MYSQL5.6主数据库192.168.201.135MYSQL5.6从数据库1192.168.201.136MYSQL5.6从数据库2安装步骤安装数据库四台服务器安装5.6以上版本数据库，详细安装数据库步骤省略设置修改/etc/my.cnf[mysqld]datadir=/data/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0log-bin=mysql-binbinlog_format=ROWserver-id = 29log-slave-updates=truegtid-mode=onenforce-gtid-consistency=truesync-master-info=1[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid红色字体部分四台机器一样，打开gtid-mode、binlog等参数，server-id四台机器均不一样设置用户权限mysql-133 、mysql-134 、 mysql-135 、 mysql-136：GRANT ALL PRIVILEGES ON *.* TOfabric@% identified by ‘fabric’ WITH grant option;GRANT ALL PRIVILEGES ON *.* TOfabric@127.0.0.1 identified by ‘fabric’ WITH grant option;flush privileges;安装FABRIC软件上传：mysql-utilities-1.5.3.zip 和 mysql-connector-python-2.1.1-1.el6.noarch.rpm 到192.168.201.133上安装mysql-connector-python-2.1.1-1.el6.noarch.rpmrpm -ivh mysql-connector-python-2.1.1-1.el6.noarch.rpm解压 mysql-utilities-1.5.3.zipunzip mysql-utilities-1.5.3.zip复制lib包（确保机器有PYTHON环境）cd mysql-utilities-1.5.3/ cp -r mysql/ /usr/lib/python2.6/site-packages/ 一路覆盖输入y 创建FABRIC配置文件cd mysql-utilities-1.5.3/mkdir -p etc/mysqlcd mysql-utilities-1.5.3/etc/mysqlvi fabric.cfg 贴入如下内容，注意按照实际情况修改[storage]中的信息[storage]address = 127.0.0.1:3306user = fabricpassword = fabricdatabase = fabricauth_plugin = mysql_native_passwordconnection_timeout = 6connection_attempts = 6connection_delay = 1[servers]user = fabricpassword = fabricunreachable_timeout = 5[protocol.xmlrpc]address = localhost:32274threads = 5user = adminpassword =disable_authentication = norealm = MySQL Fabricssl_ca =ssl_cert =ssl_key =[protocol.mysql]address = localhost:32275user = adminpassword =disable_authentication = nossl_ca =ssl_cert =ssl_key =[executor]executors = 5[logging]level = INFOurl = file:///var/log/fabric.log[sharding]mysqldump_program = /usr/bin/mysqld