基于GTID搭建主从
来源:互联网 发布:linux查看网卡命令 编辑:程序博客网 时间:2024/05/18 12:33
1 停止iptables (主从)service iptables stopchkconfig iptables off2 添加配置文件 (主从)------主库-------------------------log-bin=mysql-bin server-id=553306gtid-mode=on enforce-gtid-consistency=truelog-slave-updates=truebinlog-format=ROW master-info-repository=TABLE relay-log-info-repository=TABLE sync-master-info=1slave-parallel-workers=2 binlog-checksum=CRC32master-verify-checksum=1 slave-sql-verify-checksum=1binlog-rows-query-log_events=1report-port=3306report-host=192.168.1.55-------从库--------------------# 必选项log-bin=mysql-bin server-id=563306gtid-mode=on enforce-gtid-consistency=truelog-slave-updates=truebinlog-format=ROW master-info-repository=TABLE relay-log-info-repository=TABLE sync-master-info=1slave-parallel-workers=2 binlog-checksum=CRC32master-verify-checksum=1 slave-sql-verify-checksum=1binlog-rows-query-log_events=1report-port=3306report-host=192.168.1.56server-id=563306log-bin=mysql-bin[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid/etc/init.d/mysql restart注意重启mysql3 创建用户 (主库)GRANT REPLICATION SLAVE ON *.* to 'daoslave'@'%' identified by 'dao'; flush privileges; 4 主库导出mysqldump --master-data=2 --single-transaction -A >slavedata.sql 5 从库建立账户GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'dao' WITH GRANT OPTION;flush privileges; 6 清除从库之前的日志 mysql> reset master ;Query OK, 0 rows affected (0.04 sec)7 主库操作导入mysql -h 192.168.1.56 -uroot -p <slavedata.sql8 主库查询binlog binglog positoinshow master status9 从库操作 指向主库change master to master_host='192.168.1.55',master_user='daoslave',master_password='dao' ,MASTER_AUTO_POSITION=1 ; 10 开启slavestart slave ;11 检查状态主库mysql> show master status \G ;*************************** 1. row *************************** File: mysql-bin.000003 Position: 300 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: e7e51a04-963a-11e5-a126-000c29056345:11 row in set (0.00 sec)ERROR: No query specifiedshow slave status \G ;mysql> show slave status \G ;*************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.1.55 Master_User: daoslave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 300 Relay_Log_File: localhost-relay-bin.000002 Relay_Log_Pos: 408 Relay_Master_Log_File: mysql-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 300 Relay_Log_Space: 616 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 553306 Master_UUID: e7e51a04-963a-11e5-a126-000c29056345 Master_Info_File: /var/lib/mysql/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: e7e51a04-963a-11e5-a126-000c29056345:1 Auto_Position: 11 row in set (0.00 sec)
0 0
- 基于GTID搭建主从
- 基于mysqldump搭建gtid主从
- MySql基于GTID主从复制的搭建
- 基于gtid复制模式下的主从同步搭建测试
- GTID:基于GTID搭建从库
- mysql主从数据库配置基于GTID
- Mysql-5.7 基于GTID主从复制
- MySQL5.6基于GTID的主从复制
- mysql主从复制配置(基于GTID)
- Mysql-5.7 基于GTID主从复制
- mysql gtid模式主从复制搭建
- 搭建基于GTID的复制方式
- MySQL主从复制之基于GTID及多线程
- MariaDB基于GTID主从复制及多主复制
- MySQL优化之七--Mysql基于GTID的主从复制
- MySQL study之--MySQL基于GTID的主从复制
- MySQL基于GTID模式的主从复制设置
- MySQL基于非GTID模式的主从同步设置
- python3打包成exe
- bzoj2132 圈地计划
- 鸡排七
- 14.未公开的Oracle数据库秘密笔记——10079事件和网络数据包
- 047 exam c 20-end
- 基于GTID搭建主从
- (九十六)函数和结构
- bzoj3275 Number
- 15.未公开的Oracle数据库秘密笔记——X$固定表介绍
- 实战c++中的vector系列--vector应用之STL的find、find_if、find_end、find_first_of、find_if_not(C++11)
- linux下进程资源的限制——struct rlimit详解
- scala习题(十)——特质
- Android 资源管理 Asset 、Raw 和Drawable
- 图的深度优先遍历算法