What is mysql multi-instance and how to configure it

The following is about what mysql multiple instances are and how to configure them. The secret of the text lies in being close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on what mysql multiple instances are and how to configure them.

Mysql multi-instance means that on a CVM, mysql service opens multiple different ports (such as 3306, 3307) and runs multiple service processes. These mysql service processes listen to different data ports through different socket, and then provide their own services without interference.

Multiple instances of mysql share a set of mysql applications on the same CVM, so you only need to deploy the mysql program once when you deploy mysql, rather than multiple times. However, different my.cnf configuration files, launchers, and data files are used among multiple instances of mysql. In terms of providing services, mysql multiple instances appear to be independent and independent of each other logically, and multiple instances obtain the hardware resources of the relevant CVM according to the set values of the configuration file.

Multi-instance introduction of mysql

Use multiple configuration files to start different processes to implement multiple instances

Use separate configuration files to implement multiple instances through the official native mysqld_multi

Is there anything you don't understand about what mysql multi-instances are and how to configure them? Or if you want to know more about it, you can continue to follow our industry information section.