… master you add binary log filters; this ensures that the top-level master and its binary logs are fully intact, and then the binary log…] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…; mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication… broken. Scenario #3: The master has crashed before sending all writes If the binary logs of the master are no longer readable, you… the binary logs of the crashed master. The first thing to do after choosing which slave will be the new master is to…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…::heartbeat:IPaddr2): Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [... config: Can't open logfile '/var/log/corosync.log' for reason: Permission denied (13).#012. ... We can now copy the configuration file on all nodes: [root@percona1 ~]# scp /…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…Running: No Slave_SQL_Running: Yes [...] The error log tells us why the IO thread has… slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and…#2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion Enabling GTID-based …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… Master_User: test Master_Port: 3306 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File… Master_User: rsandbox Master_Port: 35301 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
… slave until master-log-file master-log-pos’ reliable enough to synch up two slaves with their master? I have a set up now with master and… slave 2 behind slave1 to make it a chain replication , master => slave 1 = > slave 2. The only option I see to… to make sure master_log_position on slave 1 is ahead of slave 2 and stop slave 2, take the master positions off…
Comment: Using Flexviews - part two, change data capture
March 22, 2013 By 26 Comments
…select * from binlog_consumer_status; +———–+—————–+—————–+———————+ | server_id | master_log_file | master_log_size | exec_master_log_pos | +———–+—————–+—————–+———————+ | 11111 | binlog.000006 | 262934935 | 16450550…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… passive server has mysqld running and replicating from the active master. In theory, failing over is the simple matter of moving…, the logs are replayed with Percona Playback by streaming the slow log from the active server. wget -q -O – http://master_server:3307…, and only have a log file for debugging purposes. Streaming logs from stdin Percona Playback now supports the –query-log-stdin command-line option…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest should…’t be able to have access to the slow query log file, so pt-query-digest is often used with the –processlist… installed by the package manager, with the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… on the replication environment, master or slave: # innobackupex /destination/ In the destination folder there will be a file with the name xtrabackup…-11e2-a604-080027635ef5:1-4 Now it contains both, binary log coordinates and GTID information. That information is also printed by…-080027635ef5:1-4″; slave1 > CHANGE MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check…
