Duplicate Indexes in MySQL

Valerie Parham-Thompson explains why duplicate (redundant) indexes are sometimes helpful.

Read More >

Using the MariaDB CONNECT Engine to Merge Heterogeneous Data Sources

Find out how to use MariaDB CONNECT Engine to merge heterogeneous data sources in this how-to blog post from Valerie Parham-Thompson.

Read More >

MySQL on AWS: RDS vs EC2

If you are thinking in moving your MySQL databases to AWS, this analysis by Gabriel Ciciliani may help you determine if RDS is the appropriate solution for your data.

Read More >

How to Do an In-Place Migration to Tungsten

Overview On this post I will explain how to do an in-place migration to Tungsten. We will start with a MySQL topology consisting of 3 nodes (1 master, 2 slaves) using native MySQL replication, and convert that into a 3…

Read More >

Performing Schema Changes in a Tungsten Environment

Discover the alternatives for performing schema changes in a Tungsten environment, which uses Tungsten replicator/cluster instead of traditional MySQL replication.

Read More >

New MySQL File System Vulnerabilities

Get insight into the recent MySQL file system vulnerabilities.

Read More >

Using ProxySQL to validate MySQL Updates

Derek Downey provides a quick look at ProxySQL.

Read More >

Enabling InnoDB Compression

Learn how to recover some disk space by enabling InnoDB compression.

Read More >

Using gh-ost for online schema changes

The pt-online-schema-change tool has been a workhorse for years, allowing MySQL DBAs to alter tables with minimal impact to application workload, and before MySQL had native online alter capabilities. Although consistently grateful for the tool’s existence, I never liked the…

Read More >

Rejoining a Node to MySQL’s InnoDB Cluster

Derek Downey, OSDB Practice Advocate at Pythian, gives you the steps to setup and deploy a local sandbox Cluster as well as the steps to kill a node.

Read More >
Page 1 of 1812345...10...Last Page »