Just a heads up, if you do decide to enable OpenSSL so you can do encrypted MySQL replication. There are two bugs that will affect replication and the mysqldump command. They're as follows:

Bug #24148 regression tests hang with SSL enabled
http://bugs.mysql.com/bug.php?id=24148
http://lists.mysql.com/commits/17286

Bug #27669 mysqldump: Got error: 2026: SSL connection error when trying to connect
http://bugs.mysql.com/bug.php?id=27669
http://lists.mysql.com/commits/24329

This may cause lots of problems with MySQL and SSL Replication using OpenSSL.

Cheers!

AutoMySQLBackup is a shell script that allows daily, weekly and monthly backups of your local and remote MySQL Databases. It's meant to run on Linux/Unix through a cron job. Its highly configurable, and easy to setup as I will show you today!

First you will need to acquire the shell script and drop it on your server. You can download AutoMySQLBackup on their SourceForge Project Page

I woke up to a very big announcement today. I was browsing digg and found that MySQL was acquired by Sun Microsystems. You can read more about the acquisition on the MySQL blog of Kaj Arno about the acquisition of MySQL by Sun Microsystems. My take, with Sun releasing Solaris into the Open Source realm, this is just another piece of software that they can put under their belt and package with Solaris. I have included some blurbs from Kaj Arno's blog below.

Heres an article that helped me with an issue over at a friends site http://www.ftatalk.com
Their site was exploding and they need to tune out the current server as much as possible. One thing that I noticed was that MySQL wasn't tuned properly. So After making some changes and finding out that there was no thread caching, I searched the web and found this article.

Wow, it's been a busy week. I was totally swamped for several days dealing with the remember.yahoo.com MySQL servers and related stuff. And then I used a day or two to recover (sleep, shower, etc).
Anyway, I made some interesting discoveries along the way. The most surprising one had to do with thread caching on Linux when you have a busy MySQL server--busy in a particular way, mind you.

Read the full article at jeremy.zawodny.com

***UPDATE*** I have moved ftatalk.com over to lighttpd and its doing wonders! You can also check out the ftatalk.com mirror at http://www.satfix.net
I will also be writing an article about lighttpd and how it can help you get the most out of your hardware.

If you've ever required OpenSSL support enabled for MySQL Server 5.0 under debian, then you will need to recompile MySQL. Under Debian this is very easy.

This application suite is quite the AIO (All in One). I have used eGroupware, and was a joy. I was trying to find more projects to create in it than actually using it to manage them. This is defiantly an application you want to check out and play around with.

OfficeSpot.Net Collaboration Server Preview 2 (Default branch) - The OfficeSpot.Net Collaboration Server is a
one-stop solution for all your groupware needs. It
is based on Ubuntu 6.06 LTS and is preloaded with
eGroupWare, Postfix, OpenLDAP, MySQL, DBMail,
Spamassasin, and ClamAV.

License: GNU General Public License (GPL)

Changes:
This release contains updated versions of eGroupWare (1.4), DBMail (latest stable SVN revision), and ClamAV (0.90.3). The installation process was streamlined and the online documentation was updated.

[FreshMeat]