El server pasó la noche sin out of memory killer (oom-killer), y sigue andando.
Solución momentánea: optimicé #mariadb / #mysql con esto:
innodb_buffer_pool_size = 128M
key_buffer_size = 16M
max_connections = 30
query_cache_size = 32M
Eso bajó el consumo de RAM del MariaDB del 18% al 12% (el server tiene 1GiB, el cambio es grande).
Y no jode al rendimiento para el volume de tráfico que tiene ahora.
MariaDB Foundation released #MariaDB 11.4 version 11.4.7. https://mariadb.org/download/
MariaDB Foundation released #MariaDB 10.11 version 10.11.13. https://mariadb.org/download/
Allez hop, nouvel article sur le #blog concernant la récupération de mes bases de données #mariadb suite à la mort de mon cluster #k3s https://blog.seboss666.info/2025/05/recuperer-les-bases-de-donnees-de-feu-mon-cluster-k3s-sans-backup/
"apache2 invoked oom-killer"
Se me está quedando chiquita la memoria del server :S
Habrá que optimizar algunas cosillas.
⚙️ SSD-Powered #cPanel Web Hosting – Up to 25x Faster ⚙️ SSD-Powered cPanel Web Hosting by Rad Web Hosting
Built for Performance. Backed by Reliability. Ready to Scale.
Developers, sysadmins, and power users—we built this for you. Our SSD-powered cPanel hosting is engineered on high-availability infrastructure, with ...
Continued 👉 https://blog.radwebhosting.com/%e2%9a%99%ef%b8%8f-ssd-powered-cpanel-web-hosting-up-to-25x-faster/?utm_source=mastodon&utm_medium=social&utm_campaign=ReviveOldPost #cloudlinux #letsencrypt #mariadb #postgresql #phpmyadmin #phppgadmin #laravel #softaculous #litespeed #joomla #wpcli #csf
⚠️ Spoiler alert: Yes, you can! Get started with the #MariaDB #Kubernetes Operator:
https://dzone.com/articles/mariadb-cluster-on-kubernetes-lab-test
⚙️Are you looking for an #online #database #modeling #tool with #SQL generation?
With the latest updates (e.g. modeling of #association #classes), BESSER is your ideal tool to #design and #generate your databases in many different "flavours" :
☑️ #SQLLite
☑️ #PostgresQL
☑️ #MySQL
☑️ #MariaDB
☑️ #MSSQLServer
☑️ and even #SQLAlchemy
Ready to give it a try? No installation required! ➡️ https://editor.besser-pearl.org/
Did I already mention is completely 🆓 and #opensource?
@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!
#opensuse #linux #postfix #dovecot #mariadb #apache #sogo #selfhosting #email
Anyone here with knowledge of the innards of #Mariadb? Trying to set up Galera with an existing database and getting this error (during Mariabackup sst):
InnoDB: Attempted to open a previously opened tablespace. Previous tablespace user at filepath: ./user.ibd uses space ID: 39. Cannot open filepath: ./mysql/wsrep_streaming_log.ibd
Here ./user.idb is an old file file that hasn't changed (according to the fs) in 3 years. The active idb file is in a subdirectory.
@ruud @pekkakurki Oh, wow, that sounds like there should be plenty of capacity for 1000s of users.
I have had ChatGPT write me a manual for #friendica admin since I am just getting started. There are some #MariaDB optimizations mentioned
Of course, you never know what ChatGPT does or if it is of any help.
🤩 4-node MariaDB Galera Cluster running on #Kubernetes (K3s on Orange Pi LTS 3). How-to article coming soon... stay tuned!
#MariaDB #GaleraCluster #K8s #OrangePi #EdgeComputing #HomeLab #Database
Optimize MariaDb Server 11.4 on Ubuntu 22.04 for a Raspberry Pi 5 with 16GB of Ram? #server #raspberrypi #nginx #mariadb
MariaDB Foundation released #MariaDB 11.4 version 11.4.5. https://mariadb.org/download/
MariaDB Foundation released #MariaDB 10.11 version 10.11.11. https://mariadb.org/download/
Tried running Umami with MariaDB? Everything works—until it doesn’t. I hit a weird Prisma migration error and dug into the fix. If you're self-hosting analytics, this is worth a look.
#Umami #MariaDB #SelfHosting #Prisma #WebDev #OpenSource
https://rogueninja.com/blog/posts/running-umami-with-mariadb-what-breaks-and-how-to-fix-it
MariaDB Foundation released #MariaDB 11.4 version 11.4.6. https://mariadb.org/download/
MariaDB Foundation released #MariaDB 10.11 version 10.11.12. https://mariadb.org/download/
