Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   In modern data architectures, we’re increasingly moving from single-node design systems to distributed architectures using multiple nodes – often spread across multiple [&]

The post Upcoming Webinar Tuesday, 7/31: Using MySQL for Distributed Database Architectures appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/30/upcoming-webinar-tuesday-7-31-using-mysql-for-distributed-database-architectures/

Percona announces the release of Percona Server for MongoDB 3.4.16-2.14 on July 27, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. [&]

The post Percona Server for MongoDB 3.4.16-2.14 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/27/percona-server-for-mongodb-3-4-16-2-14-is-now-available/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. OSCON happened last week and was incredible. It is true there was less of a database focus, and a lot more topics covered. In fact, youd have found it hard to find database content. There was [&]

The post This Week in Data with Colin Charles 46: OSCON Recap, Google Site Reliability Workbook appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/27/this-week-in-data-with-colin-charles-46/

The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing the best primary key depending on your workload. As a principal architect at Percona, one of my main duties is to tune customer databases. There are many aspects related to performance tuning [&]

The post Tuning InnoDB Primary Keys appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/26/tuning-innodb-primary-keys/

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101  Geo-Partitioning on Thursday, July 26th, 2018 at 12:30 PM PDT (UTC-7) 3:30 EDT (UTC-4). Register Now In this webinar, we will discuss the common shard keys and demonstrate how to build a worldwide distributed sharded cluster using tags.Tags can be [&]

The post Webinar Thursday, July 27, 2018: MongoDB Sharding 101  Geo-Partitioning appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/24/webinar-mongodb-sharding-101-geo-partitioning/

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101  Geo-Partitioning on Thursday, July 26th, 2018 at 12:30 PM PDT (UTC-7) 3:30 EDT (UTC-4). Register Now In this webinar, we will discuss the common shard keys and demonstrate how to build a worldwide distributed sharded cluster using tags.Tags can be [&]

The post Webinar Thursday, July 27, 2018: MongoDB Sharding 101  Geo-Partitioning appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/24/webinar-mongodb-sharding-101-geo-partitioning/

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101  Geo-Partitioning on Thursday, July 26th, 2018 at 12:30 PM PDT (UTC-7) 3:30 EDT (UTC-4). Register Now In this webinar, we will discuss the common shard keys and demonstrate how to build a worldwide distributed sharded cluster using tags.Tags can be [&]

The post Webinar Thursday, July 27, 2018: MongoDB Sharding 101  Geo-Partitioning appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/24/webinar-mongodb-sharding-101-geo-partitioning/

Please join Percona Senior MySQL DBA for Managed Services, Dov Endress, as he presents XA Transactions on Wednesday, July 25th, 2018 at 12:00 PM PDT (UTC-7) / 3:00 PM EDT (UTC-4). Register Now Distributed transactions (XA) are becoming more and more vital as applications evolve. In this webinar, we will learn what distributed transactions are [&]

The post Webinar Weds 7/25: XA Transactions appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/23/webinar-weds-7-25-xa-transactions/

Welcome to the third part of this series. Im glad youre still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell. MySQL Shell This is the last [&]

The post InnoDB Cluster in a Nutshell Part 3: MySQL Shell appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/20/innodb-cluster-in-a-nutshell-part-3-mysql-shell/

Welcome to the third part of this series. Im glad youre still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell. MySQL Shell This is the last [&]

The post InnoDB Cluster in a Nutshell Part 3: MySQL Shell appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/20/innodb-cluster-in-a-nutshell-part-3-mysql-shell/

Welcome to the third part of this series. Im glad youre still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell. MySQL Shell This is the last [&]

The post InnoDB Cluster in a Nutshell Part 3: MySQL Shell appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/20/innodb-cluster-in-a-nutshell-part-3-mysql-shell/

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101 on July 19th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). Register Now   This tutorial is a continuation of advanced topics for the DBA. In it, we will share best practices and tips on how to perform [&]

The post Webinar Wed 7/19: MongoDB Sharding appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/webinar-wed-7-19-mongodb-sharding/

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101 on July 19th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). Register Now   This tutorial is a continuation of advanced topics for the DBA. In it, we will share best practices and tips on how to perform [&]

The post Webinar Wed 7/19: MongoDB Sharding appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/webinar-wed-7-19-mongodb-sharding/

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101 on July 19th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). Register Now   This tutorial is a continuation of advanced topics for the DBA. In it, we will share best practices and tips on how to perform [&]

The post Webinar Wed 7/19: MongoDB Sharding appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/webinar-wed-7-19-mongodb-sharding/

Please join Percona’s Chief Evangelist, Colin Charles as he presents as he presents MariaDB 10.3 vs. MySQL 8.0 on Wednesday, July 18th, 2018, at 9:00 AM PDT (UTC-7) / 12:00 PM EDT (UTC-4). Register Now   Technical considerations Are they syntactically similar? Where do these two databases differ? Why would I use one over the [&]

The post Webinar Wed 7/18: MariaDB 10.3 vs. MySQL 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/webinar-wed-7-18-mariadb-10-3-vs-mysql-8-0/

Please join Percona’s Chief Evangelist, Colin Charles as he presents as he presents MariaDB 10.3 vs. MySQL 8.0 on Wednesday, July 18th, 2018, at 9:00 AM PDT (UTC-7) / 12:00 PM EDT (UTC-4). Register Now   Technical considerations Are they syntactically similar? Where do these two databases differ? Why would I use one over the [&]

The post Webinar Wed 7/18: MariaDB 10.3 vs. MySQL 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/webinar-wed-7-18-mariadb-10-3-vs-mysql-8-0/

Please join Percona’s Chief Evangelist, Colin Charles as he presents as he presents MariaDB 10.3 vs. MySQL 8.0 on Wednesday, July 18th, 2018, at 9:00 AM PDT (UTC-7) / 12:00 PM EDT (UTC-4). Register Now   Technical considerations Are they syntactically similar? Where do these two databases differ? Why would I use one over the [&]

The post Webinar Wed 7/18: MariaDB 10.3 vs. MySQL 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/webinar-wed-7-18-mariadb-10-3-vs-mysql-8-0/

If you’re reading consumer SSD reviews and using them to estimate SSD performance under database workloads, you’d better stop. Databases are not your typical consumer applications and they do not use IO in the same way. Let’s look, for example, at this excellent AnandTech review of Samsung 960 Pro   a consumer NVMe device that [&]

The post Why Consumer SSD Reviews are Useless for Database Performance Use Case appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/why-consumer-ssd-reviews-are-useless-for-database-performance-use-case/

If you’re reading consumer SSD reviews and using them to estimate SSD performance under database workloads, you’d better stop. Databases are not your typical consumer applications and they do not use IO in the same way. Let’s look, for example, at this excellent AnandTech review of Samsung 960 Pro   a consumer NVMe device that [&]

The post Why Consumer SSD Reviews are Useless for Database Performance Use Case appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/why-consumer-ssd-reviews-are-useless-for-database-performance-use-case/

If you’re reading consumer SSD reviews and using them to estimate SSD performance under database workloads, you’d better stop. Databases are not your typical consumer applications and they do not use IO in the same way. Let’s look, for example, at this excellent AnandTech review of Samsung 960 Pro   a consumer NVMe device that [&]

The post Why Consumer SSD Reviews are Useless for Database Performance Use Case appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/18/why-consumer-ssd-reviews-are-useless-for-database-performance-use-case/