This week, we discuss GTIDs in MySQL 5.6 and how they work with replication. In Ear Candy, we link to an extremely useful resource for complicated MySQL query patterns. In At the Movies, we present The Finer Art of Being a 'Senior' Employee.
Oracle's upcoming webinars:
MySQL Security Enhancements and Important Security Tips for ISVs and OEMs on Thursday, February 21st.
MySQL Performance and Scalability in Spanish Thursday, February 28th.
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.
MySQL 5.6 GTIDs
Global transaction identifier (GTID) concept MySQL manual page
How to use GTIDs with replication
SHOW SLAVE STATUS in MySQL 5.6. Here's an example, note the Master_UUID, Retrieved_Gtid_Set and Executed_Gtid_Set fields:
mysql> show slave status\G
*************************** 1. row ***************************
1 row in set (0.00 sec)
START SLAVE syntax in MySQL 5.6, including the UNTIL SQL_BEFORE_GTIDS and UNTIL SQL_AFTER_GTIDS clauses.
mysqlfailover script for use on commandline or with MySQL Workbench.
Using GTIDs for failover and scaleout MySQL Manual page.
We talk about Artful Software's Common SQL Queries. These are great patterns for SQL queries, including complex aggregations and date/time handling. The direct link to the query page is http://artfulsoftware.com/infotree/mysqlquerytree.php and you can also read the entire ebook called "Get it Done with MySQL".
At the Movies
This week we present Sheeri doing a 17-minute talk at Linux Conference Australia about The Finer Art of Being a Senior Sysadmin.
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 4th. We have a new venue that you need to come and check it out. It worked great for last night's presentation and we're excited about the future.
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.