Articles by Shiv Iyer

About Shiv Iyer

Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.

Seamlessly Switching MySQL Replication Modes: Transitioning Between GTID and Non-GTID Without Downtime

Introduction to MySQL GTID Replication Changing the mode of replication in MySQL from and to GTID (Global Transaction Identifier) mode without taking the server offline requires careful planning and execution. The process involves ensuring that [...]

Step-by-Step Guide to Setting Up Point-in-Time Recovery in PostgreSQL 16

Point-in-Time Recovery in PostgreSQL Point-in-Time Recovery (PITR) in PostgreSQL 16 offers a robust solution for database backup and disaster recovery. PITR revolves around the continuous archiving of WAL (Write-Ahead Logging) files and the ability to […]

Optimizing MySQL Performance: Best Practices for Effective Indexing and Function Usage

Introduction Implementing functions on MySQL indexes, often referred to as using functional or expression-based indexes, is a topic with some nuanced considerations. Here's why this practice can be problematic and some tips and tricks for [...]

Effective Strategies for Troubleshooting Ad-Hoc Query Performance Issues in MySQL

Introduction Ad-Hoc Query Performance in MySQL Troubleshooting performance issues with ad-hoc queries in MySQL involves identifying and resolving inefficiencies or execution delays. Since ad-hoc queries are often one-off or dynamically generated, they can perform poorly [...]

Comprehensive Guide to Troubleshooting Binlog File Inconsistencies in MySQL Replication

Introduction: Binlog file Inconsistencies in MySQL Replication Troubleshooting binary log file inconsistencies in MySQL replication is a critical task because these inconsistencies can cause replication errors, data drift, and potential loss of data integrity. Since [...]

Troubleshooting MySQL Error 1130 (HY000) – Host is not allowed to connect to this MySQL server

Introduction MySQL Error 1130 (HY000): "Host is not allowed to connect" is a common issue that arises when a MySQL server rejects a connection attempt from a client. This problem is typically related to MySQL's [...]

Key Enhancements in MySQL 8 Group Replication for Improved Performance and Reliability

Introduction MySQL 8 introduced several significant improvements to Group Replication, enhancing its performance, usability, and reliability. These enhancements make MySQL Group Replication more robust and easier to use, particularly in high-availability and distributed computing environments. [...]

Impact of MySQL Server Misconfiguration on Group Replication Performance

Introduction Incorrect configuration of MySQL Server can significantly impact the performance of Group Replication, which is a crucial component for achieving high availability and scalability in MySQL. Here's how wrong configurations can negatively affect Group [...]

Understanding InnoDB Cluster for MySQL Horizontal Scaling

Understanding InnoDB Cluster: Internal Mechanics for MySQL Horizontal Scaling

Introduction InnoDB Cluster, a key feature of MySQL, provides a high-availability solution that also enables horizontal scaling of MySQL. It integrates several MySQL features – Group Replication, MySQL Shell, and MySQL Router – to facilitate [...]

Adaptive Joins in PostgreSQL 16 (mimicked feature)

Introduction PostgreSQL does not natively offer "Adaptive Hash Joins" as a built-in feature for query execution.Instead, the query planner selects join methods, such as nested loop, hash join, or merge join, during plan generation.Additionally, it [...]

The Data Transformation Company

Data Architecture, Engineering and Operations for SQL, NoSQL, NewSQL, Cloud Native Data Platforms, Analytics and AI