Shulou(Shulou.com)06/01 Report--

To test the Mysql group replication mechanism, create multiple mysql instances on windows. The steps are as follows:

First, create a folder to store the data files of database

For example, create a separate folder: d:\ Server\ mysqlS1\ data

Second, create a separate configuration file and modify the port and datadir in it

You can make a copy of the original my.ini and modify the configuration.

-

Datadir=D:/Server/mysqlS1/data

Port=3307

-

This step is not necessary, but through the configuration file, you can reduce the parameters used when the command line starts

Third, initialize the data folder

Mysqld-defaults-file=s1.ini-initialize

S1.ini is the previously modified configuration file

Fourth, start a new instance

Mysqld-defaults-file=s1.ini-console

Fifth, access to new instances

Mysql-u root-P 3307

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.