This week we discuss pt-table-checksum for keeping data in sync. Ear Candy is a rational look at why one company chose MySQL; At the Movies is using MySQL in a practical way for Big Data.
pt-table-checksum
pt-table-checksum
pt-table-sync
Episode 151, where we talked about Oracle toolsmysqldbcompare and mysqldiff
Options discussed:
–replicate, –no-create-replicate-table
–no-check-binlog-format
–recurse (default is infinite), –recursion-method
–no-replicate-check, –quiet
–retries, –resume, –run-time
–set-vars
–no-empty-replicate-table
–max-lag, –check-slave-lag
–max-load (default: threads_running=25)
–pid
–no-check-plan
–no-check-replication-filters
–no-check-slave-tables
You can also give a comma-separated list of configuration files to read in, with the –config option. If you use it, the –config option has to be the first option on the commandline. The documentation says to look at the output using –help to see the default configuration files, and in the testing we did, this looked at:
/etc/percona-toolkit/percona-toolkit.conf
/etc/percona-toolkit/pt-table-checksum.conf
/root/.percona-toolkit.conf
/root/.pt-table-checksum.conf
–databases, –tables, –engines, –databases-regex, –tables-regex, –columns, –where
–ignore-databases, –ignore-tables, –ignore-engines (FEDERATED,MERGE by default), –ignore-columns, –ignore-databases-regex, –ignore-tables-regex
–chunk-time, –chunk-size, –chunk-index, –chunk-size-limit本文来源gaodai$ma#com搞$代*码*网(
–progress
–function (default is CRC32)
–float-precision
–explain
–replicate-check-only
–trim
–replicate-database
Ear Candy
Case study: Why Baron Schwarz chose MySQL for the backend of his company
At the movies
This week in At the Movies, we present Jonathan Levin speaking aboutUsing MySQL to Build Big Data Applications. In this 26 minute video, Jonathan shows how to create summary tables in MySQL for handling big data.
Where you can see us
Sheeri will be at theJune Boston MySQL User Groupon Monday, June 9th, where we’ll have Amrith Kumar talking about DB as a service using trove on openstack.
Gerry will be at theJune Seattle MySQL User Groupon Monday, June 9th, where we’ll talk about WebScaleSQL.
Sheeri and Gerry will be attendingOSCon 2014from Sunday July 20th through Thursday July 24th.
Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter:@oursqlcast
orTweet about @oursqlcast
Trackback URL for this post:
http://technocation.org/trackback/1315
转载请注明原文链接：OurSQL Episode 185: Getting in Sync_MySQL
