I am a Junior DBA at Mydbops. This is my first blog professionally, I would like to brief my encounter with Log-rotate in first few weeks of my work, Hope it will help other beginners as well. This Blog will cover the following sections. Introduction to Log-rotate Issues FacedSolutions (Fix for the above issues)Best practicesHow … Continue reading Configuring efficient MySQL Logrotate
Introduction: At Mydbops we support a good number of clients on AWS cloud (Aurora and RDS). Amazon Relational Database Service (RDS) is providing the cloud based database service. It is the cost-efficient, resize able & ease to manage. As in any other DBaaS, If you need to analyse the log files (Error log / Slow … Continue reading Reading Amazon RDS MySQL/Aurora log file from terminal.
This presentation was made at LSPE event in Bangalore (India) held at Walmart labs on 10-03-2018. This presentation focuses how we have harnessed the power of Ansible at Mydbops.
At MyDBOPS we focus on faster database operations. So we have build our own set of our tools and also we use standard open source tools. Percona tool kit and Xtrabackup are some of the prominent tools we use. This is presentation about a few percona tool that every DBA should consider using it.
This presentation by MyDBOPS team shows the various monitoring commands and tools in Linux for the effective operation of DBA's. As more than 90% of MySQL servers runs on Linux OS it becomes mandatory for DBA's or DevOPS to team to be efficient in Linux monitoring and Troubleshooting.