Monthly Archives - November 2018

PostgreSQL Streaming Physical Replication With Slots

postgres replication using slots

PostgreSQL streaming physical replication with slots simplifies setup and maintenance procedures. Usually, you should estimate disk usage for the Write Ahead Log (WAL) and provide appropriate limitation to the number of segments and setup of the WAL archive procedure. In this article, you will see how to use replication with slots and understand what problems […]

Read more

Percona Server for MySQL 5.6.42-84.2 Is Now Available

Percona Server for MySQL 8.0

Percona announces the release of Percona Server 5.6.42-84.2 on November 29, 2018 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.6.42, including all the bug fixes in it, Percona Server 5.6.42-84.2 is the current GA release in the Percona Server 5.6 series. All of Percona‘s software is open-source and free.
Improvements

PS-4790: Improve user statistics accuracy

Bugs Fixed

Slave replication could break if upstream bug #74145 (FLUSH […]

Read more

MySQL High Availability: Stale Reads and How to Fix Them

solutions for MySQL Stale Reads

Continuing on the series of blog posts about MySQL High Availability, today we will talk about stale reads and how to overcome this issue.
The Problem
Stale reads is a read operation that fetches an incorrect value from a source that has not synchronized an update operation to the value (source Wiktionary).
A practical scenario is when […]

Read more

What Happens If You Set innodb_open_files Higher Than open_files_limit?

MySQL innodb_open_files open_file_limit settings

The settings of MySQL configuration variables have a fundamental impact on the performance of your database system. Sometimes it can be a little tricky to predict how changing one variable can affect others, and especially when dealing with cases like the one I’ll describe in this post, where the outcome is not very intuitive. […]

Read more

Setup Compatible OpenLDAP Server for MongoDB and MySQL

Set up LDAP authentication for MySQL and MongoDB

By the end of this article, you should be able to have a Percona Server for MongoDB and Percona Server for MySQL instance able to authenticate on an OpenLDAP backend. While this is mostly aimed at testing scenarios, it can be easily extended for production by following the OpenLDAP production best practices i.e. attending […]

Read more

Upcoming Webinar Thurs 11/29: Improve MongoDB Performance with Proper Queries

Improve MongoDB Performance with Proper Queries

Please join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt, as he presents Improve MongoDB Performance with Proper Queries on Thursday, November 29th, 2018, at 12:30 PM PST (UTC-8) / 3:30 PM EST (UTC-5).
Register Now
There are many different ways you can use queries in MongoDB to find the data you need. However, knowing which queries […]

Read more

See Percona CEO Peter Zaitsev’s Keynote at AWS re:Invent: MySQL High Availability and Disaster Recovery

AWS re:Invent

Join Percona CEO Peter Zaitsev at AWS re:Invent as he presents MySQL High Availability and Disaster Recovery on Tuesday, November 27, 2018, in the Bellagio Resort, Level 1, Gaugin 2 at 1:45 PM.

In this hour-long session, Peter describes the differences between high availability (HA) and disaster recovery (DR), and then moves through scenarios detailing […]

Read more

Percona Server for MongoDB 3.4.18-2.16 Is Now Available

Percona Server for MongoDB Operator

Percona announces the release of Percona Server for MongoDB 3.4.18-2.16 on November 23, 2018. Download the latest version from the Percona website or the Percona Software Repositories.
Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers.
Percona Server for MongoDB extends MongoDB […]

Read more

Compression options in MySQL (part 1)

Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data as possible in MySQL. As you will see, there are quite a few different ways. Of course things like compression ratio matters a lot but, other items like performance of inserts, selects and updates, […]

Read more