While at Percona Live this year I was reminded about ZFS and running MySQL on top of a ZFS-based storage platform.

Now I’m a big fan of ZFS (although sadly I don’t get to use it as much as I used to after I shutdown my home server farm), and I did a lot of different testing back while at MySQL to ensure that MySQL, InnoDB and ZFS worked correctly together.

Of course today we have a completely new range of ZFS compatible environments, not least of which are FreeBSD and ZFS on Linux, I think it’s time to revisit some of my original advice on using this combination.

Unfortunately the presentations and MySQL University sessions back then have all been taken down. But that doesn’t mean the advice is any less valid.

Some of the core advice for using InnoDB on ZFS:

• Configure a single InnoDB tablespace, rather than configuring multiple tablespaces …

While Shard-Query can work over multiple nodes, this blog post focuses on using Shard-Query with a single node.  Shard-Query can add parallelism to queries which use partitioned tables.  Very large tables can often be partitioned fairly easily. Shard-Query can leverage partitioning to add paralellism, because each partition can be queried independently. Because MySQL 5.6 supports the partition hint, Shard-Query can add parallelism to any partitioning method (even subpartioning) on 5.6 but it is limited to RANGE/LIST partitioning methods on early versions.

The output from Shard-Query is from the commandline client, but you can use MySQL proxy to communicate with Shard-Query too.

In the examples I am going to use the schema from the Star Schema Benchmark.  I generated data for scale factor 10, which means about 6GB of data in the largest table. I am going to show a few different queries, and …

My faithful readers, please spare 10 mins of your time, and read Baron's excellent post: https://vividcortex.com/blog/2014/04/30/why-mysql

Nuff said.


Since I can't really shut up, and only if you do like my (humble) take on this, I could say in short:

Every technology/platform/framework I choose, will end up surprising me, limiting me for things can be done easily, and throw many painful challenges at me if and when I need to do things that are closer to the platform's "edges". This is true for everything including Rails, JEE, Hibernate, MongoDB, MySQL.

I've learned that the more mature, generically-capable, transparent and ecosystem-rich a solution is - the less painful surprises for me in the worst timings - and more successful I am in my job.

There are two parts to this tutorial. In the first one, I am going to show how to login to a remote server without using a password (when you normally do need a password to login). Secondly, I am also going to show you how to setup SSH on your local machine so that you can use short aliases to connect to remote machines.

I have successfully used these techniques on Linux and Mac OS X for the past year or so.

Vlad Fedorkov and the creator of Sphinx Search speaking at Percona Live 2014. They cover the basics of Sphinx, as well as faceted search, auto-correction, searching with ranges, geo spatial search, non-full-text search (filtering, grouping, sorting), and about some of Sphinx’s full-text search operators (ie. field-limit operator and quorum operator). A talk at Percona Live […]

Laine explains the options for running MySQL at high volumes at Amazon Web Services, exploring options around database as a service, hosted instances/storages and all appropriate availability, performance and provisioning considerations using real-world examples from Call of Duty, Obama for America and many more. Laine will show how to build highly available, manageable and performant […]

The Brainiac Corner is a format where we talk with some of the smartest minds in the system, database, devops, and IT world. If you have opinions on pirates, or anything else related, please don't hesitate to contact us. 

Today, we interview Shlomi Noach, who, in addition to receiving MySQL Community Member of the Year and Oracle Technologist of the Year Awards, runs data infrastructure at Outbrain.

How did you get from stork to brainiac (i.e. what do you do today and how did you get there)?

I'm an engineer drawn into the world of MySQL. My first serious experience with MySQL was when having to deal with growth of a company I co-founded. I later began training and consulting for MySQL, and was exposed to many interesting companies and use cases. I began developing open source …

What's new in VividCortex? We'll do these blog posts once a week to let you know all of the changes such as new features, bug fixes, performance improvements, and even a peek into the future.

Upcoming Events

If you haven't seen the VividCortex application in action, please register for a live demo on production systems on May 14th.

Catch us at the following upcoming events:

• Monitorama
• Velocity

Upcoming Improvements

• Agent management UI in the web application.
• More agent performance improvements.
• Events dashboard redesign and performance improvements.
• Replication dashboard, for real-time live updating view of your replication topology and …

What's new in VividCortex? We'll do these blog posts once a week to let you know all of the changes such as new features, bug fixes, performance improvements, and even a peek into the future.

Upcoming Events

If you haven't seen the VividCortex application in action, please register for a live demo on production systems on May 14th.

Catch us at the following upcoming events:

• Monitorama
• Velocity

Upcoming Improvements

• Agent management UI in the web application.
• More agent performance improvements.
• Events dashboard redesign and performance improvements.
• Replication dashboard, for real-time live updating view of your replication topology and …

The Brainiac Corner is a format where we talk with some of the smartest minds in the system, database, devops, and IT world. If you have opinions on pirates, or anything else related, please don't hesitate to contact us. 

Today, we interview Shlomi Noach, who, in addition to receiving MySQL Community Member of the Year and Oracle Technologist of the Year Awards, runs data infrastructure at Outbrain.

How did you get from stork to brainiac (i.e. what do you do today and how did you get there)?

I'm an engineer drawn into the world of MySQL. My first serious experience with MySQL was when having to deal with growth of a company I co-founded. I later began training and consulting for MySQL, and was exposed to many interesting companies and use cases. I began developing open source …