Fill out a quick survey on your cloud data plans.

Today, keeping your enterprise agile and flexible is not just an advantage, it is a requirement. Many of the systems and processes once controlled by businesses onsite are moving offsite to “service” models. This includes Platform as a Service (PaaS), Software as a Service (SaaS), Infrastructure as a Service (IaaS), Database as a Service (DBaaS), etc.

These services are usually referred to as being in the cloud. The enterprise using the service doesn’t maintain or manage the infrastructure of the service in question.

Migrating database workloads to the cloud can be a vital part of improving customer experience, gaining deeper business insights and increasing efficiency. More enterprises are …

Get your Percona Live Open Source Database Conference 2018 Super Saver tickets now.

The countdown is on for the annual Percona Live Open Source Database Conference 2018! The conference takes place in Santa Clara, CA from April 23-25, 2018. The theme is Championing Open Source Databases, and the three-day conference will focus on the latest trends, news and best practices in MySQL, MongoDB, PostgreSQL and other open source databases. It includes tracks on time series data, cloud databases, operations, business/case studies and more.

This year’s conference will feature one day of tutorials and …

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.

The CFP for Percona Live Santa Clara 2018 closes December 22, 2017: please consider submitting as soon as possible. We want to make an early announcement of talks, so we’ll definitely do a first pass even before the CFP date closes. Keep in mind the expanded view of what we are after: it’s more than just MySQL and MongoDB. And don’t forget that with one day less, there will be intense competition to fit all the content in.

A new book on MySQL Cluster is out: Pro MySQL NDB Cluster by Jesper Wisborg Krogh and Mikiya Okuno. At 690 pages, it is a weighty tome, and something I fully plan on reading, considering I haven’t played with …

In this blog post I’ll look at the performance of Percona XtraDB Cluster on AWS using different service instances, and recommend some best practices for maximizing performance.

You can use Percona XtraDB Cluster in AWS environments. We often get questions about how best to deploy it, and how to optimize both performance and spend when doing so. I decided to look into it with some benchmark testing.

For these benchmark tests, I used the following configuration:

• Region:
  • Availability zones: US East – 1, zones: b, c, d
  • Sysbench 1.0.8
  • ProxySQL 1.4.3
  • 10 tables, 40mln records – ~95GB dataset
  • Percona XtraDB Cluster 5.7.18
  • Amazon Linux AMI

We …

Join Percona’s Chief Evangelist, Colin Charles as he presents Databases in the Hosted Cloud on Wednesday, October 4, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7).

Register Now

Today you can use hosted MySQL/MariaDB/Percona Server for MySQL/PostgreSQL in several “cloud providers” as a database as a service (DBaaS). Learn the differences, the access methods and the level of control you have for the various public databases in the hosted cloud offerings:

• Amazon RDS including Aurora
• Google Cloud SQL
• Rackspace OpenStack DBaaS
• Oracle Cloud’s MySQL Service …

This blog post will give a brief overview of Amazon RDS capabilities and limitations, and how Percona Support can help you succeed in your Amazon RDS deployments.

One of the common questions that we get from customers and prospective customers is about Percona Support with Amazon RDS. As many companies have shifted to the cloud, or are considering how to do so, it’s natural to try to understand the limitations inherent in different deployment strategies.

Why Use Amazon RDS?

As more companies move to using the cloud, we’ve seen a shift towards work models in technical teams that require software developers to take on more operational duties than they have traditionally. This makes it essential to abstract infrastructure so it can be interacted with as code, whether through automation or APIs. Amazon RDS presents a compelling DBaaS product with significant flexibility while maintaining ease of deployment.

Use …

Many organizations are shifting toward the cloud, but how much are they moving over? New post explains top five reasons to move your MySQL database to AWS EC2.

The post Top 5 Reasons to Move MySQL to AWS EC2 appeared first on Datavail.

In this blog post, we’ll look at some tips on how to configure Aurora RDS parameters.

I was recently deploying a few Aurora RDS instances, a process very similar to configuring a regular RDS instance. I noticed a few minor differences in the way you configure Aurora RDS parameters, and very few articles on how the commands should be structured (for RDS as well as Aurora). The only real literature available is the official Amazon RDS documentation.

This blog provides a concise “how-to” guide to quickly change Aurora RDS parameters using the AWS CLI. Aurora retains the parameter group model introduced with RDS, with new instances having the default read only parameter groups. For a new instance, you need to create and allocate a new parameter group (this requires a DB reboot). After that, you can apply changes to …

If you like to read (a lot) and you're considering to migrate your database workloads to AWS, this might be something for you. Nearly 75 pages of ideas for planning, executing, and troubleshooting database migrations to Amazon Aurora.

I recently published an Aurora Migration Handbook in the form of an AWS Whitepaper. The document can be downloaded from here:

https://d0.awsstatic.com/whitepapers/Migration/amazon-aurora-migration-handbook.pdf

Happy reading!

Usually application don’t connect directly to Percona XtraDB Cluster, but go through a proxy – ProxySQL, for instance. However, if only one proxy node is used it becomes a single point of failure. Not long ago Marco Tusa wrote about how to configure two ProxySQL nodes in front of XtraDB cluster. If deployed on EC2 instances, it […]

The post Setup High Availability For ProxySQL via KeepAlived In AWS appeared first on TwinDB.