Archive for the ‘Database’ Category
Getting Rid Of MySQL Binary Logs
In: Database| Maintenance| MySQL
25 Jun 2009If 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 [...]
- (1) Comment
- Tags: binary, binary logs, logs, master, MySQL, mysql master, MySql Slave, slave
The Beauty of mysqlcheck
In: Database| Maintenance| MySQL| Repair
22 Jun 2009I 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 2008We 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 2008I 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 [...]
- (1) Comment
- Tags: DRBD, failover, file system, filesystem, ha, Linux, master, mount, MySQL, Replication, server pair, slave
Recent Posts
Categories
- Aashish (11)
- Amazon (1)
- apache (3)
- Audio (1)
- Backup (2)
- Bushan (1)
- centos (2)
- cluster (1)
- Database (4)
- Education (3)
- Hack Admin (1)
- Hardware (1)
- iptables (2)
- Key Strokes (1)
- Khaled (3)
- LDAP (1)
- Linux (23)
- Maintenance (5)
- Monitoring (2)
- MySQL (9)
- Network (5)
- OpenVPN (1)
- Repair (2)
- Replication (2)
- S3 (1)
- Scripts (4)
- Security (5)
- Software (3)
- TCP/IP (5)
- ubuntu (7)
- Windows (1)
- Workaround (3)
- freedom yourself: Apache Modules and Their Functions | Hack Admin... A transformational MMO that's n [...]
- 3 Thirty 6 Publications: 3Thirty6 Publications... solid post my dad does this kind of work BUT last thing i [...]
- best online casinos: on line casino... The online casino and gambling industry is one of the most rapid [...]
- onebuckresume: TeenVogue? {Looking|Searching|Seeking} for fashion advice, celebrity buzz or beauty trends? [...]
- CARLTON: B [...]