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

Did you know that in previous versions of MySQL there were some “hidden” functions that not many users knew about? One of them disappeared on the 16th of October 2012 with the release of 5.6.8rc. Did you find which one it was? SHOW AUTHORS SHOW AUTHORS was last present in 5.6.7rc and displayed a list […]

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.

Overview In a world where database performance and security are paramount, MySQL’s robust component architecture offers numerous ways to enhance and protect the customer’s data. Chief among them is the Connection-Control component now available in MySQL 9.2.0 for Community and Enterprise Editions, and HeatWave. This new component helps administrators manage and mitigate the risk of […]

MySQL Shorts is a playlist on the MySQL YouTube channel dedicated to short form tutorials that focus on a single feature or solution to a problem. This video series covers a variety of different topics. For this post, we will sumamrize all the ‘Shorts’ that highlight MySQL Document Store. Episode 4 In our 4th episode, we showed […]

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.