by Jay Janssen | May 11, 2016 | Cloud, MySQL
In this post, we’ll discuss how you can quick start MySQL testing using Docker, specifically in a Mac environment.Like a lot of people, I’m hearing a lot about Docker and it’s got me curious. The Docker ecosystem seems to be moving quickly, however,... by Jay Janssen | Sep 14, 2015 | Insight for DBAs, MySQL
Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability. This blog is for me to address the extra questions I didn’t have time to answer on the stream. What do you think about using Galera Cluster but... by Jay Janssen | Aug 31, 2015 | MySQL, Percona Software
There can be a lot of confusion and lack of planning in Percona XtraDB Clusters in regards to nodes becoming desynchronized for various reasons. This can happen a few ways: An IST or SST joining node catching up after a state transfer (Joined/Joining state)... by Jay Janssen | Aug 20, 2015 | MySQL, Percona Software
State Snapshot Transfer (SST) at a glance PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize. This is analogous to cloning a slave in asynchronous replication: you... by Jay Janssen | Aug 5, 2015 | MySQL, Percona Software
IST Basics State transfers in Galera remain a mystery to most people. Incremental State transfers (as opposed to full State Snapshot transfers) are used under the following conditions: The Joiner node reports Galera a valid Galera GTID to the cluster The Donor... by Jay Janssen | Jul 16, 2015 | MySQL, Percona Software
In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster (PXC) node without triggering an actual SST. Practically this reproduces the SST steps, but it can be handy if you already had backups available... by Jay Janssen | Jul 16, 2015 | MySQL, Percona Software
Beware the SST In Percona XtraDB Cluster (PXC) I often run across users who are fearful of SSTs on their clusters. I’ve always maintained that if you can’t cope with a SST, PXC may not be right for you, but that doesn’t change the fact that SSTs with... by Jay Janssen | Jul 6, 2015 | MySQL, Percona Software
I noticed that in the latest release of Percona XtraDB Cluster (PXC), the behavior of wsrep_OSU_method changed somewhat. Prior to this release, the variable was GLOBAL only, meaning to use it you would: mysql> set GLOBAL wsrep_OSU_method='RSU'; mysql>... by Jay Janssen | Jun 2, 2015 | Insight for DBAs, MySQL
It seems these days if anyone knows anything about tuning InnoDB, it’s that you MUST tune your innodb_buffer_pool_size to 80% of your physical memory. This is such prolific tuning advice, it seems ingrained in many a DBA’s minds. The MySQL manual to... by Jay Janssen | Dec 22, 2014 | MySQL, Percona Software
Background on Backup Locks I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH TABLES WITH READ LOCK (FTWRL)... by Jay Janssen | Dec 5, 2014 | Benchmarks, MySQL, Percona Software
Introducing Consul I’m always interested in what Mitchell Hashimoto and Hashicorp are up to, I typically find their projects valuable. If you’ve heard of Vagrant, you know their work.I recently became interested in a newer project they have called... by Jay Janssen | Dec 3, 2014 | MySQL, Percona Software
One new feature in Percona XtraDB Cluster (PXC) in recent releases was the inclusion of the ability for an existing cluster to auto-bootstrap after an all-node-down event. Suppose you lose power on all nodes simultaneously or something else similar happens... by Jay Janssen | Nov 25, 2014 | MySQL, Security
I log into a lot of different servers running MySQL and one of the first things I do is create a file in my home directory called ‘.my.cnf’ with my credentials to that local mysql instance: [client] user=root password=secret 123... by Jay Janssen | Nov 21, 2014 | Cloud, MySQL, Percona Software
I’m happy to announce that Google has added Click-to-deploy functionality for Percona XtraDB Cluster (PXC) on Google Cloud Compute nodes. This gives you the ability to rapidly spin up a cluster for experimentation, performance testing, or even production use on... by Jay Janssen | Nov 14, 2014 | Insight for DBAs, MySQL, Percona Software
Thanks to all who attended my Nov. 12 webinar titled, “Percona XtraDB Cluster as a MySQL HA Solution for OpenStack.” I had several questions which I covered at the end and a few that I didn’t. You can view the entire webinar and download the slides... by Jay Janssen | Nov 6, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
MySQL is the most popular and widely used open source database on the planet. OpenStack is fast evolving as the defacto open source cloud platform. OpenStack services such as Nova (Compute), Cinder (Storage), Neutron (Networking), to name just a few, all use MySQL as... by Jay Janssen | Sep 22, 2014 | MySQL, Percona Services, Percona Software
Interest in Percona XtraDB Cluster / Galera has been high ever since we introduced the product in 2012. I typically have a conversation about Galera and Percona XtraDB Cluster (PXC) at least once a week with a consulting customer who wants to know if it will be... by Jay Janssen | Sep 3, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software, Webinars
Join me online next week (September 10 at 10 a.m. PDT) for my live webinar on Migrating to Percona XtraDB Cluster. This was a popular webinar that I gave a few years ago, so I’m doing it again with updates for Register here! by Jay Janssen | May 21, 2014 | Insight for DBAs, MySQL, Percona Software
I’ve had the opportunity to train lots of people on Percona Live MySQL Conference and Expo in Santa Clara, California for the last two years. Baron even attended this year and had this say: “Jay Janssen’s tutorial on Percona XtraDB Cluster was... by Jay Janssen | May 8, 2014 | MySQL, Percona Software
Overview Percona XtraDB Cluster 5.6 has been GA for several months now and people are thinking more and more about moving from 5.5 to 5.6. Most people don’t want to upgrade all at once, but would prefer a rolling upgrade to avoid downtime and ensure 5.6 is...