mysql-fabric安装搭建手册

《mysql-fabric安装搭建手册》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、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三、安装步骤1、安装数据库四台服务器安装5.6以上版本数据库，详细安装数据库步骤省略2、设置修改/etc/my.cnf[mysqld]datadir=/data/mysqlsocket=

2、/var/lib/mysql/mysql.sockuser=mysql#Disablingsymbolic-linksisrecommendedtopreventassortedsecurityriskssymbolic-links=0log-bin=mysql-binbinlog_format=ROWserver-id=29log-slave-updates=truegtid-mode=onenforce-gtid-consistency=truesync-master-info=1[mysqld_s

3、afe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid红色字体部分四台机器一样，打开gtid-mode、binlog等参数，server-id四台机器均不一样3、设置用户权限mysql-133、mysql-134、mysql-135、mysql-136：GRANTALLPRIVILEGESON*.*TO'fabric'@'%'identifiedby‘fabric’WITHgrantoption;GRANTALLPRIVI

4、LEGESON*.*TO'fabric'@'127.0.0.1'identifiedby‘fabric’WITHgrantoption;flushprivileges;1、安装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-ivhmysql-connect

5、or-python-2.1.1-1.el6.noarch.rpm解压mysql-utilities-1.5.3.zipunzipmysql-utilities-1.5.3.zip复制lib包（确保机器有PYTHON环境）cdmysql-utilities-1.5.3/cp-rmysql//usr/lib/python2.6/site-packages/一路覆盖输入y2、创建FABRIC配置文件cdmysql-utilities-1.5.3/mkdir-petc/mysqlcdmysql-utilitie

6、s-1.5.3/etc/mysqlvifabric.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=fa

7、bricunreachable_timeout=5[protocol.xmlrpc]address=localhost:32274threads=5user=adminpassword=disable_authentication=norealm=MySQLFabricssl_ca=ssl_cert=ssl_key=[protocol.mysql]address=localhost:32275user=adminpassword=disable_authentication=nossl_ca=ssl_c

8、ert=ssl_key=[executor]executors=5[logging]level=INFOurl=file:///var/log/fabric.log[sharding]mysqldump_program=/usr/bin/mysqldumpmysqlclient_program=/usr/bin/mysqlprune_limit=10000[statistics]prune_time=3600[failure_trackin