Buy Percona ServicesBuy Now!

Sysbench-tpcc Supports PostgreSQL (No, Really This Time)

 | April 19, 2018 |  Posted In: Benchmarks, Database Monitoring, Insight for DBAs, MySQL

Sysbench-tpcc Supports PostgreSQL

This time, we really mean it when we say sysbench-tpcc supports PostgreSQL. When I initially announced sysbench-tpcc, I mentioned it potentially could run against PostgreSQL, but it was more like wishful thinking than reality. The reality was that even though both databases speak SQL, the difference in dialects was too big and the queries written […]

Read More

Congratulations to Our Friends at Oracle with the MySQL 8.0 GA Release!

 | April 19, 2018 |  Posted In: InnoDB, Insight for DBAs, Insight for Developers, MySQL, Percona Live

MySQL 8.0 GA

It is a great today for whole MySQL community: MySQL 8.0 was just released as GA! Geir Høydalsvik has a great summary in his “What’s New in MySQL 8.0” blog post. You can find additional information about MySQL 8.0 Replication and MySQL 8.0 Document Store that is also worth reading. If you can’t wait to upgrade to MySQL […]

Read More

Restore a MongoDB Logical Backup

 | April 18, 2018 |  Posted In: Backups, Insight for DBAs, MongoDB

MongoDB Logical Backup

In this article, we will explain how to restore a MongoDB logical backup performed via ‘mongodump’ to a mongod instance. MongoDB logical backup requires the use of the ‘mongorestore‘ tool to perform the restore backup. This article focuses on this tool and process. Note: Percona develops a backup tool named Percona-Lab/mongodb-consistent-backup, which is a wrapper for ‘mongodump‘, adding […]

Read More

Webinar Thursday, April 19, 2018: Running MongoDB in Production, Part 1

 | April 18, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Technical Webinars

Running MongoDB

Please join Percona’s Senior Technical Operations Architect, Tim Vaillancourt as he presents Running MongoDB in Production, Part 1 on Thursday, April 19, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you a seasoned MySQL DBA that needs to add MongoDB to your skills? Are you used to managing a small environment that runs well, but […]

Read More

Using Hints to Analyze Queries

 | April 17, 2018 |  Posted In: MySQL

Hints to Analyze Queries

In this blog post, we’ll look at using hints to analyze queries. There are a lot of things that you can do wrong when writing a query, which means that there a lot of things that you can do to make it better. From my personal experience there are two things you should review first: The table […]

Read More

Webinar Wednesday, April 18, 2018: Percona XtraDB Cluster 5.7 Tutorial

 | April 17, 2018 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster

Percona XtraDB Cluster Tutorial

Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial on Wednesday, April 18, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Never used Percona XtraDB Cluster before? Come join this 45-minute tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster. In this […]

Read More

Binlog and Replication Improvements in Percona Server for MySQL

 | April 16, 2018 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL

Percona Server for MySQL

Due to continuous development and improvement, Percona Server for MySQL incorporates a number of improvements related to binary log handling and replication. This results in replication specifics, distinguishing it from MySQL Server. Temporary tables and mixed logging format Summary of the fix: As soon as some statement involving temporary tables was met when using a mixed binlog format, MySQL […]

Read More

ProxySQL 1.4.7 and Updated proxysql-admin Tool Now in the Percona Repository

 | April 16, 2018 |  Posted In: Percona Server for MySQL, Percona XtraDB Cluster, ProxySQL

ProxySQL for Connection Pooling

ProxySQL 1.4.7, 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 […]

Read More

Webinar Tuesday April 17, 2018: Which Amazon Cloud Technology Should You Chose? RDS? Aurora? Roll Your Own?

 | April 16, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Cloud and MySQL, Technical Webinars

Amazon Cloud Technology

Please join Percona’s Senior Technical Operations Engineer, Daniel Kowalewski as he presents Which Amazon Cloud Technology Should You Chose? RDS? Aurora? Roll Your Own? on Tuesday, April 17, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you running on Amazon, or planning to migrate there? In this talk, we are going […]

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.