Weekly summaries of MySQL News.

MySQL News

Issue #85

Prepping Your MySQL Indexes for a Character Set Change. Switching a table's character set often means you're using more bytes. You need to take your index length limits into account before moving ahead.

Query Optimization: From 0 to 10 (and up to 5.7). Did you miss Percona Live Europe this year? Here's a free set of slides covering Jaime Crespo's talk on Query Optimization.

HowTo: Retrieve Direct Messages From Twitter and Store Them in MySQL. Are you a Twitter user? A MySQL enthusiast? This Perl script might make your social media operations smoother than ever.

Ubuntu: Steps to install/update MySQL to the latest DMR. If you want to stay up to speed on MySQL's developments, check out these instructions for updating to the latest Development Milestone Release.

MySQL Group Replication plugin issues with 5.7.8-rc2. Once you've got MySQL 5.7.8-rc2 running, be on the lookout for this "Segmentation Fault" bug.

MariaDB/MySQL: ON REPLACE triggers. If you're thinking about using REPLACE as a shortcut for SELECT + (UPDATE or INSERT), you'd better consider your triggers first!

High Availability MySQL on cPanel with Galera Cluster. "It is not uncommon to find MySQL to be the culprit when it comes to overloading the server. By having a remote MySQL server or cluster, we can offload some of the burden and increase the availability of other important services on the server."

Create MySQL Index. They're not called "fast access paths" for nothing!

Containers everywhere! Getting started with Docker. Physical shipping containers are easy to manage because they have predictable and defined dimensions. Why not software containers too? This primer will get you acclimated with Docker.

How Shopify handles 300M uniques a month running Rails, Docker, and MySQL. Here's some serious scalability in action (plus Docker actually running in production).  

Jobs section

Draft Kings is looking for an experienced MySQL DBA to run the show on the database side. If interested, reach out to the recruiting manager directly at

Tumblr is looking for MySQL engineers with a strong programming background. If you want to help Jetpants hit mach speed, check out their listing here. is looking for a MySQL Database administrator to join our headquarters in Amsterdam, NL. Apply here.

GitHub is looking to hire a Database Infrastructure Engineer who wants to build, maintain and scale high impact database clusters. If you are interested, check out their listing.

The Wikimedia Foundation is looking for a DBA with advanced experience with MariaDB and/or MySQL, to work with databases related to Wikipedia and other Wikimedia projects. Find out more here.  

Thanks!  Baron & Anna  

Comic Cred - Bill Amend

Forward to Friend 
Licensed under Creative Commons Attribution-ShareAlike 4.0 International
2015 VividCortex, Inc. 

Our mailing address is:
696 Berkmar Circle
Charlottesville, VA 22901
unsubscribe from this list    update subscription preferences 
Email Marketing Powered by Mailchimp