As database footprints continue to explode, many companies are looking for ways to deal with such rapid growth.  One approach is to refactor traditional relational databases to fit into a NoSQL engine, where horizontal scalability is easier.  However, in many cases, this is in no way a trivial undertaking. Another approach that has been gaining [&]

https://www.percona.com/blog/2021/04/06/which-version-of-mysql-should-i-use-for-myrocks/

Recovering to a particular time in the past is called Point-In-Time Recovery (PITR). With PITR you can rollback unwanted DELETE without WHERE clause or any other harmful command. PITR with Percona XtraBackup is pretty straightforward and perfectly described in the user manual. You need to restore the data from the backup, then apply all binary [&]

https://www.percona.com/blog/2021/04/02/percona-xtrabackup-point-in-time-recovery-for-the-single-database/

Nobody likes change, especially when that change may be challenging.  When faced with a technical challenge, I try to remember this comment from Theodore Roosevelt: “Nothing in the world is worth having or worth doing unless it means effort, pain, difficulty.”  While this is a bit of an exaggeration, in this case, the main concept [&]

https://www.percona.com/blog/2021/04/02/upgrading-to-mysql-8/

Percona Technical Account Managers get the privilege of working with some of our largest enterprise clients day in and day out.  As such, we get to really focus on how to best leverage our technology to generate measurable benefits for our users.  While it is fun to “nerd out” and always strive to use the [&]

https://www.percona.com/blog/2021/04/01/working-to-validate-myrocks-in-the-enterprise-with-dropbox/

In past versions of MySQL, there was often an ‘upgrade dance’ that had to be performed in starting up a newly upgraded MySQL instance with the previous version configuration file. In some cases a few deprecated options might no longer be supported in the newer server version, triggering an error and a subsequent shutdown moments [&]

https://www.percona.com/blog/2021/04/01/easily-validate-configuration-settings-in-mysql-8/

It is no secret that compute and storage costs are the main drivers of cloud bills. Migration of data from the legacy data center to the cloud looks appealing at first as it significantly reduces capital expense (CapEx) and keeps operational expenses (OpEx) under control. But once you see the bill, the lift and shift [&]

https://www.percona.com/blog/2021/04/01/infinitely-scalable-storage-with-high-compression-feature/

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering applications need to be able to handle changing traffic workloads while remaining responsive and stable in order to deliver an excellent user experience. Further, DBAs are also expected to find cost-efficient means of [&]

https://www.percona.com/blog/2021/03/31/webinar-april-14-optimize-and-troubleshoot-mysql-using-percona-monitoring-and-management/

As many of you may remember, Percona added the super_read_only feature way back in Percona Server for MySQL 5.6.21, based on work done by WebScaleSQL. This feature eventually found its way into the Community branch of MySQL starting with 5.7.8, and it works the same in both cases. While this is now old news, over [&]

https://www.percona.com/blog/2021/03/31/mysql-101-using-super_read_only/

In this blog post, I’ll look at how to import custom dashboards into Percona Monitoring and Management (PMM) 2.x, and give some tips on how to automate it. The number of dashboards in PMM2 is constantly growing. For example, we recently added a new HAProxy dashboard to the latest 2.15.0 release. Even though the PMM [&]

https://www.percona.com/blog/2021/03/30/how-to-automate-dashboard-importing-in-percona-monitoring-and-management/

I have been working a while with customers, supporting both MongoDB and MySQL technologies. Most of the time when an issue arises, the customers working with MySQL collect most of the information happening in the DB server, including all the queries running that particular time, using “show full processlist;” This information would help us to [&]

https://www.percona.com/blog/2021/03/30/whats-running-in-my-db-a-journey-with-currentop-in-mongodb/

Its release roundup time again here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Todays [&]

https://www.percona.com/blog/2021/03/29/security-fixes-for-percona-xtradb-cluster-updated-percona-distribution-for-mysql-release-roundup-march-29-2021/

For MySQL, MyISAM and InnoDB storage engines are very popular. Currently, we are mostly using InnoDB engines for high reliability and high performance. Apart from those engines, we also have some other alternative engines and they have some nice features in them. In this blog, I am going to explain some of those engines, which [&]

https://www.percona.com/blog/2021/03/26/overview-of-mysql-alternative-storage-engines/

Have you ever wondered what it takes to complete Percona Server for MySQL (PS), Percona XtraDB Cluster (PXC), and Percona XtraBackup (PXB) releases?  Let’s step back just a minute and talk about what Percona stands for. We believe we “stand on the shoulders of giants.” This means we respect our upstream sources and work to [&]

https://www.percona.com/blog/2021/03/25/the-steps-involved-in-creating-a-percona-product-release/

Transportable tablespaces were introduced in MySQL 5.6. Using this feature, we can directly copy a tablespace to another server and populate the table with data. This is a very useful feature for large tables. The transportable tablespace mechanism is faster than any other method for exporting and importing tables because the files containing the data [&]

https://www.percona.com/blog/2021/03/24/importing-an-encrypted-innodb-tablespace-into-mysql/

Starting a long time ago, we wanted to reproduce workload in a non-production environment, and there were different attempts to achieve that goal (Query Playback is just one of them). But there is another point of view, where you need to write your own workload to do so. Both Have Pros and Cons Reproduce Workload: [&]

https://www.percona.com/blog/2021/03/23/is-a-session-analyzer-a-good-tool-to-simulate-real-traffic/

Due to CVE-2020-29488, Percona XtraBackup is modifying how xbstream handles absolute paths to prevent malicious file injections. Like the tar archiving utility, the new behavior removes the leading / character and references to the parent directory. Fixes are available in Percona XtraBackup versions: >= 2.4.22 >= 8.0.23-16.0 For example, ../../../d1/../d2/h.txt will be saved in the [&]

https://www.percona.com/blog/2021/03/23/cve-2020-29488-changes-in-how-absolute-paths-are-handled-in-percona-xtrabackup-xbstream/

More and more companies are adopting GitOps as the way of implementing Continuous Deployment. Its elegant approach built upon a well-known tool wins the hearts of engineers. But even if your git repository is private, it’s strongly discouraged to store keys and passwords in unencrypted form. This blog post will show how easy it is [&]

https://www.percona.com/blog/2021/03/22/storing-kubernetes-operator-for-percona-server-for-mongodb-secrets-in-github/

Good intentions can sometimes end up with bad results.  Adding indexes boosts performance until it doesn’t. Avoid over-indexing. The difference between your application being fast, responsive, and scaling properly is often dependent on how you use indexes in the database.  MongoDB is no different, its performance (and the overall performance of your application) is heavily [&]

https://www.percona.com/blog/2021/03/22/want-mongodb-performance-you-will-need-to-add-and-remove-indexes/

Its release roundup time again here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Todays [&]

https://www.percona.com/blog/2021/03/15/kubernetes-operator-for-percona-server-for-mongodb-sharding-bug-fixes-for-percona-server-for-mysql-5-7-release-roundup-march-15-2021/

Join Percona Technical Expert Corrado Pandiani as he presents a quick yet robust comparison of the different backup solutions that can be used with MongoDB. This webinar will highlight:  Terminology  Elements of MongoDB Backups  Backup & Restore Solution  Performance and Impact Comparison Please join Corrado Pandiani on Friday, March 26, 2021, [&]

https://www.percona.com/blog/2021/03/11/webinar-march-26-mongodb-backups-overview/