Introduction

The purpose of this test is to benchmark MySQL 5.6 performance on hardware with Haswell CPUs, SSDs and PCIe Flash storage devices.

Background

Software

• SysBench OLTP workload installed on the database machine
  
• MySQL 5.6.24 distribution from Percona
  
• jemalloc used for MySQL Server and Sysbench test client
  
• Charts are plotted using MySQL Performance Analyzer

Method

• Data and software on server was wiped out post every test run.
  
• Predefined number of tables - 16 or 64
  
• Predefined size of rows - 20M per table
  

Tests
Read Only
Read Write
Concurrencies vary from 1 to 512 with incremental increase
EXT4 vs XFS

…

We had a great time meeting with folks from the industry and are excited about the innovations being pursued by the community and various companies. 

Videos of our keynote panel participation and talks are available now.

Percona Live 2015 Keynote Panel discussion - Ritesh Chhajer

High Availability using Percona XtraDB Cluster - Trey Raymond & Yashada Jadhav

MySQL Performance Analyzer - Xiang Rao & Ashwin Nellore

…

We had a great time meeting with folks from the industry and are excited about the innovations being pursued by the community and various companies. 

Videos of our keynote panel participation and talks are available now.

Percona Live 2015 Keynote Panel discussion - Ritesh Chhajer

High Availability using Percona XtraDB Cluster - Trey Raymond & Yashada Jadhav

MySQL Performance Analyzer - Xiang Rao & Ashwin Nellore

…

A real fast list of stuff from the Percona Live 2014 event.

Yahoo’s Performance Analyzer

Yahoo is developing a MySQL performance analyzer that should be released as open source later this year. From the demo, it looks like it pulls in most of the MySQL metrics, shows you a processlist and then lets you drill into a processlist with explain. Will have to keep my eye out for this.

ChatOps with Hubot

GitHub’s Sam Lambert has a set of hubot chatops scripts for MySQL. I was already looking at depoying hubot for the ability to push messages from a remote source into an IRC channel, so this would be a natural fit. He also mentioned using Janky to tie CI with hubot.

DevOps at Outbrain

Shlomi …

The Percona Live MySQL Conference and Expo 2014 is just two months away. I’m very excited about this year’s event which continues our tradition of open technical discussions and inviting all parties to the table.

We have a great amount of technical talks from Oracle – I’m especially excited about future-focused talks shedding some light about what to expect in MySQL 5.7 and beyond. This content is best covered by developers actually designing the system and writing the code. We also have great coverage of MySQL alternatives from Percona and MariaDB. You can view the entire program here.

It is great to see well-rounded coverage of many …

There has been some interesting discussion on-line recently about how to handle database (meaning MySQL, but really it applies to other systems too) failover. The discussion that I’ve followed so far, in order, is:

• GitHub’s report on their automated failover and downtime issues
• Baron’s follow-up to that, Is automated failover the root of all evil? which generated a bit of discussion in the comments
• Peter’s follow-up to both, The Math of Automated Failover which heads in the direction I was going when I realized I might want to toss my 2 cents into the mix
…

Mark Cuban is no fool. A tech billionaire, the no-nonsense owner of the Dallas Mavericks is just the sort of person you'd expect to value software patents. So the title of his blog post this Tuesday, "I hope Yahoo crushes Facebook in its patent suit," may not look out of place to you.

read more

MapR and Funambol raise funding. VMware virtually supports PostgreSQL. And more.

# MapR raised $20m series B for its Hadoop distribution from Redpoint Ventures, Lightspeed Venture Partners and NEA.

# Funambol raised $3m in funding from previous investors HIG Ventures, Pacven Walden Ventures and Nexit Infocom.

# VMware launched vFabric Postgres as part of vFabric Data Director database-as-a-service launch.

# Citrix released a new edition of CloudStack, …

Yoshinori Matsunobu sparked some interest recently when he posted about his MySQL MHA HA solution, and there has been some discussion of it internally at Yahoo compared with the standard we currently have.  

Full disclosure:  I haven’t read every bit of the documentation or tried it out yet, so I apologize in advance to Yoshinori if I mistakenly represent his hard work. 

I see a lot of great ideas in Yoshinori’s release, it seems to focus on two main problems:

1. A process to monitor an active master and perform a failover when it fails
2. The bit that finds the most “caught-up” slave and distributes …

A herd of Hadoop announcements. Rockmelt raises $30m. And more.

A herd of Hadoop announcements
# Yahoo! and Benchmark Capital confirmed the formation of Hortonworks, an independent company focused on the development and support of Apache Hadoop.

# Cloudera announced the availability of Cloudera Enterprise 3.5 and the launch of Cloudera SCM Express, based on the new Service and Configuration Manager in Cloudera Enterprise 3.5.

# MapR …