LegalySpace

MySQL update and optimization
SOFTWARE PUBLISHING
September 2021 – October 2021 (1 month)
France, France

Initial context

Legalyspace, a fast-growing company, is requesting a DBA Expert for migration and professional support.

Customer requests

• An audit of MySQL 5.1.56 databases
• Improved performance
• Professional support in deployment
• Script to save MySQL to a local directory
• Dividing an ibdata1 file into individual table files

Expertise delivered

• Optimization of BBD settings
• Professional guidance and support for the migration with the writing of a step-by-step procedure.

Deliverables

• An audit of MySQL configuration and performance problems in the form of a list of recommendations
• Step-by-step deployment plan to migrate MySQL to the new desired versions + idbdata1 included by table partitioning
• Troubleshooting assistance regarding possible application issues related to the MySQL upgrade on two client migrations.
• Proposal for an index and/or SQL rewrite for the TOP 5 slow queries to improve
• Alternative my.cnf configuration settings
• mysqldump backup script that can backup locally on a volume

The audit methodology

1. An analysis of the database configuration, structure and indexes
2. An analysis of slow query logs
3. Testing Alternative Configuration Options in MySQL
4. Rewriting the first 5 slow queries and/or index proposal

The migration methodology

1. Development of a deployment plan to migrate MySQL to newer versions:

• 5.1.56 to 5.5
• 5.5 to 5.6
• 5.6 to 5.7
• 5.7 verse 8