Posts Tagged ‘Replication

TYPES OF MYSQL REPLICATION

*

Statement-based Replication
*

Row-based Replication
*

Mixed

To change the type of Replication modify my.cnf configuration file and change

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 [...]

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 [...]


Recent Posts