Re: Replication port configuration(3307)
Posted by:
Rick James
Date: February 15, 2016 04:47PM
Eh? You want to use 3306 for regular access, but 3307 for Slave access? Why?
The Slave (and only the slave) should be GRANT REPLICATION SLAVE ON *.* ... -- That is the security.
Do you have some other reason for the split?
Normally, all accesses are via 3306. If you want 2 instances of MySQL on the same machine (and same VM/IP), then you should look into a separate Port.
Master-Master is simply two Masters that are also Slaves to each other. Recommend you write to only one of the Masters, though.
Subject
Views
Written By
Posted
1468
February 08, 2016 02:26AM
Re: Replication port configuration(3307)
1274
February 15, 2016 04:47PM
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.