Percona hosted another excellent Percona Live conference this past December 3-4 in London.  It was my pleasure to deliver 3 talks including the first keynote following Peter Zaitsev.  Percona does a great job of organizing these conferences--this year's London conference was well attended and in an excellent location in Kensington.  My thanks to the entire Percona team for putting this together.

Here are the slides for my talks in case you would like to see them.

Keynote:  Future-Proofing MySQL for the World-Wide Data Revolution -- Covering the greatly exaggerated death of MySQL and design patterns for robust MySQL systems that can last for decades

Talk:   …

Inspired by the benchmark in this post, we decided to run some NDB vs Galera benchmarks for ourselves.

We confirmed that NDB does not perform well using m1.large instances. In fact, it’s totally unacceptable -  no setup should ever have a minimum latency of 220ms - so m1.large instances are not an option. Apparently the instances get CPU bound, but CPU utilization never goes above ~50%. Maybe top/vmstat can’t be trusted in this virtualized environment?

So, why not use m1.xlarge instances? This sounds like a better plan!

As in the original post, our dataset is 15 tables of 2M rows each, created with:

./sysbench --test=tests/db/oltp.lua --oltp-tables-count=15 --oltp-table-size=2000000 --mysql-table-engine=ndbcluster --mysql-user=user --mysql-host=host1 prepare

Benchmark against NDB was executed with:

…

Inspired by the benchmark in this post, we decided to run some NDB vs Galera benchmarks for ourselves.

We confirmed that NDB does not perform well using m1.large instances. In fact, it’s totally unacceptable -  no setup should ever have a minimum latency of 220ms - so m1.large instances are not an option. Apparently the instances get CPU bound, but CPU utilization never goes above ~50%. Maybe top/vmstat can’t be trusted in this virtualized environment?

So, why not use m1.xlarge instances? This sounds like a better plan!

As in the original post, our dataset is 15 tables of 2M rows each, created with:

./sysbench --test=tests/db/oltp.lua --oltp-tables-count=15 --oltp-table-size=2000000 --mysql-table-engine=ndbcluster --mysql-user=user --mysql-host=host1 prepare

Benchmark against NDB was executed with:

…

SkySQL is looking for a great Support Engineer to join our Team and work the APAC shift. This means you do not need to reside in APAC, but just want to work those hours.

If interested, there is a full description of the position here:

http://www.skysql.com/company/careers/skysql-support-engineer-apac

And as the post says, if you are interested, please send your resume/CV to careers@skysql.com.

Also, if you’d like, please feel free to ping me as well [chris at skysql dot com] and I can try to get your resume looked at with a higher priority (and feel free to ask me any questions too).

Happy Holidays!

MySQL 5.6

Replication

Note 1760
Storing MySQL user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MySQL Manual for more about this issue and possible alternatives.

With the new 5.6, while doing a change master to, I received the message
Query OK, 0 rows affected, 2 warnings (0.04) sec

A quick show warnings revealed the above note which is a ER_INSECURE_CHANGE_MASTER.

It took some digging, but yes, it's possible to store replication information in a table …

As this topic came up a few times this week for discussion at various places, I thought of composing a post on “Data Scientist vs. Data Analytics Engineer”; even though[...]

16 Table Join Benchmarks were ran at Amazon Web Services.

Results available at www.paralleluniverse-inc.com/benchmarks.shtml .

Percona Live London 2012 was again a great event.
You can find some of the slides on [Plus], enjoy! :

If you would like to add your slides, post a comment with the link.

We are excited to announce that the new version of Jet Profiler for MySQL 3 is finally available.

This release includes the following important improvements:
- SSH Tunneling - connect to remote database servers using SSH tunneling.
- HTML Reports - makes saving and sharing the profiling results easier.
- Japanese translation.
- Improved memory management for large result sets.
- Bug fixes.

We also offer a completely new solution called Jet Profiler Enterprise. In addition to all the features in the professional version, it allows multiple instances so you can record from many databases at once. It also supports command line scheduling for automated recording.

For more details please read …

Learn more about the uncompromising scalability, uptime, and agility of MySQL Cluster by taking the authentic MySQL Cluster training course.

During this three day class, you will learn how to properly configure and manage the cluster nodes to ensure high availability, how to install the different nodes as well as get a better understanding of the internals of the cluster.

Events currently on the schedule for this class include: