Buy Percona ServicesBuy Now!

Upcoming Webinar Tuesday, 7/31: Using MySQL for Distributed Database Architectures

 | July 30, 2018 |  Posted In: Insight for DBAs, MySQL, Performance Tuning, Technical Webinars

Distributed Database Architectures

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 […]

Read More

This Week in Data with Colin Charles 46: OSCON Recap, Google Site Reliability Workbook

 | July 27, 2018 |  Posted In: MariaDB, MongoDB, MyRocks, MySQL, Yandex ClickHouse

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, you’d have found it hard to find database content. There was […]

Read More

Tuning InnoDB Primary Keys

 | July 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL

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 […]

Read More

InnoDB Cluster in a Nutshell Part 3: MySQL Shell

 | July 20, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, Insight for Developers, JSON, MySQL

MySQL InnoDB Cluster MySQL Shell

Welcome to the third part of this series. I’m glad you’re 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 […]

Read More

Webinar Wed 7/18: MariaDB 10.3 vs. MySQL 8.0

 | July 18, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MySQL, MySQL 8.0, open source databases, Technical Webinars

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 […]

Read More

Why Consumer SSD Reviews are Useless for Database Performance Use Case

 | July 18, 2018 |  Posted In: Benchmarks, Insight for DBAs, MySQL, open source databases, Percona Server for MySQL

Anandtech Table reviewing consumer SSD performance

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 […]

Read More

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

 | July 17, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Cloud and MySQL, Insight for DBAs, MySQL, MySQL DBaaS, ProxySQL

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

InnoDB Cluster in a Nutshell: Part 2 MySQL Router

 | July 16, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, MySQL, open source databases

MySQL Router MySQL Cluster

MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group replication. Now we will go through the second component, MySQL Router.  We will address MySQL Shell in a final instalment […]

Read More

This Week in Data with Colin Charles 45: OSCON and Percona Live Europe 2018 Call for Papers

 | July 13, 2018 |  Posted In: MariaDB, MySQL, MySQL 8.0, Percona Live, Prometheus

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Hello again after the hiatus last week. I’m en route to Portland for OSCON, and am very excited as it is the conference’s 20th anniversary! I hope to see some of you at my talk on […]

Read More