If you run a website, you are most likely running a database underneath. The de facto free database for internet applications is without a doubt MySQL. However, running this can be a bit overwhelming if you’ve never touched a database before. Here are 20 resources for getting you starting with MySQL, covering everything from installing to optimizing your queries to perform better:
In the Beginning
- THE Getting Started Article
- EasyPHP – PHP/MySQL/PHPMyAdmin Quick Install
- PHP MySQL Tutorial from Scratch
- WAMPServer – Another quick install
- How to Setup a Load-Balanced MySQL Cluster
- MySQL GUI Client Tools
- A Guide to Stored Procedures
Advanced Topics
- Securing MySQL
- Backup MySQL Databases Automatically
- Optimizing MySQL
- Dos and Dont’s of MySQL Connection Management in PHP
- Mirror Delicious Bookmarks into a MySQL Database
- How to Setup Database Replication
- 10 Tips for Optimizing MySQL Queries
- Benchmarking MySQL on the Amazon Cloud
- Turn MySQL into XML
Reference
- Official MySQL Reference Manual
- MySQL Official Developer’s Zone
- phpMyAdmin
- Useful MySQL stuff
- Language Cheat Sheet
- MySQL Performance Blog
- Google’s MySQL Performance Tools
Have any other gems you’d like to share? Send me a comment and share it with the world!
Leave A Comment