MySQL Forums
Forum List  »  Replication

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
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.