EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live 2017: Deploying MongoDB on Public Clouds

 | April 26, 2017 |  Posted In: Cloud and NoSQL, Insight for DBAs, Insight for Developers, Percona Live

MongoDB on Public Clouds

Today at Percona Live 2017, the afternoon is jam-packed with open source technology lectures filled with community members eager for the latest on the best strategies – including how you should deploy MongoDB on public clouds. Dharshan Rangegowda (CEO of ScaleGrid) discussed deploying MongoDB on public clouds. ScaleGrid provides a fully managed Database-as-a-Service (DBaaS) solution […]

Read More

Percona Live 2017: Day Two Keynotes

 | April 26, 2017 |  Posted In: Big Data, InnoDB, Insight for DBAs, Insight for Developers, MySQL, MySQL 8.0, Percona Live

Percona Live 2017

Welcome to the second day of the Percona Live Open Source Database Conference 2017, and the second set of Percona Live keynotes! It’s a bit rainy outside today, but that isn’t bothering the Percona Live attendees (we’re all indoors learning about new open source technologies)! Day two of the conference kicked off with another four keynote […]

Read More

Better Than Linear Scaling

 | April 22, 2017 |  Posted In: Hardware and Storage, High-availability, Insight for DBAs, Insight for Developers, MySQL

Scalability

In this blog, we’ll look at how to achieve better-than-linear scaling. Scalability is the capability of a system, network or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth. For example, we consider a system scalable if it is capable of increasing its total output under […]

Read More

Dealing with MySQL Error Code 1215: “Cannot add foreign key constraint”

 | April 6, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

MySQL error code 1215

In this blog, we’ll look at how to resolve MySQL error code 1215: “Cannot add foreign key constraint”. Our Support customers often come to us with things like “My database deployment fails with error 1215”, “Am trying to create a foreign key and can’t get it working” or “Why am I unable to create a […]

Read More

New MariaDB Dashboard in Percona Monitoring and Management Metrics Monitor

 | April 3, 2017 |  Posted In: Events and Announcements, InnoDB, Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Monitoring and Management, Percona Server, Percona Software, PMM

MariaDB

In honor of the upcoming MariaDB M17 conference in New York City on April 11-12, we have enhanced Percona Monitoring and Management (PMM) Metrics Monitor with a new MariaDB Dashboard and multiple new graphs! The Percona Monitoring and Management MariaDB Dashboard builds on the efforts of the MariaDB development team to instrument the Aria Storage Engine Status Variables related […]

Read More

Upgrading to Percona Server for MongoDB 3.4 from Previous Versions

 | March 15, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB

MMAPv1

This post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we will walk through upgrading to Percona Server for MongoDB 3.4 from a previous MongoDB version. We will highlight the important details to guarantee the successful completion of this task in your environment. MongoDB 3.4 was just released, and […]

Read More

How to Change MongoDB Storage Engines Without Downtime

 | March 7, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB

MongoDB Storage Engines

This blog is another in the series for the Percona Server for MongoDB 3.4 bundle release. Today’s blog post is about how to migrate between Percona Server for MongoDB storage engines without downtime. Today, the default storage engine for MongoDB is WiredTiger. In previous versions (before 3.2), it was MMAPv1. Percona Server for MongoDB features […]

Read More

Quest for Better Replication in MySQL: Galera vs. Group Replication

 | February 24, 2017 |  Posted In: Group Replication, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster, Replication

Group Replication

UPDATE: Some of the language in the original post was considered overly-critical of Oracle by some community members. This was not my intent, and I’ve modified the language to be less so. I’ve also changed term “synchronous” (which the use of is inaccurate and misleading) to “virtually synchronous.” This term is more accurate and already used by both […]

Read More

WAN Synchronous Clusters: Dealing with Latency Using Concurrency

 | February 1, 2017 |  Posted In: Group Replication, Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster, Replication

WAN Latency

In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency Problem Our customers often ask us for help or advice with WAN clustering problems. Historically, the usual solution for MySQL WAN deployments is having the primary site in one data center, and stand-by backup site in […]

Read More