database

What's new in MariaDB 11

Cristian Buleandra

Oct 6, 2024 — 1 min read

Here is a summary of the key updates in MariaDB from versions 11.0 to 11.7:

MariaDB 11.0 (Released: June 2023)

Performance: Query execution improvements, including optimized joins and faster storage engines.
Security: Enhanced encryption options and better user authentication methods.
Replication: Improved replication handling for better performance in distributed databases.

MariaDB 11.1 (August 2023)

JSON: Enhanced JSON functionality, including optimized query performance on JSON data types.
Privileges: Role-based privileges improvements.

MariaDB 11.2 (November 2023)

Performance: Improvements in query optimization and execution speed for complex queries.
Data Types: New data types and functions, such as better support for geospatial data.

MariaDB 11.3 (February 2024)

InnoDB Enhancements: Increased stability and performance in the InnoDB storage engine.
Security: Introduction of stricter default configurations for increased security.

MariaDB 11.4 (May 2024)

Backup Improvements: Faster backups with optimized data handling.
Performance: General improvements in storage and index handling.

MariaDB 11.5 (August 2024)

Replication: Enhanced replication, particularly for XA transactions.
Optimizer: Improvements for better query performance.
Partitioning: Fixes to address server crashes.

MariaDB 11.6 (August 2024)

Spider Engine: Stability improvements in the Spider storage engine.
Character Sets: Fixed crashes related to character set handling.
Replication: Improved semisynchronous replication.

MariaDB 11.7 (TBA ~September 2024)

Galera Cluster: Updated for better performance.
Backup: Improved handling of secure password management during backups.

These updates show a clear focus on improving database performance, security, and user convenience across the MariaDB 11.x series.

Coolify Ghost blog shows 404 after restart

⚠️After restarting my Ghost instance on Coolify v4.0.0-beta.366, my blog started showing 404 Not Found Errors. There is a bug in this Coolify version which causes this. Solution: The fix for me was to go Configuration → Edit Compose File and to add this line to my ghost

Coolify BackBlaze B2 retention

Coolify provides a way to locally set the retention for backups (how many copies to store): The problem with this is that it only applies to the local backups, stored in your Coolify instance, and not to the remote S3 backups. Without any retention policies, your S3 will retain all

Bitnami Discourse 3.3.2 update error

Problem: Do you get this error trying to update your Bitnami Discourse installation? NameError: uninitialized constant ChatMessageSerializer::BasicUserWithStatusSerializer (NameError) has_one :user, serializer: BasicUserWithStatusSerializer, embed: :objects ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Did you mean? BasicUserSerializer /opt/bitnami/discourse/plugins/chat/app/serializers/chat_message_serializer.rb Solution: You can fix this error and finalize the

How to enable PDO extension on Coolify WodPress image

To enable the PHP PDO_MYSQL extension, you can add a new command to the docker compose. Add those lines in the wordpress service after retries: 10: command: > bash -c " docker-php-ext-install pdo pdo_mysql && docker-entrypoint.sh apache2-foreground" The file file should look like this: services: