Basically, Auditing is the process of monitoring and recording the activity happening inside the Server. MariaDB Audit Plugin works with MariaDB, MySQL and Percona Servers. It is used to log the database Operations like, SQL Statements, User informations, Connections. The information is stored in a user defined log file or in Syslog. Available audit plugins … Continue reading Integrating MariaDB Audit plugin in MySQL 5.7
We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard. PMM has many advantages Easy to deploy (docker based) Flexible Customizable Query Analytics One-stop solution for MySQL,Mongo,ProxySQL … Continue reading Setting up a High Availability for PMM
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.