In this blog post, Ill look at MyRocks performance through some benchmark testing. As the MyRocks storage engine (based on the RocksDB key-value store http://rocksdb.org ) is now available as part of Percona Server for MySQL 5.7, I wanted to take a look at how it performs on a relatively high-end server and SSD storage. [&]

The post A Look at MyRocks Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/30/a-look-at-myrocks-performance/

This blog post describes how to keep sensitive data secure on slave servers in a MySQL async replication setup. Almost every web application has a sensitive data: passwords, SNN, credit cards, emails, etc. Splitting the database to secure and public parts allows for restricting user and application parts access to sensitive data. Field encryption This is [&]

The post Keep Sensitive Data Secure in a Replication Setup appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/30/keep-sensitive-data-secure-in-replication-setup/

This blog post describes how to keep sensitive data secure on slave servers in a MySQL async replication setup. Almost every web application has a sensitive data: passwords, SNN, credit cards, emails, etc. Splitting the database to secure and public parts allows for restricting user and application parts access to sensitive data. Field encryption This is [&]

The post Keep Sensitive Data Secure in a Replication Setup appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/30/keep-sensitive-data-secure-in-replication-setup/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 is now over! All things considered, I think it went off quite well; if you have any comments/complaints/etc., please dont hesitate to drop me a line. I believe a survey [&]

The post This Week In Data with Colin Charles 37: Percona Live 2018 Wrap Up appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/27/this-week-in-data-with-colin-charles-37-percona-live-2018/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 is now over! All things considered, I think it went off quite well; if you have any comments/complaints/etc., please dont hesitate to drop me a line. I believe a survey [&]

The post This Week In Data with Colin Charles 37: Percona Live 2018 Wrap Up appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/27/this-week-in-data-with-colin-charles-37-percona-live-2018/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 is now over! All things considered, I think it went off quite well; if you have any comments/complaints/etc., please dont hesitate to drop me a line. I believe a survey [&]

The post This Week In Data with Colin Charles 37: Percona Live 2018 Wrap Up appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/27/this-week-in-data-with-colin-charles-37-percona-live-2018/

What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA? When it comes to being a software critic, a lot. In many ways, the work of a software critic is easy. We risk very little and thrive on negative criticism, which is fun [&]

The post MySQL 8.0 GA: Quality or Not? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/27/mysql-8-0-ga-quality-or-not/

What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA? When it comes to being a software critic, a lot. In many ways, the work of a software critic is easy. We risk very little and thrive on negative criticism, which is fun [&]

The post MySQL 8.0 GA: Quality or Not? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/27/mysql-8-0-ga-quality-or-not/

What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA? When it comes to being a software critic, a lot. In many ways, the work of a software critic is easy. We risk very little and thrive on negative criticism, which is fun [&]

The post MySQL 8.0 GA: Quality or Not? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/27/mysql-8-0-ga-quality-or-not/

One of the great values of a Percona Support contract is that we provide bug fixes for covered software, and not just support in terms of advice on how to use it. This is the skill which is most likely missing from in-house for most customers, as it requires a team with code knowledge to [&]

The post How Percona Support handles bugs appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/11/how-percona-support-handles-bugs/

Percona is glad to announce the release of Percona Server 5.6.24-72.2 on May 8, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.24, including all the bug fixes in it, Percona Server 5.6.24-72.2 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source [&]

The post Percona Server 5.6.24-72.2 is now available appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/08/percona-server-5-6-24-72-2-is-now-available/

Percona is glad to announce the release of Percona Server 5.5.43-37.2 on May 8, 2015. Based on MySQL 5.5.43, including all the bug fixes in it, Percona Server 5.5.43-37.2 is now the current stable release in the 5.5 series. Percona Server is open-source and free. Details of the release can be found in the 5.5.43-37.2 [&]

The post Percona Server 5.5.43-37.2 is now available appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/08/percona-server-5-5-43-37-2-is-now-available/

While our engineering team is working on finalizing the TokuMXse storage engine, I want to provide an experimental build that you can try and test MongoDB 3.0 with our storage engine. It is available here percona.com/downloads/TESTING/Percona-TokuMXse-rc5/percona-tokumxse-3.0.3pre-rc5.tar.gz To start MongoDB with TokuMXse storage engine use: [crayon-5550729b07cec230327124/] I am looking for your feedback!

The post MongoDB with Percona TokuMXse  experimental build RC5 is available! appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/08/mongodb-percona-tokumxse-experimental-build-rc5-available/

We discussed in an earlier post how to design indexes for many types of queries using a single table. Here is a real-world example of the challenges you will face when trying to optimize queries: two similar queries, but one is performing a full table scan while the other one is using the index we [&]

The post MySQL indexing 101: a challenging single-table query appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/08/mysql-indexing-101-a-challenging-single-table-query/

For those PCT users who forget to regularly check query performance, you can now get server query reports delivered to your email daily or weekly. The report contains a digest of the most critical performance information related to a particular MySQL instance, enabling you to act on any recent issues. There are convenient links that [&]

The post Introducing email reports for Percona Cloud Tools! appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/07/introducing-email-reports-percona-cloud-tools/

Contents Summary Analysis Mitigating factors P.O.C Acknowledgments Summary During a code audit performed internally at Percona, we discovered a viable information disclosure attack when coupled with a MITM attack in which percona-toolkit and xtrabackup perl components could be coerced into returning additional MySQL configuration information. The vulnerability has since been closed. Timeline 2014-12-16 Initial research, [&]

The post Percona Security Advisory CVE-2015-1027 appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/06/percona-security-advisory-cve-2015-1027/

Percona CEO Peter Zaitsev and Big Data guru Alexander Rubin will be speaking at Meetups along the East Coast next week with stops in Boston (May 11), New York City (May 12), Philadelphia (May 13) and Baltimore (May 14). Dubbed the “MySQL Whistle-Stop Tour” since they’ll be traveling city to city via Amtrak, Peter will [&]

The post Peter Zaitsev hits the road for East Coast MySQL Meetup tour appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/06/peter-zaitsev-hits-the-road-for-east-coast-mysql-meetup-tour/

Being schemaless is one of the key features of MongoDB. On the bright side this allows developers to easily modify the schema of their collections without waiting for the database to be ready to accept a new schema. However schemaless is not free and one of the drawbacks is write amplification. Lets focus on that [&]

The post MongoDBs flexible schema: How to fix write amplification appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/05/mongodbs-flexible-schema-how-to-fix-write-amplification/

MySQL replication isnt perfect and sometimes our data gets out of sync, either by a failure in replication or human intervention. We are all familiar with Percona Toolkits pt-table-checksum and pt-table-sync to help us check and fix data inconsistencies  but imagine the following scenario where we mix regular replication with the Tungsten Replicator: We [&]

The post Keep your MySQL data in sync when using Tungsten Replicator appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/04/keep-your-mysql-data-in-sync-when-using-tungsten-replicator/

An idea for a benchmark based on the arrival request rate that I wrote about in a post headlined Introducing new type of benchmark back in 2012 was implemented in Sysbench. However, Sysbench provides only a simple workload, so to be able to compare InnoDB with TokuDB, and later MongoDB with Percona TokuMX, I wanted [&]

The post LinkBenchX: benchmark based on arrival request rate appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/05/01/linkbenchx-benchmark-based-arrival-request-rate/