… – as well as go into more detail about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… that are difficult to work with. MyISAM does not maintain checksum consistency during regular operations and is not ACID compliant. MyISAM… the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…’ll have to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some… snapshots! Integrity With ZFS each record on disk has a checksum. If a cosmic ray flip a bit on a drive…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… pt-archiver, to efficiently purge purge data from huge tables pt-table-checksum/pt-table-sync, to check if data on replicas is in… short pt-online-schema-change, to run ALTER TABLE statements on large tables without downtime You can reserve your spot for this… last only a few seconds How to run ALTER TABLE on your largest tables without downtime REGISTER NOW for this MySQL webinar…
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
…-table-checksum: cluster. This method attempts to auto-discover cluster nodes, alleviating the need to specify cluster node DSNs in a DSN table…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… up with data inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which is found in Percona Toolkit…
Post: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
… “–recursion-method dsn=DSN-TABLE” when running pt-table-checksum, where “DSN-TABLE” is a DSN specifying the above DSNs table. For example: –recursion-method… DSN table, else pt-table-checksum will not check them for differences. Here’s the abbreviated output of a real run: $ ./pt-table-checksum h…
Post: Timezone and pt-table-checksum
September 25, 2012 By 1 Comment
… for this as a result of how pt-table-checksum/pt-table-sync calculate their checksums. Lets look at an example: Node1 > PDT > select… can use the –set-vars option with pt-table-checksum like this: pt-table-checksum –replicate percona.checksums –databases=foo –set-vars=”time_zone=’+00…
Post: DBD::mysql 4.014 breaks pt-table-checksum 2.0
February 21, 2012 By Leave a Comment
… tools, but currently pt-table-checksum 2.0 is the only victim. This bug does not affect pt-table-checksum 1.0, and it cannot be worked around in pt-table-checksum 2.0 because the bug in in DBD::mysql. This bug affects pt-table-checksum 2.0 but…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… checksums help you in this case? Yes, they will! Replication checksums on replicas Checksums on slaves are controlled by the slave_sql_verify_checksum… is writing checksums for binary log events: master [localhost] {msandbox} ((none)) > show global variables like ‘binlog_checksum‘; +—————–+——-+ | Variable_name | Value | +—————–+——-+ | binlog_checksum | CRC32… fix the problem right now (either manually or with pt-table-checksum/pt-table-sync) than several days or several weeks later, as…
