Create new instance in Mysql

Question

I am trying to create a new instance of Mysql on a machine that already has it installed. I did the manual process of creating a new directory and setting up the file .ini, but when starting the service the following error appears:

The "Nomedainstancia" service cannot be started

For more help, type NET HELPMSG 3534.

Does anyone know any other way to create a new instance in mysql, with new password, new port etc?

I did this recently on Sql Server and it’s quite simple, just install again that a new instance is created.

Answer 1

You could use the mysql_multi to run two database instances on the same server. You should note that to have a great advantage over this configuration, the ideal is to use each database about hard drives different from the server. Since the biggest bottleneck is usually on the disk. The settings keep the same originals in my.cnf the difference is that you will have to create two blocks server with the different configurations for each seat.

There are several extensive documentations about mysql_multi I’m attaching this how to mysql how it is configured but can perform other searches.