EmergencyEMERGENCY? Get 24/7 Help Now!

A technical WebScaleSQL review and comparison with Percona Server

 | May 22, 2014 |  Posted In: Insight for Developers, MySQL, Percona Server, Percona Software

The recent WebScaleSQL announcement has made quite a splash in the MySQL community over the last few weeks, and with a good reason. The collaboration between the major MySQL-at-scale users to develop a single code branch that addresses the needs of, well, web scale, is going to benefit the whole community. But I feel that […]

Read More

MySQL High Availability With Percona XtraDB Cluster (Percona MySQL Training)

 | May 21, 2014 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, XtraDB Cluster

I’ve had the opportunity to train lots of people on Percona XtraDB Cluster (PXC) over the last few years the product has existed.  This has taken the form of phone calls, emails, blog posts, webinars, and consulting engagements. This doesn’t count all the time I’ve spent grilling Codership on how things actually work.  But it […]

Read More

Database auditing alternatives for MySQL

 | May 20, 2014 |  Posted In: Insight for DBAs, MySQL, Security

Database auditing is the monitoring of selected actions of database users. It doesn’t protect the database in case privileges are set incorrectly, but it can help the administrator detect mistakes. Audits are needed for security. You can track data access and be alerted to suspicious activity. Audits are required for data integrity. They are the […]

Read More

Errant transactions: Major hurdle for GTID-based failover in MySQL 5.6

 | May 19, 2014 |  Posted In: High-availability, Insight for DBAs, MySQL

I have previously written about the new replication protocol that comes with GTIDs in MySQL 5.6. Because of this new replication protocol, you can inadvertently create errant transactions that may turn any failover to a nightmare. Let’s see the problems and the potential solutions. In short Errant transactions may cause all kinds of data corruption/replication […]

Read More

Benchmark: SimpleHTTPServer vs pyclustercheck (twisted implementation)

 | May 16, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL

Github user Adrianlzt provided a python-twisted alternative version of pyclustercheck per discussion on issue 7. Due to sporadic performance issues noted with the original implementation in SimpleHTTPserver, the benchmarks which I’ve included as part of the project on github use mutli-mechanize library, cache time 1 sec 2 x 100 thread pools 60s ramp up time 600s […]

Read More

Introduction to the Percona Server Audit Log feature

 | May 16, 2014 |  Posted In: MySQL, MySQL Audit Log Plugin, Percona Server, Percona Software

Percona has developed an Audit Log feature that is now included in Percona Server since the recent 5.5 and 5.6 releases. This implementation is alternative to the MySQL Enterprise Audit Log Plugin: Percona re-implemented the Audit Plugin code as GPL as Oracle’s code was closed source. This post is a quick introduction to this plugin. […]

Read More

High Availability with MySQL Fabric: Part I

and  | May 15, 2014 |  Posted In: High-availability, Insight for DBAs, MySQL

In our previous post, we introduced the MySQL Fabric utility and said we would dig deeper into it. This post is the first part of our test of MySQL Fabric’s High Availability (HA) functionality. Today, we’ll review MySQL Fabric’s HA concepts, and then walk you through the setup of a 3-node cluster with one Primary and two […]

Read More

Why ALTER TABLE runs faster on Percona Server 5.5 vs. MySQL 5.5

 | May 15, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Server

Some of us Perconians are at OpenStack summit this week in Atlanta. Matt Griffin, our director of product management, tweeted about the turbo-hipster CI talk about their experience of ALTER TABLEs running faster on Percona Server. Oracle’s Morgan Tocker then tweeted in response, asking why this was the case. I decided that the simplest way to […]

Read More