Creating a Simple MySQL Binlog Server

In my previous Blog i have explained how we can integrate MySQL tools ( Percona Tool kit ) with systemd service, At Mydbops works with multiple clients ,we get various requirements from customers a few may be a complex ones ,one of the requirement was to setup a binlog server and copy the Production binlogs … Continue reading Creating a Simple MySQL Binlog Server

XtraDB Cluster troubleshooting a rejected node.

PXC(Percona XtraDB Cluster), aka Galera cluster, is one of my favorite clustering technology for MySQL that comes with real Multi-master capabilities, Write-set based nearly real-time replication and many more features. I could proudly say that Mydbops is one of the very few companies who have been supporting mission-critical clusters and preaching PXC ie., Galera cluster … Continue reading XtraDB Cluster troubleshooting a rejected node.

Integrating MySQL tools with Systemd Service

In my day to day tasks as a DB Engineer at Mydbops we have been using multiple MySQL tools for multiple use cases to ensure an optimal performance and availability for servers managed by our Remote DBA Team. A tool like pt-online-schema can be used for any DDL changes ( Overview to DDL algorithm ), … Continue reading Integrating MySQL tools with Systemd Service

Two Methods of ClickHouse Backup and Recovery

ClickHouse is known as a data analytics processing engine. ClickHouse is one of the open-source column-oriented database-oriented management systems capable of real-time generation of analytical data reports using SQL queries. Clickhouse came a long way since it inception 3 years ago. Why Mydbops recommends ClickHouse for Analytics ? ClickHouse is a Columnar Store built for … Continue reading Two Methods of ClickHouse Backup and Recovery