mysql-fabric安装搭建手册.docx

Mysql-Fabric安装手册一、 Fabric简介二、 环境说明IP安装软件作用33FABRIC,MYSQL5.6FABRIC节点34MYSQL5.6主数据库35MYSQL5.6从数据库136MYSQL5.6从数据库2三、 安装步骤1、 安装数据库四台服务器安装5.6以上版本数据库，详细安装数据库步骤省略2、 设置修改/etc/fmysqlddatadir=/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=1mysqld_safelog-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：GRANT ALL PRIVILEGES ON *.* TOfabric% identified by fabric WITH grant option;GRANT ALL PRIVILEGES ON *.* TOfabric identified by fabric WITH grant option;flush privileges;4、 安装FABRIC软件上传：mysql-utilities-1.5.3.zip 和 mysql-connector-python-2.1.1-1.el6.noarch.rpm 到33上安装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/ 一路覆盖输入y5、 创建FABRIC配置文件cd mysql-utilities-1.5.3/mkdir -p etc/mysqlcd mysql-utilities-1.5.3/etc/mysqlvi fabric.cfg 贴入如下内容，注意按照实际情况修改storage中的信息storageaddress = :3306user = fabricpassword = fabricdatabase = fabricauth_plugin = mysql_native_passwordconnection_timeout = 6connection_attempts = 6connection_delay = 1serversuser = fabricpassword = fabricunreachable_timeout = 5protocol.xmlrpcaddress = localhost:32274threads = 5user = adminpassword =disable_authentication = norealm = MySQL Fabricssl_ca =ssl_cert =ssl_key =protocol.mysqladdress = localhost:32275user = adminpassword =disable_authentication = nossl_ca =ssl_cert =ssl_key =executorexecutors = 5logginglevel = INFOurl = file:/var/log/fabric.logshardingmysqldump_program = /usr/bin/mysqldumpmysqlclient_program = /usr/bin/mysqlprune_limit = 10000statisticsprune_time = 3600failure_trackingnotifications = 300notification_clients = 50notification_interval = 60failover_interval = 0detections = 3detection_interval = 6detection_timeout = 1prune_time = 3600connectorTTL = 1clientpassword=6、 配置FABRICcd mysql-utilities-1.5.3/scripts./mysqlfabric.py manage setup -param=storage.user=fabric -param=storage.password=fabric执行成功如下：rootLINUX-133 scripts# ./mysqlfabric.py manage setup -param=storage.user=fabric -param=storage.password=fabricINFO 1423215343.624905 - MainThread - Initializing persister: user (fabric), server (:3306), database (fabric).Finishing initial setup=Password for admin user is not yet set.Password for admin/xmlrpc: Repeat Password: Password set.Password set.No result returned其中需要设置密码！7、 启动fabric./mysqlfabric.py manage start &成功如下显示：rootLINUX-133 scripts# INFO 1423215428.250776 - MainThread - Initializing persister: user (fabric), server (:3306), database (fabric).WARNING 1423215428.262590 - MainThread - Provider error: No module named novaclient.INFO 1423215428.262762 - MainThread - Loading Services.INFO 1423215428.275188 - MainThread - MySQL-RPC protocol server started, listening on localhost:32275INFO 1423215428.287599 - MainThread - Fabric node starting.INFO 1423215428.311008 - MainThread - Starting Executor.INFO 1423215428.311106 - MainThread - Setting 5 executor(s).INFO 1423215428.311695 - Executor-0 - Started.INFO 1423215428.316116 - Executor-1 - Started.INFO 1423215428.316985 - Executor-2 - Started.INFO 1423215428.320461 - Executor-3 - Started.INFO 1423215428.320902 - MainThread - Executor started.INFO 1423215428.324943 - MainThread - Starting failure detector.INFO 1423215428.325697 - Executor-4 - Started.INFO 1423215428.329437 - XML-RPC-Server - XML-RPC protocol server (, 32274) started.INFO 1423215428.329723 - XML-RPC-Server - Setting 1 XML-RPC session(s).INFO 1423215428.331874 - XML-RPC-Session-0 - Started XML-RPC-Session.8、 创建成员组./mysqlfabric.py group create my_grouprootLINUX-133 scripts# ./mysqlfabric.py group create my_groupPassword for admin: Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249eTime-To-Live: 1 uuid finished success result- - - -8c239399-96d9-4d70-9bce-b959a0807ead 1 1 1state success when description- - - - 3 2 1.42322e+09 Triggered by . 4 2 1.42322e+09 Executing action (_create_group).5 2 1.42322e+09 Executed action (_create_group).9、 添加成员./mysqlfabric.py group add my_group 34:3306./mysqlfabric.py group add my_group 35:3306./mysqlfabric.py group add my_group 36:3306查看成员信息./mysqlfabric.py group lookup_servers my_grouprootLINUX-133 scripts# ./mysqlfabric.py group lookup_servers my_group Password for admin: Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249eTime-To-Live: 1 server_uuid address status mode weight- - - - -7273da29-0ffe-11e5-b5d1-0050569639d8 34:3306 SECONDARY READ_ONLY 1.095438039-0ffe-11e5-b5d2-005056967286 35:3306 SECONDARY READ_ONLY 1.099708bb9-0ffe-11e5-b5d2-00505696c191 36:3306 SECONDARY READ_ONLY 1.010、 自动选主./mysqlfabric.py group promote my_group Password for admin: WARNING 1423215558.970159 - Executor-4 - Candidate (99708bb9-0ffe-11e5-b5d2-00505696c191) cannot become a master due to the following reasons: issues to become a master (is_gtid_not_enabled: False, is_slave_updates_not_enabled: False, is_not_running: False, is_binlog_not_enabled: False, no_rpl_user: False), prerequistes as a slave (), valid master (True).INFO 1423215559.225000 - Executor-4 - Master has changed from None to 95438039-0ffe-11e5-b5d2-005056967286.Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249eTime-To-Live: 1 uuid finished success result- - - -eeb08f95-c869-458d-8e98-347dea78d11c 1 1 1state success when description- - - - 3 2 1.42322e+09 Triggered by . 4 2 1.42322e+09 Executing action (_define_ha_operation). 5 2 1.42322e+09 Executed action (_define_ha_operation). 3 2 1.42322e+09 Triggered by . 4 2 1.42322e+09 Executing action (_find_candidate_fail). 5 2 1.42322e+09 Executed action (_find_candidate_fail). 3 2 1.42322e+09 Triggered by . 4 2 1.42322e+09 Executing action (_check_candidate_fail). 5 2 1.42322e+09 Executed action (_check_candidate_fail). 3 2 1.42322e+09 Triggered by . 4 2 1.42322e+09 Executing