In our previous posts, we have covered different log files and how to use them to troubleshoot MySQL, but that is not all that MySQL has to offer. But what do you do when the standard approach fails to pinpoint the problem? In this post, we will take a closer look at pt-stalk - a tool which may help you understand what is going on with MySQL when the standard approach fails to catch the problem.

This is the nineteenth installment in the ‘Become a MySQL DBA’ blog series. Our previous posts in the DBA series include:

• Troubleshooting Galera cluster issues - part 2,
• Troubleshooting Galera cluster issues - part 1,
• …

A Productive Nine Months It’s been around 9 months since we did the first cut of our own MySQL Docker images, and it is time for a bit of an update on where we are in Dockerland these days, and also to talk about some important security related improvements we made to the images lately. […]

PGConf Silicon Valley was excellent this year: good organization, great speakers, and top-notch vibes in general. We were excited to see everybody visiting (and crowding!) our booth and the overall very positive community presence. Highlights included a presentation about Postgres' use at TripAdvisor, a look at Amazon RDS for Postgres, and consideration of system scalability and the future of relational database management systems.

Baron Schwartz, VividCortex's own founder and CEO, was at the Silicon Valley conference, and he's said that it was the best PGConf he's been to yet. On November 18th, Baron even led a breakout session, titled "Analyzing PostgreSQL Network Traffic with vc-pgsql-sniffer," in which he explained both the principles and practice that come together to result in VividCortex's powerful sniffer tools. Even the questions asked at Baron's talk were fantastic.

To watch a video of Baron's breakout session, find …

We just announced availability of MySQL Cluster Manager 1.4.0! In this post we’ll highlight some details of the MCM 1.4.0 release.

Based on MySQL 5.6 MySQL Cluster Manager is part of the commercial MySQL Cluster offering from Oracle. MCM 1.4.0 is now based on the tried and tested MySQL 5.6 release.…

I posted earlier in the year how to configure a Fedora instance to test PHP code on a local VM. However, I’ve got a few questions on how to find those posts. Here’s a consolidation with links on those steps:

1. Go to this blog post and install the httpd and php libraries with the yum installer.
2. In the same blog post as step 1 (you can put the sample PHP code into the /var/www/html directory for testing), connect to the yum shell and remove the php-mysql library and then install the mysqlnd library.
3. Go to this blog …

The results in the survey were very favourable to Galera Cluster providing high availability for MySQL and OpenStack components. Galera Cluster with MariaDB received second place, Galera with MySQL fifth place and Galera with Percona Server (Percona XtraDB Cluster) sixth place. Altogether Galera Cluster with three different MySQL variants is clearly the most popular database high availability solution for OpenStack users.

This survey report analyzes respondents who completed or updated the survey during a two-week window in September 2015, and questions represent some modifications from prior surveys in keeping with the evolution of the OpenStack platform. This survey represents a snapshot of 1,315 users and 352 deployments, provided voluntarily. The User Survey is not a market survey and does not express …

When you work with complicated queries, especially ones which contain subqueries, it is easy to make a typo or misinterpret column name. While in many cases you will receive a 

column not found

 error, sometimes you can get strange results instead.

Like finding 4079 countries in Antarctica:

mysql> select count(*) from City where CountryCode in (select CountryCode from Country where Continent = 'Antarctica');
+----------+
| count(*) |
+----------+
|     4079 |
+----------+
1 row in set (0.05 sec)

Or not finding any cities in Georgia:

mysql> select Name, Language from City join CountryLanguage using (CountryCode) where CountryCode in (select Code from Country where District='Georgia' and Continent='Asia');
Empty set (0.18 sec)

I used a standard …

Data is the most important asset any organization has especially those who belongs to web, mobile, social, enterprise and cloud applications.

Availability refers to the ability to cope with, and if necessary recover from, failures on the host, including failures of MySQL, the operating system, or the hardware and maintenance activity that may otherwise cause downtime.

Because each application has different operational and availability requirements, MySQL offers a range of certified and supported solutions, delivering the appropriate levels of High Availability (HA). 

Factors to consider for HA Solution: 

• Operational Capabilities
• Budgetary Constraints
• The level of availability required (In terms of Time)
• The type of application being deployed
  • Mission critical services …

UK server monitoring platform provider moves from MySQL to MariaDB with ClusterControl

Stockholm, Sweden and anywhere else in the world - 08 December 2015 – Severalnines, the provider of open source database management tools, today announced its latest customer, CloudStats.me. CloudStats.me is a cloud-based server monitoring platform capable of monitoring Linux, Windows, OS X servers and personal computers, web sites and IP addresses. Users of CloudStats.me range from system administrators to website owners and web hosting providers, such as WooServers, HudsonValleyHost and other SMEs.

CloudStats.me is a UK company which currently monitors more than 1300 servers and 1000 websites and its server monitoring platform is growing rapidly at 500-1000 new users per week, adding approximately 1.5 servers to each new user …

I am a MySQL DBA role as usual check the problems and seek a solution.
On one of the production host (MySQL v5.1.53), I started getting errors in this series:

[Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'binlog.000942' at postion 45042

[ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

[Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'binlog.000928' at postition

[ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

…

Some expert says you should increase the slave_net_timeout and some says to check value of  relay_log_space_limit but it is default already

slave_net_timeout = 3600
relay_log_space_limit = 0 (unlimited) 
max_allowed_packet = 128MB

I can see no heavy queries …