EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live 2017 Tutorials Day

 | April 25, 2017 |  Posted In: Benchmarks, Big Data, Cloud and MySQL, Cloud and NoSQL, InnoDB, JSON, MariaDB, MongoDB, MyRocks, MySQL, Percona Live

Percona Live Keynotes

Welcome to the first day of the Percona Live Open Source Database Conference: Percona Live 2017 tutorials day! While technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies. Today attendees went to training sessions taught by […]

Read More

Better Than Linear Scaling

 | April 22, 2017 |  Posted In: Hardware and Storage, High-availability, Insight for DBAs, Insight for Developers, MySQL

Scalability

In this blog, we’ll look at how to achieve better-than-linear scaling. Scalability is the capability of a system, network or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth. For example, we consider a system scalable if it is capable of increasing its total output under […]

Read More

Percona Server for MySQL in Docker Swarm with Secrets

 | April 21, 2017 |  Posted In: Docker, MySQL, Security

This quick post demonstrates using Percona Server for MySQL in Docker Swarm with some new authentication provisioning practices. Some small changes to the startup script for the Percona-Server container image allows us to specify a file that contains password values to set as our root user’s secret. “Why do we need this functionality,” I hear you cry? When we […]

Read More

Simplified Percona XtraDB Cluster SSL Configuration

 | April 21, 2017 |  Posted In: MySQL, Percona XtraDB Cluster, Security, XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at a feature that recently added to Percona XtraDB Cluster 5.7.16, that makes it easier to configure Percona XtraDB Cluster SSL for all related communications. It uses mode “encrypt=4”, and configures SSL for both IST/Galera communications and SST communications using the same SSL files. “encrypt=4” is a new encryption […]

Read More

Percona Live Featured Session with Casper Kejlberg-Rasmussen: Placing Databases @ Uber

 | April 20, 2017 |  Posted In: MySQL, Percona Live

Percona Live

Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live […]

Read More

Performance improvements in Percona XtraDB Cluster 5.7.17-29.20

and  | April 19, 2017 |  Posted In: MySQL, Percona XtraDB Cluster

Percona XtraDB Cluster

In our latest release of Percona XtraDB Cluster, we’ve introduced major performance improvements to the MySQLwrite-set replication layer. In this post, we want to show what these improvements look like. For the test, we used the sysbench OLTP_RW, UPDATE_KEY and UPDATE_NOKEY workloads with 100 tables, 4mln rows each, which gives about 100GB of datasize. In all […]

Read More

The mysqlpump Utility

 | April 17, 2017 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

mysqlpump

In this blog, we’ll look at the mysqlpump utility. mysqlpump is a utility that performs logical backups (which means backing up your data as SQL statements instead of a raw copy of data files). It was added in MySQL Server version 5.7.8, and can be used to dump a database or a set of databases to a file and […]

Read More

Percona Live Featured Session with Wei Hu – AliSQL: Breakthrough for the Future

 | April 13, 2017 |  Posted In: MySQL, Percona Live

Percona Live

Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live […]

Read More