The latest from the MySQL community

Percona Live Open Source Database Conference 2019 in North America has moved to Austin, Texas: a cool place to be, and host to many big names in the tech space. Read what Dave Stokes, MySQL Community Manager for Oracle, has to say in favor of Austin.

If you need a conference ticket for Austin, put in your proposal now!

Those who are successful with their presentation or tutorial submissions will receive a pass to the full three days of the event. Closing date for the call for papers is Sunday, January 20.

Percona is adopting an industry trend by organizing the conference into 13 separate tracks …

Please join Percona’s MySQL Product Manager, Tyler Duzan as he presents Walkthrough of Percona Server MySQL 8.0 on Wednesday, January 9th at 11:00 AM PDT (UTC-7) / 2:00 PM (UTC-4).

Register Now

Our Percona Server for MySQL 8.0 software is the company’s free, enhanced, drop-in replacement for MySQL Community Edition. The software includes all of the great features in MySQL Community Edition 8.0. Additionally, it includes enterprise-class features from Percona made available free and open source. …

An exciting feature-full new version of MySQL (v8.x) was released on April 2018. Along with those exciting features, there were many changes and enhancements done in MySQL's internal optimizer. Naturally, we at EverSQL keep an eye on major changes in MySQL's optimizer, to make sure we are familiar with them and co-exist with them.

So now that 2019 started, I thought it's a good point in time to look back and see how well this new version is adopted by the community. To do that, we surveyed our users for 3 months, from October to December 2018, asking which MySQL database version are they using for their main product's environment. Please note that these results are in no way scientifically-true, nor statistically-true. It's just the data we received and thought it can be interesting to share with the community.

During these 3 months, we received 2000 survey replies from professionals working in companies with more than 5 people. So …

In Part I, we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Now in Part II, we will discuss the details of MySQL semisynchronous replication and the related configuration settings that help us ensure redundancy and consistency of the data in our HA setup. Make sure to check back in for Part III where we will review various failure scenarios that could arise and the way the framework responds and recovers from these conditions.

What is MySQL Semisynchronous Replication?

Simply put, in a …

A few days ago, I stepped into a trap !  This made me lose time for fixing things (and even more for writing this post...).  In the hope that you will avoid my mistake, I am sharing this war story.  I also obviously opened a bug, more about this below.

TL&DR: be careful when using CHANGE MASTER TO MASTER_DELAY = N: it might wipe your relay logs !

As written in the TL&DR, running CHANGE MASTER 

We know that MySQL query cache is deprecated as of MySQL 5.7.20 and removed in MySQL 8.0 and It has been recommended to use ProxySQL (or other) external query cache instead.

In this blog post, we’ll present the ProxySQL query cache functionality and how does it help us.

How to setup ProxySQL between client and database servers is out of the scope of this article.

If you are looking for other articles on ProxySQL Series :

• MySQL replication Read-Write Split up
• Replication Switchover using Proxysql And …

Releasing Excellent Strategies to Begin a University or college Essay Make certain your strategy includes a launch, mid and bottom line. In accordance with the system which you will need to obtain, there exist unique problems on how to write a effect cardstock to a documentary you should make. In the carry on piece, you may also check the documentary with other individuals around the specified variety or issue so that you can get paid audience have greater understanding of the report. Your visitor would desire to know just how the making has effects on them-and regardless of if the studying will at the mercy of them most definitely Correct right away, it is best to painting a photograph within the particular person or scenario and display the activity transpiring. Evidently, it’s not possible to obtain all the deserving thoughts with the txt in 20 min, but which can be the length of time it entails to build your appearance and select even if you …

Aiven Blog: Read about the 2019 launch of Aiven for MySQL, a popular database engine for better handling of back-ups in cloud environments.

MySQL is the next database engine to be launched on Aiven.

Since 5.7.12 MySQL includes what is called the X plugin, but also it includes X protocol and X DevApi. But what is all this and how does it work? Let me share a personal short story on how I found myself investigating this feature. In a previous post I wrote about the MySQL Router tool, and our colleague Mr. Lefred pointed out that I was wrong about X protocol, because I mentioned it was created to be used with JSON docs. Given this input, I wanted to investigate in a little bit more depth about what all this “X” means and how it can be used in our day to day operations.

First problem I found is that the documentation is pretty extensive in the how’s but it was really hard to find the what’s. This is a bit strange, because for people trying to research about …