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".
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.
Crash-safe replication in MySQL 5.6 from Mats Kindahl
Bug 67246 which was resolved with a documentation update.
Mats Kindahl's blog post about checksumming replication events in MySQL 5.6
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.
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.