Although only available as a Release Candidate, MySQL 8 is already proving itself to be a huge leap forward in many regards. Error logging is no exception. The MySQL development team just announced that they have redesigned the error logging subsystem to use a new component architecture.

The redesign will allow the filtering of log events, as well as the routing of error log output to multiple destinations, via the enabling of multiple sink components.  This will make it possible to send error log events to third-party systems for additional formatting and analysis.

In today’s blog, we’ll explore how to employ MySQL 8’s component-based error logging to achieve a variety of logging configurations. Note that all this is specific for MySQL 8 and is not available in earlier versions and also not in MariaDB. However, MariaDB has an option to write the error log to the system “syslog” on systemd-based Linux variants – …

What is an InnoDB Buffer Pool?

InnoDB buffer pool is the memory space that holds many in-memory data structures of InnoDB, buffers, caches, indexes and even row-data. innodb_buffer_pool_size is the MySQL configuration parameter that specifies the amount of memory allocated to the InnoDB buffer pool by MySQL. This is one of the most important settings in the MySQL configuration and should be configured based on the available system RAM.

In this post, we’ll walk you through two approaches of setting your InnoDB buffer pool size value, examine the pros and cons of those practices, and also propose a unique method to arrive at an optimum value based on the size of …

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents “Basic Internal Troubleshooting Tools for MySQL Server” on Thursday, February 15, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5).

Register Now

MySQL Server has many built-in troubleshooting tools. They are always available and can provide many insights on what is happening internally. Many graphical tools, such as Percona Monitoring and Management …

Airvantage is a Value Added Service Provider for mobile telecommunication networks. Airvantage offers various gaming platforms, and subscriber retention initiatives like emergency airtime, mobile money integration, etc.

A simple solution for staying compliant

Airvantage host each customer’s database on its server (virtual) as they are bound to do so from a legislative perspective. They are presently monitoring several production servers that are spread over various countries in Africa and the Caribbean. Looking at many tools, including ManageEngine and some open source alternatives, Airvantage opted for Monyog for its simplicity, ease of config, and relatively affordable price-tag.

Liam described what he needed was “a complete MySQL monitoring system with early-warning mechanisms which allow him to sleep much better”.  With Monyog, Liam instantly started relying on the 600+ monitors and alerts to become better at …

Airvantage is a Value Added Service Provider for mobile telecommunication networks. Airvantage offers various gaming platforms, and subscriber retention initiatives like emergency airtime, mobile money integration, etc.

A simple solution for staying compliant

Airvantage host each customer’s database on its server (virtual) as they are bound to do so from a legislative perspective. They are presently monitoring several production servers that are spread over various countries in Africa and the Caribbean. Looking at many tools, including ManageEngine and some open source alternatives, Airvantage opted for Monyog for its simplicity, ease of config, and relatively affordable price-tag.

Liam described what he needed was “a complete MySQL monitoring system with early-warning mechanisms which allow him to sleep much better”.  With Monyog, Liam instantly started relying on the 600+ monitors and alerts to become better at …

We've recently made a change "in the background", adding an index to each of our release note documents. For an (ample) example, look at the MySQL 5.7 release notes' index page.

The index should make it a lot easier for users to spot (and track) changes of particular features throughout the versions of a MySQL release series (for example, MySQL 5.7 or 8.0).

Release note indexes are automatically updated as new changelogs are created; this is one of the advantages of our highly automated documentation infrastructure -- keeping indexes updated manually would simply not be possible.

Update (2017-07-03): New screenshot, reflecting more readable / less cluttered links to individual release notes.

FATAL: Cannot connect to MySQL server on 'localhost': Cacti Error - Solution to the issue while setting-up.

The post Cannot connect to MySQL server on ‘localhost’: Cacti Error first appeared on Change Is Inevitable.

HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how to set it up with Percona XtraDB Cluster (PXC) so that it only sends queries to available nodes. The same approach can be used in a regular master-slaves setup to spread the read load across multiple slaves. However with MySQL replication, another factor comes into play: replication lag. In this case the approach mentioned for Percona XtraDB Cluster does not work that well as the check we presented only returns ‘up’ or ‘down’. We would like to be able to tune the weight of a replica inside HAProxy depending on its replication lag. This is what we will do in this post using HAProxy 1.5.

Agent …

Recently a several releases of MySQL Server were announced to our mailing lists. Do not miss following news:

• Announced releases:
  • Jun 6, 2013 - MySQL Server 5.1.70
  • Jun 6, 2013 - MySQL Server 5.5.32
  • Jun 6, 2013 - MySQL Server 5.6.12
• More can be found at: …

Percona is glad to announce the release of Percona Playback 0.6 for MySQL on April 9, 2013. Downloads are available from our download site and Percona Software Repositories.

Percona Playback for MySQL is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playback you can measure how a server or database upgrade, change in my.cnf or schema change can affect the overall performance of your MySQL database server.

Percona Playback …