當(dāng)前位置：首頁 > 运维知识 > 数据库 >内容正文

数据库

mysql 数据复制停止工作_linux – Mysql GTID复制停止工作

發(fā)布時(shí)間：2023/12/9 数据库 38 豆豆

生活随笔收集整理的這篇文章主要介紹了 mysql 数据复制停止工作_linux – Mysql GTID复制停止工作小編覺得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.

我在主服務(wù)器和從服務(wù)器之間設(shè)置了

mysql gtid復(fù)制.有趣的是,我發(fā)現(xiàn)復(fù)制在幾分鐘后停止工作,我必須使用stop slave并啟動(dòng)slave來重啟mysql復(fù)制.誰能告訴我是什么原因?qū)е逻@個(gè)問題？

改變奴隸主：

mysql> change master to

-> master_host = 'master.com',

-> master_user = 'replica',

-> master_password = 'password',

-> master_port = 3306,

-> MASTER_CONNECT_RETRY = 5,

-> MASTER_RETRY_COUNT = 0,

-> MASTER_AUTO_POSITION=1;

主配置文件：

[mysqld]

user = mysql

pid-file = /var/run/mysqld/mysqld.pid

socket = /var/run/mysqld/mysqld.sock

port = 3306

basedir = /usr

datadir = /data/mysql_data

tmpdir = /tmp

lc-messages-dir = /usr/share/mysql

skip-external-locking

binlog-format = MIXED

interactive_timeout=180

wait_timeout=180

key_buffer = 16M

max_allowed_packet = 16M

thread_stack = 192K

thread_cache_size = 8

myisam-recover = BACKUP

max_connections = 300

query_cache_limit = 1M

query_cache_size = 16M

general_log = 1

log_error = /var/log/mysql/error.log

server-id = 1

log_bin = /var/log/mysql/mysql-bin.log

log_bin_trust_function_creators = 1

log-slave-updates = true

# enable GTID

gtid-mode = on

enforce-gtid-consistency = true

master-info-repository=TABLE

relay-log-info-repository=TABLE

sync-master-info=1

binlog-checksum=CRC32

master-verify-checksum=1

expire_logs_days = 10

max_binlog_size = 100M

奴隸配置：