Upcoming Webinar Thurs 1/24: Databases Gone Serverless?
9 hours ago, percona

Please join Percona’s Senior Technical Manager, Alkin Tezuysal, as he presents Databases Gone Serverless? on Thursday, January 24th, at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now Serverless computing is becoming more popular with developers. For instance, it enables them to build and run applications without needing to operate and manage servers. This […]...

Monitor and Optimize Slow Queries with PMM and EverSQL – Part One
19 hours ago, percona

A common challenge with continuously deployed applications is that new and modified SQL queries are constantly being introduced to the application. Many companies choose to use a database monitoring system (such as PMM) to identify those slow queries. But identifying slow queries is only the start – what about actually optimizing them? In this post […]...

Percona Live 2019: Committee Announced and a Short Extension
1 day ago, percona

We had a great response to our call for papers, thank you! However great we believe having the conference in Austin, TX will be, moving to a new area of the US is still a leap of faith until we see the numbers. So we’re thankful that so many of you continue to support and […]...

Percona XtraDB Cluster Operator 0.2.0 Early Access Release Is Now Available
4 days ago, percona

  Percona announces the release of Percona XtraDB Cluster Operator  0.2.0 early access. The Percona XtraDB Cluster Operator simplifies the deployment and management of Percona XtraDB Cluster in a Kubernetes or OpenShift environment. It extends the Kubernetes API with a new custom resource for deploying, configuring and managing the application through the whole life cycle. Note: […]...

Percona XtraBackup 2.4.13 Is Now Available
4 days ago, percona

Percona is glad to announce the release of Percona XtraBackup 2.4.13 on January 18, 2018. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. […]...

Replication Manager Works with MariaDB
4 days ago, percona

Some time ago I wrote a script to manage asynchronous replication links between Percona XtraDB clusters. The original post can be found here. The script worked well with Percona XtraDB Cluster but it wasn’t working well with MariaDB®.  Finally, the replication manager works with MariaDB. First, let’s review the purpose of the script. Managing replication […]...

Percona Server for MySQL 8.0.13-4 Is Now Available
5 days ago, percona

Percona announces the release of Percona Server for MySQL 8.0.13-4 on January 17, 2019 (downloads are available here and from the Percona Software Repositories). This release contains a fix for a critical bug that prevented Percona Server for MySQL 5.7.24-26 from being upgraded to version 8.0.13-3 if there are more than around 1000 tables, or if the maximum allocated InnoDB table ID is […]...

Using Parallel Query with Amazon Aurora for MySQL
5 days ago, percona

Parallel query execution is my favorite, non-existent, feature in MySQL. In all versions of MySQL – at least at the time of writing – when you run a single query it will run in one thread, effectively utilizing one CPU core only. Multiple queries run at the same time will be using different threads and will […]...

Percona Server for MongoDB 3.2.22-3.13 Is Now Available
6 days ago, percona

Percona is glad to announce the release of Percona Server for MongoDB 3.2.22-3.13 on January, 16 2019. 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.2 Community Edition. It supports MongoDB 3.2 protocols and drivers. […]...

Customizing Per-Process Metrics in PMM
1 week ago, percona

If you have set up per-process metrics in Percona Monitoring and Management, you may have found yourself in need of tuning it further to not only group processes together, but to display some of them in isolation. In this blogpost we will explore how to modify the rules for grouping processes, so that you can […]...

Upcoming Webinar Thurs 1/17: How to Rock with MyRocks
1 week ago, percona

Please join Percona’s Chief Technology Officer, Vadim Tkachenko, as he presents How to Rock with MyRocks on Thursday, January 17th at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now MyRocks is a new storage engine from Facebook and is available in Percona Server for MySQL. In what cases will you want to […]...

Should You Use ClickHouse as a Main Operational Database?
1 week ago, percona

First of all, this post is not a recommendation but more like a “what if” story. What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. However, ClickHouse is super efficient for timeseries and provides […]...

AWS Aurora MySQL – HA, DR, and Durability Explained in Simple Terms
1 week ago, percona

It’s a few weeks after AWS re:Invent 2018 and my head is still spinning from all of the information released at this year’s conference. This year I was able to enjoy a few sessions focused on Aurora deep dives. In fact, I walked away from the conference realizing that my own understanding of High Availability (HA), […]...

Percona Backup for MongoDB 0.2.0-Alpha Is Now Available
1 week ago, percona

Percona announces the first public release of Percona Backup for MongoDB 0.2.0-Alpha on January 10, 2019. Percona Backup for MongoDB is a distributed, low-impact solution for consistent backups of MongoDB sharded clusters and replica sets. This is a tool for creating consistent backups across a MongoDB sharded cluster (or a single replica set), and for restoring those […]...

ProxySQL 1.4.13 and Updated proxysql-admin Tool
1 week ago, percona

ProxySQL 1.4.13, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s 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é Cannaò created […]...

PostgreSQL Updatable Views: Performing Schema Updates With Minimal Downtime
1 week ago, percona

Recently, one of our customers asked us how to minimize downtime when upgrading the database structure with changes that are not backwards-compatible. It’s an interesting question and I would like to visit some alternatives here. I will use PostgreSQL for this series of posts and walk through updatable views, INSTEAD OF Triggers, and the Rule […]...

Percona Toolkit 3.0.13 Is Now Available
1 week ago, percona

Percona announces the release of Percona Toolkit 3.0.13 for January 9, 2019. 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, […]...

Amazon Aurora Serverless – The Sleeping Beauty
1 week ago, percona

One of the most exciting features Amazon Aurora Serverless brings to the table is its ability to go to sleep (pause) when idle. This is a fantastic feature for development and test environments. You get access to a powerful database to run tests quickly, but it goes easy on your wallet as you only pay […]...

Percona Live 2019 Tracks
2 weeks ago, percona

Percona Live Open Source Database Conference 2019 in North America has moved to Austin, Texas. a cool place to be, host to many big names in the tech space. Read what Dave Stokes, MySQL Community Manager for Oracle, has to say in favor of Austin. If you need a conference ticket for Austin, put in […]...

Upcoming Webinar Wed 1/9: Walkthrough of Percona Server MySQL 8.0
2 weeks ago, percona

Please join Percona’s MySQL Product Manager, Tyler Duzan as he presents Walkthrough of Percona Server MySQL 8.0 on Wednesday, January 9th at 11:00 AM PDT (UTC-7) / 2:00 PM (UTC-4). Register Now Our Percona Server for MySQL 8.0 software is the company’s free, enhanced, drop-in replacement for MySQL Community Edition. The software includes all of […]...

Next