OurSQL Episode 128: Your Global ID Please

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.

Events
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.

Oracle's next MySQL tech tour in Stockholm, Sweden March 20th.

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 GTIDs
Global transaction identifier (GTID) concept MySQL manual page
How to use GTIDs with replication
gtid_mode
enforce_gtid_consistency
gtid_purged
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 ***************************
               Slave_IO_State:
                  Master_Host: localhost
                  Master_User:
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File:
          Read_Master_Log_Pos: 4
               Relay_Log_File: localhost-relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File:
             Slave_IO_Running: No
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 0
              Relay_Log_Space: 151
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 0
                  Master_UUID:
             Master_Info_File: /usr/local/mysql/data/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State:
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set: 7F691F08-642A-11E2-8AB1-236696BEF48B:1-6
1 row in set (0.00 sec)

New mysqlbinlog features, read_from_remote_server and read_from_remote_master

Blueprint to support GTIDs in xtrabackup

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.

Blog post about using the mysqlfailover script for automatic failover with MySQL 5.6 and GTID replication

Restrictions on replication with GTIDs

Using GTIDs for failover and scaleout MySQL Manual page.

Ear Candy
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.

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/1212