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 […]Read more
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 […]Read more
If you’re reading this you may be a TokuMX user, or you’re thinking about using TokuMX. If the latter case applies, I bet you’re already using some form MongoDB today. Either way, you’ve probably heard about the MongoDB Innovation Awards announced in April by MongoDB, Inc. More here if you this is the first […]Read more
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 […]
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.
Errant transactions may cause all kinds of data corruption/replication errors […]Read more
Are you attending MongoDB World 2014? If so, I’d like to invite you to race ahead of the morning joggers by attending a breakfast meet-up where you’ll be able to discuss your big data challenges with database gurus:
Mark Callaghan of Facebook (and the Small Datum blog)
Kenny Gorman of ObjectRocket by Rackspace
Charity Majors of Parse […]
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 total duration
testing simulated node […]
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 […]Read more
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 […]
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 […]Read more