This article is a part of our Rockstar DBA initiative, a platform for thought leaders to share their knowledge and make a positive contribution towards the database management community.
Manojit Paul, with more than 19 years of professional DBA experience in enterprise database solutions, especially Sybase product set and database infrastructure is our first Rockstar DBA.
Let’s hear from Manojit about how he manages MySQL databases, why he loves Monyog, his advice to young DBA’s and more.
How do you manage your MySQL databases?
We presently have 9 MySQL servers in production trading environment, all being managed via a host of automated scripts which I’ve created and manual intervention when issues are reported. We deploy Monyog for managing 5 of these critical MySQL instances.
What are your biggest challenges when dealing with MySQL databases?
MySQL is not real enterprise class (evident from Gartner Reports omissions) and the rest of our database infrastructure relies on Sybase ASE and replication platform used for actual trading and logistics. We do have selective schema replication in MySQL but lack of proper scaling and optimization is a challenge.
How does Monyog help you? What’s your favorite feature?
We deploy Monyog for the MySQL monitoring and its web based dashboard helps with quicker problem identification and resolution. What I really like about Monyog is the dashboard with real-time statistics along with the charts displaying the overall performance metrics.
Do you use other tools to manage your MySQL servers?
We do not use any other MySQL related tools except the dbadmin scripts I have written.
According to you, what is the future of MySQL?
I want MySQL to compete with Percona/MariaDB and keep up with the feature sets that are still missing, like object level replication and online database backups and more support for the community version too.
What advice can you offer to young enthusiasts who want to pursue a career as DBA?
I personally follow these basic rules. Not sure who gave these to me, they are helping me all along my professional life.
- Assume nothing
- Have contingencies
- Plan and Execute with precision
- Strive for Zero Defect work
We are thankful to Manojit Paul for sharing his thoughts with us. We would love to hear your feedback as comments about our Rockstar DBA initiative.
Sharing is caring. If you are a DBA who has something significant to offer to the community, we welcome you to be our next Rockstar DBA. Just send an email to us at firstname.lastname@example.org