In this post I’m going to discuss the strategy used by our team to manage the changes taking place in the database. Most of the time we as developers mainly focus on implementing the feature and put less effort on manage the database changes. For instance individual might not straight away see the importance in […]

or summary  for lazy guys on how to use it...

{autotoc enabled=yes}

I know that a lot has being written around Xtrabackup, and good documentation can be found on the Percona web site.

Anyhow I had to write a summary and clear procedure for my teams, so I choose to share those with all, given it could provide benefit to all community.

Each major topic is associate to a checklist, that need to be follow to prevent mistakes. Overview Xtrabackup is a hot backup tool, that allow you to perform backup on InnoDB with very limited impact on the running transactions/operations. In order to do this xtrabackup, copy the IBD files AND it takes information out from the REDO log, from a starting point X. This information needs to be then apply to the datafiles, before restarting the MySQL server on restore. In short the Backup operation is compose by 2 main phases:

1. Copy of …

We released the release candidate for MariaDB Galera Cluster on 21st December 2012, not traditionally the best time to make a release. We want to make this a GA release soon and we also want to ensure its well tested. Download it. Read the release notes. Give us feedback/report bugs.  Blog about it too!

It happened last year at the previous Conference, and it's going to happen this year as well.

There will be a session of lightning talks during the conference, for the joy of both the audience and the speakers.

Lightning talks are fun and instructional micro events. Their official purpose is to give the audience a chance to learn something in a very limited amount of time. The real purpose is for the speaker to be as entertaining and memorable as possible within the allocated time.

The call for participation is open from now until February 10th. If you have something that you want to say in not more than 5 minutes, you can SUBMIT A PROPOSAL.

In addition to propose a compelling description that will …

Using MySQL replication gives you an opportunity to scale out read queries. However, MySQL replication is asynchronous; the slave may fall behind.

This Wednesday, January 23 2013, I'll be presenting a free webinar about using MySQL replication on busy PHP web sites.  Register here:  http://www.percona.com/webinars/readwrite-splitting-mysql-and-php

Applications have variable tolerance

Interested in the latest MySQL information across different topics? Don't miss our webinars taking place this week and next!

Thursday, January 24

What’s New in MySQL Connector/.NET 6.6

The recently released MySQL Connector/.NET 6.6 contains impressive new features and capabilities. Join this technical webinar for a quick overview of MySQL Connector/.NET fundamentals followed by a demo and a deeper dive into MySQL Connector/.NET 6.6 technologies.

Learn More and Register Now

Tuesday, January 29

MySQL Enterprise Edition Management Tools

MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, and uptime. In this webinar, we will focus …

The MySQL database provides top-level performance. Here are two courses to help you get the most out of your MySQL system.

Troubleshooting MySQL Performance With Sveta Smirnova

This 1 day seminar is an opportunity to interact with Sveta Smirnova, MySQL engineer, expert on MySQL Performance and author of MySQL Troubleshooting.

Sign up for this seminar scheduled for February 28th, 2013 in London, England. 

Sveta will start from basics, working towards more advanced cases that DBAs would usually need years of experience to identify or …

SkySQL Roadshow is coming to Stockholm on Feb 7, come by and meet us. I'll be ending the day with a talk on Big Data, which will be a more generic Big Data talk with some MySQL relevance, but with the focus on Big Data in general.

I haven't blogging much recently, but that has some reasons. I am since Dec 1 the proud father of twins, a little boy and a little girl. I have yet to teahc them to write proper SQL, the have particular issues with subqueries, but we'll get there. In order to create the usual mess of things and to make sure things are at the brink of running out of control, we decided to renovate our flat in the middle of all this. But I'll get there, and once we have a new kitchen installed, I'll do some more blogging, I have some things piled up to write about.

/Karlsson

SkySQL is a well known support provider in the MySQL ecosystem and since 2012 they are also an official Galera partner. SkySQL customers can get Galera Cluster for MySQL support as part of their SkySQL support contract, and issues are handled by the same experienced and friendly support engineers whether they relate to Galera or not. Codership engineers will collaborate with SkySQL support engineers to fix Galera specific bugs or problems, providing the customer a seamless support experience.

To celebrate our collaboration with SkySQL, we are joining the SkySQL and MariaDB Roadshow 2013:

• Stuttgart, January 25
• …

Last time I wrote about a few tips that can make you more efficient when using the command line on Unix. Today I want to focus more on pager.

The most common usage of pager is to set it to a Unix pager such as less. It can be very useful to view the result of a command spanning over many lines (for instance SHOW ENGINE INNODB STATUS):

mysql> pager less
PAGER set to 'less'
mysql> show engine innodb status\G
[...]

Now you are inside less and you can easily navigate through the result set (use q to quit, space to scroll down, etc).

Reminder: if you want to leave your custom pager, this is easy, just run pager:

mysql> pager
Default pager wasn't set, using stdout.

Or \n:

mysql> \n
PAGER set to stdout