User:ASarabadani (WMF)/Database for developers toolkit

This tries to help developers have a handbook for their day-to-day work that depend on databases.

Concepts

 * Glossary
 * Choosing storage technology
 * Normalization

Policies

 * MediaWiki database policy
 * Manual:Coding conventions/Database

How-to...

 * ...write code accessing database
 * ...write a schema change patch
 * Note: Once schema change is merged, it won't be automatically applied to WMF production. See Schema changes on how to make it happen.
 * ...handing database transaction and other advanced issues such as handling replication lag
 * ...make queries against production (for testing or understanding)
 * ...debug
 * For local debug see: See Manual:How_to_debug
 * For general logs of production traffic see User:ASarabadani (WMF)/Database for devs toolkit/How-to/Monitor
 * ...monitor (to see impact of your changes)
 * ...improve performance
 * ...do a data migration in production

Resources

 * Training accessible to WMF and WMDE staff (In Google Drive)
 * Books:
 * High Performance MySQL