Over the last several months we’ve designed and built an events dashboard that lets you inspect very large amounts of system event data quickly (interactively). This feature was driven by customer requests and feedback. The initial proof of concept established its usefulness right away, when customers began remarking that they’d diagnosed server issues by noticing events such as database restarts, replication failures, and configuration changes. At least one customer told us this saved them a long wild-goose chase.

The key concept is that event data is loaded fully into the browser and then you can thin-slice and drill down without reloading any events. And it’s fast. Really fast – it remains responsive even with hundreds of thousands of events. Here’s what the last 30 days of fine-grained events looks like on our own systems:

The skyline along the top shows events by count over time. The left-hand pane lets you …

Over the last several months we’ve designed and built an events dashboard that lets you inspect very large amounts of system event data quickly (interactively). This feature was driven by customer requests and feedback. The initial proof of concept established its usefulness right away, when customers began remarking that they’d diagnosed server issues by noticing events such as database restarts, replication failures, and configuration changes. At least one customer told us this saved them a long wild-goose chase.

The key concept is that event data is loaded fully into the browser and then you can thin-slice and drill down without reloading any events. And it’s fast. Really fast – it remains responsive even with hundreds of thousands of events. Here’s what the last 30 days of fine-grained events looks like on our own systems:

The skyline along the top shows events by count over time. The left-hand pane lets you …

Covering indexes can result in orders of magnitude performance improvements for queries. Bradley’s presentation on covering indexes describes what a covering index is, how it can effect performance, and why it works. However, the definition of a covering index can get cumbersome since MySQL limits the number of columns in a key to 16 (32 on MariaDB).

Tokutek introduced multiple clustering indexes into MySQL to address these problems. Zardosht describes the multiple clustering indexes feature and how clustering indexes differ from covering indexes. Zardosht also describes the …

MariaDB 5.5.39 was recently released (it is the latest MariaDB 5.5), and is available for download here:

https://downloads.mariadb.org/mariadb/5.5.39/

This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

• Includes all bugfixes and updates from MySQL 5.5.39 (MySQL 5.5.39 Overview and Highlights)
• XtraDB updated to the version from …

There may come a time when you want to collect some of your emails, put them into a database, and search them with Sphinx. If that time has come, you may enjoy this blog post. It will outline one way to get emails from Gmail into MySQL (with PHP’s IMAP extension) so that they become [...]

FromDual holds its annual company meeting this year in Barcelona, Spain.

We are pleased to invite everybody interested in MySQL technologies (MySQL, Galera Cluster, FromDual Tools, Percona Cluster, MariaDB, etc.) to participate on Thursday evening September 11 at the HCC MONTBLANC, Via Laietana 61, to meet, exchange ideas and discuss MySQL related topics.

The event starts at 18:00, we will meet in the hotel lobby. The planned schedule is:

• How to Implement GTID Replication in MySQL 5.6 (25') and 5' Questions and Answers.
• MySQL backup/restore for anonymized exports (25') and 5' Questions and Answers.
• Break 15 min
• Quick presentation (15') of YOUR project or company.
• Quick presentation (15') of YOUR project or company.
• Break 15 min
• Quick presentation (15') of YOUR project or company.
…

While working on some new features in MariaDB 10.1, I noticed that a normal user couldn't disable the slow query log, which I thought was a bit silly.

While implementing and documenting this feature, I noticed that the information about the different logs is quite spread around and it's not that trivial to find out how to enable/disable the different logs.

To solve this, I created a new MariaDB kb entry, "Overview of the MariaDB logs that I hope MariaDB and MySQL users will be find useful.

Here follows a copy of the kb entry. If you have any comments or things that could be added, please do it in the kb entry so that it will benefit as many as possible!
Overview of MariaDB logsThere are many variables in MariaDB that you can use to …

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.39. This is a Stable (GA) release.

See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the MariaDB Knowledge Base for general information about the MariaDB 5.5 series.

Download MariaDB 5.5.39

Release Notes Changelog …

August 6, 2014 By Severalnines

Well over a thousand sessions have been submitted for the OpenStack Summit and two of them includes our good selves! We’ve submitted two talks with partners of ours: 

• ClusterControl: Efficient and reliable MySQL Management, Monitoring, and Troubleshooting for OpenStack HA)
• Deploying Databases for OpenStack

… and would love it if the talks were included in the final agenda. For that to happen, we need a few more of your votes today!

The OpenStack Summit is a five-day conference for developers, users, and …

MySQL for Visual Studio 1.2 introduces several new features:

• Web Configuration support for MySQL Personalization Provider.
• Web Configuration support for MySQL SiteMap Provider.
• Web Configuration support for MySQL Simple Membership Provider.
• MySQL ASP.NET MVC Project Wizard.
• MySQL Windows Forms Project Wizard.

In this post we are going to see the last one, The MySQL Windows Forms Project Wizard, in action.