Buy Percona ServicesBuy Now!

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

Percona Server for MongoDB 3.6.5-1.3 Is Now Available

 | July 11, 2018 |  Posted In: Events and Announcements, MongoDB, Percona Live, Percona Server for MongoDB, Percona Software

MongoRocks

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

Read More

AMD EPYC Performance Testing… or Don’t get on the wrong side of SystemD

 | July 11, 2018 |  Posted In: Benchmarks, MySQL, Percona Server for MySQL

Ubuntu 16 AMD EPYC

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

Read More

When Database Warm Up is Not Really UP

 | July 10, 2018 |  Posted In: InnoDB, MySQL, Percona Monitoring and Management, PMM

first few minutes MySQL Warm Up graph from PMM

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

Read More

Percona Live Europe 2018 Call for Papers is Now Open

 | July 10, 2018 |  Posted In: Events and Announcements, MySQL, MySQL 8.0, open source databases, Percona Live, Percona Server for MySQL

Percona Live Europe Open Source Database Conference PLE 2018

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

Read More

InnoDB Cluster in a nutshell – Part 1

 | July 9, 2018 |  Posted In: Group Replication, High-availability, InnoDB, MySQL

innodb cluster in a nutshell part 1

Since MySQL 5.7 we have a new player in the field, MySQL InnoDB Cluster. This is an Oracle High Availability solution that can be easily installed over MySQL to get High Availability with multi-master capabilities and automatic failover. This solution consists in 3 components: InnoDB Group Replication, MySQL Router and MySQL Shell, you can see […]

Read More

Percona Toolkit 3.0.11 Is Now Available

 | July 6, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Server for MongoDB, Percona Server for MySQL, Percona Toolkit

percona toolkit

Percona announces the release of Percona Toolkit 3.0.11 on July 6, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona […]

Read More

Another Day, Another Data Leak

 | July 6, 2018 |  Posted In: Business Continuity, MongoDB, MySQL, Percona Server for MongoDB, Percona Server for MySQL, Security

another day another data leak Exactis

In the last few days, there has been information released about yet another alleged data leak, placing in jeopardy “…[the] personal information on hundreds of millions of American adults, as well as millions of businesses.” In this case, the “victim” was Exactis, for whom data collection and data security are core business functions. Some takeaways […]

Read More