一致性哈希 数据迁移 mysql_数据库安装及数据迁移(一致性hash)版.docx

安装mysql数据库以及半同步

1.上传mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz 并解压

2.新建log, binlog, tmp, run, relaylog, log目录

3.修改f文件，参见下文。

4.执行scripts/mysql_install_db --user=mysql

5.执行./bin/mysqld_safe --defaults-file=./f --user=mysql & 启动mysql

6.登陆mysql客户端：mysql -h -P3309

7.在mysql客户端中执行下列语句：

1)install plugin rpl_semi_sync_master soname 'semisync_master.so';

2)install plugin rpl_semi_sync_slave soname 'semisync_slave.so';

3)grant replication slave,replication client on *.* to 'rpl'@'%' identified by 'rpl123';

4)drop user ''@localhost;

5)grant all on *.* to root@'%' identified by 'root123' with grant option;

6)使用show global variables like '%gtid%';查看git是否启动

gtid_mode??????????????? | ON??? |?#说明gti功能已启动

7)使用show?status?like?'%emi%'查看插件是否安装成功

8.修改数据库root口令 ./bin/mysqladmin -u root -S /mysql/mysql-5.6.20-linux-glibc2.5-x86_64/run/mysqld.sock password 'root123'

9.重启mysql

10.登陆备服务器上mysql客户端并执行下列语句：

1)stop slave; #停止同步

2)CHANGE MASTER TO MASTER_HOST = '4', MASTER_PORT = 3316, MASTER_USER = 'rpl', MASTER_PASSWORD = 'rpl123', MASTER_AUTO_POSITION = 1;

注：ip及端口都为主服务器地址

3)start slave; #启动同步

4)使用show slave status查看一下复制状态

Slave_IO_Running: Yes??#IO线程与SQL线程都是yes，说明复制启动完成。

f 注：在实际部署时请注意IP、端口及路径

[mysqld]skip-host-cacheskip-name-resolvelower_case_table_names?=?1#?basic?setting#basedir?=?/home/poc/3316/mysql-5.6.20-linux-glibc2.5-x86_64datadir?=?/home/poc/3316/mysql-5.6.20-linux-glibc2.5-x86_64/datatmpdir?=?/home/poc/3316/mysql-5.6.20-linux-glibc2.5-x86_64/tmpsocket?=?/home/poc/3316/mysql-5.6.20-linux-glibc2.5-x86_64/run/mysqld.sockport?=?3316pid-file?=?/home/poc/3316/mysql-5.6.20-linux-glibc2.5-x86_64/run/mysqld.pid#?innodb?settingdefault-storage-engine?=?InnoDBinnodb_file_per_table?=?1log-bin?=?/home/poc/3316/mysql-5.6.20-linux-glibc2.5-x86_64/binlog/bin-log-mysqldlog-bin-index?=?/home/poc/3316/mysql-5.6.20-linux-glibc2.5-x86_64/binlog/bin-log-mysqld.indexrelay_log?=?/home/poc/3316/mysql-5.6.20-linux-glibc2.5-x86_64/rela