OurSQL Episode 189: Syncing Both Ways

This week we discuss advanced pt-table-sync, including bidirectional sync. Ear Candy is starting MySQL on low-memory virtual machines, and At the Movies is "What's New With MySQL and MariaDB?"

pt-table-sync
Episode 188, where we talked about pt-table-sync basics
pt-table-sync documentation

Options discussed:
--bidirectional
--chunk-column
--conflict-column
--conflict-comparison - greatest, least, newest, oldest, equals, matches
--conflict-value
--conflict-error
--conflict-threshold
--print
--execute

--algorithm - default is "chunk, nibble, group by, stream"

--[no]-buffer-to-client
--[no]-buffer-to-mysql

--function - CRC32, MD5, SHA1, FNV_64, MURMUR_HASH

Ear Candy
https://www.skysql.com/blogs/willfong/starting-mysql-low-memory-virtual-...

At the movies
This week in At the Movies, we have a movie of my talk 2 months ago at the New York Linux Users Group, on What's New in MySQL and MariaDB?.

Where you can see us
Sheeri will be at the July Boston MySQL User Group on Monday, July 14th, where we'll have David Berube talking about "Improving Your Database Designs with Practical Database Theory"..

Gerry will be at the July Seattle MySQL User Group on Monday, July 14th.

Sheeri will be attending the TDWI Executive Summit in Boston from Sunday July 20th through Wednesday July 23rd.

Gerry will be attending OSCon 2014 from 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
or Tweet about @oursqlcast