Tag: MySQL

Duplicate Indexes in MySQL

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

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 >

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 >

Auditing MySQL Users With McAfee Plugin

Ivan Groenewold, MySQL Database Consultant at Pythian, discusses auditing MySQL users with the McAffee plugin.

Read More >

Ansible Dependencies for Docker Containers

I recently had the opportunity to test out Ansible’s ability to interact with docker containers. Some might ask why we would want Ansible to connect to running containers. Afterall, we can build the containers to our liking using ansible-container, or…

Read More >

Exposing Innodb Internals via System Variables: Part 5, Consistency / Statistics handling

In part 5 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at variables that relate to enforcing data consistency, and how index statistics are handled and stored.

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