How to Setup a Google Cloud SQL Replica from an External MySQL Primary
This is the first in a series of blog posts on how to migrate a MySQL instance from a VM to Google...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | MySQL
Exploring Backup/Restore Comparison Using MySQL Shell Utility vs. Percona XtraBackup Utility vs. MySQLDump
In this blog post, we will be comparing the time it takes for backup and restore using MySQL Shell...
MySQL 8.0 – Invisible Indexes
Overview In this blog, we aim to discuss the new MySQL 8.0 feature: invisible indexes and how to...
Find and remove unused & duplicate indexes in MySQL
Overview: It is a general rule of thumb, that the more indexes you have on a table, the slower the...
How to prevent replication break while adding index/column using pt-osc
Overview of ISSUE: This post is regarding a scenario where the pt-osc command breaks replication...
pt-online -schema corner case: When you don’t want to replicate your alter activities across the whole cluster.
Intro When we want to perform a heavy ALTER TABLE against a several gigabytes table the options are...
Why Migrate Your PostgreSQL, MySQL or SQL Server to Google Cloud SQL?
Whether you’re using a PostgreSQL, MySQL or SQL Server relational database, a migration to Google...
Migrate RDB to Cloud SQL Using Google’s Dataflow
Most corporations have huge amounts of data in RDBMS (relational database management system). When...
Replicating MySQL to Snowflake with Kafka and Debezium—Part Two: Data Ingestion
Here we go again Hello, and welcome to this second part of my “Replicating MySQL to Snowflake”...
Replicating MySQL to Snowflake with Kafka and Debezium—Part One: Data Extraction
What, Snowflake? Yes, Snowflake. While my core skills are based on the Oracle database, lately I’ve...
