Buy Percona ServicesBuy Now!

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/19: MongoDB Sharding

 | July 18, 2018 |  Posted In: High-availability, Insight for DBAs, Insight for Developers, MongoDB, open source databases, Percona Server for MongoDB, Technical Webinars

MongoDB shard zones

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

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

ProxySQL 1.4.9 and Updated proxysql-admin Tool Now in the Percona Repository

 | July 16, 2018 |  Posted In: Percona Server for MySQL, Percona XtraDB Cluster, ProxySQL

ProxySQL 1.4.9

ProxySQL 1.4.9, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created […]

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

Why MySQL Stored Procedures, Functions and Triggers Are Bad For Performance

 | July 12, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0

Execution map for func1()

MySQL stored procedures, functions and triggers are tempting constructs for application developers. However, as I discovered, there can be an impact on database performance when using MySQL stored routines. Not being entirely sure of what I was seeing during a customer visit, I set out to create some simple tests to measure the impact of […]

Read More