… statements reflect only my opinion and not any official Percona position, and I will look forward to being able to retract… similarities end. Q: What kind of replication issues can you get with storage solutions like GlusterFS? A: I have to admit…. I was able to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… to single-server Innodb, we’d get: [On a single node Innodb server] a given row can’t be modified more than… performance you can expect is modifying a given row once per RTT, it could get slower if apply times start to lag… tradeoffs, but we’re making them (anyone obsessively testing slave position to ensure it’s caught up with the master?). Synchronous…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… from its old master. If not, it may get writes from the old master, which can cause …), replication may start again. But as the master position has been deleted, replication will restart at the …-related configuration: mysql> stop slave; Query OK, 0 rows affected (0,00 sec) mysql> reset slave all; …
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… used in DML statements. A statement based replication slave can get out of sync with the master fairly easily, especially if… included in the binary log, only positions. mysqlbinlog mysql_sandbox25162-relay-bin.000005 –base64-output=decode-rows -v > decoded.log Examine the… represented by the column position prefixed with @. There you have it. You can now find out exactly which row is missing and…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… master status \G *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.00… there are 3 log file names and log file positions which can get confusing, and indeed I often see people using wrong… close, quite often being at same master position at all. Even if replication gets a bit behind in most cases you would…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…who may not get their salaries on time!). mysql> delete from salaries where emp_no = 10001; Query OK, 17 rows affected (…output=decode-rows –start-position 336796712 –stop-position 336797133 mysql-bin.000022 | mysql [root@sb logs]# mysqlbinlog –verbose –base64-output=decode-rows –start-position …
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
…POSITION: 1 POSITION_IN_UNIQUE_CONSTRAINT: 1 REFERENCED_TABLE_SCHEMA: test REFERENCED_TABLE_NAME: Foo REFERENCED_COLUMN_NAME: A *************************** 2. row… -N | mysql -E *************************** 1. row *************************** test.Bar.ID: 42 DIY RI We can get information about foreign …
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
… position, and its position in replication relative to its master. In contrast, the old version of this tool supported only a single row… file: ginger-bin.000033 position: 7936 relay_master_log_file: NULL exec_master_log_pos: NULL *************************** 2. row *************************** ts: 2011-08-03T18… who runs replication should be running pt-heartbeat already to get a reliable indicator of actual replication delay. This avoids the…
Post: What does Handler_read_rnd mean?
June 15, 2010 By 15 Comments
…() method is called. This method fetches a row from a table based on a “fixed position,” i.e. a random-read. What… “next” row in the table. The operation advances the cursor position so the next time it’s called, you get the next row. The… sorted list, using the position to fetch each one. This is quite likely to result in retrieving rows from random points in…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… (However, if you type ROLLBACK the temporary table doesn’t get dropped. It’s not really transactional — it just doesn’…slave replay events up until position 207, kill it, and restart it: slave1 > show slave status\G *************************** 1. row *************************** Master_Log_File: …
