MySQL Forums
Forum List  »  Replication

Re: Database connections to Slave
Posted by: Jesse Toninger
Date: November 15, 2018 03:29PM

There are definitely more qualified people than me on these boards to answer this but in the interest of community, here goes.

In a typical setup your slave server would be set to read only, as in the case of most applications the vast majority of database operations are reads. Your application would then be structured to send any write operations directly back to the master, which would then push down.

It requires your knowledge of what your application is doing at a given time to manage this.

You CAN set up writable slaves, or Master-Master replication, but these come with a whole host of other potential risks others could speak to better than I. You basically better be sure you would never have conflicting data entered into both databases at once.

Speaking very much as a DB layperson, stick with Read-Only slaves unless you have a specific reason why that wont work

Options: ReplyQuote


Subject
Views
Written By
Posted
648
November 13, 2018 01:45AM
316
November 13, 2018 10:01AM
Re: Database connections to Slave
339
November 15, 2018 03:29PM


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.