by Jervin Real | Apr 29, 2019 | Insight for DBAs, MongoDB
We have successfully used ZFS for MySQL® backups and MongoDB® is no different. Normally, backups will be taken from a hidden secondary, either with mongodump , WT hot backup or filesystem snapshots. In the case of the latter, instead of LVM2, we will use... by Jervin Real | Apr 26, 2019 | Cloud
There are three different ways ProxySQL can direct traffic between your application and the backend MySQL services. Locally, on the MySQL servers. Between the MySQL servers and the application. Colocated on the application servers themselves.Without going through too... by Jervin Real | Apr 2, 2019 | Insight for DBAs, MySQL, ProxySQL
Distributed systems are hard – I just want to echo that. In MySQL, we have quite a number of options to run highly available systems. However, real fault tolerant systems are difficult to achieve.Take for example a common use case of multi-DC replication where... by Jervin Real | Nov 27, 2018 | MongoDB, MySQL
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... by Jervin Real | Nov 21, 2018 | Insight for DBAs, Insight for Developers, MongoDB
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... by Jervin Real | Nov 19, 2018 | Cloud, MySQL
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... by Jervin Real | Nov 16, 2018 | Cloud, MySQL
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... by Jervin Real | Sep 7, 2018 | Cloud, Insight for DBAs, MySQL, Webinars
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... by Jervin Real | Jun 7, 2018 | Cloud
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... by Jervin Real | Feb 16, 2018 | MySQL
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... by Jervin Real | Jan 31, 2018 | Cloud, Insight for DBAs, MySQL
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... by Jervin Real | Jan 16, 2018 | Insight for DBAs, MySQL
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... by Jervin Real | Jan 9, 2018 | Insight for DBAs, MySQL
In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the first of two parts.You can see Part 2 of this post here. ClickHouse is fast Blazing fast! It’s quite easy to pick up, and with ProxySQL integrating with existing... by Jervin Real | Sep 25, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at how to avoid shared locks from subqueries.I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query: MySQL update ibreg set k=1 where id in (select id from ibcmp where id >... by Jervin Real | Sep 19, 2017 | Insight for DBAs, ProxySQL, Security
In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance.When deploying MySQL with SSL, the main concern is that the initial handshake causes significant overhead if you are not using connection pools (i.e., mysqlnd-mux with... by Jervin Real | Sep 14, 2017 | Insight for DBAs, MySQL, Webinars
Hello again! On August 16, we delivered a webinar on MySQL backups. As always, we’ve had a number of interesting questions. Some of them we’ve answered on the webinar, but we’d like to share some of them here in writing. What is the best way to... by Jervin Real | Aug 11, 2017 | MySQL
In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7!First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here.I received a number of interesting... by Jervin Real | Jul 14, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll look at a trick we use at Percona when upgrading to MySQL 5.7.I covered this subject (and others) in my webinar Learning MySQL 5.7 on Wednesday, July 19, 2017. On Upgrading to MySQL 5.7 We’ve been doing upgrades for quite... by Jervin Real | Dec 18, 2015 | Insight for DBAs, MySQL
Performance Schema In many types of database workloads, using a multi-threaded slave from 5.6+ helps improve replication performance. I’ve had a number of users enable this feature, but have not seen anyone ask how each thread is performing. Here’s a... by Jervin Real | Oct 26, 2015 | Percona Software
While we should be aiming for small and fast transactions with Galera, it is always possible at some point you might want a single large transaction, but what is involved?First, this is supposed to be controlled by two settings, wsrep_max_ws_rows and...