Setting up two MySQL servers on the same machine?

Hi Guys,

Is it possible to set up two MySQL servers on the same machine on Win32
(Windows XP Pro)? I currently have one MySQL server running that is used
for doing all my web development, which is a copy of the main web server.
Since this is a test database I regularly sync the real database to it to
restore it's contents, but while testing it accepts both reads and
writes.

I am now starting on a project where I want to set up a local MySQL
server that will be a read only SLAVE of that MASTER web server, so that
writes will go out to the real MASTER server on the web, but reads will
come from the local SLAVE. This will solve the performance problem I have
so that regular reads (99% of the transactions) will be blindingly fast,
but both the server on the web and the local machine will remain in sync.

Of course I also still want to be able to do local web development on my
machine so I still want a read/write server on the box that is used by
the local web server for testing and development (and debugging with Zend
Studio).

Hence I need to figure out how to set up two servers running on the same
machine. One will be my test database server and one will be the slave
for my new project. I assume one of the servers will have to run on a
different port (probably my slave to make it easier as then my test web
code won't need changing ;-), but how can I get MySQL to start two
servers on the machine?

Thanks!

---
Kendall Bennett
Chief Executive Officer
SciTech Software, Inc.
Phone: (530) 894 8400
http://www.scitechsoft.com

~ SciTech SNAP - The future of device driver technology! ~



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org