Linux How To's

PyMyDB Backup 0.5.1

The first version of PyMyDB Backup has been released and is based on Python 2.4.3. This is a Python script that will back up your MySQL databases, calculate the size of the backed up files, tarball and compress the contents, then email the results. To use:     Download the EPEL Read more…

By jason, ago
mysql

MySQL Replication

​Setting up MySQL replication is an easy process to do. First you need to edit your my.cnf files on your two servers and add the following: Server 1     server-id=1     auto_increment_offset=1     auto_increment_increment=3     log-bin=mysql_log Server 2     server-id=2     auto_increment_offset=1     auto_increment_increment=3     log-bin=mysql_log Make sure that the Read more…

By jason, ago