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

The post When Should I Use Amazon Aurora and When Should I use RDS MySQL? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/17/when-should-i-use-amazon-aurora-and-when-should-i-use-rds-mysql/

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

The post When Should I Use Amazon Aurora and When Should I use RDS MySQL? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/17/when-should-i-use-amazon-aurora-and-when-should-i-use-rds-mysql/

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

The post When Should I Use Amazon Aurora and When Should I use RDS MySQL? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/17/when-should-i-use-amazon-aurora-and-when-should-i-use-rds-mysql/

ProxySQL 1.4.9, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Perconas 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'e Canna`o created [&]

The post ProxySQL 1.4.9 and Updated proxysql-admin Tool Now in the Percona Repository appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/16/proxysql-1-4-9-and-updated-proxysql-admin-tool-now-in-the-percona-repository/

ProxySQL 1.4.9, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Perconas 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'e Canna`o created [&]

The post ProxySQL 1.4.9 and Updated proxysql-admin Tool Now in the Percona Repository appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/16/proxysql-1-4-9-and-updated-proxysql-admin-tool-now-in-the-percona-repository/

ProxySQL 1.4.9, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Perconas 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'e Canna`o created [&]

The post ProxySQL 1.4.9 and Updated proxysql-admin Tool Now in the Percona Repository appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/16/proxysql-1-4-9-and-updated-proxysql-admin-tool-now-in-the-percona-repository/

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

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

https://www.percona.com/blog/2018/07/16/innodb-cluster-in-a-nutshell-part-2-mysql-router/

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

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

https://www.percona.com/blog/2018/07/16/innodb-cluster-in-a-nutshell-part-2-mysql-router/

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

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

https://www.percona.com/blog/2018/07/16/innodb-cluster-in-a-nutshell-part-2-mysql-router/

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. Im en route to Portland for OSCON, and am very excited as it is the conferences 20th anniversary! I hope to see some of you at my talk on [&]

The post This Week in Data with Colin Charles 45: OSCON and Percona Live Europe 2018 Call for Papers appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/13/this-week-in-data-with-colin-charles-45-oscon-and-percona-live-europe-2018-call-for-papers/

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. Im en route to Portland for OSCON, and am very excited as it is the conferences 20th anniversary! I hope to see some of you at my talk on [&]

The post This Week in Data with Colin Charles 45: OSCON and Percona Live Europe 2018 Call for Papers appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/13/this-week-in-data-with-colin-charles-45-oscon-and-percona-live-europe-2018-call-for-papers/

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. Im en route to Portland for OSCON, and am very excited as it is the conferences 20th anniversary! I hope to see some of you at my talk on [&]

The post This Week in Data with Colin Charles 45: OSCON and Percona Live Europe 2018 Call for Papers appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/13/this-week-in-data-with-colin-charles-45-oscon-and-percona-live-europe-2018-call-for-papers/

Recently, Dimitri published the results of measuring MySQL 8.0 on Intel Optane storage device. In this blog post, I wanted to look at this in more detail and explore the performance of MySQL 8, MySQL 5.7 and Percona Server for MySQL using a similar set up. The Intel Optane is a very capable device, so I [&]

The post On MySQL and Intel Optane performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/13/on-mysql-and-intel-optane-performance/

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

The post Why MySQL Stored Procedures, Functions and Triggers Are Bad For Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/12/why-mysql-stored-procedures-functions-triggers-bad-performance/

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

The post Why MySQL Stored Procedures, Functions and Triggers Are Bad For Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/12/why-mysql-stored-procedures-functions-triggers-bad-performance/

Percona announces the release of Percona Server for MongoDB 3.6.5-1.3 on July 11, 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.6 Community Edition. It supports MongoDB 3.6 protocols and drivers. Percona [&]

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

https://www.percona.com/blog/2018/07/11/percona-server-for-mongodb-3-6-5-1-3-is-now-available/

Ever since AMD released their EPYC CPU for servers I wanted to test it, but I did not have the opportunity until recently, when Packet.net started offering bare metal servers for a reasonable price. So I started a couple of instances to test Percona Server for MySQL under this CPU. In this benchmark, I discovered some [&]

The post AMD EPYC Performance Testing& or Dont get on the wrong side of SystemD appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/11/amd-epyc-performance-testing-ps-systemd/

The common wisdom with database performance management is that a “cold” database server has poor performance. Then, as it “warms up”, performance improves until finally you reach a completely warmed up state with peak database performance. In other words, that to get peak performance from MySQL you need to wait for database warm up. This [&]

The post When Database Warm Up is Not Really UP appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/10/when-database-warm-up-is-not-really-up/

The common wisdom with database performance management is that a “cold” database server has poor performance. Then, as it “warms up”, performance improves until finally you reach a completely warmed up state with peak database performance. In other words, that to get peak performance from MySQL you need to wait for database warm up. This [&]

The post When Database Warm Up is Not Really UP appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/10/when-database-warm-up-is-not-really-up/

Announcing the opening of the Percona Live Europe Open Source Database Conference 2018 in Frankfurt, Germany call for papers. It will be open from now until August 10, 2018. Our theme this year is Connect. Accelerate. Innovate. As a speaker at Percona Live Europe, you’ll have the opportunity to CONNECT with your peers—open source database [&]

The post Percona Live Europe 2018 Call for Papers is Now Open appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/10/percona-live-europe-2018-call-for-papers-open/