Introduction

This blog is a follow up to my original blog in https://blog.mariadb.org/performance-evaluation-of-mariadb-10-1-and-mysql-5-7-4-labs-tplc/ . First of all I would like to thank for all the comments I received. Based on the comments there was a concern if the differences seen on performance was due to different configuration setup. Furthermore, I did not know that there was a configuration variable to get similar multi-threaded flush mechanism on MySQL as there is on MariaDB. To find out if the different configuration variables or different defaults were the reason for different performance, I ran several rounds of new tests.

Test 1

Changing number of buffer pool instances or value of innodb thread concurrency do not seem to have significant effect on at least LinkBench benchmark …

Disclaimer: I’m not specially an expert of benchmarking, this post is to compare different options. All comments and advices are welcome.

I’m not telling you anything new, the show processlist command is a fantastic command line tool for instant check.
But what about monitor your databases with this command embedded in a tool?

Just have a look at this graph:

With 5K queries per seconds, how much will be hidden with a show processlist executed every seconds? Probably a lot.
So, I wanted to test which alternatives could be efficient to retrieve all the queries during a time lapse.

Test procedure and configuration

I used sysbench 0.5 (with oltp.lua) to make my tests on different configurations and …

Dear MySQL Users,

The MySQL developer tools team announces 6.2.2 RC – the final release
candidate for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the upcoming major update for the official MySQL
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL
5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5,
with features such as:

• A new spatial data viewer, allowing graphical views of result sets
  containing GEOMETRY data and taking advantage of the new GIS
  capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting
  on.
• MySQL Fabric cluster connectivity – Browsing, view status, and connect
  to any MySQL instance in a Fabric Cluster. …

The MySQL developer tools team announces 6.2.2 RC – the final release candidate for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the upcoming major update for the official MySQL 
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL 5.6  and MySQL 5.7
DMR (Development Release) as well as MySQL Fabric 1.5, with features such as:

• A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and
   taking advantage of the new GIS capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting on.
• MySQL Fabric cluster connectivity – Browsing, view status, and connect to any MySQL instance in a 
  Fabric Cluster. …

Jothir wrote great blog post, introducing MEB's "Backup to Cloud" feature. And while this blog post is great source of information for Amazon users who consider using MEB it is not so clear how to setup the cloud storage itself for those MEB users who are only considering storing backups in the Cloud. I actually was one of them and decided to share my experience.

OK, so what do you need to start using MEB with Amazon S3 service?

1. Amazon AWS account. You can register it for free at https://portal.aws.amazon.com/gp/aws/developer/registration/index.html
2. A bucket where …

Tue, 2014-09-02 12:00svetoslavsavov

When you need a fast and reliable hosting solution, you should consider which web server and database system to use. Many sites find the combination of nginx (pronounced "engine x") and MariaDB to be an optimal solution. Let's see how to install and configure the applications to work together.

Nginx is a stable, lightweight, and fast open source web server. Nowadays it is the second most popular web server overall, after Apache. More and more system architects are installing it on their servers to support heavy resource demands and efficiently handle the traffic volume at popular web sites. Nginx can also serve as a reverse proxy service in front of Apache, and handle load-balancing.

For its part, MariaDB is a fast and a reliable database engine. Though it is a binary drop-in replacement …

很久之前看过这个帖子,当时没有细究,这几天看了下mysql相关的internal 突然想起这个问题,跟三四个朋友讨论了下 想把这个问题展开讲一讲。

源帖子内容见：https://community.oracle.com/thread/1087650?start=0&tstart=0

这个帖子的内容为一个老外问oracle如何避免partial write的,也就是大家所说的半个IO问题,IO 在写到一半的时候发生断裂,（瞬间断线,瞬间crash瞬间存储或者机器故障等） 虽然这个情况极少发生,但是在非常规恢复的时候也是经常遇到的,例如某个block内部出现不一致,也就是我们所谓的逻辑坏块。
我仔细的又过了一遍帖子,发现下面的几个回答完全不准确,或者有点张冠李戴的意思。

首先我们看看什么是mysql 的double write:

—–引自 …

To get more familiar with docker and to create a test setup for MySQL Cluster I created docker images for the various components of MySQL Cluster (a.k.a. NDB Cluster)

At first I created a Fedora 20 container and ran all components in one container. That worked and is quite easy to setup. But that's not how one is supposed to use docker.

So I created Dockerfile's for all components and one base image.

The base image:

• contains the MySQL Cluster software
• has libaio installed
• has a mysql user and group 
• serves as a base for the other images

The management node (ndb_mgmd) image:

• Has ndb_mgmd as entrypoint
• Has a config.ini for the cluster …

Fri, 2014-08-29 11:18ivanstoykov

This blog post will show how to Install MaxScale and MariaDB 5.5 Galera Cluster with Severalnines Cluster Control on Amazon Virtual Private Cloud.

The steps in this blog

Step 1. How to setup Amazon Virtual Private Cloud
Step 2. How to prepare the MariaDB Galera Cluster nodes and to set the subnet routings
Step 3. How to install MariaDB Galera 3 node cluster in the private subnet of an AWS VPC using Severalnines Cluster Control
Step 4. How to build MaxScale from git source on the Cluster Control node

Components in this High Available set up

• MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB
• Cluster Control makes managing your MariaDB Galera Cluster easier
• MaxScale makes load balancing and other flexible customisation possible

Step 1. How to setup Amazon Virtual Private Cloud …

A common concern in the MySQL community is how to best implement high availability for MySQL. There are various built-in mechanisms to accomplish this such as Master/Master and Master/Slave replication using binary logs as well as FOSS solutions such as Galera and Tungsten, just to name a few. Often times, IT Managers and DBAs alike opt to avoid implementing a third party solution due to the added administrative overhead without fully evaluating the available solutions. In today’s blog post, I would like to describe the process for configuring a Master/Slave topology and switching to a Master/Master topology with Tungsten Replicator.

Tungsten Replicator is a well known tool that has gained much acclaim in the area of MySQL Enterprise database implementation, however, many teams tend to stay away from the implementation to avoid over-complicating the replication topology. I have listed and described all of the steps required to …