Have you ever spent a lot of time thinking about how to install and configure a Linux server for MySQL database? I will try to highlight all the critical steps and some of the decisions you may need to make.

Linux distribution.

Unless you have a really good experience in systems administration, choose a widely supported Linux distribution. The best choices usually are RedHat or its free cousin called CentOS. Compatible alternatives you could also consider are Scientific Linux and Oracle Linux. Make sure you will be installing a 64-bit version, unless you have a very good reason not to.

Storage.

If you have multiple disks available in the server, create a single array from all disks. Choose RAID level that offers better performance rather than more disk space, so either RAID 1 or RAID …

Key Notes

It was simply amazing for me as ex-MySQL AB to be at the conference today.
I was really emoted seeing so much people most of the ones I know, all together again.
The spirit was again the right one, with the will to say WE ARE HERE!
Impressive, and I am happy to say once more, “I was there”.
I am not going to comment the keynote speeches, but want to share the Baron message.
We are here to share, and help each other to make better, help each other to go beyond our current limit.
The spirit was the right one, the people there probably the most smart in the field, so why not.
I have only one world AMAZING.

Topic: Measuring Scalability and Performance With TCP

What if you had all the data you needed to measure system performance
and scalability at any tier, discover performance and stability
problems before they happen, and plan for capacity …

Lets see what HA solutions can be designed in mysql and where are they suited.

1. Single master - single slave.

M(RW)|S(R) A simple master slave solution can be used for a small site - where all the inserts go into the master and some (non-critical) requests are served from the slave. In case if the master crashes, the slave can be simply promoted as the master - once it has replicated the "

Winners of the 2012 MySQL Community Awards were announced at the Percona Live MySQL Conference and Expo just a few hours ago:

...

In terms of continuing with MySQL traditions, it has been my privilege the past years to be the secretary of the MySQL Community Awards panel. We have so many amazing persons, products and companies in this community. One of the nicest thing we can do to each other, and what really builds and fuels a community, is to show appreciation and say thanks to people that really deserve it.

read more

Today we released MariaDB 5.5.23 as stable (GA). The last few days we have also released MariaDB 5.3.6 stable (second GA release) and MariaDB 5.2.12 and MariaDB 5.1.62.

The reason for doing the older releases was that we found a very serious security issue in all recent MariaDB / MySQL releases and we strongly recommend everyone to upgrade to one of the above releases ASAP. We have informed Oracle of the problem and they are likely to issue a new MySQL release soon!

That said, I am very happy that MariaDB 5.5 is finally available as a stable release and I wish you the best of luck with it!

MariaDB 5.5 includes all features from MySQL 5.5 and MariaDB 5.3 (with the exception of OQGraph for which we are awaiting a patch from the OQgraph developers to solve a compatibility issue).

MariaDB 5.5 is a …

Download PDF Presentation

Determining the Query Execution Plan (QEP) of an SQL statement is the primary analysis tool for DBAs. Understanding how to interpret the information from the EXPLAIN command and what additional commands and tools exist to add supplementary information are essential skills that will be used daily in production operations.

The MySQL EXPLAIN QEP is significantly different from an Oracle QEP and Oracle DBAs need to understand and learn the most appropriate way to understand and navigate this information to effective …

Schooner announced initial benchmarks of SchoonerSQL™ against the new Percona XtraDB Cluster. Percona XtraDB Cluster is a distribution of Percona Server with the Galera HA toolkit.

Standard benchmarks are a proxy for the performance that users may see with their own workloads. Schooner ran the standard DBT2 benchmark, which is the open-source OLTP version of the TPC-C benchmark, using a heavy workload of 1,000 warehouses with 32 concurrent connections to the database and zero think time. Measurements in each case were made using a typical two-node master-slave configuration. Each node was a standard IBM x86 server with 12/24 processor cores/threads, 72 GB of DRAM, and two 320 GB Fusion-io ioDriveDuos, running Red Hat Enterprise Linux 6.2. 

SchoonerSQL Delivers Three Times the Throughput of …

Liveblog: What’s New In MySQL 5.5 and 5.6 Replication
presented by Giuseppe Maxia at the Percona Live MySQL Conference and Expo.

Has been working with MySQL for 11 years.
Yesterday Oracle released MySQL 5.6.5 with new stuff, so the content was rewritten last night.
main features we’ll talk about:
5.5 semi synchronous replication
5.6 delayed replication
server uuid
crash-safe slave
multi-threaded slave
global transaction identifiers

In MySQL 5.5 – what is semisync replication? It increases reliability by making sure that the changes are committed on at least one of the slaves before the write query is returned.
To use it, install the plugin rpl_semi_sync_master on the master, and rpl_semi_sync_slave on the slave. Then you configure the master to use the plugin, and then you restart both the master and slave to activate the plugin and config.

Once you …

MySQL is receiving mainstream media attention this week with Twitter publicly deciding to open source work on its MySQL database. Of course, the problems we see every day are being called out. Per GigaOm’s article:

But it [MySQL] has its problems, among them scalability and performance under the pressure of high transaction rates.

Like Twitter, our customer AppDynamics, is working to better manage data at high availability rates, but they’re taking a slightly different tact. In a recent post on the AppSignal blog, Boris Livshutz, introduces what he calls a ‘Data Cloud’ and looks for common ground between SQL and NoSQL rather than calling out the differences. …

We are pleased to announce the immediate availability of MariaDB 5.5.23. This stable (GA) release incorporates MariaDB 5.3.6 and MySQL 5.5.23, some performance improvements, and bug fixes.

• MariaDB 5.5.23 Release Notes
• MariaDB 5.5.23 Changelog
• MariaDB 5.5.23 Downloads

Please see the What is MariaDB 5.5 page for an overview of MariaDB 5.5.

Sources, binaries, and package downloads are available from our …