pt-stalk tool collects MySQL diagnostic data for further analysis to resolve intermittent issues.

Sometimes problems with MySQL can happen seemingly randomly and last for only a few seconds. Many times server issues arise and by the time we login to check, it seems to have disappeared, leaving us frustrated. So, we need to find a way to know what the server is up to when a problem occurs in order to fix it. We need a tool that automatically collects data, when a condition is met. Thanks to Percona Toolkit pt-stalk is available for just this task. It helps to diagnose the problem by capturing a ton of diagnostic data that can help us to pinpoint the cause of the issue.

pt-stalk watches a trigger condition to beome true, then collects data to help diagnose problems. The tool is designed to run as a daemon with root privileges, …

pt-stalk tool collects MySQL diagnostic data for further analysis to resolve intermittent issues.

Sometimes problems with MySQL can happen seemingly randomly and last for only a few seconds. Many times server issues arise and by the time we login to check, it seems to have disappeared, leaving us frustrated. So, we need to find a way to know what the server is up to when a problem occurs in order to fix it. We need a tool that automatically collects data, when a condition is met. Thanks to Percona Toolkit pt-stalk is available for just this task. It helps to diagnose the problem by capturing a ton of diagnostic data that can help us to pinpoint the cause of the issue.

pt-stalk watches a trigger condition to beome true, then collects data to help diagnose problems. The tool is designed to run as a daemon with root privileges, …

Join 27,000 others and follow Sean Hull on twitter @hullsean. I was shocked to find this article on ReadWrite: The Truth About DevOps: IT Isn’t Dead; It’s not even Dying. Wait a second, do people really think this? Truth is I have heard whispers of this before. I was at a meetup recently where the […]

It has been just over 2 weeks since the last libAttachSQL version was released.  I had a great vacation in the middle which for once meant that I didn't do any work for the week I was away :)

For those who don't know about it, libAttachSQL is a lightweight, non-blocking C connector for MySQL servers.  It is Apache 2.0 licensed so plays well with both Open Source and Commercially licensed applications.  I have been developing it for 2 months now as part of my work for HP's Advanced Technology Group.  It is hosted on GitHub and uses many freely available tools (such as Travis CI) to host and test various parts of the project.

Once again I thank everyone for the feedback I have received. …

The MySQL for Database Administrators training course is one of the most popular courses at Oracle. This is not surprising since it provides a comprehensive range of administration skills to those using the world's most popular open source database.

You can travel to an education center to take this 5-day instructor-led course, and as shown in the table below, events are currently scheduled for delivery in 8 languages (Arabic, Brazilian Portuguese, English, French, Hebrew, Italian, Spanish, Turkish).

If you want to take this training from your own desk, you have two options:

• Training-on-Demand: Start training within 24 hours of registration, following training at your own pace.
• Live-Virtual Event: Follow a live event …

Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment? Perhaps that concern is unnecessarily.

I am going to present here some simple tips that hopefully will let fresh Galera users prevent headaches when there is the need to recover part or a whole cluster in certain situations. I used Percona XtraDB Cluster (project based on Percona Server and Galera library + MySQL extensions from Codership) to prepare this post, but most if not all of the scenarios should also apply to any solution based on MySQL+Galera tandem you actually chose, whether these are binaries from Codership, MariaDB Galera Cluster or …

I have a difficult task of making this post interesting, helpful and personal at the same time. I think the main goal is to balance these aspects, and I really appreciate your comments and suggestions that I will add here. For the busy readers who may be put off by the length of this post, here is a very short summary: I spent 4 wonderful years, first as the head of Field Services, then as a CTO, I believe it is now time for a change, so I am leaving SkySQL. I am leaving behind a great company and very good friends, but I am not disappearing completely, and I will continue supporting the work I started and the projects I created with the help of such great people. For many, leaving a company is not easy, and it is extremely difficult if you have contributed to its creation and development since the beginning. Even more difficult is to depart from ideas and projects that you have shaped and …

September 1, 2014 By Severalnines

According to Forrester, a DBA in a large enterprise manages between 8 and 275 databases, with the industry average being 40 databases to a DBA. Larger databases usually require extra effort around tuning, backup, recovery and upgrade. Cloud, as well as automation and management tools can help improve the number of databases managed by one DBA.  

With that background, we were pretty excited to introduce support for management of single-instance MySQL and MariaDB databases in ClusterControl 1.2.6. The majority, if not all of the cluster users out there, use single-instance or master-slave replicated setups along their mission-critical …

I recently completed a four country tour of Baltic Sea countries presenting this seminar series at:

• Helsinki, Finland on Wednesday August 20.
• Stockholm, Sweden on Thursday August 21.
• Riga, Lavtia on Tuesday August 26.
• Talinn, Estonia on Wednesday August 27.

This seminar of four presentations provided a detailed review of the essential lifecycle components for developing a successful software application and offered a checklist for your company to review the design, development, deployment and support practices of your MySQL business applications. Presentations …

To get more familiar with docker and to create a test setup for MySQL Cluster I created docker images for the various components of MySQL Cluster (a.k.a. NDB Cluster)

At first I created a Fedora 20 container and ran all components in one container. That worked and is quite easy to setup. But that's not how one is supposed to use docker.

So I created Dockerfile's for all components and one base image.

The base image:

• contains the MySQL Cluster software
• has libaio installed
• has a mysql user and group 
• serves as a base for the other images

The management node (ndb_mgmd) image:

• Has ndb_mgmd as entrypoint
• Has a config.ini for the cluster …