August 28, 2014 By Severalnines Check Out Our Latest Resources for MySQL, MariaDB & MongoDB Clusters

Here is a summary of resources & tools that we’ve made available to you in the past weeks. If you have any questions on these, feel free to contact us!

New Technical Webinars

Performance Tuning of HAProxy for Database Load Balancing

09 September 2014 - with Baptiste Assmann of HAProxy Technologies

Do you know what HAProxy can tell you about your application and database instances? Do you know the difference between …

Baron Schwartz, our CEO and founder, is speaking at the Performance and Capacity Conference by CMG on November 6th. CMG, the Computer Measurement Group is a not-for-profit organization that focuses on the efficiency and scalability of IT service delivery through measurement, quantitative analysis and forecasting. It has been a reputable, worldwide resource for best practices in the IT profession since 1974.

Baron will be contributing to these efforts when he presents on “Using Regressions to Estimate Query Resource Consumption.” VividCortex uses regression to generate metrics for many things that cannot be measured directly, allowing us to provide robust sets of data while reducing the measurement intrusion effect on systems. In particular, our customers are able to see the estimated CPU usage of a group of queries and better plan for capacity. …

Baron Schwartz, our CEO and founder, is speaking at the Performance and Capacity Conference by CMG on November 6th. CMG, the Computer Measurement Group is a not-for-profit organization that focuses on the efficiency and scalability of IT service delivery through measurement, quantitative analysis and forecasting. It has been a reputable, worldwide resource for best practices in the IT profession since 1974.

Baron will be contributing to these efforts when he presents on “Using Regressions to Estimate Query Resource Consumption.” VividCortex uses regression to generate metrics for many things that cannot be measured directly, allowing us to provide robust sets of data while reducing the measurement intrusion effect on systems. In particular, our customers are able to see the estimated CPU usage of a group of queries and better plan for capacity. …

Swanhart-Tools includes FlexCDC, a change data capture tool for MySQL. FlexCDC follows a server’s binary log and usually writes “changelogs” that track the changes to tables in the database. I say usually because the latest version of Swanhart-Tools (only in github for now) supports FlexCDC plugins, which allow you to send the updates to a remote data source, or to any other place of your liking.  You can find out more about FlexCDC basics in a previous blog post.

Please note that FlexCDC still needs to have source and destination instances defined in the configuration, even when using plugins.  This is because the FlexCDC state (how much into …

Swanhart-Tools includes FlexCDC, a change data capture tool for MySQL. FlexCDC follows a server’s binary log and usually writes “changelogs” that track the changes to tables in the database. I say usually because the latest version of Swanhart-Tools (only in github for now) supports FlexCDC plugins, which allow you to send the updates to a remote data source, or to any other place of your liking.  You can find out more about FlexCDC basics in a previous blog post.

Please note that FlexCDC still needs to have source and destination instances defined in the configuration, even when using plugins.  This is because the FlexCDC state (how much into which …

While doing some testing (that I published later here) on the still-in-development MySQL 5.7 I wanted to do some analysis on the configuration to see if the changes in performance were due to the code changes or just to the new MySQL defaults (something that is very common in the migration from 5.5 to 5.6 due to the default transaction log size and other InnoDB parameters). This is a quick post aiming to identify the global variables changed between these two versions.

You could tell me that you could just read the release notes, but my experience (and this is not an exception, as you will see) …

You got a production support call related to connection usage. Max_connections is set to 400 and  connection usage has reached the maximum limit.

Below are some of the customized reports that can be used to trace the problem

Count by host :

mysql> select count(*),host from information_schema.processlist group by HOST;
+----------+-----------+
| count(*) | host |
+----------+-----------+
| 1 | localhost |
+----------+-----------+
1 row in set (0.03 sec)

Count by database:

mysql> select count(*),host from information_schema.processlist group by DB;
+----------+-----------+
| count(*) | host      |
+----------+-----------+
|        1 | localhost |
+----------+-----------+
1 row in set (0.00 sec)

Count by username:

mysql> select count(*),user from information_schema.processlist group by user; …

You probably already know that Sphinx supports MySQL binary network protocol. But, if you haven’t heard– Sphinx can be accessed with the regular ol’ MySQL API. Pretty much any language you use to query MySQL can be used to query Sphinx. So, in this post, to demonstrate how using ‘SphinxQL’ (our subset of SQL) makes [...]

The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona Support team receives a request from a customer to assist in the configuration of such an environment. MySQL provides a tool to facilitate the execution of multiple instances called mysqld_multi:

“mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status.”

For tests and development purposes, …

The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona Support team receives a request from a customer to assist in the configuration of such an environment. MySQL provides a tool to facilitate the execution of multiple instances called mysqld_multi:

“mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status.”

For tests and development purposes, …