Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Running two diff MySQL versions at once?

I would like to upgrade my Wordpress. I share the server with other people. Wordpress upgrade will require a MySQL upgrade (from 4.x series to 5.x series). I could upgrade the MySQL, but I fear that would break other people's applications and force them to upgrade as well. So I'd like to run two MySQL, keeping the existing 4.x series for legacy apps and another 5.x series for newer apps. What needs to be done to do this?

1 Answer

Relevance
  • 1 decade ago
    Favorite Answer

    It's not complicated at all.

    The main thing is to run them on different ports. When you specify in your applications where to connect for an older version to its regular port, for others - new port.

    You also must have different socket, shared memory base, pid file.

    If you want logging - make sure they have separate logging files.

    so next options must be unique for each instance:

    --port=port_num

    --socket=path

    --shared-memory-base-name=name

    --pid-file=file_name

    for logging:

    --log=file_name

    --log-bin=file_name

    --log-update=file_name

    --log-error=file_name

    --bdb-logdir=file_name

    Addition:

    Here is a good description for both *nix and Windows.

    http://dev.mysql.com/doc/refman/5.0/en/multiple-se...

Still have questions? Get your answers by asking now.