Planet MariaDB Server
Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and other DMLs could have unwanted side-effects such as inconsistent ordering: rows can appear in different order on different nodes in your cluster.If you are not actively relying on row orders, this could seem acceptable. Deletes […]…
Read more
2024-03-28
Source:
Percona
Codership is please to announce a new release of Galera Manager. This brings the installer to version 1.13.0 (you can check this by typing: ./gm-installer version which will report gm-installer version 1.13.0 (linux/amd64)) and the actual Galera Manager GUI to 1.8.4. Users will notice many usability improvements, and multiple fixes for issues filed at the […]…
Read more
2024-03-28
Source:
Galera Cluster
OK, MariaDB Server didn’t specifically win, but a project around the MariaDB Catalogs feature won and the team behind it was led by me. In this post, I shall dig into what the CloudFest Hackathon is, what we did there and why it is a big deal. … Continue reading "MariaDB Wins at the CloudFest Hackathon" The post MariaDB Wins at the CloudFest Hackathon appeared first on MariaDB.org….
Read more
2024-03-27
Source:
MariaDB Foundation
PostgreSQL releases major versions relatively often, about once a year. This is because the PostgreSQL Global Development Group (PGDG) is committed to providing new features and improvements to the database on a regular basis. Of course, there are some drawbacks to releasing major versions so often. One is that it can be difficult for users […] The post What’s new in PG15 appeared first on Severalnines….
Read more
2024-03-27
Source:
SeveralNines
In this video, Nickolay Ihalainen, a Senior Scaling Specialist at Percona Global Services, explains how to set up replication with standby clusters for Kubernetes databases using Percona’s open-source tools, including the Percona Operator for PostgreSQL A Standby Cluster is a backup version of your main database. It’s there to keep your data safe and make sure your database can keep running even if something goes wrong with the main one….
Read more
2024-03-27
Source:
Percona community blog
Mission-critical applications require high availability. The goal of high availability is to provide users with consistent access to services or resources, minimizing the chances of interruption….
Read more
2024-03-26
Source:
Programming Brain
Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36 (release notes, download), with Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous option for your MySQL High […]…
Read more
2024-03-26
Source:
Galera Cluster
MySQL is a very popular database and a good choice for new projects. But is it the best choice?Luckily you have several options for this choice.MySQL Community vs. Enterprise EditionsTraditionally, the MySQL Community Edition has been a mainstay in the open source community for decades, and it is available for free. Originally, MariaDB was a […]…
Read more
2024-03-26
Source:
Percona
Let’s talk about MongoDB! This week, Jan Wieremjewicz, Senior Product Manager, and Michal Nosek, Pre-Sales Enterprise Architect at Percona, made two series of videos covering basic to advanced concepts in MongoDB and backups. Le’s explore them together! Enterprise Scale Backups for MongoDB with Open Source Software In the first video about enterprise-scale backups for MongoDB using open-source software, Jan and Michal discuss the challenges and solutions associated with backing up large datasets in MongoDB….
Read more
2024-03-26
Source:
Percona community blog
Log file synchronization plays a crucial role in the performance and reliability of MySQL’s InnoDB storage engine. The efficiency and speed of log file synchronization directly impact database throughput, latency, and durability. Here’s how this […] The post The Impact of Log File Synchronization on InnoDB Performance and Durability appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse….
Read more
2024-03-25
Source:
MinervaDB Blog
The pg_wal directory (formerly known as pg_xlog in versions before PostgreSQL 10) is a crucial component of PostgreSQL, storing Write-Ahead Logging (WAL) files. These files are essential for data durability and crash recovery, as they […] The post Managing Excessive Growth of pg_wal in PostgreSQL: Causes and Solutions appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse….
Read more
2024-03-25
Source:
MinervaDB Blog
Broken foreign keys in PostgreSQL, or in any relational database system, refer to a situation where a foreign key value in one table does not have a corresponding primary key value in another table. This […] The post Preventing Broken Foreign Keys in PostgreSQL: Causes and Solutions appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse….
Read more
2024-03-25
Source:
MinervaDB Blog
Troubleshooting statistics and cost estimation in PostgreSQL is crucial for understanding and optimizing query performance. PostgreSQL uses statistics to make informed decisions about the best way to execute queries, including which indexes to use and […] The post Optimizing Query Performance: Tips for Troubleshooting PostgreSQL Statistics and Cost Estimation appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse….
Read more
2024-03-24
Source:
MinervaDB Blog
PostgreSQL 16 brings significant enhancements to its query planner/optimizer, directly influencing performance, scalability, and reliability. Here are some key improvements and their impacts: Parallelization of FULL and RIGHT Joins: PostgreSQL 16 has introduced the ability […] The post Enhancements in PostgreSQL 16 Query Planner/Optimizer: Boosting Performance, Scalability, and Reliability appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse….
Read more
2024-03-23
Source:
MinervaDB Blog
Troubleshooting long-running queries in PostgreSQL and identifying wait events, along with insights into application and session operations, involves several steps. This process helps in pinpointing the root cause of performance issues and in formulating appropriate […] The post Optimizing PostgreSQL: A Guide to Troubleshooting Long-Running Queries and Wait Events appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse….
Read more
2024-03-23
Source:
MinervaDB Blog