Has your OS ever refused to install the MariaDB client package or the MySQL client package due to a conflict with the other?

It feels like it should be possible to have both, but unfortunately I have yet to see a solution for this.

For a subset of these cases, all that you want is just to have the client tools such as the mariadb/ mysql CLI and the mariadb-dumper/ mysqldumper backup programs co-existing on the same OS. (I.e. you don't care about the static/dynamic libmariadbclient/libmysqlclient libs etc).

So, I decided to write up my solutions for this:
https://dbdemon.com/installing_mariadb_and_mysql_clients_on_same_unix_host/

Per-table unique FOREIGN KEY constraint names – new feature in MariaDB 12.1: https://mariadb.org/per-table-unique-foreign-key-constraint-names-new-feature-in-mariadb-12-1/ #mariadb #opensource #database

If anyone decided to set up #Nextcloud, I've learned that it runs so much better on #PostgreSQL than #MySQL or #MariaDB.

Speaker confirmed for #NextcloudConf25!

Michael “Monty” Widenius, creator of #MySQL and co-founder of #MariaDB, will be joining us in Berlin!

Decades of #OpenSource wisdom, from a true pioneer.
Sept 27–28
Berlin, Germany

Tickets: https://nextcloud.com/conference-2025/

*Takes a deep breath*

#MariaDB might be the best general database engine ever and it sucks that the for-profit company using the name kept stepping on rusty rakes over and over again so that people in suits who can't distinguish the corp from the foundation pushed for other platforms.

Side note: #PostgreSQL, I want to love you, but I have so many similar feelings about you as I do about coding in rust. You're too pedantic for your own good.

The only thing really preventing me from using @writefreely is that they use #mariadb

Better experience and fast, secure way to create a connection with MariaDB.

// Config.php

$mariadb = ini_get('pdo_mysql.default_socket');

$pdo = new PDO("mysql:unix_socket=$mariadb;dbname=test", 'root', '');

if($pdo){
echo "Database connection success!";
}

As @louis mentioned in his blog article “As all things in life, we have to start somewhere.” For a highly-available passbolt environment, that start is a single node.

Read the details in the guide here: https://hubs.li/Q03vNBbC0

Apparently the 2038 problem was fixed in #MariaDB 2 months ago, and considering the last time I checked up on this there were literally no plans to fix it ever, and some of the projects I've built do have date values beyond 2038 ('lifetime' accounts that expire in 2100 etc ), I'm genuinely a bit relieved about this one!

Absolutely no idea what the status of this is in anything other than MariaDB mind. That's going to be a fun year as a #Gentoo #Linux guy isn't it?

Don’t miss tomorrow’s webinar on what’s new in #MariaDB 11.8 LTS—features, improvements, and why it matters for your apps.

Register now and join us live: https://go.mariadb.com/25Q2-WBN-GLBL-Community11.8-2025-06-25_Registration-LP.html

SHOW INNODB STATUS; truncates long queries on #mariadb 10.6..

I hate this...

Now what?
I'll query grafana for the whole query?

/sigh

Exportar consulta SQL 2 CSV

Por un problema con PHPMyAdmin que es como lo hago normalmente he tenido que buscar la forma de exportar una consulta de SQL a MySQL/MariaDB a CSV en modo comandos.

SELECT id, shortname, fullnameFROM mdl_courseINTO OUTFILE '/tmp/courses.csv'FIELDS TERMINATED BY ','ENCLOSED BY '"'LINES TERMINATED BY '\n';

Pero me devolvía el error:

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

Solución: Insertar al archivo my.cnf en la sección [mysqld] la línea:

secure-file-priv = ""

Usage of MariaDB Auto Upgrade #MariaDB
https://blog.martinscloud.com/mariadb-the-usage-of-mariadb_auto_upgrade/

This is just beautiful. The project uses #MariaDB to store all the collected data. It makes heavy use of #API endpoints which will be a top priority not only for the internal workings. My focus mostly lies in making this as flexible as possible so people can configure it exactly as they need it. Configuration will be in #yaml.

What i got so far is:

• packet capturing (from client, sent to the control server)
• a webhook (which will be a drop-in replacement for #Discord's since a lot of services support sending logs to discord webhooks)

What's planned:

• Log file monitoring (like #Fail2Ban, but more advanced and easier to configure)
• A fully featured dashboard which visualizes the data and gives you control and a transparent overview of your network activity.
• IP banning (multiple ways to make it flexible)
• Maybe even some advanced responses (like reporting all ports as open for nmap scans)

I would be very interested to know what you think. Ideas, criticism and questions are very welcome. As soon as the base is working, i will push it to #Github.

Galera Cluster acquired by @mariadb
https://www.admin-magazine.com/News/MariaDB-Acquires-Galera-Cluster?utm_source=mam
#MariaDB #GaleraCluster #Codership #database #enterprise #HighAvailability

Install and Configure #Cacti on #AlmaLinux #VPS This article provides a guide demonstrating how to install and configure Cacti on AlmaLinux VPS.

What Is Cacti?
Cacti is an open-source network monitoring and graphing tool built on top of RRDtool. It’s designed to collect, store, and visualize time-series data from networks and systems.
What Cacti Does

Polls data from devices ...
Continued https://blog.radwebhosting.com/install-and-configure-cacti-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #mariadb #selfhosted #opensource #letsencrypt #selfhosting #rrdtool

MariaDB 11.8 LTS open-source RDBMS is out, featuring full MariaDB Vector support, faster backups, improved replication, and more.
https://linuxiac.com/mariadb-11-8-lts-rdbms-lands-with-vector-search/