Buy Percona ServicesBuy Now!

Percona Live 2018 Featured Talk: Data Integrity at Scale with Alexis Guajardo

 | April 23, 2018 |  Posted In: Cloud and MySQL, Insight for DBAs, Insight for Developers, Percona Live, Security

Alexis Google Percona Live 2018

Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post highlights Alexis Guajardo, Senior Software Engineer at Google.com. His session talk is titled […]

Read More

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

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

Flashback: Another Take on Point-In-Time Recovery (PITR) in MySQL/MariaDB/Percona Server

 | April 12, 2018 |  Posted In: Backups, Database Recovery, Insight for DBAs, MariaDB, MySQL

Point-In-Time Recovery

In this blog post, I’ll look at point-in-time recovery (PITR) options for MySQL, MariaDB and Percona Server for MySQL. It is a common good practice to extend data safety by having additional measures apart from regular data backups, such as delayed slaves and binary log backups. These two options provide the ability to restore the data […]

Read More