This blog describes how to configure systemd for multiple instances of MySQL. With package installations of MySQL using YUM or APT, it’s easy to manage MySQL with systemctl, but how will you manage it when you install from the generic binaries?

Here, we will configure multiple MySQL instances from the generic binaries and manage them using systemd.

Why do you need multiple instances on the same server?

We will do that, but why would you need multiple instances on the same host in the first place? Why not just create another database on the same instance? In some cases, you will need multiple instances on the host. 

1. You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs.
2. Backup testing. You can run multiple instances on a server to test your backups with the correct version and configs. …

There are plenty GUI and Web application used to monitor a MySQL server. But if you are long time MySQL DBA, you might have used (and abused) Innotop !

I loved it ! And I even became maintainer of it. This particular task became more and more complicated with the different forks and their differences. Also, let’s be honest, Perl saved my life so many times in the past… but this was in the past. These days, having Perl on a system is more complicated.

But Innotop is still very popular in the MySQL world and to help me maintaining it, I would like to welcome a new member in the maintainer group: yoku0825. Tsubasa Tanaka has been a long time user and contributor of Innotop and I’m sure will keep to good work.

I’ve tried to find an alternative to Innotop, and I even wrote my own clone in Go …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.43 (release notes, download) and MySQL-wsrep 8.0.34 (release notes, download), with Galera replication library 4.16 (release notes, download) implementing wsrep API version …

I know, we just released version 8.1, so isn't it a bit early to think about version 10 now? But 5.7 has almost reached its end of life, and MySQL engineers are already working on 8.2 and 8.3. With this speed, we can expect to get to version 10 within a few years. Let's have a look at what we've done in MySQL Server to prepare for this, and what you can and should do to future proof your applications.

We are excited to introduce MySQL HeatWave auditing. It provides a robust and powerful auditing mechanism that meets the most demanding data governance, compliance, and security requirements for:  MySQL HeatWave Audit leverages the robust technology found in MySQL Enterprise Audit. It enables Database Administrators to define filters that specify which events and activities are collected. These database events provide details […]

MySQL HeatWave audit provides a robust and powerful auditing mechanism that meets the most demanding data governance, compliance, and security requirements.

This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations/different data centers. InnoDB ClusterSet automatically manages replication from the primary cluster to the replica clusters via a specific ClusterSet Async replication channel. If the primary cluster becomes inaccessible due to a loss of network connectivity or a data center issue, you can make a replica cluster active in its place.

Now, let’s see in detail how exactly we can configure the topology.

We have used the sandbox environment available via MySQLShell utility for this setup.

Environment

Cluster1:
         127.0.0.1:3308
         127.0.0.1:3309
         127.0.0.1:3310

Cluster2:
         127.0.0.1:3311
         127.0.0.1:3312
         127.0.0.1:3313

Router: …

SQL is derided by many and for good reason. It’s key to scalability yet terribly difficult to write good code.

You can write tighter queries in MySQL easily by following 3 simple tricks –

SUBQUERIES, UNION, and PAGING.

In this article, we will explain all these patterns to write MySQL codes more efficiently.

3 Best and Simple Ways for Tighter MySQL Code

Here are a few quick tips to write tighter queries in MySQL:

1. Get Rid of Those Subqueries!

Subqueries are a standard part of SQL, unfortunately, MySQL doesn’t handle them very well. Luckily there’s a sweet rewrite that can put you in the fast lane. Here’s how to speed up a MySQL subquery by rewriting as a join.

Note that another compelling reason to upgrade to MySQL 5.6 is that this tweak has been rolled into the …

MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without blocking the master database.

All of these goals can be achieved using some powerful tools. Here’s a quick guide to those tools and how to use them.

5 Ways To Fortify MySQL Replication

Here are all the best 5 ways to fortify MySQL replications:

1. Build New Replicas Without Downtime

Something we’re sure you need to do quite often is to build new slaves. You can snapshot from another slave by bringing the slave down, copying its datadir to an alternate machine, updating the server_id and then starting up. However sometimes you have no slave, or your current slaves are serving data.

In those cases, …

MySQL databases are great workhorses of the internet. They back tons of modern websites, from blogs and checkout carts to huge sites like Facebook. But these technologies don’t run themselves.

When you’re faced with a system that is slowing down, you’ll need the right tools to diagnose and troubleshoot the problem.  MySQL has a huge community following and that means scores of great tools for your toolbox.

In this article, we have mentioned 7 ways that will troubleshoot MySQL effectively and efficiently. Let’s explore them below.

7 Ways to Troubleshoot MySQL

Here are 7 ways to troubleshoot MySQL:

1. Use Innotop

Innotop is a great tool for MySQL which despite the name monitors MySQL generally as well as InnoDB usage. It’s fairly easy to install, just download the perl script. Be sure to include a [client] section to your local users .my.cnf file …