Linux

Managing MySQL with MySQL Workbench

This week's techmail was Managing MySQL with MySQL Workbench. I've always been a CLI guy when it comes to MySQL (as with most things: mutt, irssi, etc.), and when I needed something GUIrific I went with phpMyAdmin. However, I've looked at MySQL Workbench and I like what I'm seeing. The tip discusses what makes make MySQL Workbench appealing for me.

Read More

Linux

Why PostgreSQL is a better enterprise database than MySQL

This week's techmail is Why PostgreSQL is a better enterprise database than MySQL which takes a look at what makes PostgreSQL a compelling database, when compared to MySQL. Particularly in light of the whole Oracle/MySQL thing, I think it's good to remind people that choice still exists, and that the "runner up" might actually be the better choice. This one mostly focuses on authentication, but that is definitely one area where PostgreSQL ...

Read More

Linux

Set up rsyslog to store syslog messages in MySQL

This week's TechMail is Set up rsyslog to store syslog messages in MySQL which gives a brief rundown of how to setup rsyslog to log messages in a MySQL database so that you can use a viewer such as phpLogCon in order to view/filter them. For me, this is a novelty thing more than a practical thing... grep is much more efficient and if centralized storage is what you need/want, rsyslog can do ...

Read More

Linux

Firewall MySQL with GreenSQL

This past week's TechMail is Firewall MySQL with GreenSQL which talks about a really cool little application-level firewall that sits between your database-accessing code and MySQL. Really neat concept and although I've played with it a bit, I need to find some time to really dig into it as I can really see it being useful (especially in a web-hosting environment where you don't really know what other people are running or whether ...

Read More

Linux

Configure Snort to log packets to MySQL

This week's TechMail is Configure Snort to log packets to MySQL which looks at using MySQL to store snort logs and BASE to view them. Already there's a comment there about someone wanting to know how to do it on Windows. I'm sure it's possible, but my first instinct was to reply "you can't". Someone has a case of snort envy perhaps?

Read More