Re: Multiple Slave instances on same machine
Posted by:
Adam Nelson
Date: September 05, 2017 11:59AM
Running multiple instances is done commonly for testing or development so it's technically possible. I don't think it would be recommended in any production environment due to it's single point of failure and potential resources constraints (2x the network activity, 2x the IO requests, not to mention memory).
If you are going to run multiple instances you are correct in that they will need separate ports and separate data directories. They will also need separate configurations (either separate config files or alternatively you can specify these via CLI switches) in which you will need to specify different log locations, different socket file locations, different tmp locations (for best preformance), different bin file locations, and other items. The 5.7 manual actually has a section on this.
The 5.7 Manual has details on this :
https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html
Subject
Views
Written By
Posted
598
August 31, 2017 11:49AM
Re: Multiple Slave instances on same machine
538
September 05, 2017 11:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.