Synopsis of Mydbops 10th edition of opensource database meetup

We're ecstatic and energised at the prospect of sowing the seeds of knowledge in our opensource database community. Thank you to everyone who came out to our 10th opensource database meetup. Our meetup series began in 2018, and the 10th edition took nearly three years to complete. However, we prioritised quality above quantity when distilling. … Continue reading Synopsis of Mydbops 10th edition of opensource database meetup

Webinar Summary: Migrate your EOL MySQL Servers

This brief summarises the proceedings and outcomes of the 2nd MyWebinar which was held on 13th February 2021 at Online Webinar. As part of our thought leadership webinar series, our latest hosting webinar Migrate your EOL MySQL Servers (seamless migration to MySQL group replication / InnoDB cluster) We have conducted MyWebinar with a very positive … Continue reading Webinar Summary: Migrate your EOL MySQL Servers

Fastest Parallel replication method in MySQL 8.

From MySQL 5.7, we had a Multi-threaded Slave (MTS) Applier mechanism called LOGICAL_CLOCK to overcome the problems of parallel replication within a database. To further improve the parallelisation mechanism, from MySQL 8 (5.7.22) we have write-set replication, so before going further , lets look at the difference between Logical clock (LC) and Writeset. LOGICAL_CLOCK Transactions that … Continue reading Fastest Parallel replication method in MySQL 8.

Dockerizing MySQL step by step.

As a Database Engineer in Mydbops. We tend to solve multiple complex problems for our esteemed customers. To control the System resources and scale up /down based on needed we are evaluating Dockers and Kubernetes. Docker is a set of platform as a service products that uses OS-level virtualization to deliver software in packages called … Continue reading Dockerizing MySQL step by step.

Integrating MariaDB Audit plugin in MySQL 5.7

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

Building a MySQL Firewall with ProxySQL

We are aware of ProxySQL as an SQL load balancing tool with a lot of features bundled in it.Now it has added firewall rules integrated too. Below are a few interesting features explained and explored by our Mydbops team. MySQL replication Read-Write Split up Replication Switchover using ProxySQL And MHA HA for Proxysql with keepalived … Continue reading Building a MySQL Firewall with ProxySQL

Present Pandemic Situation is Daunting!!! Mitigate your Worries on Database to Mydbops.

Firstly, let’s start with the Universal Truth: STAY HOME, STAY SAFE, WORK FROM HOME. Said that, we are already aware that database is the schema for any business operations. Procrastination in optimizing the database will lead to a disaster. Hiring a resource considering the present situation is even more tedious. Mydbops can help in your … Continue reading Present Pandemic Situation is Daunting!!! Mitigate your Worries on Database to Mydbops.

Troubleshooting an OLAP system on InnoDB

As a part of Mydbops Consulting we have a below problem statement from one of our client. "We have a high powered server for reporting which in turn powers our internal dashboard for viewing the logistics status.Even with a high end hardware, we had a heavy CPU usage and which in turn triggers spikes in … Continue reading Troubleshooting an OLAP system on InnoDB

MySQL Clone Plugin Speed Test

In my previous blog, I have explained how the MySQL clone plugin works internally. In this blog, I am going to do a comparison of  Backup and Recovery speed of MySQL clone plugin with other available mysql open source backup tools. Below tools are used for speed comparison of Backup and Recovery, Clone-Plugin Xtrabackup mysqldump … Continue reading MySQL Clone Plugin Speed Test

MySQL Binlog server with Maxscale

This is the our next blog in Maxscale series, Below is a list of our previous blogs, which provides deep insight for Maxscale and its use cases for different architectures. Scale with Maxscale part – 1 (Intro & Galera Cluster) Scale with Maxscale part – 2 (Administration, Installation & operation) Scale with Maxscale part – … Continue reading MySQL Binlog server with Maxscale