… and one slave connected (not semi-sync). Semi-sync Same as the control but with semi-sync enabled on the slave (slave was…-sync transaction (a whole lot more work). Sysbench 32-client test For this test I used the latest sysbench with 20 tables… innodb_support_xa being disabled in the PXC environments Semi-sync performs dismally under concurrency. Think about it, our single inserts…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system with RAID… –num-threads=2 –test=oltp –oltp-test-mode=complex –oltp-table-size=100000 –oltp-distinct-ranges=0 –oltp-order-ranges=0… – we get 2350 transactions/sec with sync_binlog=1 and 2550 transactions/sec with sync-binlog=0 which is about 10% overhead…
Comment: Resyncing table on MySQL Slave
July 1, 2008 By 11 Comments
… of sync. There may be some data sync issues you discover through replication errors; or perhaps you use mk-table-sync or mk-table-checksum, or MySQL’s built-in CHECKSUM() function. At any rate, if it’s a small table, mk-table-sync is actually the best tool anyway, as with one command it will checksum the table, determine differences…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
…/tbl.txt’ INTO TABLE tbl; UNLOCK TABLES; This will dump master’s table content to the file clean the table on master and slave… table in “rep_old” – this can be very handy if you would like to later investigate why data got out of sync and may be do some manual touch ups after you resync the data. Note – this process works well for small tables…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… to make sure replication is in sync to begin with to avoid false positives. mk-table-checksum is a tool to do… the same position and used mk-table-checksum to ensure the data is in sync. mk-table-checksum can use replication to check…. Another table remained though. We used mk-table-sync –print as a diff tool for MySQL to see what is different in the tables…
Comment: Percona Toolkit Webinar followup Q&A
March 12, 2013 By 1 Comment
Hi, Pt-table sync in my experience was not good enough when I was trying to sync two servers with all MYISAM tables. There was a huge difference between them and pt-table-sync was causing table locks on master as expected. So when you have Myisam tables and you have data…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… and when use Maatkit mk-table-checksum to check what tables are out of sync and when use mk-table-sync to resync them. Last… a while with slaves which are a bit out of sync, which is quite often better than having just master available…
Comment: Resyncing table on MySQL Slave
March 5, 2012 By 11 Comments
question: Does mk-table-sync locks master table while sync slave tables against master? what about mk-table-checksum, does that lock master table too?
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
… new –utc option. * Fixed bug 918056: pt-table-sync false-positive error “Cannot nibble table because MySQL chose no index instead of the PRIMARY index” This is an important bug fix for pt-table-sync: certain chunks from pt-table-checksum resulted in an impossible WHERE, causing the…
Comment: Percona Toolkit 2.0.1 and 1.0.2 released
January 5, 2012 By 5 Comments
We changed pt-table-checksum enough that we had to update pt-table-sync to stay compatible with its table format, and that introduced… a hot-fix release to fix this bug in pt-table-sync: https://bugs.launchpad.net/percona-toolkit/+bug/911996
