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 >

Monitor Cassandra using Zabbix

Find out the detailed steps to set up a monitoring framework to monitor Cassandra cluster metrics through Zabbix.

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 >

OTN appreciation day: public-yum

In the spirit of OTN Appreciation Day, Bjoern Rost, Principal Consultant at Pythian, talks about his favourite favourite Oracle feature: public-yum.

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 >

7 tips for managing Infrastructure with Terraform

Kevin Pedersen, Team Manager, Service Reliability Engineering at Pythian, provides some considerations to keep your Terraform environment manageable.

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 >

Custom MySQL statistics with collectd

Gabriel Ciciliani, MySQL Lead Database Consultant at Pythian, explains how to generate custom MySQL statistics using collectd.

Read More >

vm.swappiness and OOM in RHEL6

The behavior of vm.swappiness was always a bit confusing for novice linux users, as setting vm.swappiness to 0 would not completely disable swapping in the system during a memory crunch. vm.swappiness would only affect the agressiveness of swapping. Following upstream…

Read More >