Posts Tagged ‘slave’

MySQL Server Replication with ssl

In: Bushan| Linux| MySQL| Replication

4 Mar 2010

TYPES OF MYSQL REPLICATION

*

Statement-based Replication
*

Row-based Replication
*

Mixed

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

Getting Rid Of MySQL Binary Logs

In: Database| Maintenance| MySQL

25 Jun 2009

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

The Beauty of mysqlcheck

In: Database| Maintenance| MySQL| Repair

22 Jun 2009

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

When to use MySQL BlackHole Tables

In: Database| Maintenance| MySQL

14 Jun 2008

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

Quick and Dirty DRBD with HA

In: Database| Linux| MySQL| Replication

6 May 2008

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

Categories

Archives

Copyright © 2009 - Hack Admin - is proudly powered by WordPress | Log in

Based upon Compositio Theme, created by: Design Disease.