OurSQL Episode 188: Back in Sync

This week we discuss pt-table-sync basics. Ear Candy is about how MyISAM can seem transaction-aware, and At the Movies is MySQL and NoSQL at Craigslist.

Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming SkySQL events
Upcoming MySQL events

OSCon 2014 will be held at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.

FrOSCon 2014 will be held Saturday 23 August - Sunday 24 August at the University of Applied Sciences Bonn-Rhein-Sieg in Germany.

Training
SkySQL Trainings
Tungsten University trainings
Oracle's MySQL Trainings
Percona Trainings

pt-table-sync
Episode 185 where we talked about pt-table-checksum.

pt-table-sync documentation

Options described:
--sync-to-master
--replicate
--recursion-method
--explain-hosts
--no-index-hint
--chunk-column
--set-vars
--verbose
--execute
--dry-run
--print
--replace
--no-check-child-tables
--no-foreign-key-checks
--no-unique-checks
--no-check-master, --no-check-slave
--no-check-triggers
--no-hex-blob
--wait
--timeout-ok
--no-transaction, --transaction
--lock-value
--lock-and-rename

Options shared with pt-table-checksum
--trim
--where
--ignore-columns, --ignore-databases, --ignore-engines, --ignore-tables
--columns, --databases, --engines, --tables
--chunk-index, --chunk size

Ear Candy
In this week's ear candy, we present suddenly, MyISAM became transaction aware by Peter Laursen at MONyog.

At the movies
This week in at the movies, we present MySQL and NoSQL at Craigslist presented by Jeremy Zawodny at the San Francisco MySQL Meetup.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast