shakedown.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A community for live music fans with roots in the jam scene. Shakedown Social is run by a team of volunteers (led by @clifff and @sethadam1) and funded by donations.

Administered by:

Server stats:

253
active users

#mariadb

0 posts0 participants0 posts today

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-dump/ mysqldump 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:
dbdemon.com/installing_mariadb

dbdemon · Installing both MariaDB and MySQL clients on the same Unix hostHow to make MySQL's mysql, mysqldump co-exist with MariaDB's mariadb, mariadb-dump in a Unix-like OS
#mariadb#mysql#pkg

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 👉 blog.radwebhosting.com/install #mariadb #selfhosted #opensource #letsencrypt #selfhosting #rrdtool

RadWeb, LLC · Install And Configure Cacti On AlmaLinux VPS - VPS Hosting Blog | Dedicated Servers | Reseller HostingThis article provides a guide demonstrating how to install and configure Cacti on AlmaLinux VPS.
Replied in thread

@blog As an old IT geek that started in this game long before the modern internet (I had an email address in the 1980s when all it could do was talk to UK or US universities or the military via JANET or DARPANET etc.over UUCP) I have been increasingly depressed at how big US tech has worked so hard at killing off the original,, open, standardised, federrated design principles of the web and sucking everyone into their closed silos.

Email is one of the original protocols in use and is still federated in theory but nearly everyone iis forced onto Google or Microsoft as there are few good alternatives.

I have hosted own email (plus calendar and contacts) for 25 years now. Not too tricky if you are IT savvy... but...

My stack (all open source):

Opensuse Linux
Postfix email server
MariaDB database
Dovecot IMAP server
Apache web server
Amavis anti-spam/anti-virus
Spamassasin spam filters
SOGo groupware

Plus good secure DNS with SPF, DKIM and DMARC records and reverse-ip for the server.

Give it a go!

10 Steps to Protect Your #VPS Against SQL Injection
This article provides a guide discussing how to protect your VPS against SQL injection.
What is SQL Injection?
SQL Injection is a type of cyber attack where an attacker inserts or “injects” malicious SQL code into a query through input fields, URLs, or other data entry points. If the application doesn't properly validate or sanitize the input, the ...
Continued 👉 blog.radwebhosting.com/how-to- #mariadb #vpsguide #sqlinjection #postgresql

RadWeb, LLC · 10 Steps To Protect Your VPS Against SQL Injection - VPS Hosting Blog | Dedicated Servers | Reseller HostingHere’s a detailed guide on how to protect your VPS against SQL Injection attacks.

#Perl DBD::mysql and the corresponding #RHEL package have always been #MariaDB compatible, i.e., you could install MariaDB and DBD::mysql RPMs together.
But the new DBD::mysql package in #CentOS stream can no longer be installed with MariaDB.
I filed a bug (issues.redhat.com/browse/RHEL-) and #RedHat said it's not supposed to work. Except it always has.
What do you think?
(Note if it doesn't work then all Perl scripts on the host that use DBD::mysql must be modified to use DBD::MariaDB instead.)
#mysql

issues.redhat.comLoading...

New House Projects – Weather Watching V0.5

I've always been fascinated with the weather. I can still remember the daily routine of charting the weather in kindergarten with meticulous scientific rigor: Each morning one pupil, on a rotation, would peer out a window and then mark down if it was sunny, or cloudy, or possibly raining...

topslakr.com/2025/04/new-house

Topslakr.com · New House Projects – Weather Watching V0.5I’ve always been fascinated with the weather. I can still remember the daily routine of charting the weather in kindergarten with meticulous scientific rigor: Each morning one pupil, on a rot…

Finally got data to import from a .csv file into a MariaDB table, for my toy train db. It dropped ~150 records from errors, so I'll have to do it again tomorrow.

As ever, data normalization is the key. I learned I have more steps to take after I save a LibreOffice Calc file as a .csv file, before importing it.

Still, real progress, and I feel good about that.

I've been playing around with converting a website's database from MariaDB to SQLite. SQLite is consistently 100 - 200ms faster when performing search queries on a table with ~100,000 rows using DataTables and PHP. There doesn't appear to be any noticeable speed difference querying individual rows. Also, I'm not sure if I'm being a bit heavy handed with it, but I've managed to corrupt the SQLite db numerous times, which is concerning.