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
Linux How To's

MySQL Backup Scripts

I needed a place to host my scripts, so I opened an account on GitHub. If you are unaware of what GitHub is, its a great place to publish code to the public by using Git; they also offer private hosting for a fee. Even if you do not have 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