This week we finish our 2-part series on xtrabackup. Ear Candy is changing the sorting behavior of GROUP BY and At the Movies is a talk on performance schema.
Events
DB Hangops -
every other Wednesay at noon Pacific time
Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center, with a community dinner on the 11th.
[Read more]This week, we talk about Percona's Xtrabackup. Ear Candy talks about .frm files and how many fields an InnoDB table can have, and At the Movies is a talk about indexes.
Xtrabackup
Episode 38 where we previously talked about
Xtrabackup
Installing Percona's Xtrabackup
Operating system permissions and database privileges needed to use xtrabackup
This week we discuss features of Percona Server 5.6 compared to MySQL 5.6. Ear Candy is about pt-upgrade, and At the Movies is a set of lightning talks.
Events
DB Hangops -
every other Wednesay at noon Pacific time
Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center
Training
SkySQL Trainings
This week we interview Luis Soares about multi-source replication. Ear Candy is about memory allocation with FEDERATED and FEDERATEDX storage engines, and At the Movies is about increasing performance by archiving data.
Download the
multi-source replication MySQL server snapshot at labs.
Enabling MySQL multi-source replication on
Luis' blog,
A quick introduction to multi-source replication,
with an example
Actually, this is episode 156, sorry about the error in the title!
This week we interview Mats Kindahl, a MySQL Senior Principal Software Engineer, about the open source Fabric framework for transaction-safe, semi-automatic sharding and high availability. Because we recorded this during the MySQL Connect conference there is no Ear Candy, nor At the Movies.
Events
DB Hangops -
every other Wednesay at noon Pacific time
As a leader of a technical operations team I often have to work on technical operations engineer hiring. This process involves a lot of interviews with candidates and during those interviews along with many challenging practical questions I really love to ask questions like “What are the most important resources you think an Operations Engineer should follow?”, “What books in your opinion are must-read for a techops engineer?” or “Who are your personal heroes in IT community?”. Those questions often give me a lot of information about candidates, their experience, who they are looking up to in the community, what they are interested in, and if they are actively working on improving their professional level.
Recently, one of the candidates asked me to share my lists with him and I thought this information could be valuable to other people so I have decided to share it here on my blog.
Must-Read Books List
First …
[Read more]In this episode, we finish our series about the MySQL Utilities. Ear Candy is pt-stalk, and At the Movies is a fast parallel query engine.
MySQL Utilities part 5
Part 1 of MySQL
Utilities
Part 2 of MySQL
Utilities
Part 3 of MySQL
Utilities
Part 4 of MySQL
Utilities
[bugzilla2]$ mysqlrplcheck --master=root:PASS@bugzilla1
--slave=root:PASS@localhost:/var/lib/mysql/mysql.sock
This week we continue our series exploring the MySQL Utilities. Ear Candy is using the performance schema to find out which accounts fail to properly close connections, and At the Movies has a video about databases and determinism.
Part 1 of MySQL
Utilities
Part 2 of MySQL
Utilities
Part 3 of MySQL
Utilities
Part 5 of MySQL
Utilities
Events
DB Hangops -
every other Wednesay at noon Pacific time
This week we continue our series on MySQL Utilities, talking about replication and failover tools. Ear Candy is a gotcha with poor GRANT syntax that MySQL does not give warnings about, and At the Movies is an open forum from the SkySQL Solutions Day a few months ago.
Part 1 of MySQL
Utilities
Part 2 of MySQL
Utilities
Part 4 of MySQL
Utilities
Part 5 of MySQL
Utilities
MySQL Utilities part 3
mysqlfailover
This week we continue our series on the MySQL Utilities. In this week's Ear Candy, we talk about a path problem installing MySQL Utilities on Ubuntu, and At the Movies is a preview of the SkySQL data suite.
Part 1 of MySQL
Utilities
Part 3 of MySQL
Utilities
Part 4 of MySQL
Utilities
Part 5 of MySQL
Utilities
Events
DB Hangops -
every other Wednesay at noon Pacific time
Percona University is coming to Washington, DC on Thursday, September 12th.
…
[Read more]