Skip to content
This repository has been archived by the owner on Sep 13, 2018. It is now read-only.

really stress test DB replication #11

Open
binary1230 opened this issue Oct 10, 2014 · 1 comment
Open

really stress test DB replication #11

binary1230 opened this issue Oct 10, 2014 · 1 comment

Comments

@binary1230
Copy link
Contributor

I don't know the full extent here but this happened at Magfest 8.5

the internet went down for an entire day of registrations. when it came back, the slave server was out of sync with master.

this has something to do with a maximum size of the transaction logs (WAL logs) that can be sync'd without any intervention.

we should ensure that no matter how much data has changed, and however long the slave server has been offline, that the database is in a valid state on the slave after it sync's.


unrelated: a way to detect when this invalid state is occuring would be useful as well.

@binary1230
Copy link
Contributor Author

mental note: investigate streaming replication as a solution to this.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant