Planet MariaDB

In a previous post, A Horizontal Scalability Mindset for MySQL, I discussed the concerns around growing individual MySQL instances too large and some basic strategies: Optimizing/minimizing size with proper data types Removing unused/duplicate indexes Keeping your Primary Keys small Pruning data Finally, if those methods have been exhausted, I touched on horizontal sharding as the […]… Read more

It’s been a while since Percona started to develop its own software products, but collecting reviews is a new experience for us. We started this activity about a year ago, and the results we got are stunning. Your reviews said more about us than we ever could imagine. From everyone at Percona, we’d like to […]… Read more

The “Misc features” preview includes all the other features that did not make it into a separate dedicated preview binary. MariaDB Server 10.7 includes the JSON_EQUALS function, which compares inputs as JSON objects, regardless of whitespace, key order, or number format. … Continue reading "10.7 feature preview: Miscellaneous features" The post 10.7 feature preview: Miscellaneous features appeared first on MariaDB.org…. Read more

By default, MariaDB does not check if a user reuses a password. Some security policies require users to choose a new password each time, and the Password Reuse Check plugin, available in a MariaDB 10.7.0 preview, enables this functionality. … Continue reading "10.7 preview feature: Password Reuse Check plugin" The post 10.7 preview feature: Password Reuse Check plugin appeared first on MariaDB.org…. Read more

As a Technical Account Manager at Percona, I get to work with many of our largest clients. While the industry verticals vary, one main core challenge generally remains the same – what do I do with all this data? Dealing with massive data sets in MySQL isn’t a new challenge, but the best approach still […]… Read more

The future of technology adoption belongs to developers. The future of application deployment belongs in the cloud. The future of databases belongs to open source. That’s essentially the summary of Percona’s innovation strategy and that’s the reason I decided to join Percona – I believe the company can provide me with the perfect platform for […]… Read more

It’s release roundup time again here at Percona! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. […]… Read more

We are merry & galvanized for bestowing seeds of cognizance to our opensource database community. Thank you to all those who attended in our 9th edition of MyWebinar.  We hope our session was able to elevate & seam your workmanship to perfection. We are committed in giving back to our opensource database community by hosting more … Continue reading Synopsis of Mydbops 9th edition of MyWebinar →… Read more

What are Replication Filters in MySQL? A replication filter is used to filter out the necessary databases and tables that will be replicated in the replica. The replication filter can be set either in my. cnf or the command line. The change made in those databases will be logged in binary log files. The filter … Continue reading Replication Filters in MySQL an Overview →… Read more

If you are using table partitioning, you have likely heard of the ALTER TABLE … EXCHANGE PARTITION … WITH TABLE … command. It existed in MariaDB since forever. … Continue reading "10.7 preview feature: CONVERT PARTITION" The post 10.7 preview feature: CONVERT PARTITION appeared first on MariaDB.org…. Read more

String formatting can easily lead to code clutter. Code readability in Python was considerably improved with Python 3’s f-strings. Now, something similar is available in MariaDB 10.7. … Continue reading "10.7 preview feature: Python-like sformat" The post 10.7 preview feature: Python-like sformat appeared first on MariaDB.org…. Read more

MySQL 8 comes with a lot of good features, and recently I explored its password management systems. I wanted to put together a series of blogs about it, and this is the first part. In this post, I am going to explain the following topics in detail. Password Reuse Policy Random Password Generation Password Reuse […]… Read more

This article is meant to provide a high-level overview of how a web-based application is commonly structured nowadays. Keep in mind the topic presented is very simplified. It is meant as an introduction only and hopefully encourages the reader to investigate some of the concepts in more depth. Monolith vs Microservices With the rise of […]… Read more

Mydbops propounds free webinars & meetups about MySQL, MongoDB, and PostgreSQL, the major three opensource databases.  What greater thing can we give to our community than to diversify their skill sets and improve their craftsmanship by providing free Webinars with niche topics, illustrations, Q&A, and, most importantly, more fun as we work together to sharpen our … Continue reading Mydbops MyWebinar 9th edition – Speaker Announcement →… Read more

MariaDB has had support for histograms as part of Engine Independent Table Statistics since 10.0. As part of Google Summer of Code (MDEV-21130), Michael Okoko, together with his mentor Sergey Petrunia, have implemented a new format (using JSON) for histograms that significantly improves the accuracy and flexibility of histograms. … Continue reading "10.7 preview feature JSON Histograms" The post 10.7 preview feature JSON Histograms appeared first on MariaDB.org…. Read more