by Jay Janssen | Feb 12, 2013 | MySQL, Percona Events, Percona Live
I’ve been woefully neglectful of my responsibilities to post regularly about Percona Live MySQL Conference and Expo 2013 (PLCME 2013), but here’s some highlights of what I am planning to attend from the schedule. Read to the very bottom for the... by Jay Janssen | Dec 5, 2012 | Insight for DBAs, MySQL, Percona Software
I had a customer recently who needed to reduce their database size on disk quickly without a lot of messy schema redesign and application recoding. They didn’t want to drop any actual data, and their index usage was fairly high, so we decided to look for... by Jay Janssen | Dec 3, 2012 | MySQL, Percona Events
As Percona Live London is raging in the UK, I thought it fitting to remind everyone about the next big Percona Live: MySQL Conference and Expo 2013 in Santa Clara, Californa on April 22-25, 2013. You can register NOW for this conference, and the Super... by Jay Janssen | Nov 26, 2012 | MySQL, Percona Software
I learn more and more about Galera every day. As I learn more, I try to keep my myq_gadgets toolkit up to date with what I consider is important to keep any eye on on a PXC node. In that spirit, I just today pushed some changes to the... by Jay Janssen | Nov 20, 2012 | MySQL, Percona Software
I have addressed previously how multi-node writing causes unexpected deadlocks in PXC, at least, it is unexpected unless you know how Galera replication works. This is a complicated topic and I personally feel like I’m only just starting to wrap my... by Jay Janssen | Nov 8, 2012 | MySQL
This is not necessarily going to be a comprehensive post, but I learned somethings about MySQL SSL today that I thought would be worth sharing.I was setting up a PRM install for a customer and one of the requirements was SSL replication. In this particular case,... by Jay Janssen | Nov 8, 2012 | MySQL, Percona Events
I was honored to be asked to be a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA. Personally, I’ve been attending this conference for 6 or 7 years and missing it only when... by Jay Janssen | Nov 5, 2012 | MySQL, Percona Events
On November 15th at 1PM Eastern / 10 AM Pacific, I will be giving a webinar entitled “The Hazards of Multi-writing in a Dual-Master Setup”. In my experience many people do not understand the difficulty of managing writes to RDBMS datastores in a... by Jay Janssen | Sep 12, 2012 | MySQL, Percona Events, Percona Software
I’ve mentioned this before, but I’m delivering a tutorial on Percona XtraDB Cluster / Galera at Percona Live NY 2012 right in midtown-Manhattan on October 1st.I really want this tutorial to be hands-on, not just a 3 hour lecture, so you can... by Jay Janssen | Aug 17, 2012 | MySQL, Percona Software
Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication. For those who don’t know, it gives you: Fully Synchronous replication with a write latency increase equivalent to a ping RTT to... by Jay Janssen | Jun 14, 2012 | Benchmarks, MySQL, Percona Software
I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment. They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other. Test Environment The test... by Jay Janssen | Jun 6, 2012 | MySQL, Percona Software
Thanks to all who attended my webinar today. The session was recorded and will be available to watch for free soon here.There were a lot of great questions asked during the session, so I’d like to take this opportunity to try to answer a few of them: Q: Is there... by Jay Janssen | May 24, 2012 | Insight for DBAs, MySQL, Percona Events, Percona Software
Whenever I learn about a new technology, I typically want to know the major administrative touch points more than I want to know exhaustive detail about every configuration option. Give me the gist, show me enough to get started, and give me a link to the... by Jay Janssen | Feb 17, 2012 | MySQL
This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship. Some basic facts Most of us know... by Jay Janssen | Dec 16, 2011 | MySQL
There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority of... by Jay Janssen | Nov 29, 2011 | Insight for DBAs, MySQL
As I stated in my last post, I decided to use the Innodb Table monitor to diagnose an Index count mismatch error a customers found in their mysqld.err log to verify if the problem still existed.The Innodb Table Monitor has existed for basically forever in Innodb... by Jay Janssen | Nov 29, 2011 | MySQL
I had a customer recently who a few strange errors in their mysqld.err log: [ERROR] Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL 1 [ERROR] Table database_name/table_name contains...