When you make a change to your MySQL configuration in production it would be great to know the impact (a “before and after” type of picture). Some changes are obvious. For many variables proper values can be determined beforehand, i.e. innodb_buffer_pool_size or innodb_log_file_size. However, there is 1 configuration variable which is much less obvious for many people working with MySQL: query_cache.

The idea of query cache is great, however, there are a lot of issues with MySQL query …

I don’t normally quote The Register, but I was clearing tabs and found this article: 350 DBAs stare blankly when reminded super-users can pinch data. It is an interesting read, telling you that there are many Snowden’s in waiting, possibly even in your organisation. 

From a MariaDB standpoint, you probably already read that column level encryption as well as block level encryption for some storage engines are likely to come to MariaBD 10.1 via a solution by Eperi. However with some recent breaking news, Google is also likely to do this – see this thread about  …

Congratulations to the entire team at Red Hat, for the release of Red Hat Enterprise Linux 7 (RHEL7). The release notes have something important, under Web Servers & Services:

MariaDB 5.5

MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. MariaDB preserves API and ABI compatibility with MySQL …

It was announced that MariaDB is now the default implementation of MySQL in the newly released Red Hat Enterprise Linux 7.

News of the Red Hat Enterprise Linux 7 can be found here.

And mention of MariaDB replacing MySQL as the default implementation is referenced in their release notes here.

The full change log entry reads:

MariaDB 5.5

• MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. MariaDB preserves API and ABI compatibility with MySQL and adds …

In TokuMX 1.5 that is right around the corner, the big feature will be partitioned collections. This feature is similar to partitioned tables in Oracle, MySQL, SQL Server, and Postgres. A question many have is “why should I use partitioned tables?” In short, it’s complicated. The answer depends on your workload, your schema, and your database of choice. For example, this Oracle related post states “Anyone with un-partitioned databases over 500 gigabytes is courting disaster.” That’s not true for TokuDB or TokuMX. Nevertheless, partitioned tables are valuable; it’s why we …

Another MySQL User Group meeting called "MySQL User Camp-Bangalore" is announced for Jun 20 in Bangalore, India!! Please find more details below:

• Date and time: June 20, 2014 at 3PM IST
• Place: Bangalore, Kalyani Magnum campus
• Registration: Registration is needed, please contact mysql.bangalore@gmail.com
• URL

Agenda:

• MySQL 5.7 New Features and NoSQL support in MySQL
• Sharding as implemented in MySQL Fabric
• Open discussion with MySQL developers

We are looking forward to seeing you on Jun 20!!

And now we return to our previously-scheduled blog series "Docker: Containers for the Masses". To bring the reader up to speed with what episodes have already aired:

• Introduction -- this episode introduced the reader to the storyline and characters: what are containers, how they work containers vs. virtual machines, what is Docker.
• Installation -- this episode featured information about installing Docker

In today's episode, the real excitement begins with actually using …

As an update to the previous announcement from Mar 25, 2014 please find below the updated list of events where MySQL Community team is attending and/or supporting. This time you can find not only EMEA & APAC ones but also conferences & events we are covering in the US & Canada. You are invited to meet our engineers at the events below.  

EMEA 

• NEW!! BGOUG, Sandanski, Bulgaria, June 13, 2014
  •  Georgi Kodinov will attend and speak at this local Oracle User Group event. Feel free to come.
• PHP Tour Lyon, Lyon, France, June 23-24, 2014
  • MySQL team is …

#DBHangOps 06/12/14 -- MySQL Credential management and Gaps

Check out the recording below!

Hello everybody!

Join in #DBHangOps this Thursday, June, 12, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

• MySQL Credentials

  • How do you set them up?
  • How do you store them?
  • Who has access to them?

• Gaps -- When do you stop working on a specific task

  • How do you know when you've hit the "80/20" threshold?
  • What's a "sub-optimization"?
  • When are you "over-optimizing"?

  • When do you stop automating and accept manual process

    • What is important to automate in your environment?
    …