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
[edit]Policies
[edit]How-to...
[edit]- ...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