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 wikitech: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#SQL_errors
  • 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