Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Scalable systems live or die by schema clarity. That’s why most engineers now use database diagram tools to map, manage, and document their structures. But not all tools are built for modern, fast-moving teams. Here’s a look at the top database diagram tools making a difference in 2025.
The post Best Database Diagram Tools–Free and Paid appeared first on Devart Blog.
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.
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 …
[Read more]On April 22-23rd, 2025, the Oracle Conference Center in Redwood Shores, California, buzzed with excitement as the MySQL and HeatWave Summit 2025 kicked off. The MySQL and HeatWave Summit is the largest gathering of MySQL users, developers and product experts in the world. The summit brought together developers, DBAs, experts, and users for this two day event packed with learning, networking, and celebration of MySQL’s latest advancements.
On April 22-23rd, 2025, the Oracle Conference Center in Redwood Shores, California, buzzed with excitement as the MySQL and HeatWave Summit 2025 kicked off. The MySQL and HeatWave Summit is the largest gathering of MySQL users, developers and product experts in the world. The summit brought together developers, DBAs, experts, and users for this two day […]
Last week I had the opportunity to speak at the MySQL and Heatwave Summit in San Francisco. I discussed the impact of the new MySQL 8.0 default caching_sha2_password authentication, replacing the mysql_native_password authentication that was the default for approximately 20 of the 30 years that MySQL has existed.
Announcing Vitess 22 # The Vitess maintainers are happy to announce the release of version 22.0.0, along with version 2.15.0 of the Vitess Kubernetes Operator. This release is the first to benefit from a 6-month-long development cycle, after our recent change to the release cadence. Version 22.0.0 comes with significant enhancements to query serving and cluster management. These changes have allowed Vitess to be more performant and easier to operate compared to version 21.
While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE). There has been recent activity on this bug, showing an easy workaround. This, even if it is known since 16 July 2024, has not been talked about much, so this deserves a blog post.
This blog post will describe how to start working with MySQL HeatWave in OCI. We will interconnect MySQL HeatWave instance with OCI Compute instance and even import data and execute SQL commands over them. First, I will describe the overall picture of what we want to achieve. Then I’ll walk you through the setup of […]
Connecting to MySQL HeatWave in OCI
When I’m working with MySQL, I care not just about whether a single query is slow, but how much total load the server can handle before performance starts to drop.
Tools like mysqlslap help by generating
synthetic workloads to simulate multiple clients and measure the
server’s Queries Per Second (QPS).
In this post, I’ll walk through a script I used to benchmark
MySQL server performance with mysqlslap, and discuss
when it makes sense to use it over more advanced tools like
sysbench. I originally used this script in a blog post published
at ReadySet: Vertical Scaling of MySQL vs. Horizontal Scaling
with ReadySet.
Why Benchmark a MySQL Server?
Benchmarking gives a rough idea of how a MySQL server performs under …
[Read more]