by Yves Trudeau | Dec 7, 2017 | Hardware and Storage, Insight for DBAs, MySQL, Percona Software
This post is a hands-on look at ZFS with MySQL. In my previous post, I highlighted the similarities between MySQL and ZFS. Before going any further, I’d like you to be able to play and experiment with ZFS. This post shows you how to configure ZFS with MySQL in a...
by Peter Zaitsev | Nov 9, 2017 | MySQL
In this blog post, I’ll look at MySQL and Linux context switches and what is the normal number per second for a database environment. You might have heard many times about the importance of looking at the number of context switches to indicate if MySQL is...
by Tim Vaillancourt | Aug 12, 2016 | MongoDB
In this post, we’ll discuss tuning Linux for MongoDB deployments. By far the most common operating system you’ll see MongoDB running on is Linux 2.6 and 3.x. Linux flavors such as CentOS and Debian do a fantastic job of being a stable, general-purpose...
by Vadim Tkachenko | Jun 20, 2016 | MySQL
This post is a continuance of my Docker series, and examines Running Percona XtraDB Cluster nodes with Linux Network namespaces on the same host. In this blog I want to look into a lower-level building block: Linux Network Namespace. The same as with cgroups, Docker...
by Nik Vyzas | Mar 30, 2016 | Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent years as a lightweight alternative to virtualization. It is ideal for building virtual development and testing environments....
by Akshay Suryawanshi | Jul 10, 2015 | Insight for DBAs, MySQL, Webinars
Have you ever wondered what could happen if your MySQL database goes down? Although it’s evident such a crash will cause downtime – and surely some business impact in terms of revenue – can you do something to reduce this impact? The simple answer is...
by Vadim Tkachenko | Jul 1, 2015 | MongoDB, MySQL
Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical...
by Daniel Guzmán Burgos | Nov 12, 2014 | Insight for DBAs, MariaDB, MySQL, Percona Software
Did your logging stop working after you set up logrotate? Then this post might be for you. Some time ago, Peter Boros wrote about Rotating MySQL Slow Logs safely, explaining the steps of a “best practice” log rotate/archive. This post will add more info...
by Jericho Rivera | May 13, 2014 | MySQL, Percona Software
There are a couple of posts about setting up Percona XtraDB Cluster on Vagrant and Percona Server on MySQL Sandbox – those are two of the top tools used by the Percona Support team for testing and bug processing among other things. In this post, however, I will...
by Alexander Rubin | Dec 7, 2013 | MySQL
Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those...
by Fernando Ipar | Oct 29, 2013 | Insight for DBAs, Percona Events, Webinars
Next week, on Nov. 6, I will be delivering a webinar about running MySQL on Windows, with a strong focus on Linux-based sysadmins and DBAs – and how not to go crazy in the process. An interesting (and challenging!) part of working for Percona is that you never...
by Yves Trudeau | May 24, 2013 | Hardware and Storage, Insight for DBAs, MySQL
I am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low virtualization...
by Vadim Tkachenko | Feb 28, 2013 | MySQL, Percona Software
Following Roel’s post, Percona Server on the Raspberry Pi: Your own MySQL Database Server , I thought what other crazy gadget can I run Percona Server on? And having an Asus Nexus 7 Android tablet I decided to give it a try. Anything below contains a risk that...
