In my previous post, I talked about implementing multi-threaded replication (MTR) using Percona Server 5.6. The server pairs that are utilizing MTR are also exclusively using the TokuDB storage engine.

I find TokuDB to be a fascinating engine. I can tell I will need to re-watch our Dbhangops session where Tim Callaghan talked about the differences between B-Tree and Fractal Tree indexes. There’s also a session on how compression works in …

…

Monitoring tools offer alerts based on thresholds and time-series charts of status counters, but they do not tell us what we should monitor. On Tuesday, February 10th at 2 PM EST, Baron Schwartz will discuss the guiding principles needed to answer these questions.

The following questions will be answered:

• What status counters from MySQL are central and core, and which are peripheral?
• What is the meaning of MySQL status metrics?
• Which subsystems inside MySQL are the most common causes of problems in production?
• What is the unit of work-getting-done in MySQL, and how can you measure it?
• Which open-source tools do a good job at monitoring in the way we recommend at VividCortex?
• Which new and/or popular open-source tools should you evaluate when choosing a solution?

To find out more information and register, click …

With JSON functionality, alternate protocols (HTTP, memcache), a move towards saner defaults and crash safety, pluggable logging etc it really looks like MySQL is following what we did in Drizzle years ago, which is great!

I recently updated the High Performance MySQL website to modernize it. I am impressed at how easy it is these days to get a great little brochure site hosted. It used to be a lot more work. I used a variety of tools and services to do this and decided to share this for people who are interested. Hopefully you’ll add comments and point me towards more tools and tips to make these things even easier for me in the future!

Before

The website used to be a WordPress blog. This used to be my go-to solution for everything. It used to be the easiest way to whip together something quickly and put it online.

But WordPress sites have a bunch of problems.

• They need a database. Database down, website down.
• They need care and feeding. WordPress is a major hack target and you have to update it or you’re going to end up serving malware and ads without …

I recently updated the High Performance MySQL website to modernize it. I am impressed at how easy it is these days to get a great little brochure site hosted. It used to be a lot more work. I used a variety of tools and services to do this and decided to share this for people who are interested. Hopefully you’ll add comments and point me towards more tools and tips to make these things even easier for me in the future!

Before

The website used to be a WordPress blog. This used to be my go-to solution for everything. It used to be the easiest way to whip together something quickly and put it online.

But WordPress sites have a bunch of problems.

• They need a database. Database down, website down.
• They need care and feeding. WordPress is a major hack target and you have to update it or you’re going to end up serving malware and ads without …

I recently updated the High Performance MySQL website to modernize it. I am impressed at how easy it is these days to get a great little brochure site hosted. It used to be a lot more work. I used a variety of tools and services to do this and decided to share this for people who are interested. Hopefully you’ll add comments and point me towards more tools and tips to make these things even easier for me in the future!

So how do you use MySQL Fabric to set up a Highly Available Server Farm? The last two postings in this series were on installing Fabric on a master and then setting up slaves. Now it is time to get get the Fabric Farm started.

The Fabric controller is node number 1 and the slaves are 10, 20, and 30 at IP 10.10.13.1, 10, 20, and 30 respectively. I am keeping with the last octet of the IP addresses for clarity. I am trying to recreate the Fabric Farm from this image.

On the 10, 20, and 30 systems we need to add the following to the mysld section of the my.cnf
[mysqld]
binlog-format=ROW
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
report-host=192.168.0.201
report-port=3306
server-id=1
log-bin=mysql1-bin.log

Next set up replication …

Percona is glad to announce the release of Percona Server 5.6.22-72.0 on February 6, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on MySQL 5.6.22, including all the bug fixes in it, Percona Server 5.6.22-72.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – and …

Many of you have already heard about NoSQL databases and one of the the most used tool is Memcached, where you add a cache layer between the application and database. Since MySQL version 5.6, a new plugin is available to do the integration between MySQL and Memcached. On this article, we will learn how to install it on linux, and some basic configurations of it.

Pre-requirements:
Install libevent

Installation:
To install memcached support we will need to create a few tables responsible for MySQL and memcached integration. MySQL already includes the file which creates those tables (innodb_memcached_config.sql), you can find this file in a sub folder of your basedir. To discover where is your basedir, run the bellow command:

mysql> SHOW VARIABLES LIKE 'basedir';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| basedir       | /usr  | …