OurSQL Episode 47: Replication logs and objects

This week, we talk about replication logs and replication objects.

Feedback: Via Henrik Ingo
- Drizzle has microsecond granularity for timestamp. MariaDB just
developed a patch for that, in the 5.3 tree.

editors note: updated with a specific link from Henrik

More Replication

Purging binary logs:
PURGE BINARY LOGS TO ‘mysql-bin.12345’;
PURGE BINARY LOGS BEFORE ‘datetime’; (can use string or date expression, like NOW()-interval 5 DAY)
Can also say “PURGE MASTER LOGS”

expire_logs_days - purge *after* x days, so if expire_logs_days is 7, you can have up to 8 days of logs. expires after every log rotate.

What is and what isn’t replicated:
SELECT statements are not replicated
INSERT/UPDATE/DELETE statements are replicated, even if they change 0 rows on the master.

Views, events, and objects are all covered, but too numerous and specific to list in the notes.

Ear Candy -
This week’s ear candy comes from friend-of-the-show Gerry Narvaja. A few years ago Gerry wrote a short blog post about replication limitations, and one of the items he mentioned is something we don’t often think about: The MySQL status variables show how many times a command was issued, but does not include commands issued by the replication thread.


Where you can see us

Sarah will be at the Velocity Conference, Tuesday June 14th through Thursday June 16th in Santa Clara CA, speaking about the many layers of caching in the modern web stack. Get 20% off registration by using discount code FRIEND

She'll additionally be at Devopsdays June 17 and 18 in Mountain View, California.

We will both be at Open Source Bridge from Tuesday, June 21st – through Friday, June 24th in Portland, Oregon.

Sheeri will be at Kscope 11, an Oracle Developer Conference, from Sunday, June 26th through Thursday, June 30th in Long Beach, California speaking about Securing MySQL.

We will both be at OSCon 2011 from Monday, July 25th through Friday, July 29th in Portland, Oregon. Get 20% off registration using the discount code os11com.

Facebook group
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369