any of you fine people use mysql replication + ssl in a production environment? any issues to warn about?
-
-
@Pinboard query that runs on master but (for any reason) fails on slave .. of course, mysql's first rate error logs are v helpful </snark>Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
@Pinboard networking burps (possibly, maybe), or cross db queries, where one of the dbs isn't replicated ... -
@mintywalker got it. I assume you're familiar with the various percona tools for 'managing' replication? They help a little - Show replies
New conversation -
-
-
@Pinboard if an autoincrement index gets out of sync, 'cause you accidentally do an insert on the slave (thus, duplicate key clashes) -
@mintywalker and I've found it a lifesaver to have auto_increment_offset, avoids collisions and tells you what machine a row was saved on - Show replies
New conversation -
-
-
@Pinboard all stuff that "should never happen". I'd say I average once every ~12-18 months or so. Often around major server sysadmin workThanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.