The MySQL development team just published a Labs release of the MySQL Server (available under “MySQL Server 8.0.0 Optimizer”).
A prominent feature of this release, which I developed, is [Recursive] Common Table Expressions, also known as

• [recursive] CTE,
• [recursive] subquery factoring,
• WITH [RECURSIVE] clause.

…

We're very happy to announce the general availability of the next release of MySQL Enterprise Monitor, version 3.3 (see the full changelog here). This is the best in class tool for monitoring and management of your MySQL assets, included with your MySQL Enterprise Edition subscription.

What's New?

Backup Dashboard -- The new  …

Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL. From understanding concepts and technologies, to the tooling, specific commands and files to execute and edit, there’s a lot of things you need to know even when planning a test deployment (the Quick Start Guide for Group Replication should give you an idea).…

Today we are introducing a new MySQL feature called MySQL InnoDB Cluster. Make sure to watch the demo video on the MySQL YouTube Channel!

Find out more by looking into the MySQL InnoDB Cluster documentation.

If you got questions or feedback please feel free to post on the MySQL Forums.…

Introducing the new MySQL InnoDB Cluster Feature

MySQL has had good support for replication for a long time. After all, it is one of the key features that have enabled companies like Facebook, Booking, Twitter and so many others to grow and scale to such extreme scale with MySQL as their primary database engine.…

Ever wondered why Docker is so much popular. Here it is why?  Docker has made it so much easier to spin up nodes as required and then map them all in quick easy way .

In this tutorial I am going to setup a Master-Master Replication between 2 Mysql Nodes , and of course both of them running on Docker based on Ubuntu 16 LTS.

Requirements: –

• docker setup . Refer to Docker article for installing docker
• docker pull mysql:latest from docker hub repo .

Lets crack on

Step 1  – Prepare the configurations / data folders 

Best thing of this docker mysql image is that you can setup your own Data, Log, config, passwords …

We're very excited to announce the General Availability of Oracle MySQL Cloud Service!

Oracle MySQL Cloud Service allows you to accelerate innovation and to rapidly, securely and cost-effectively develop & deploy modern applications powered by the world’s most popular open source database.

Built on the proven MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, integrated and enterprise-ready cloud service that enables organizations to deliver MySQL-based applications globally at scale.

Check out the Oracle MySQL Cloud Service video for a rapid …

In MySQL 8.0.0, the Performance Schema can now instrument server errors. There are 5 new summary tables introduced:

mysql> show tables like "%by_error%";
+-------------------------------------------+
| Tables_in_performance_schema (%by_error%) |
+-------------------------------------------+
| events_errors_summary_by_account_by_error |
| events_errors_summary_by_host_by_error    |
| events_errors_summary_by_thread_by_error  |
| events_errors_summary_by_user_by_error    |
| events_errors_summary_global_by_error     |
+-------------------------------------------+
5 rows in set (0.02 sec)

As names suggest, statistics of errors in these tables are aggregated by error.…

In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin.

X Plugin allows MySQL to function as a document store. We don’t need to define any schema or use SQL language while still being a fully ACID database. Sounds like magic – but we know the only thing that magic does is make planes fly!

Alexander already wrote a blog post exploring how the X Plugin works, with some examples. In this post, I am going to show some more query examples and how they are transformed.

I have enabled the slow query …

With the added complexity of growing data volumes and ever changing workloads, database performance tuning is now necessary to maximize resource utilizations and system performance. However, performance tuning is often easier said than done.

Let’s face it, tuning is difficult for a number of reasons. For one thing, it requires a significant amount of expertise in order to understand execution plans, and often update or re-write good SQL. On top of that, tuning is usually very time consuming. There will always be a large volume of SQL statements to sort through, which may lead to uncertainty around which specific statement needs tuning; and given every statement is different, so too is the tuning approach.

As data volumes grow and technology becomes increasingly complex, it is becoming more important to tune databases properly to deliver end-user experience and to lower infrastructure costs. Performance tuning can help database …