Unanswered: Setting up multiple instances of MySQL databases (was "The Best Method?")
This thread may be similar to my last one, however upon looking back at my old thread, I cannot seem to see the responses. Either way, here is what I am trying to do.
Scenario: Setting up multiple instances of MySQL databases on the same server. I've never done this with MySQL.
In doing my research is this the same as running multiple MySQL Servers on the same machine? The reason that I ask is that in the MySQL Ref Manual it seems to make reference to this where I would be running the 'mysqld_multi' to manage all instances. Is this true? And if so, it seems as though setting up multiple instances is somewhat convuluted. Any help or advice would be GREATLY appreciated
What is the best method for setting up multiple instances on a MySQL server?
With setting up multiple instances on a 4.1 Server, I have tried just modifying the my.cnf to include say 5 variations of the values that appear under [mysqld] and it does not seem to work. It would be great if there was a tool that would allow you to setup multiple instances on a server, rather than just one.
I am setting this up on Windows 2000 Server. This is a test server, so I am just trying to figure out how to create instances. Currently I've created 10 my-#.ini files and each has a different port and data directory. I couldn't find where I could change the socket name for each instance.
Currently I have MySQL Server 5.0 installed on a Windows 2000 Server. There are 10 my-# ini files as I need 10 instances of MySQL. I've created one MySQL service for each instance, however upon either:
a) running net start MySQL#
b) starting the MySQL# service from Administrative Tools - Services
In both cases it seems as though only 2 instances will start, and then I'll get a 1067 error. I then read through the online documentation for this 1067 error and I cannot seem to move forward.