0

I am Avinash.

I am willing to install an additional MySQL instance on a UAT server for testing purposes. I am using MySQL Community Server 5.5.58 installed on RHEL7.2.

I am going through the MySQL Docs https://dev.mysql.com/doc/refman/5.5/en/multiple-servers.html , which tells me that I would require certain unique operating parameters such port, socket, pid, datadir and log files related parameters. To achieve better performance, it also recommends to use different tmpdir. This is well understood.

I can either use different binaries or the same binary for this purpose.

If I am using same binary, I'll have to use mysqld_multi and use the same config file. If I use mysqld_multi, I'll have to put different sections for mysqld daemon such as mysqld1, mysqld2 and so on. All using unique values for above mentioned operating parameters.

Please help me out here. Am I correct about mysqld_multi?

My second question is about bind-address variable. https://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_bind-address Here, it explains that "The MySQL server listens on a single network socket for TCP/IP connections. This socket is bound to a single address, but it is possible for an address to map onto multiple network interfaces."

My question is that will I need an additional NIC and an additional IP address for the second MySQL instance?

For the existing instance, I have disabled the bind-address option. Do I need to add the bind-addresses for both the instances.

Also, the second instance will be used only by me (for now).

Thanking you.

Improve this question
2
  • I don't have MySQL Sandbox or Docker.
    – Avinash Pawar
    Commented Mar 13, 2018 at 12:34
  • I thought that mysql_multi was dead (or at least not supported).
    – Rick James
    Commented Mar 15, 2018 at 0:37

1 Answer 1

Reset to default
-1

why dnt you start new instance with different cnf file (keeping diffrent PORT and diffrent socket file)

for example :

cd /opt/mysql_installation/u01/mysql_5.7.17/bin/ ./bin/mysqld_safe --defaults-file=/opt/mysql_installation/my.cnf &

Improve this answer
3
  • --> well, I'm going to try that definitely, but my second question is about bind-address. what about bind-address? do I need additional NIC and IP? Thank you for your reply.
    – Avinash Pawar
    Commented Mar 14, 2018 at 10:44
  • Use a different port, not diff IP.
    – Rick James
    Commented Mar 15, 2018 at 0:37
  • you dnt need any other ip , as same ip with diffrent port will work for you
    – shyam rakhecha
    Commented Mar 15, 2018 at 11:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.