Summary of MySQL master slave replication data

1. Copy principle official reference document: http://dev.mysql.com/doc/refman/5.6/en/replication.html blog address 1:http://prog3.com/sbdm/blog/mchdba/article/details/11354771 blog address 2:http://prog3.com/sbdm/blog/mchdba/article/details/8717513 as below 1.png are shown:...
Read(2227) comments(0)

Nagios monitor MySQL from the library error: cannot open shared object libmysqlclient.so.18: file: No such

Do a MySQL slave monitoring time and need to check the MySQL script, check the time error: error while loading the shared libraries: libmysqlclient.so.18: cannot open shared object file: no such file or directory1, error information is as follows: [root@slave ~]# /usr/local/n...
Read(2402) comments(0)

[MySQL replication] 20G following the MySQL database from the library to quickly build

Because 20g below, so the data capacity is relatively small, with mysqldump database export business has little effect, so use this model from the library build: PS: master-data=1, record the master log file and read Master log Read_Master_Log_Pos: backup in the backup SQL log/usr/ local/mysql/bin/mysqldump -uroot - pre-S...
Read(2194) comments(7)

[MySQL-MM] production environment to automatically restore the process of M2 in a MM library, sharing from scratch to write automated reconstruction of the script and ideas

1 Introduction There are 48 + mm group node, if every time a manual repair, a two time fortunately, the number is inevitable that some useless work, because a script automatically, avoid every time in M library manual backup, manually copy, manually establish a connection, manually set the copy information process, my purpose, a sh run command, all things are ready, the rest of the bubble a cup of coffee, Nestle or Pu'er tea, on the side quietly wait or can also take rest for a moment, looked at the M2 restoration success: 2 Environment Must be MMM architecture, and...
Read(2015) comments(0)

[MySQL production environment replication fault repair Last_IO_Errno: 1045 error connecting'replication@ Last_IO_Error: to master

1 repair start slave cluster, the error is as follows: Stop slave mysql>; OK Query, 0 affected rows (0.10 sec) - reset the replication parameters Change master to master_host='10.24.54.18'mysql>, master_port=3306, master_user='replication', master...
Read(3920) comments(1)

[MySQL production environment data recovery fatal error: OR no'datadir']innobackupex: option in group'mysqld' in MySQL options

1 perform recovery command [xxx@xxx-c001db1 tmp]$time /usr/bin/innobackupex --rsync --user= "user" --password= "#xxx$" /mysqldata/shared/backup [--rsync] can record Master points for replication settings. Backup Utility v1.5.1-xtraba InnoDB...
Read(3860) comments(4)

[MySQL replication error Last_Error: 1666 Error executing row event:]Last_Errno:'Cannot execute statement: imposs

Received an email alarm, last error: error executing row:'Cannot execute you impossible to write to binary log since statement is in row format and BINLOG_FORMAT format = STATEMENT.' Log on to Mysql, see Slave...
Read(2399) comments(0)

12 groups of MySQL DB nodes, each group of 2 Master-Master, batch removal of expired binlog free disk space

Received a call, disk alarm, found to be a lot of DML operations lead to n binlog produced, so it is necessary to clear already sync binlog log, 12 groups of nodes to MySQL dB (n = 2 Master-Master need bulk removal expired binlog free disk space. Scheme, a total of 24 dB, a Taiwan to clean up certainly not work, you need to write a script, the bulk of the operation, the program is probably as follows 1, the establishment of double master list masterl...
Read(1397) comments(0)

[警告]中止连接11203分贝:“IDE”用户:“校正”主持人:“prd01。MB。com”(有一个错误的

0301的时候切换到 SEP 6 09:16:16 prddb0301 mysqld:130906 9:16:16 [警告]中止连接11203分贝:“IDE”用户:“校正”主持人:“prd01。MB。com”(有一个错误的书面通信数据包) 6 09:1 SEP …
阅读(1465) 评论(0)

MySQL主库已经存在的基础上搭建从库的过程-->(旧资料整理)

【备注】: 主机192.168.250.20 备机192.168.250.40   主从复制 1主机上面已经有了mysql5.1.53-log版。   2备机上没有MySQL数据库,需要在备机上安装mysql5.1.53-log软件,具体参考SVN文档”系统MySQL \文件\ it_sys_mysql_installation .docx”。   3再次确…
阅读(4719) 评论(11)

last_errno:1062,last_error:错误的重复录入'…'关键'主'查询。的详细分析过程

线上环境我从来没有碰到过1062的问题,测试环境开发环境不停的出现类似问题,以往为了赶时间都是跳过或者直接重新做,这会有时间,就好好去查查问题所在。 1从库报错信息: MySQL >显示奴隶地位的G *************************** 1。行***************************…
阅读(3941) 评论(1)

MySQL复制--最快的从库搭建方法(焦油包)

——最快的从库搭建方法 0、准备从库第一次数据备份,临时锁所有表 开启窗口1 MySQL > FLUSH TABLES WITH READ锁; 查询确定,0行受影响(0秒) MySQL >显示主人的地位; + + + -------------- ------------------ ----------…
阅读(1329) 评论(0)
    个人资料
    • 访问:995244次
    • 积分:一万六千零二
    • 等级:
    • 排名:320名第
    • 原创:438篇
    • 转载:3篇
    • 译文:2篇
    • 评论:522条
    我的课程
    博客专栏
    技术网址连接
    http://dev.mysql.com/doc/
    文章分类
    文章存档
    Latest comments