Cloud and MySQL

Amazon AWS Service Tiers

This blog post discusses the differences between the Amazon AWS service tiers.
Many people want to move to an Amazon environment but are unsure what AWS service makes the most sense (EC2, RDS, Aurora). For database services, the tiering at Amazon starts with EC2, then moves up to RDS, and on to Aurora. Amazon takes on […]

Read more

Monitoring OS metrics for Amazon RDS with Grafana

OS Metrics

This article describes how to visualize and monitor OS metrics for Amazon RDS instances using Grafana. We use CloudWatch as a data source, and Grafana to query CloudWatch API in real-time to get data. The setup instructions include just four quick steps (assuming you already use Grafana).
Setup
1. Create an IAM user on the AWS panel, […]

Read more

Take Percona’s One-Click 2017 Top Database Concerns Poll

2017 top database concerns

Take Percona’s One-Click 2017 Top Database Concerns Poll.
With 2017 coming quick around the corner, it’s time to start thinking about what next year is going to bring to the open source database community. We just finished Percona Live Europe 2017, and at the conference we looked at new technologies, new techniques, and new ideas. […]

Read more

Percona Live Europe 2016: “Google Cloud SQL: MySQL in the Cloud” with Pravin Pillai

percona live europe

We’re winding down here at the Percona Live Europe Open Source Database Conference 2016, but there are still talks going on.
The conference has a technical focus with an emphasis on the core topics of MySQL, MongoDB, PostgreSQL and other open source databases. Tackling subjects such as analytics, architecture and design, security, operations, scalability and […]

Read more

Amazon RDS and pt-online-schema-change

Amazon RDS and pt-online-schema-change

In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together.
The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by community users and customers. Using it on Amazon RDS requires knowing about some specific […]

Read more

Docker MySQL Replication 101

Docker

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. The solution is flexible and seamlessly integrates with popular CI tools.
 
This post walks through the setup of MySQL replication […]

Read more

Bare-metal servers for button-push database-as-a-service

Enterprises’ demand flexibility, scalability and efficiency to keep up with the demands of their customers — while maintaining the bottom line. To solve this, they’re running to cloud infrastructure services to both cut costs and take advantage of cutting-edge technology innovations. Clouds have brought simplicity and ease of use to infrastructure management. However, with […]

Read more

2016 Percona Live Tutorials Schedule is UP!

12 Days Until Percona Live

We are excited to announce that the tutorial schedule for the Percona Live Data Performance Conference 2016 is up!
The schedule shows all the details for each of our informative and enlightening Percona Live tutorial sessions, including insights into InnoDB, MySQL 5.7, MongoDB 3.2 and RocksDB. These tutorials are a must for any data performance professional!
The Percona […]

Read more

Amazon Aurora in sysbench benchmarks

In my previous post Amazon Aurora – Looking Deeper, I promised benchmark results on Amazon Aurora.
There are already some results available from Amazon itself: https://d0.awsstatic.com/product-marketing/Aurora/RDS_Aurora_Performance_Assessment_Benchmarking_v1-2.pdf.
There are also some from Marco Tusa: http://www.tusacentral.net/joomla/index.php/mysql-blogs/175-aws-aurora-benchmarking-blast-or-splash.html.
Amazon used quite a small dataset in their benchmark: 250 tables, with 25000 rows each, which in my calculation corresponds to 4.5GB worth of […]

Read more

Amazon Aurora – Looking Deeper

Recently my colleague (by Percona) Yves Trudeau and colleague (by industry) Marco Tusa
published their materials on Amazon Aurora. Indeed, Amazon Aurora is a hot topic these days, and we have a stream of customer inquiries regarding this technology. I’ve decided to form my own opinion, and nothing is better than a personal, hands-on experience, which I […]

Read more