Planet MariaDB

Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are obviously direct and indirect cost connotations as well. PostgreSQL provides very detailed statistics through a number of catalog views and extensions that can be easily added to provide more […]… Read more

The Call for Papers for MariaDB Server Fest 2021 is open until Monday 16 August 2021. We’d like you to put in a submission. … Continue reading "MariaDB Server Fest 2021 – CFP – Make a submission" The post MariaDB Server Fest 2021 – CFP – Make a submission appeared first on MariaDB.org…. Read more

Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you […]… 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 … Continue reading Mydbops MyWebinar 7th edition – Speaker Announcement →… Read more

MariaDB enables developers to combine the power of SQL with the control of procedural programming through the use of Oracle PL/SQL…. Read more

We’ve recently received some questions regarding PL/Java and I found it hard to get clear instructions searching on the internet. It’s not that there is no good information out there, but most of it is either incomplete, outdated, or confusing and I decided to create this short “how-to” and show how to install it and […]… Read more

Updating documents on MongoDB prior to version 4.2 was quite limited. It was not possible to set values to a conditional expression, combine fields, or update a field based on the value of another field on the server-side. Tracing a parallel to the SQL update statements, for example, it wasn’t possible to do something like […]… Read more

Recently I wanted to play with the latest and greatest Percona Distribution for MongoDB Operator which had a bug fix I was interested in. The bug fix was merged in the main branch of the git repository, but no version of the Operator that includes this fix was released yet. I started the Operator by […]… Read more

Quality of software is a critical topic in the IT world today. Agile methodologies in software development brought new opportunities and customized development processes, which make releasing software easier and faster. But for this reason, I experienced that a lot of new, small IT companies provide “fast cooked” software, with none, or very poor quality assurance. Whatever can happen, will happen. Murphy’s law At Continuent, we develop business-critical and mission-critical MySQL database clustering and replication software that is used to protect billions of dollars of revenue each year For this reason, and the fact that our software runs in many… Read more

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7 and 8.0, consisting of MySQL-wsrep 5.7.34 (release notes, download) and MySQL-wsrep 8.0.25 (release notes, download) with Galera replication library 3.34 (release notes, download) implementing wsrep API version 25 and Galera replication library 4.9 (release notes, download) […]… Read more

Introduction:The Situation Recently we had a customer support case where all of the Replicas were SUSPECT in cctrl: [LOGICAL] /east > ls … DATASOURCES: +—————————————————————————-+ |db1(slave:ONLINE, progress=-1, latency=-1.000) | |STATUS [OK] [2021/07/16 11:32:15 PM UTC] | +—————————————————————————-+ | MANAGER(state=ONLINE) | | REPLICATOR(role=slave, master=db2, state=SUSPECT) | | DATASERVER(state=ONLINE) | +—————————————————————————-+ +—————————————————————————-+ |db2(master:ONLINE, progress=15010618, THL latency=0.942) | |STATUS [OK] [2021/05/29 09:20:27 PM UTC] | +—————————————————————————-+ | MANAGER(state=ONLINE) | | REPLICATOR(role=master, state=ONLINE) | | DATASERVER(state=ONLINE) | +—————————————————————————-+ +—————————————————————————-+ |db3(slave:ONLINE, progress=-1, latency=-1.000) | |STATUS [OK] [2021/06/25 03:22:28 PM UTC] | +—————————————————————————-+ | MANAGER(state=ONLINE) | | REPLICATOR(role=slave, master=db2, state=SUSPECT) | | DATASERVER(state=ONLINE) | +—————————————————————————- Further… Read more

As of MySQL 8.0, performance_schema.data_locks shows InnoDB data locks. Before MySQL 8.0, you must SET GLOBAL innodb_status_output_locks=ON and ruminate on the output of SHOW ENGINE INNODB STATUS. The image below (click to see full size) shows how the former maps to the latter for three record locks and one table lock on table t. Information Schema tables INNODB_LOCKS and INNODB_LOCK_WAITS are deprecated as of MySQL 5.7 and removed as of MySQL 8…. Read more

We have several PostgreSQL versions that support logical decoding to replicate data changes from a source database to a target database, which is a cool and very powerful tool that gives the option to replicate all the tables in a database, only one schema, a specific set of tables or even only some columns/rows, also […]… Read more

Fiserv, a Percona customer, will discuss the business case and results they achieved working with Percona to run MongoDB.  Register for a Fireside Chat taking place on Tuesday, July 27, 1 PM EDT! If you use MongoDB to build business applications that need to scale quickly, the chances are that your company is paying dearly […]… Read more

How to Migrate from Galera Cluster to Continuent Tungsten Clustering for MySQL or MariaDB Migrating from any source to Tungsten Clustering without downtime is a similar process – here we look at Galera Cluster One question we often get from potential customers is, “Tungsten Clustering meets all of our needs, but how do we migrate off our existing systems?” As part of our support, we help our new customers with these kinds of migrations. Although the process is similar for most sources, in this Webinar Matt will show you specifically how to migrate from Galera to Tungsten Cluster. Status: Webinar replayAgenda: The… Read more