OurSQL Episode 43: Repli-cans and repli-can'ts

Note: We said this was episode 44, but it's really episode 43!

In this episode we give the basics of how replication works, giving knowledge about the fundamentals about replication to better understand why it has certain limitations and benefits.

Slave IO thread states in SHOW PROCESSLIST
mk-table-checksum
MIXED binary log format defaults to STATEMENT, unless certain conditions apply, which are listed at that link.

Troubleshooting
Replication and max_allowed_packet

Ear Candy
How to mess up replication -- in which we explain how to replicate some, but not all, data, and the best and worst ways to do so.

How to rewrite the database name during replication

Where you can see us:
Sheeri will be at OpenDBCamp next week, Fri May 6th - Sun May 8th in Sardinia, Italy.

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.

We will both be at Open Source Bridges 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.

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

Trackback URL for this post:

http://technocation.org/trackback/1113