Archive for the ‘MySQL’ Category

MySQL binary log rotation

We are running a MySQL replication setup, and find that the binary logs get very large, very quickly. Since MySQL didn’t come with a log rotation script, we rolled our own. Usage is simple:
At the top of the script are some definitions that you need to change for your setup:

MYSQL_USER MYSQL_PASS - You [...]

Enabling GD library for PHP 4.4.4 on Mac OS X

For some reason, GD is not enabled in the default Mac OS X build of PHP 4.4.4. Here’s an easy way to install. Make sure you have the following fink packages installed:

libpng3
libjpeg

1. Download the source code for PHP 4.4.4
PHP 4.4.4 source
2. Unpack the source
tar jxvf php-4.4.4.tar.bz2
cd php-4.4.4
3. Compile and install the GD extension

cd [...]