Author - Jervin Real

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

Identifying Unused Indexes in MongoDB

mongodb index usage stats PMM visualization

Like MySQL, having too many indexes on a MongoDB collection not only affects overall write performance, but disk and memory resources as well. While MongoDB holds predictably well in scaling both reads and writes options, maintaining a heathly schema design should always remain a core character of a good application stack.
Aside from knowing when […]

Read more

Migrating to Amazon Aurora: Design for Flexibility

Migrating to Amazon Aurora

In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings.
Previous blogs in the migrating to Amazon Aurora series:

Migrating to Amazon Aurora: Reduce the Unknowns
Migrating to Amazon Aurora: Optimize for […]

Read more

Migrating to Amazon Aurora: Optimize for Binary Log Replication

Migrating to Amazon Aurora 1

In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings.
In our previous article, we discussed the importance of continuous query performance analysis, especially in Amazon Aurora where there is […]

Read more

Migrating to Amazon Aurora: Reduce the Unknowns

Migrating to Amazon Aurora

Migrating to Amazon Aurora. Shutterstock.com
In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings.
While DBaaS encapsulates a lot of the moving pieces, it also means relying on this approach […]

Read more

Upcoming Webinar Tues 9/11: Migrating to AWS Aurora: A Checklist for Success

Migrating to AWS Aurora: A Checklist for Success

Please join Percona’s Senior Consultant, Jervin Real, as he presents Migrating to AWS Aurora: A Checklist for Success. The event will take place on Tuesday, September 11th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).
Register Now
 
In the last few weeks, we have shown you how to successfully migrate from on-premise MySQL […]

Read more

Using gh-ost with Amazon Aurora for MySQL

gh-ost online schema change

In this day and age of agile methodologies and fast-paced development methods, database schema changes are as inevitable as the growth of data. We have been thoroughly familiar with the effectivity of pt-online-schema-change for the last couple of years but it has one limitation. If the table is too hot to acquire metadata locks […]

Read more

Why ZFS Affects MySQL Performance

zfs

In this blog post, we’ll look at how ZFS affects MySQL performance when used in conjunction.
ZFS and MySQL have a lot in common since they are both transactional software. Both have properties that, by default, favors consistency over performance. By doubling the complexity layers for getting committed data from the application to a persistent […]

Read more

Aurora Hash Join Optimization (with a Gentle Reminder on Lab Features)

Aurora Hash Join Lab Mode

The Aurora hash join feature for relational databases has been around for a while now. But unlike MySQL Block Nested Loop algorithm, an Aurora hash join only caters to a specific number of use cases. When implemented with the optimizer properly, they can provide great benefits with certain workloads. Below we’ll see a brief […]

Read more

Updating/Deleting Rows From Clickhouse (Part 2)

ClickHouse

In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the second of two parts.
In the first part of this post, we described the high-level overview of implementing incremental refresh on a ClickHouse table as an alternative support for UPDATE/DELETE. In this part, we will show you the actual steps and […]

Read more