Tag - Percona Software

Pstress: Database Concurrency and Crash Recovery Testing Tool

Pstress Percona

Databases are complicated software made to handle the concurrent load while making specific guarantees about data consistency and availability. There are many scenarios which should be tested that can only happen under concurrent conditions.
Pstress is a probability-based open-source database testing tool designed to run in concurrency and to test if the database can recover when […]

Read more

Evaluating Percona XtraDB Cluster 8.0 Scaling Capabilities

Percona XtraDB Cluster Scaling

Percona XtraDB Cluster 8.0 is on the final stretch before GA release, and we have pre-release packages available for testing.
I wanted to see how Percona XtraDB Cluster 8.0 performs in CPU and IO-bound scenarios, like in my previous posts about MySQL Group Replication.
In this blog, I want to evaluate Percona XtraDB Cluster 8.0 scaling […]

Read more

Need to Connect to a Local MySQL Server? Use Unix Domain Socket!

Unix Socket Domain

When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address –  “localhost” or 127.0.0.1  – or use Unix Domain Socket.
If you have a choice (if your application supports both methods), use Unix Domain Socket as this is both more secure and more efficient.
How […]

Read more

LDAP Authorization in Percona Server for MongoDB, Security Fix in XtraBackup 8.0.11: Release Roundup 4/13/2020

percona software releases

It’s release roundup time here at Percona!
Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct links to the software or service itself.
Today’s post includes those which have come […]

Read more

Percona XtraBackup: Backup and Restore of a Single Table or Database

Percona XtraBackup of Single Table

The backup and restore of a complete database is an extensive exercise. But what if you need to restore just one table which has been mistakenly modified by an incorrect query? Help is at hand with Percona XtraBackup.
For our purpose, we will take a test database having tables created by the sysbench tool. The […]

Read more