MySQL Workbench
This video explains why so many DBAs and developers use MySQL Workbench every day to designs, develops and administers MySQL databases. [youtube s-KIpKjDMNI]
Category: MySQL
DRBD and MySQL: High Availability Match Made In Heaven
DRBD is popular as a good low-cost high availability solution for MySQL. It offers synchronous data replication without MySQL having to worry about the details. You can avoid some of the problems of MySQL’s statement based replication and configuration file complexity. [youtube YHfGZNQAhNg]
Working with MySQL and SUM
In this screencast, you are going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. We will be combining them to come up with some useful queries. This can reduce the number of queries you need to run for fetching certain types …
PHP/MySQL User System: Validation
This video shows how to add validation to a registration form. We validate name, email, and password, as well as display error messages to the user. Producer: ThinkVitamin
PostgreSQL versus MySQL
A comparison between the two databases presented by Ed Boyajian, the CEO of EnterpriseDB. Video Producer: NYC MySQL Group
The Gunson Rules of Database Administration
A common-sense list of 10 or so dos and don’ts of being a DBA that I have realized over the years. It includes rules such as: * When someone says “just test that on the production database”, don’t. * Debugging and optimizing SQL is a fun and easy way to …