MongoDB on ARM Processors
1 day ago, percona

ARM processors have been around for a while. In mid-2015/2016 there were a couple of attempts by the community to port MongoDB to work with this architecture. At the time, the main storage engine was MMAP and most of the available ARM boards were 32-bits. Overall, the port worked, but the fact is having MongoDB […]...

How To Test and Deploy Kubernetes Operator for MySQL(PXC) in OSX/macOS?
2 days ago, percona

In this blog post, I’m going to show you how to test Kubernetes locally on OSX/macOS. Testing Kubernetes without having access to a cloud operator in a local lab is not as easy as it sounds. I’d like to share some of my experiences in this adventure. For those who have already experienced in Virtualbox […]...

Upcoming Webinar Thurs 3/21: MySQL Performance Schema in 1 hour
2 days ago, percona

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents MySQL Performance Schema in 1 hour on Thursday, March 21st, 2019, at 10:00 am PDT (UTC-8) / 1:00 pm EDT (UTC-5). Register Now MySQL 8.0 Performance Schema is a mature tool, used by humans and monitoring products. It was born in 2010 as “a […]...

PostgreSQL Upgrade Using pg_dumpall
3 days ago, percona

There are several approaches to assess when you need to upgrade PostgreSQL. In this blog post, we look at the option for upgrading a postgres database using pg_dumpall. As this tool can also be used to back up PostgreSQL clusters, then it is a valid option for upgrading a cluster too. We consider the advantages […]...

Percona Server for MySQL 8.0.15-5 Is Now Available
6 days ago, percona

Percona announces the release of Percona Server for MySQL 8.0.15-5 on March 15, 2019 (downloads are available here and from the Percona Software Repositories). This release includes fixes to bugs found in previous releases of Percona Server for MySQL 8.0. Incompatible changes In previous releases, the audit log used to produce time stamps inconsistent with the ISO 8601 standard. Release 8.0.15-5 of Percona Server […]...

Percona Server for MongoDB 3.6.11-3.1 Is Now Available
6 days ago, percona

Percona announces the release of Percona Server for MongoDB 3.6.11-3.1 on March 15, 2019. Download the latest version from the Percona website 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.6 Community Edition. It supports MongoDB 3.6 protocols and drivers. Percona Server for […]...

MySQL Ripple: The First Impression of a MySQL Binlog Server
6 days ago, percona

Just about a month ago, Pavel Ivanov released Ripple under the Apache-2.0 license. Ripple is a MySQL binlog server: software which receives binary logs from MySQL or MariaDB servers and delivers them to another MySQL or MariaDB server. Practically ,this is an intermediary master which does not store any data, except the binary logs themselves, […]...

Percona’s Open Source Data Management Software Survey
1 week ago, percona

Click Here to Complete our New Survey! Last year we informally surveyed the open source community and our conference attendees. The results revealed that: 48% of those in the cloud choose to self-manage their databases, but 52% were comfortable relying on the DBaaS offering of their cloud vendor. 49% of people said “performance issues” when […]...

Super Saver Discount Ends 17 March for Percona Live 2019
1 week ago, percona

Tutorials and initial sessions are set for the Percona Live Open Source Database Conference 2019, to be held May 28-30 at the Hyatt Regency in Austin, Texas! Percona Live 2019 is the premier open source database conference event for users of MySQL®, MariaDB®, MongoDB®, and PostgreSQL. It will feature 13 tracks presented over two days, plus […]...

Live MySQL Slave Rebuild with Percona Toolkit
1 week ago, percona

Recently, we had an edge case where a MySQL slave went out-of-sync but it couldn’t be rebuilt from scratch. The slave was acting as a master server to some applications and it had data was being written to it. It was a design error, and this is not recommended, but it happened. So how do you […]...

Upcoming Webinar Thurs 3/14: Web Application Security – Why You Should Review Yours
1 week ago, percona

Please join Percona’s Information Security Architect, David Bubsy, as he presents his talk Web Application Security – Why You Should Review Yours on March 14th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now In this talk, we take a look at the whole stack and I don’t just mean LAMP. […]...

PMM’s Custom Queries in Action: Adding a Graph for InnoDB mutex waits
1 week ago, percona

One of the great things about Percona Monitoring and Management (PMM) is its flexibility. An example of that is how one can go beyond the exporters to collect data. One approach to achieve that is using textfile collectors, as explained in  Extended Metrics for Percona Monitoring and Management without modifying the Code. Another method, which is […]...

Switch your PostgreSQL Primary for a Read Replica, Without Downtime
1 week ago, percona

In my ongoing research to identify solutions and similarities between MySQL – PostgreSQL, I recently faced a simple issue. I needed to perform a slave shift from one IP to another and I did not want to have to restart the slave that is serving the reads. In MySQL, I can repoint the replication online […]...

Reducing High CPU on MySQL: a Case Study
2 weeks ago, percona

In this blog post, I want to share a case we worked on a few days ago. I’ll show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting. The customer had noticed a linear high CPU usage in one of their MySQL instances […]...

Settling the Myth of Transparent HugePages for Databases
2 weeks ago, percona

The concept of Linux HugePages has existed for quite a while: for more than 10 years, introduced to Debian in 2007 with kernel version 2.6.23. Whilst a smaller page size is useful for general use, some memory intensive applications may gain performance by using bigger memory pages. By having bigger memory chunks available to them, […]...

Upcoming Webinar Thurs 3/7: Enhancing MySQL Security
2 weeks ago, percona

Join Percona Support Engineer, Vinicius Grippa, as he presents his talk Enhancing MySQL Security on Thursday, March 7th, 2019 at 7:00 AM PST (UTC-8) / 10:00 AM EST (UTC-5). Register Now Security is always a challenge when it comes to data. What’s more, regulations like GDPR add a whole new layer on top of it, […]...

How to Upgrade Aurora MySQL from 5.6 to 5.7
2 weeks ago, percona

Over time, software evolves and it is important to stay up to date if you want to benefit from new features and performance improvements.  Database engines follow the exact same logic and providers are always careful to provide an easy upgrade path. With MySQL, the mysql_upgrade tool serves that purpose. A database upgrade process becomes […]...

How to Upgrade Amazon Aurora MySQL from 5.6 to 5.7
2 weeks ago, percona

Over time, software evolves and it is important to stay up to date if you want to benefit from new features and performance improvements.  Database engines follow the exact same logic and providers are always careful to provide an easy upgrade path. With MySQL, the mysql_upgrade tool serves that purpose. A database upgrade process becomes […]...

Percona XtraBackup 8.0.5 Is Now Available
2 weeks ago, percona

Percona is glad to announce the release of Percona XtraBackup 8.0.5 on March 4, 2019. Downloads are available from our download site and from 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. Offered free as an open source […]...

Upcoming Webinar Wed 3/6: MySQL High Availability and Disaster Recovery
2 weeks ago, percona

Join Percona CEO Peter Zaitsev as he presents MySQL High Availability and Disaster Recovery on Wednesday, March 6th, 2019, at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5). Register Now In this hour-long webinar, Peter describes the differences between high availability (HA) and disaster recovery (DR). Afterward, Peter will go through scenarios detailing how […]...

Next