If you’re in charge of a mysql database that does any sort of volume, you might find yourself in the peculiar situation where your binary logs have piled up to an unmanageble level. Typically you’ll use the binary logs for replication from a master server to a slave. This may not always be the case [...]
I manage a ton of mysql databases, from single wordpress instances, to clusters, to systems that have a core data structure that selectively replicates out to as many as 50 systems. Fortunately, or maybe not, they seldom have issues and after setup, other than disk space issues, I seldom have to touch them.
Recently, as I [...]
We read about the black hole table type a long time ago and it’s kind of been a running joke – why in the hell would somebody want to insert into a black hole? Many times it’s been suggested as the solution to all of our data problems… Just swap out all the InnoDB [...]
I had to dig a while on this one. I think it was mostly because it took me a while to get what was going on. Basically, I have 4 server pairs that I needed to setup. Three where to be mysql instances, a master instance, a slave instance that was only [...]