Cloud and MySQL

Amazon RDS Multi-AZ Deployments and Read Replicas

RDS Multi-AZ

Amazon RDS is a managed relational database service that makes it easier to set up, operate, and scale a relational database in the cloud. One of the common questions that we get is “What is Multi-AZ and how it’s different from Read Replica, do I need both?”.  I have tried to answer this question in […]

Read more

When Should I Use Amazon Aurora and When Should I use RDS MySQL?

Now that Database-as-a-service (DBaaS) is in high demand, there is one question regarding AWS services that cannot always be answered easily : When should I use Aurora and when RDS MySQL?
DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure, and without installing software. I’m not sure if there is […]

Read more

Is Serverless Just a New Word for Cloud-Based?

serverless architecture

Serverless is a new buzzword in the database industry. Even though it gets tossed around often, there is some confusion about what it really means and how it really works. Serverless architectures rely on third-party Backend as a Service (BaaS) services. They can also include custom code that is run in managed, ephemeral containers […]

Read more

Using gh-ost with Amazon Aurora for MySQL

gh-ost online schema change

In this day and age of agile methodologies and fast-paced development methods, database schema changes are as inevitable as the growth of data. We have been thoroughly familiar with the effectivity of pt-online-schema-change for the last couple of years but it has one limitation. If the table is too hot to acquire metadata locks […]

Read more

The Evolution of the DBA in an “As-A-Service” World

DBA

The requirements for managing and running a database in a modern enterprise have evolved over the past ten years. Those in charge of running enterprise databases have seen their focus shift from ensuring access and availability, to architecture, design and scalability responsibilities. Web-first companies pioneered the change by charging site reliability engineers (SRE’s) or […]

Read more

Percona Live 2018: POLARDB, an InnoDB Based Shared-Everything Storage Solution

Inaam Alibaba Percona Live 2018

We’re heading into the home stretch at Percona Live 2018, but the sessions are continuing. I was able to attend a talk this afternoon given by Inaam Rana, a Database Developer at Alibaba Cloud, on PolarDB, an InnoDB based shared-everything storage solution.
POLARDB provides read scale out on shared everything architecture. It features 100% backward […]

Read more

Percona Live 2018 Keynotes, Day Two

Percona Live 2018 Panel Keynote

Welcome to Percona Live 2018 keynotes, day two!
Day two of Percona Live 2018 looks to be as filled with great talks as day one. Today we started with keynote presentations from Percona, a panel on the evolution of databases and talks from VividCortex and Upwork. You can view the recording of today’s keynotes here.
Percona Welcome […]

Read more

Percona Live 2018 Sessions: Ghostferry – the Swiss Army Knife of Live Data Migrations with Minimum Downtime

Shuhao Ghostferry Percona Live 2018 Sessions

In this blog post on Percona Live 2018 sessions, we’ll talk with Shuhoa Wu, Software Developer for Shopify, Inc. about how Ghostferry is the Swiss Army knife of live data migrations.
Existing tools like mysqldump and replication cannot migrate data between GTID-enabled MySQL and non-GTID-enabled MySQL – a common configuration across multiple cloud providers that cannot be […]

Read more

Percona Live 2018 Sessions: Microsoft Built MySQL, PostgreSQL and MariaDB for the Cloud

Percona Live 2018 Sessions Microsoft Azure

In this blog post on Percona Live 2018 sessions, we’ll talk with Jun Su, Principal Engineering Manager at Microsoft about how Microsoft built MySQL, PostgreSQL and MariaDB for the cloud.
Offering MySQL, PostgreSQL and MariaDB database services in the cloud is different than doing so on-premise. Latency, connection redirection, optimal performance configuration are just a few […]

Read more