Backup and data streaming with xbstream, tar, socat, and netcat

On April 4th 2012 Xtrabackup 2.0 was released in to GA by Percona along with a new streaming feature called xbstream. This new tool allowed for compression and parallelism of streaming backups when running xtrabackup or innobackupex without having to…

Read More >

The State of MySQL High Availability Going in to 2018

High availability for MySQL has become increasingly relevant given the ever increasing rate of adoption and implementation. It’s no secret to anyone in the community that the popularity of MySQL has become noteworthy. I still remember my start with MySQL…

Read More >

Measuring the potential overhead of PMM Client on MySQL workloads

Having good historial metrics monitoring in place is critical for properly operating, maintaining and troubleshooting database systems, and Percona Monitoring and Management is one of the options we recommend to our clients for this. One common concern among potential users…

Read More >

Exporting custom metrics to influxdb

In the TICK stack from influxdata , Telegraf is used to collect and send data to influxdb. Metrics in Influxdb can then be viewed using visualization tools like Grafana. There are several input and output plugins for telegraf, which can…

Read More >

MongoDB Europe 2017 Recap

It’s November, time for MongoDB Europe event. For the second consecutive year, London hosted all the MongoDB experts to share what is new and exciting about the most popular NoSQL database in the world. After I missed the event last…

Read More >

Insights on the Sysbench 1.0 Release

If you’ve ever had to evaluate server performance, you likely know of sysbench, a performance benchmark project started by Peter Zaitsev with continued development by Alexey Kopitov. The last official release was the version 0.4, which is found in almost…

Read More >

Ansible and AWS Automation

Overview The goal was to create and manage a MySQL RDS instance and learn how to control AWS resources by using Ansible. With Ansible interacting with AWS it’s best to determine how hard or easy it is to build and…

Read More >

Asynchronous Replication from MySQL Cluster

MySQL Cluster is a highly available, distributed, shared-nothing database with very interesting performance characteristics for some workloads. Among other features, it supports automatic sharding and allows us to bypass the SQL layer if we don’t need it, via the NDB…

Read More >

An Introduction to the MongoDB Database Profiler

MongoDB’s database profiler lets us collect some performance data about operations happening on a MongoDB instance. In this post, I will show you how we can enable the profiler, what kind of information it can store for us, how to query this…

Read More >

Customizing pt-stalk to Capture the Diagnostics Data You Really Need

Valeriy Kravchuk’s great recent post on using oprofile to profile MySQL mentioned how pt-stalk, the script from Percona Toolkit to capture diagnostics data based on a detected condition, currently does not support the new operf comand, and relies instead on the deprecated and soon…

Read More >
Page 1 of 612345...Last Page »