Using pt-online-schema or gh-ost? Of course you are; everyone in the MySQL industry does. But now there’s a new online schema change tool that will obsolete these two: Spirit by renowned MySQL expert Morgan Tocker.

Using pt-online-schema or gh-ost? Of course you are; everyone in the MySQL industry does. But now there’s a new online schema change tool that will obsolete these two: Spirit by renowned MySQL expert Morgan Tocker.

During last Ubuntu Summit in Riga, I got an interesting question from Alex Lutay, engineering manager at Canonical regarding the different ways to perform some Admin API commands in MySQL Shell.

He wanted to know why, in the manual and blogs, we always use separate commands instead of combining them, as he would expect this to have an impact on the connections established with the server.

Let’s illustrate this by looking at the different ways of obtaining the state of a cluster. Here are the four different methods:

Method 1

This is the method most frequently used in the documentation:

$ mysqlsh admin@10.0.0.1
JS> cluster=dba.getCluster()
JS> cluster.status() 

Method 2

This is Alex’s preferred method as he expects to have less round trips with the network:

$ …

We don't say that quite often, but here is an update to end all updates, one of the biggest bulks of new features and enhancements that dbForge Studio for MySQL has ever seen.

The post Meet the Grand New dbForge Studio MySQL 10.0 with Integrated Source Control! appeared first on Devart Blog.

Above the Conferences and Events announced on Oct 24, we would like to also inform you about the upcoming MySQL meetups, as well as the Oracle User Group conferneces, webinars and other MySQL planned events as such. Please find the details with more information below. Planned MySQL Meetups Planned Oracle User Group Events MySQL Days, […]

MySQL & OUG meetups, events

1. Preface This blog begins by introducing the current state of systemd notifications in MySQL. It then delves into how systemd notifications can be used and how they differ from other MySQL monitoring utilities like Error log, General log, etc. This blog then discusses new granular notifications added in server initialization, startup and shutdown flows, followed […]

This blog discusses the current state of systemd notifications in MySQL and its applications and then discusses newly added systemd notifications in release 8.2.

In 2023 the All Things Open conference was held as an in person event and MySQL Community together with MySQL and Product teams attended as Bronze sponsor with a booth in the expo area and a speaking slots as announced before.   The organizers of the conference announced that approximately 3,800 participants took part out […]

All Things Open Recap