The Percona Live MySQL Conference was held once again in Santa Clara from April 1-4, 2014.
- Percona hosted another excellent conference, with 1,150 attendees from 43 countries plus a vibrant exhibit hall.
- The overall themes that emerged this year were “What’s new in MySQL 5.6?” and “The rise of Galera Cluster.” Unfortunately, Oracle delivered the 5.6 features they promised, but didn’t bother to ask production DBAs what they really needed (ie. GTIDs don’t support multimaster replication and require downtime to configure (SR 3-8856341942), and ALTER ONLINE doesn’t support throttling or background operation on slaves (SR 3-8856341908).)
- MySQL 5.7 is promising about double the performance of 5.6, but note that the 5.7 feature micro-benchmark effort hasn’t translated into a complete understanding of whole database performance yet.
- the current active branches are now: Oracle 5.6/5.7, MariaDB 10.0/10.1, Webscale SQL (Facebook, Google, LinkedIn, and Twitter), Facebook 5.6 with Deployable GTIDs, and Percona Server 5.6. (The version you want to migrate to is one based on MySQL 5.6.17 or later.)
Severalnines.com booth. They create and support cluster and cloud database solutions. Photo credit: Steve Barker, SphinxSearch.com
Percona Live 2014 opening keynote with Percona CEO Peter Zaitsev
Robert Hodges – Getting Serious about MySQL and Hadoop at Continuent
(Continuent needs to pivot into another market as MySQL’s new built-in features displace their replication products.)
‘Raising the MySQL Bar’ with Oracle’s Tomas Ulin, VP of Engineering for MySQL, Oracle
Adventures in MySQL at Dropbox, Renjish Abraham
- MySQL 5.6 has online schema change capability, however there’s no way to throttle IO consumed during the operation and the single-threaded slave will lag
- David has tested the ALTER ONLINE in MySQL 5.6.17 and will use it when ported to Percona Server
- for now uses Percona Online Schema Change utility for its throttling feature.
- tools have been created by Percona to recover Innodb data if you don’t have backups and you’re out of business otherwise. Call them!
- reviewed features in Galera Cluster versions 3 and 4
- looking good.
- Disable NUMA - echo 0 /proc/sys/vm/swappiness - bind data node threads to CPUs - cat /proc/interrupts ThreadConfig LDM = cores/2 TC = LDM/4 RealTimeScheduler=1 Numoffraglogparts=LDM Tune redo log Fragmentlogsize=256M Nooffragmentlogfiles=redobuffer=64M
- prefers “latency” graph style with transparent dots vs. line charts
- uses R and ggplot2 for graphing
- attendees tried to guess SSD performance on Peter’s notebook for different block sizes, most were proven totally wrong by sysbench
- discussion again this year about parallel query execution (same as at MariaDB BoF last year), with Peter Zaitsev also bringing it up again
- discussion about raw partitions (belief is that they will be 20% more space-efficient and 30% faster, and avoid Linux endless limitations and bugs)
- internal “development roadmap” only extends about 12 months at a time, subject to customer demands
- I griped about FK panic/data loss issues in MySQL Cluster 7.3.3. Tomas Ulin, Vice President, MySQL Engineering, said that was news to him. (See SR 3-8717994851 and SR 3-87646727311)
- Mark Callaghan, Facebook, said he was working on MongoDB now, but requested named keys in flexible schema in MySQL.
- Peter Zaitsev, Percona, said several clients are using GTIDs and they seem to work.
- Oracle pleaded with users to drop MyISAM. I mentioned the main reason was that legacy systems used older compression methods, but InnoDB could be used since it has compression too
- The Oracle MySQL Fabric project is an attempt to counter MongoDB’s automatic slave promotion.
’9 Things You Need to Know…’, Peter Zaitsev, Percona
The Evolution of MySQL in the All-Flash Datacenter, Nisha Talagala, Fusion-IO
MySQL, Private Cloud Infrastructure and OpenStack, Sean Chighizola, Big Fish Games
Keynote Panel: The Future of Operating MySQL at Scale
Question: “What is Percona’s secret to professional benchmarks?”
Answer: “Benchmark absolutely everything multiple times, time permitting.”
- comprehensive micro-benchmarking graphs of 5.7 to gain a deeper understanding of parts
- the challenge remains: how to tune the whole database to perform well?
- good comparison of relational data modelling and C* data modelling, lots of similarities
- note that MariaDB has a Cassandra plugin
- it’s good to see that Codership is paying attention to the details of replication
MySQL Community Awards
Shlomi has a comprehensive post on this years winners.
MySQL Lightning Talks (5 minutes each)
Truncating Sub Optimal DBA Verbal Responses Vectors, David Stokes (Oracle)
MySQL 5.6 Global Transaction IDs: Benefits and Limitations, Stephane Combaudon (Percona)
Zero database downtime using the Federated storage engine and Replication, prasad mani (BBC)
Scaling via adding a Table, Rick James (self)
Rick knows some clever ways to optimize solutions with MySQL. He’s doing consulting now, so contact him.
No es ‘ano’, es ‘año’! A take on encoding in your DB, Ignacio Nin (Vivid Cortex)
What Not to Say to the MySQL DBA, Gillian Gunson (Blackbird (formerly PalominoDB))
“I’ll code around it. ”
“Stop micro-optimizing. ”
“Use passive master for QA”
“MySQL is a toy database. ”
This conference is a support group. ”
Hall of Shame, Shlomi Noach
Triple active-replication in gaming anecdote: don’t do that.
The bash slave-prefetch oneliner, Art van Scheppingen (Spil Games)
Unsung Relay Log, Vishnu Rao, FlipKart
Com_relaylog_dump for tungsten and mysql 5.5
Unique User Count — Rollup, Rick James (self)
Formula for user visit estimation by counting bits.
Logical Backups in the Cloud, Bill Karwin, Percona
Backups for PHP designers
PHP class Mysql/Dump
How to Squat, Kyle Redinger (VividCortex, Inc)
Iron DBA Replication Challenge, Attunity
- one of the best conference keynotes ever, and a great primer on Open Source marketing … up there with the O’Reilly Open Source Conference keynote on the importance of Android – before it shipped.
- just write your own MySQL branch if a feature is too hard to deploy
- R has about 1,000 interesting sample databases (demos included diamonds)
- good interface for quick graphing, not so great for complex programs
- Percona usess R and gg graph module for most of the graphs you see now.
Closing Prize Drawing
About 30 high-end gifts were handed out.
Some nice prizes contributed by exhibitors, including Nexus 7 tablets, $250 AWS gift certificates, SQLyog and Monyog licenses, and a quad drone!