EmergencyEMERGENCY? Get 24/7 Help Now!

May 29 Webinar: Get More Out of MongoDB with TokuMX

 | May 22, 2014 |  Posted In: Tokutek, TokuView

MongoDB includes several powerful features like high availability, read scaling, and horizontal scalability in an easy-to-use, schema-free database platform. But, what if you could retain those properties, improve performance, and ensure scalability without specialized tuning just by replacing the storage stack? Register Now! SPEAKER: Tim Callaghan, VP of Engineering DATE: Thursday, May 29th TIME: 1pm […]

Read More

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

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.