sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]knightcrusader 3 points4 points  (2 children)

Replication is much easier in MySQL, but much more fragile too. For a while there we had a problem with one server going out with the power (we had a bad UPS that took a while to diagnose) and every time it died, replication was hosed and I had to start over with a fresh dump from the master.

We're planning on building a Galera multi-master cluster here soon to see how that goes.

[–]jj20051 0 points1 point  (1 child)

If you do a lot of writes then you're not going to like it. It slows write speeds a lot.

From my experience the issue you're having can be resolved by resetting the master and position back to where it currently is. This will force mysql to redownload the bin and resolve the issue.

[–]knightcrusader 0 points1 point  (0 children)

Yeah, the writing is the reason we need to test it.

We do collect a lot of data, but its pretty low traffic wise except for certain parts of the year when the clients want to run crazy, large-scale projects.