Virtual servers for MySQL are popular but are they the answer? Should we be containing our instances instead. An Updated Performance Comparison of
Virtual Machines and Linux Containers is an interesting study of using containers over VMs by four brilliant folk from IBM Research in Austin. There are several benefits to containers that are detailed in the study.
So what is wrong with VMs? IBM has been using them since the 1970s. Well, VMs have a static number of virtual CPUs (vCPU) and a fixed amount of RAM that bound performance. And each vCPU can only use up to one real CPUs of clock cycles. Since each VM is a Linux process, resource management like the scheduler come into play.
Containers? They are built on the kernel namespaces. A container acts like its own little Linux box but shares the overhead with other containers and the host. Stuff ‘inside’ the container can not see outside. Containers can be set up to use resources between them. Plus they can be constrained to only use a defined amount of resources such as CPU, memory and I/O.
A good part of the study looks at using MySQL on native hardware, KVM, and three Docker configurations. It is very interesting that throughput with Docker was close to native hardware and much less overhead than the KVM. SysBench shows that KVm hs much higer overhead 40%+ in ll cases. It appears that the container loses 1.5% CPU utilization.
So maybe we need to stop spinning up VMs and start deploying containers. More on this later.
The MySQL Release Notes should be part of any DBA’s regular reading list. The Changes in MySQL 5.6.20 came out last week and there are some interesting goodies.
- MySQL now includes DTrace support on Oracle Linux 6 or higher with UEK kernel.
- A new system variable
binlog_impossible_mode controls what happens if the server cannot write to the binary log, for example, due to a file error.
- The mysqlhotcopy utility is now deprecated and will be removed in a future version of MySQL
5.6.20 has a slew of bug fixes, functionality changes, and notes.
So why should you be reading the changes on a regular basis? There isa goldmine of information in them. For instance, if you use
blobs, consider this:
Important Change: Redo log writes for large, externally stored BLOB fields could overwrite the most recent checkpoint. The 5.6.20 patch limits the size of redo log BLOB writes to 10% of the redo log file size. The 5.7.5 patch addresses the bug without imposing a limitation. For MySQL 5.5, the bug remains a known limitation.
As a result of the redo log BLOB write limit introduced for MySQL 5.6, innodb_log_file_size should be set to a value greater than 10 times the largest BLOB data size found in the rows of your tables plus the length of other variable length fields (VARCHAR, VARBINARY, and TEXT type fields). Failing to do so could result in “Row size too large” errors. No action is required if your innodb_log_file_size setting is already sufficiently large or your tables contain no BLOB data. (Bug #16963396, Bug #19030353, Bug #69477)
That is golden information for those of us who used a lot of
blobs and great info for configuring servers.
High Availability With MySQL – Jay Janssen of Percona
Monday, August 4, 2014
111 W. Washington St.
Come join Jay Janssen, Principal Consultant at Percona as he speaks about High Availability with MySQL. Jay has been with Percona since 2011. Before that, spent 7 years working for Yahoo in a variety of fields including High Availability architectures, MySQL training, tool building, global server load balancing, multi-datacenter environments, operationalization, and monitoring.
Pizza and beverages will be provided.
Register before August 1st for early bird pricing!
Millions of organizations around the world trust MySQL to power their business-critical web, cloud, and embedded applications. Want to learn best practices to develop next-generation applications with MySQL? Joins us at MySQL Central @ OpenWorld.
Learn new skills
Share and network with the global MySQL community
Hear about new MySQL features directly from Oracle
Get insight on product roadmaps
The inaugural Meet-up Oklahoma City MySQL Meetup is Wednesday, July 23, 2014!
As a special guest speaker, Peter Zaitsev (CEO of Percona and co-author of High Performance MySQL) will be giving a presentation on “Best Indexing Practices”, followed by a Q/A session.
Please RSVP if you plan to attend so we can get a good headcount for food and beverages that will be provided and as always, please spread the word to friends or colleagues in the industry.
It should be a great night and great first event for the MySQL user group in OKC!
Please RSVP for next Monday’s North Texas MySQL Users Group Meeting so we will know how much pizza to order.
MYSQL Tuning Trick for Queries and Server Tuning
Monday July 14th 6PM!
Event is free to the public. Newbies welcome!
Presented By: Dave Stokes, MySQL Community Manager North America, Oracle Corporation
Plus meet Oracle Ace, Oracle MySQL Ace, and IOUG Big Shot George Trujillo who has recently moved to DFW.
6031 Connection Drive
Suite 900 Room 9068
Irving, TX 75038
Start :Monday, July 14, 2014 6:00 PM
THe MySQL APT Repository provides an easy and convenient way to get the latest MySQL software. My test server was need of a refresh so I put on a fresh install of Ubuntu 14.04 and downloaded
sudo dpkg -i mysql-apt-config_0.2.1-1ubuntu14.04_all.deb
[sudo] password for dstokes:
Selecting previously unselected package mysql-apt-config.
You will get a choice to install MySQL 5.6 or the latest 5.7 DMR.
sudo apt-get update Pulls the latest information from the repository for the various packages.
sudo apt-get install mysql-server Installs the server and will start it running. And then a quick
sudo apt-get install mysql-workbench to get me where i needed to be.
There is a detailed information at A Quick Guide to Using the MySQL APT Repository
The North Texas MySQL Uxer Group will meet July 14th in the Oracle office in Irving at 6PM. Part of the topic will be MySQL query & server tuning with MySQL Workbench and part will be a surprise from Oracle ACE, Oracle MySQL ACE, and IOUG big shot George Trujillo who was recently relocated to the Dallas / Fort Worth Area.
And yes, pizza will be served ’cause pizza makes user groups run.
6031 Connection Drive
Irving, TX 75039
MySQL is a proud sponsor of the Mountain Moodle Moot, July 9-11, 2014 – Helena, Montana. There will be sessions back-to-back covering query tuning, system tuning, and little known tricks using MySQL Workbench. This years Moot is already SOLD OUT.
Moodle is a learning management system and very popular with many schools across the world.
There are 3 three amazing social events planned for Friday afternoon – sponsored by Oracle/MySQL. Lunch, a tour train ride and a great social at the Blackfoot Brewery complete with tour and brews.
If you have your ticket and want me to cover anything specific in my sessions, please let me know!