mysql复制架构的详细配置和设置过程如下：
Master节点配置与初始化：
Master节点的配置文件如下：
[client]port = 3306socket = /tmp/master-mysql.sock[mysql]no-auto-rehash
[mysqld]sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESuser = mysqlport = 3306socket = /tmp/master-mysql.sockserver-id=1port=3306datadir=/data1/mysql/master/datalog_error=/data1/mysql/master/log/master.logpid_file=/data1/mysql/master/data/mysql.pidserver_id=101gtid_mode=onenforce_gtid_consistency=onlog_bin=master-binloglog-slave-updates=1binlog_format=rowskip_slave_start=1max_connect_errors=1000
Master节点的数据库初始化命令：
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data1/mysql/master/data
Master节点数据库启动命令：
nohup mysqld_safe --defaults-file=/data1/my-master.cnf > master.log 2>&1 &
Slave节点配置与初始化：
Slave节点的配置文件如下：
[mysqld]sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESuser = mysqlport = 3307socket = /tmp/slave-mysql.sockdatadir=/data1/mysql/slave/datalog-error = /data1/mysql/slave/log/slave.logpid-file = /data1/mysql/slave/data/slave.pidmax_connect_errors=1000gtid_mode=onenforce_gtid_consistency=onserver_id=102log-bin=slave-binloglog-slave-updates=1binlog_format=rowskip_slave_start=1
Slave数据库初始化命令：
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data1/mysql/slave/data
Slave节点数据库启动命令：
小门道AI
小门道AI是一个提供AI服务的网站
117 查看详情
nohup mysqld_safe --defaults-file=/data1/my-slave.cnf > slave.log 2>&1 &
主从节点创建超级用户：
在Master节点上创建超级用户：
[perrynzhou@debian /data1]$ mysql -uroot -P 3306 -S /tmp/master-mysql.sockmysql> create user 'admin'@'%' identified by 'admin';mysql> grant all privileges on . to 'admin'@'%';mysql> flush privileges;
GTID复制配置：
在主节点上创建复制用户：
[perrynzhou@debian /data1]$ mysql -uroot -P 3306 -S /tmp/master-mysql.sockmysql> create user 'repl'@'%' identified by 'repl';mysql> grant replication slave,replication client on . to 'repl'@'%';mysql> flush privileges;
在Slave节点上验证Master节点的复制用户：
mysql -urepl -prepl -h127.0.0.1 -P 3306
在Slave节点上配置主从复制：
[perrynzhou@debian /data1]$ mysql -uroot -S /tmp/slave-mysql.sock -P 3307 -pmysql> change master to master_host='127.0.0.1', master_user='repl', master_password='repl', master_port=3306, master_auto_position=1;mysql> start slave;
查看Slave节点的复制状态：
mysql> show slave statusG 1. row Slave_IO_State: Waiting for master to send eventMaster_Host: 127.0.0.1Master_User: replMaster_Port: 3306Connect_Retry: 60Master_Log_File: master-binlog.000007Read_Master_Log_Pos: 3452Relay_Log_File: debian-relay-bin.000006Relay_Log_Pos: 470Relay_Master_Log_File: master-binlog.000007Slave_IO_Running: YesSlave_SQL_Running: YesReplicate_Do_DB:Replicate_Ignore_DB:Replicate_Do_Table:Replicate_Ignore_Table:Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table:Last_Errno: 0Last_Error:Skip_Counter: 0Exec_Master_Log_Pos: 3452Relay_Log_Space: 994Until_Condition: NoneUntil_Log_File:Until_Log_Pos: 0Master_SSL_Allowed: NoMaster_SSL_CA_File:Master_SSL_CA_Path:Master_SSL_Cert:Master_SSL_Cipher:Master_SSL_Key:Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: NoLast_IO_Errno: 0Last_IO_Error:Last_SQL_Errno: 0Last_SQL_Error:Replicate_Ignore_Server_Ids:Master_Server_Id: 101Master_UUID: 6443e6e9-bb9c-11eb-bee9-001c420bbbe1Master_Info_File: mysql.slave_master_infoSQL_Delay: 0SQL_Remaining_Delay: NULLSlave_SQL_Running_State: Slave has read all relay log; waiting for more updatesMaster_Retry_Count: 86400Master_Bind:Last_IO_Error_Timestamp:Last_SQL_Error_Timestamp:Master_SSL_Crl:Master_SSL_Crlpath:Retrieved_Gtid_Set: 6443e6e9-bb9c-11eb-bee9-001c420bbbe1:1-13Executed_Gtid_Set: 6443e6e9-bb9c-11eb-bee9-001c420bbbe1:1-13,77c34ad3-bb9e-11eb-b695-001c420bbbe1:1-17Auto_Position: 1Replicate_Rewrite_DB:Channel_Name:Master_TLS_Version:Master_public_key_path:Get_master_public_key: 0Network_Namespace:1 row in set, 1 warning (0.02 sec)
以上就是MySQL基于GTID主从复制入门的详细内容，更多请关注创想鸟其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/459047.html
微信扫一扫 
支付宝扫一扫 
