Archive for the ‘MySQL’ Category
MySQL Server Replication with ssl
In: Bushan| Linux| MySQL| Replication
4 Mar 2010TYPES OF MYSQL REPLICATION
*
Statement-based Replication
*
Row-based Replication
*
Mixed
To change the type of Replication modify my.cnf configuration file and change
- No Comments
- Tags: Linux, MySQL, Replication, slave, SSL
How to Recover a Lost MySQL Password
20 Feb 2010This article explains the process that will allow you to recover a lost MySQL password:
Stop the MySQL server process
Identifying Slow MySQL queries
In: Aashish| Linux| Monitoring| MySQL| Scripts
13 Feb 2010MySQL can sometimes create big problems on a server when you have users abusing it.
This article will teach you how to correctly identify the queries that are creating a problem for your server.
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 [...]
- No Comments
- 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 (10)
- Amazon (1)
- apache (2)
- 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 (22)
- Maintenance (5)
- Monitoring (2)
- MySQL (8)
- 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)
- LDAP Authentication In Linux | Hack Admin: [...] Aashish [...] [...]
- MySQL Server Replication with ssl | Hack Admin: [...] Bashan [...] [...]
- IP Failover For Web Cluster | Hack Admin: [...] Aashish [...] [...]
- zkfabqp: ukzQkJ qaleealvzpma, [url=http://bdwntfifheie [...]
- How to Recover a Lost MySQL Password | Hack Admin: [...] Aashish [...] [...]