Create multiple MySQL server instances on one computer (Windows) | Free template

Here you can download a free tutorial to create and run multiple MySQL server instances on one computer by installing multiple Windows services for MySQL.

There may be many reasons for installing more than one MySQL server instance on one computer such as the use of one server instance only for testing, to provide different server instances for different customers (web host) or to test a scalable architecture with multiple database servers. You can have several different versions of MySQL Community Server on one computer that runs as separate server instances.

When MySQL Community Server is installed for the first time is there a wizard to use for configuration of the first server instance of MySQL and it is recommended that you run this wizard when you install MySQL Community Server. When you want to add more server instances of MySQL then you can use this template with a free tutorial to create multiple MySQL server instances on one computer.

Every single instance of MySQL server needs its own configuration file, its own address (IP address and port) and must run as a separate Windows service that starts automatically when Windows starts. A unique address for a MySQL server instance can be created by assigning a unique IP number or a custom port to the server instance in the configuration file.

In this template with a free tutorial to create and run multiple MySQL server instances have we in detail described how the configuration files should be created, how Windows services are installed and how to connect to server instances from MySQL Workbench. Updated: 01/01/2015 | Created by All-templates.biz

Download Create multiple MySQL server instances on one computer (Windows) | Free template »

Tags: server management