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 shines over MySQL (among many others).
Tag Archives: mysql
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 they’ve upgraded, etc.).
Improve MySQL performance with MySQLTuner
This week’s techmail is Improve MySQL performance with MySQLTuner which discusses how to use the MySQLTuner perl script to tune the MySQL server to ensure you’re not over-committing resources, that your configuration is sane, and giving helpful pointers on how to optimize your MySQL databases.
Use command-line MySQL for additional flexibility
This week’s TechMail is Use command-line MySQL for additional flexibility which delves into some quickie commands useful on the MySQL CLI client, such as setting prompts, using mysql output in scripts, etc.
