Put open source to work
July 16–17, 2018: Training & Tutorials
July 18–19, 2018: Conference
Portland, OR

Databases in the hosted cloud

Colin Charles (Percona)
4:15pm4:55pm Thursday, July 19, 2018
Level: Intermediate
Average rating: ***..
(3.00, 3 ratings)

Who is this presentation for?

  • CIOs, CTOs, developers, infrastructure planners, and DBAs

Prerequisite knowledge

  • A basic understanding of MySQL or PostgreSQL

What you'll learn

  • Learn how to run MySQL and PostgreSQL efficiently in the hosted cloud

Description

Today you can use hosted MySQL, MariaDB, Percona Server, and PostgreSQL in several cloud providers as a database as a service (DBaaS), and nearly everyone today uses some form of database in the hosted cloud.

Colin Charles explores how to efficiently deploy a database for optimal performance, with a particular focus on MySQL. You’ll learn the differences, the access methods, and the level of control you have for the various public cloud offerings: Amazon RDS including Aurora, Google Cloud SQL, Rackspace OpenStack DBaaS, Microsoft Azure, and Alibaba Cloud. You can’t control every aspect of a deployment. However, you’ll probably be happier knowing much of it is managed for you.

Topics include:

  • Backup strategies
  • Planning for multiple data centers for availability
  • Where to host your application
  • How to get the most performance out of the solution
  • Cost
  • Monitoring
  • Moving from one DBaaS to another
  • Moving from a DBaaS to your own hosted platform
Photo of Colin Charles

Colin Charles

Percona

Colin Charles is the chief evangelist at Percona. Previously, Colin was on the founding team of MariaDB Server, worked at MySQL, and worked actively on the Fedora and OpenOffice.org projects. Colin has been a MySQL user since 2000. He’s well known within open source communities in APAC and has spoken at many conferences.