OurSQL Episode 127: No Sweat Slaves

This week we begin to discuss replication features in MySQL 5.6. Ear Candy is a LOAD DATA INFILE bug and using CSV to get beyond it; At the Movies is Suzan Bond talking about "The Art of Self-Sourcing".

Events
Oracle's doing more MySQL tech tours. These seminars will be in the mornings, and are free. They will be on:
Tuesday, February 19th in Petach Tikva, Israel
Thursday, February 21st in Oslo and Brussels
Wednesday, March 20th in Stockholm.

LinuxFest Northwest will take place on Sat Apr 27th and Sun Apr 28th. The call for papers is open and you can submit proposals through Thursday Feb 28th.

Open Database Camp will be part of the Northeast LinuxFest at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. You can register and submit presentations on the opensqlcamp.org website.

Percona Live: MySQL Conference and Expo 2013 is being held at the Santa Clara Convention Center Monday April 22nd - Thursday April 25th. Submit a lightning talk!

Training
SkySQL Trainings
Oracle's MySQL Trainings
Percona Trainings

MySQL 5.6 Replication
What's new in MySQL 5.6 replication
Article by Luis Soares of the MySQL replication team about optimized row-based binary logging
binlog_row_image manual page

SHOW SLAVE STATUS in MySQL 5.6

slave-checkpoint-group option
slave-checkpoint-period option
slave-parallel-workers

Crash-Safe Replication
Crash-safe replication in MySQL 5.6 from Mats Kindahl

relay_log_recovery manual page
relay_log_info_repository manual page
master_info_repository manual page
sync_master_info manual page

Bug 67246 which was resolved with a documentation update.

Replication Checksums
Mats Kindahl's blog post about checksumming replication events in MySQL 5.6

slave-sql-verify-checksum option
binlog-checksum option
master-verify-checksum option

Time-Delayed Replication
Delayed replication manual page

pt-slave-delay is what we had to use before now.

binlog informational events
Luis Soares' blog post about binlog informational events

Remote Binlog Backup
using mysqlbinlog for remote binlog backups

Facebook describes their backup scenario and in the comments, they reveal they backported the --stop-never feature to MySQL 5.1.

Ear Candy
In this week's Ear Candy, we present a LOAD DATA INFILE bug and using CSV to get beyond it.
Episode 121, where we discussed the CSV storage engine

At the Movies
This week in At the Movies, we present Suzan Bond talking about "The Art of Self-Sourcing" at CodeConnex 2 months ago.

Where you can see us
Sheeri will be speaking at SCALE 13 in Los Angeles from Friday, February 22nd through Sunday, February 24th on Are You Getting the Best Out of Your MySQL Indexes?

Sheeri will be speaking at Confoo in Montreal, Canada on Monday February 25 - Friday March 1, 2013, giving talks in English about "Are You Getting the Best Out of Your MySQL Indexes?" and "Different (MySQL) Forks for Different Folks".

Gerry will be at the March Seattle User Group meeting on Monday March 11th.

Sheeri will be at the March Boston user group meeting on March 11th at 7 pm, we will feature friend of the show Mark Atwood from HP speaking about OpenStack.

Sheeri will present "MySQL backups" at Northeast LinuxFest in Cambridge, MA from March 16-17th. She will also be organizing Open Database Camp at the same time.

Gerry will present a tutorial during the Percona Live: MySQL Conference and Expo from Monday, April 22 through Thursday April 25th. The tutorial is on Using TokuDB: A Guided Walk Through TokuDB Implementation. Many of the concepts apply to custom MySQL / MariaDB installations as well.

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

Trackback URL for this post:

http://technocation.org/trackback/1211