The latest from the MySQL community

We are delighted to invite you to celebrate 30 years of MySQL at upcoming MySQL meetups and events. Above the celebration we also would like to give a technical update on the latest advancements in MySQL. Your presence will make this celebrations memorable! MySQL Meetups: EMEA: JAPAC: External (3rd party) Events with MySQL, HeatWave & […]

The latest update to MySQL Enterprise Edition, version 9.3, introduces a significant enhancement focused on improving primary selection on failover. This update includes an improvement to Group Replication primary failover, providing users with a better selection method of a new primary based on the member's most current data. This enhancement results in a seamless experience during failover, maintaining high availability and data integrity.

In this blog, I am going to explain the complete process involved in the MySQL group replication setup using SSL. The blog covers the complete MySQL config files as well as steps. I used the following aspects for my testing purpose.

• MySQL 9.3.0 Inn ovation release
• Ubuntu 24.10
• 3 physical servers

I also enabled the hostname based authentications between the three VMs. So that, I don’t need to provide the IPs explicitly each time. To achieve this, I used to update the the file “/etc/hosts” with following entries.

root@gr1:~# cat /etc/hosts | grep gr
198.19.249.194 gr1 gr1
198.19.249.116 gr2 gr2
198.19.249.163 gr3 gr3

---- Test
root@gr1:~# telnet gr2 3306
Trying 198.19.249.116...
Connected to gr2.
---- Works!

Creating SSL certificates:

As I am going to setting up the SSL based group replication, I need to create the required certificates …

Here we go with another update of ODBC, our reliable and high-performance tools for connecting to popular databases and cloud services from ODBC-compatible tools. This release features enhanced performance, essential new options, expanded capabilities, and much more.

The post Meet Our Newly Updated ODBC Solutions appeared first on Devart Blog.

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.41-26.22 (release notes, download), with Galera replication library 4.22 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.4-26.22 (release notes, …

Large tables can pose challenges for many operations when working with a database. Occasionally, we may need to modify the table definition. Since RDS replication does not use asynchronous for its replication, the typical switchover procedure is not feasible. However, the Blue/Green feature of RDS utilizes asynchronous replication, which allows us to update the table […]

This blog was originally published in April 2023, and we thought it was time for an update. The objective remains the same: since nearly all cloud providers offer a MySQL-based cloud service, who provides the best value?   Comparing MySQL cloud services   To answer that question, we compared the cost of the following services: […]

So, as you’ve noticed, I’ve been playing around with MySQL Router v8.4.3 and read-write splitting, and now I’ve come across some issues that my environment has generated and I’ve opened some bugs against the fiend:

Bug 116950 – Router Read-Write splitting config causes PHP RSET_HEADER error

Bug 116951 – mysqlrouter Error parsing stats_updates_frequency errors

Bug 116952 – Router w/ RW split causes ERROR: 4501 if sql script contains comments lines (“– “)

(Yup, I prepared each bug description, repeatable tasks and suggested fix …

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 …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.40-26.21 (release notes, download), with Galera replication library 4.21 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.3-26.21 (release notes, …