Best Practices with Mysql Databases

• Stored Procedures should not be used.
• All Queries taking more than 500 ms are classified as Bad Queries and will be considered as Blocker Bugs
• No unnecessary complex joins and no shared databases across multiple applications/services.
• Every database should have it's own Access Control
• Connections and Throttle Limits should be setup.
• Schema Migrations should not have any down time.
• Every database should have a Candidate Master and Multi-Redundancy
• Every database should have Orchestration setup with auto failure mode setup.
• All databases should be part of Monitoring