Pythian Blog: Technical Track | MySQL

Recent stories

Important pre-checks before running pt-online-schema-change to Add/Drop an index in MySQL

When you're working with large MySQL tables in production, making schema changes like adding or dropping indexes can be ...

by Archita Chauhan

6 min read

Planning for MySQL 5.7 End of Life with AWS Aurora

If you are one of the many MySQL 5.7 RDS Aurora customers, you will have received notification that MySQL 5.7 will ...

3 min read

How to Promote a Google Cloud Replica from an External MySQL Primary

This is the second blog in a series about how to migrate a MySQL instance from a VM to Google Cloud SQL. See the first ...

3 min read

More stories

Google Compute Engine

How to Setup a Google Cloud SQL Replica from an External MySQL Primary

MySQL

How to Migrate Your On-Prem MySQL 8 Database to RDS Using MySQL Shell Logical Backup

MySQL

Exploring Backup/Restore Comparison Using MySQL Shell Utility vs. Percona XtraBackup Utility vs. MySQLDump

MySQL

MySQL 8.0 – Invisible Indexes

MySQL

Find and remove unused & duplicate indexes in MySQL

MySQL

How to prevent replication break while adding index/column using pt-osc

MySQL

pt-online -schema corner case: When you don’t want to replicate your alter activities across the whole cluster.

MySQL

Migrate RDB to Cloud SQL Using Google’s Dataflow

MySQL

Replicating MySQL to Snowflake with Kafka and Debezium—Part Two: Data Ingestion

MySQL

Replicating MySQL to Snowflake with Kafka and Debezium—Part One: Data Extraction

MySQL

Watch Out When Running Out of Disk Space With InnoDB Group Replication Cluster

MySQL

Diagnosing Orchestrator Crashes Due to Time Drift Events

MySQL

Create 19c Database in Archive Mode Using DBCA Silent

MySQL

Ansible Inventory Automation Using Consul and Orchestrator

MySQL

Configuring MySQL in a Docker Container

MySQL

Benefits of Workshop Learning: a Cassandra Workshop Example

MySQL

How to Improve Healthcare Security With Google Chrome Security

MySQL

Docker Orientation

MySQL

Data Guard Listener Networking

MySQL

Getting started with Cloud SQL for SQL Server

MySQL

Anthos: How Google changed the perception of hybrid cloud solutions

MySQL

How to Automate Killing Inactive Sessions with Resource Manager

MySQL

MariaDB Temporal Tables: Uncut & Uncensored (Part III)

MySQL

MariaDB Temporal Tables: Uncut & Uncensored (Part II)

MySQL

MySQL high availability with ProxySQL, Consul and Orchestrator

MySQL

Cutting Costs And Building Sales By Migrating To Google Cloud Platform

MySQL

Issues and workarounds for Exadata Patching (JAN-2019)

Load More Stories