January 5, 2015 By Severalnines

Cloud storage is hot. Dropbox, Apple iCloud, Google Drive, Microsoft SkyDrive and Amazon Cloud Drive all offer cloud sharing platforms where you can store documents in the cloud and access them from all your devices. For enterprises who require full control, ownCloud is an open source solution that allows files to be stored on-premises and/or a backend cloud. 

In this blog post, we’ll show you how to deploy a high availability setup using ownCloud Community Edition. We will need to set up redundancy in each of the following layers:

• file storage
• web server
• database server
• load balancer

We will use five servers. ownCloud will run on three separate servers with MySQL Galera Cluster 5.6 and GlusterFS running on RHEL 6.5 64bit. ownCloud supports GlusterFS as primary storage. ClusterControl will be co-located …

Even if new tools from the Percona Toolkit can do a more extensive or a better job, "mysqladmin" has the advantage to be included on the Debian/Ubuntu packages of MySQL, MariaDB (and probably Percona Server as well) and to be simple of use and to understand without outputting tons of unnecessary informations.

I forked the latest version of it (3.5) to fix some bugs and add stats/infos about many new functionalities present on newer versions of MySQL but also some specific to XtraDB, to MariaDB and also TokuDB stats while still being fully compatible with older versions of MySQL.

You can find the latest version at : https://github.com/jb-boin/mariadb/blob/5.5.30/debian/additions/mysqlreport
To have more infos about it and the changelog : https://mariadb.atlassian.net/browse/MDEV-573

Have you ever tried to install Xtrabackup on Amazon EC2 instance with Oracle’s MySQL 5.6? Dependencies hell strikes when you ask pretty common and reasonable thing – run the GA version of MySQL and backup it with the most popular open-source tool – XtraBackup. From this post you will learn how to resolve the conflicts and make everybody happy.

mysql55-libs conflicts with mysql-community-libs-5.6.22

A fresh Amazon Linux AMI, 2014.09 EC2 instance comes with MySQL 5.5.40 in amzn-updates repository. Today MySQL 5.5 turns five years old. It’s a good and stable version. But many people want to run MySQL 5.6, because it’s better than 5.5, it supports full-text indexes and Oracle ends support of 5.5 this year.

Oracle distributes MySQL releases via YUM repository. Installing MySQL from the YUM repository is a good idea because YUM takes care of …

I was sad that it is over with Hack MySQL. It's features where very helpful to me especially in code testing.

VividCortex has always tracked process activity to help monitor and explain database performance, and recent enhancements to the Top Processes feature provide even more clarity. Often, processes impact one another in unexpected ways, and monitoring both MySQL and system resource utilization at high resolution is the only way to pinpoint those instances.

As we develop the product, our goal is to bring users deeper analysis of everything in the system through a unified interface across a diversity of platforms and technoligies. We are excited to announce our latest step is enhanced per-process metrics support for monitoring FreeBSD.

What does this mean? Quite simply, you can now enjoy the unparalleled insight we offer for Linux if you are using FreeBSD. This includes CPU, memory, I/O …

After 10 years HackMySQL.com has been retired. The tools are archived at github.com/daniel-nichter/hackmysql.com

I began writing MySQL tools in 2004 because at the time there were none except for mysqldumpslow. I was a Unix sysadmin in a large datacenter, so I worked on many different servers and MySQL instances. Tools for any sufficiently complex system are a necessity. Imagine a car mechanic trying to work without basic tools like an oil filter wrench, torque wrench, or belt tensioner. That's what work with MySQL was like in 2004. Certainly, many people made their own tools, but I think I was the first to develop, document, and publish general-purpose MySQL tools. If I wasn't the first then it's a tie with Baron Schwartz, creator of Maatkit. In 2008 he hired me at …

Add mysqlidxchk.

Add mysqlsniffer.

Add mysqlsla.

Add mysqlreport.