As part of the Advent calendar of content for this year, we are going to take a stroll down memory lane into the history of MySQL. In this first post, we will highlight some of the major milestones of the middle years.

For the seventh day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on MySQL Shell.

For our MySQL Advent Calendar before the 30th Anniversary Year, let's have a look at some MySQL Retrospective

MySQL HeatWave, an Oracle Cloud service, delivers high-performance query processing, efficiently manages large data volumes, and combines transactional and analytical processing within the same system. This article highlights its key features and benefits.

The post MySQL HeatWave: Real-Time Analytics and High-Performance Data Processing appeared first on Devart Blog.

For the fourth day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are discussed MySQL Document Store.

MySQL Advent Calendar Restrospective

A single hour of downtime costs companies an average of $300,000, with critical systems like databases bearing the brunt of this risk. MySQL, widely used for managing essential data, requires high availability (HA) solutions to maintain smooth uptime and avoid disruptions that can lead to financial loss or reputational damage. 

Ensuring the continuous availability of MySQL databases is essential, especially when handling high transaction volumes. ProxySQL, a powerful middleware, provides advanced support on techniques ranging from replication to clustering that assist with MySQL high availability. 

These techniques minimize vulnerabilities, improve fault tolerance, and keep systems running smoothly, even during failures or …

I’m just trying out the v8.4 Read-Write configuration for MySQL Router, that comes default in the community edition and, as they say, TL;DR “it’s default upon bootstrap”.

What does this mean and how can I go about it?

The overview is simple:

• Either install or upgrade your existing MySQL Router to v8.4 at least.
• Bootstrap the Router.
• Use the port 3310 or change it to fit your needs.

Let’s get to it:

Stop your running router:

systemctl stop mysqlrouter

Copy the old config, just in case:

cp /etc/mysqlrouter/mysqlrouter.conf /etc/mysqlrouter/mysqlrouter_v80.conf

I normally keep my mysql linux repository disabled so no “yum update” takes over version control and gives me a nasty surprise afterwards. As so, I uncomment the “mysql” entry:

vi /etc/yum.conf …

When working with MySQL databases, you may encounter the need to change a database name. However, MySQL no longer supports a direct renaming option. The RENAME DATABASE command, available in earlier versions, was removed due to the risk of data loss. Despite this, renaming a database in MySQL is still possible. This article explores the […]

The post How to Rename a MySQL Database appeared first on Devart Blog.

TL;DR ALTER TABLE and OPTIMIZE TABLE on an InnoDB table, which rebuilds the table without blocking concurrent changes to it (i.e., executed using INPLACE algorithm) and concurrent DML or purge activity on the table can occasionally lead to two significant problems: ALTER/OPTIMIZE TABLE failing with an unnecessary duplicate key error (even though there are no […]