Oracle Certified Professional (OCP) with 8 years of experience specializing in database administration, project design, and development in MySQL.
Services:
- I will Configure MySQL InnoDB Cluster including shell and router.
- Configure load balancing by routing read traffic to the read-only replica.
- Perform MySQL InnoDB cluster database tuning on slowness and hang troubleshooting.
- Configure MySQL Enterprise backup full and incremental and schedule it with crontab.
- Perform InnoDB cluster instance and memory level tuning.
- Optimize queries to enhance performance by creating indexes based on the execution plan.
- Switch database roles between the instances without downtime for maintenance activity.
- Configure MySQL Enterprise monitoring tools to ensure comprehensive health monitoring.