SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Evangelist goughb's Avatar
    Join Date
    Sep 2000
    Location
    Chicago
    Posts
    526
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Multiple MySQL Servers on Windows

    Greetings,

    Does anyone know how to set up two mysql servers on one windows box? I know mysql has documentation for a unix box but nothing for windows. Any thoughts?

    Here is the unix documentation:
    http://www.mysql.com/doc/M/u/Multiple_servers.html

    Thanks,

    Brett

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i was trying to do this too (to have 3.23 and 4.0).

    problem is that they both want to use the same my.cnf/my.ini. SO, when i want to run the other one, i have to edit the my.ini and change the datadir variable and any others that i want/need to change between the versions.

    kind of a pain.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  3. #3
    SitePoint Evangelist goughb's Avatar
    Join Date
    Sep 2000
    Location
    Chicago
    Posts
    526
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ah, I figured it out... Unfortunately you cant run it as a service. But, you can enter it in the registry in the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run

    In that key make two new strings these strings contain the full path to the application:
    C:\mysql\bin\mysqld-max-nt.exe

    *FIRST TEST IT THEN DO THE FOLLOWING*
    C:\mysql\bin\mysqld-max-nt.exe --console --port=3306

    Now on the first one put this:
    C:\mysql\bin\mysqld-max-nt.exe --port=3306

    on the second this:

    C:\mysql2\bin\mysqld-max-nt.exe --port=3307

    I put them in different directories (hence mysql, and mysql2) but, you can possibly pass it the a switch to change the base directory. Unfortunately mysql on windows doesn't have an individual service specific config file. It only looks in the root of the hard drive and the root of the system folder. But, mysql's distributed documentation says otherwise. Yet, its online documentation agrees with this theory. Sorta whack. Hope my 4 hours of toiling on this helps..

    Brett


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •