O'Reilly has published
a tutorial that shows how to manage a MySQL database.
"MySQL is a complex piece of software that may seem overwhelming when you're first trying to learn it. This article describes a set of best practices for MySQL administrators, architects, and developers that should help in the security, maintenance, and performance of a MySQL installation.
"
(Log in to post comments)
The first one is to use a real DBMS.
Posted Jul 19, 2002 10:54 UTC (Fri) by leandro (guest, #1460)
[Link]
All the tips are very fine, but then why not go the extra mile and upgrade to a real DBMS, such as PostgreSQL, SAPdb or InterBase or Firebird?
It's the way of programmers to create something very simple and then add layer after layer of complexity, after what the end result gets worse and more complicated than the full solution they should have gone for in the first place.