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.…

If you have deployed databases with high availability before, you will know that a deployment does not always go your way, even though you’ve done it a zillion times. You could spend a full day setting everything up and may still end up with a non-functioning cluster. It is not uncommon to start over, as it’s really hard to figure out what went wrong.

So, deploying a MySQL Galera Cluster with redundant load balancing takes a bit of time. This blog looks at how long time it would take to do it manually vs using ClusterControl to perform the task. For those who have not used it before, ClusterControl is an agentless management and automation software for databases. It supports MySQL (Oracle and Percona server), MariaDB, MongoDB (MongoDB inc. and Percona), and PostgreSQL.

For manual deployment, we’ll be using the popular “Google university” to …

Oracle OpenWorld starts soon and there will be a few sessions on the MySQL Optimizer.   On Monday, I will have my tutorial on how to analyze and tune MySQL queries.  Later in the week Manyi Lu, the MySQL optimizer team manager, will present what was new in the MySQL optimizer 5.7, and also give a sneak peek into the MySQL 8.0 release.  Both of us will together have a presentation  on Common Table Expressions; a new SQL feature in MySQL 8.0.  The details are as follows: 
Monday, Sep 19, 1:45 p.m.  How to Analyze and Tune MySQL Queries for Better Performance [TUT3750]
Oystein Grovlen, Senior Principal Software Engineer, Oracle

…