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.
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
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
As the name indicates, an undo log record contains information about how to undo the recent changes by a transaction. When a transaction writes data, it always makes writes on the tablespace files. InnoDB Undo log stores copy of data that is being modified by any current transaction. So, at this point in time if … Continue reading An Overview to InnoDB Undo Log
Much, if not most, of a DBA's time and resources are spent doing low-level administration work even in the most dynamic of growth atmospheres. While such routine tasks are critical to your organization's support, they rarely relate to the core competencies about revenue generation that a company has. One of the more compelling motives that … Continue reading Avoid overhead in Database and Move forward with an Expert team.
MySQL has come a long way, and keeps on bringing in new improvements and new collections of JSON functions. Here are a few techniques to store data in JSON columns. MySQL Vs MariaDB JSON Implementation : There is a key difference on how JSON is implemented in MySQL and in MariaDB. MySQL has implemented JSON … Continue reading 10 New Functions for JSON Columns in MySQL 8.
Backup and Recovery is one of the most essential jobs for every database administrator. We all know the importance of the backups for the databases. Here I am not going to write its importance, rather about the different types of backup tools available for … Continue reading Exploring Logical Backup in PostgreSQL.
Human geography examines the dynamics of cultures, societies and economies, and physical geography examines the dynamics of physical landscapes and the environment. In this blog i am going to explain what are the new Geography features available in MySQL 8.0 Major Difference in MySQL 5.7 & 8.0 Geography : There is a big change from … Continue reading GeoSpatial data handling made easy with MySQL 8.0
The world is in a pandemic situation and I believe everyone doing good. Please Stay Home! Stay Safe! In this situation, most of the people are doing WFH, and I believe its the right time to talk about how to enable the Developer, OPS Team, and DBA can initiate secure encrypted TCP connection instead of … Continue reading Securing MongoDB Cluster with TLS/SSL
COVID-19 is creating a perfect storm of instability, confusion and threats for private and public sector organisations. Every organization is almost certainly negatively affected by the current pandemic, though a few may be able to draw some optimistic conclusions from those difficult days. Here are four different ways COVID-19 is impacting Organizations who are trusting … Continue reading How Mydbops Managed Database Services could prove helpful during this Pandemic ?