03 2023 档案
摘要：#处理离线sql my2sql -user root -passwd 111111 -host 127.0.0.1 -port 3308 -mode file -work-type 2sql -local-binlog-file mysql-bin.007013 -start-file mysql-
阅读全文
摘要：1、mysql gtid 改造 1.1、数据库修改 SET GLOBAL ENFORCE_GTID_CONSISTENCY = WARN; SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON; SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
阅读全文
摘要：XtraBackup 安装2.4支持Mysql5.7,8.0支持Mysql8.0注意版本选择yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpmyum install percona-xtrabackup
阅读全文
摘要：centos7 二进制安装mysql5.7.361.libaio安装yum install libaio2.软件下载mysql-5.7.36-el7-x86_64.tar.gz 3.tar -xzvf mysql-5.7.36-el7-x86_64.tar.gz -C /usr/local/ gro
阅读全文
摘要：postgresql 9.2.23 主从复制select * from pg_stat_replication;select * from pg_roles;select * from pg_user;CREATE ROLE repl login replication encrypted pass
阅读全文
摘要：1、在每台机器上执行 SET GLOBAL.ENFORCE_GTID_CONSISTENCY = WARN; 2、在每台机器上执行 SET GLOBAL.ENFORCE_GTID_CONSISTENCY = ON; 3、在每台机器上执行 SET GLOBAL.GTID_MODE = OFF_PERM
阅读全文
摘要：reset slave 所有中继日志文件都被删除，即使它们还没有被复制 SQL 线程完全执行。 reset slave all 所有中继日志文件都被删除，它会清除连接参数(需要重新change master to) reset master: 系统变量的值 gtid_purged设置为空字符串 (
阅读全文
摘要：GTID中slave端的binlog是必须开启的，目的是记录执行过的GTID 主库#开启gtidlog-bin=mysql-binexpire_logs_days = 5binlog_format=rowserver-id = 1gtid_mode=onenforce_gtid_consistenc
阅读全文
摘要：mysql主从故障跳过错误1.从库报错 21,22,23,25无法执行Retrieved_Gtid_Set: 265c6c2a-86ca-11ed-b07a-0242ac120002:1-25Executed_Gtid_Set: 265c6c2a-86ca-11ed-b07a-0242ac12000
阅读全文
