Create new instance in MySQL

Question

Create new instance in MySQL

Navigation

#1 by (0 votes)

1

I'm trying to create a new MySQL instance on a machine that already has it installed. I made the manual process of creating a new directory and configuring the .ini file, however at the time of starting the service the following error is displayed:

The "InstanceName" service can not be started

For more help, enter NET HELPMSG 3534.

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

I recently did this in Sql Server and it's pretty simple, just install again that a new instance is created.

mysql

asked by anonymous 16.07.2017 / 19:58

1 answer

Backup and Restor Mongodb - Methods How to receive id's in the controller / model

score 0 · Accepted Answer

You could use mysql_multi to run two bank instances on the same server. You should note that in order to have a great advantage over this configuration, it is best to use each database on different hard disks 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 server blocks with the different settings for each bank.

There are lots of extensive documentation on mysql_multi I am attaching this how to mysql how to configure it but can do other searches.