Lots of #MySQL industry news! So much going on and new events, including @fosdem.org '27 dates.

Lots of #MySQL industry news! So much going on and new events, including @fosdem.org '27 dates.
Zero-downtime DB maintenance with ProxySQL: flip mysql_servers status ONLINE to OFFLINE_SOFT, let existing sessions finish, keep new traffic off https://www.valtersit.com/vault/draining-database-backend-nodes-gracefully-for-zerodowntime--7cf49e/ #mysql #proxysql #maintenance
"Building a WordPress Web Server on AWS EC2: A Hands-On Linux Administration Journey" by Abdul Aziz
Analista de Dados Sênior - RevOps | Remoto — portal
BRL 135–1k
Brazil
https://hiring.lat/job/analista-de-dados-snior-revops-remoto-portal/193773
Coroot is heading to #PerconaUniversity, September 23rd in Uruguay, Montevideo!
Take part in a free day of #PostgreSQL, #MySQL, #OpenSource and #AI themed track talks. Learn from database and observability experts: www.eventbrite.com/e/percona-un...
*Friendica - Lösch-Einstellungen richtig konfigurieren*
hyperblog.de/hoergen/posts/202…
#demhoergen #hyperblog #friendica #fediverse #datenbank #mysql #mariadb #konfiguration (1/2)
This walk through covers setting up MySQL Server on Ubuntu 24.04.2 LTS. #CybersecurityLab #MySQL
Building a cybersecurity virtual lab 6/7: Setting up MySQL Server on Ubuntu
drive.proton.me/urls/XG01TWT...
Sync configs across multiple ProxySQL nodes via the proxysql_servers table and admin interface peer polling. Full guide for Ubuntu 22.04, Debian 12, https://www.valtersit.com/vault/orchestrating-multinode-proxysql-cluster-configuration-synci-31b48e/ #mysql #proxysql #clustering
Çok tablolu UPDATE ... JOIN hedef satırı en fazla BİR KEZ günceller. Kaç satır eşleştiği fark etmez.
SET n = n - 1, eşleşme başına değil satır başına bir düşer. Sürücü de doğru sorguyla aynı affected_rows'u verir: 3.
6 satır silindi, 3 düşüm uygulandı, hata yok:
🚀 How to Deploy #Coolify on #Ubuntu #VPS
This article provides a guide demonstrating how to deploy Coolify on Ubuntu VPS.
What is Coolify?
Coolify is an open-source, self-hosted ...
Continued 👉 #mongodb #redis #postgresql #container #selfhosted #mysql #paas #selfhosting #mariadb #opensource
Following our keynote at Day 2 of #PerconaLive in Amsterdam, we wrote up a summary of our preview of #vector search in #MySQL 8.4 with #HNSW indexes.
Feedback welcome!
MySQL's utf8 maxes at 3 bytes. Emojis need 4. That's why you get error 1366 and silent truncation on inserts. This guide covers diagnosing the https://www.valtersit.com/guides/databases/mysqls-fake-utf-8-why-your-database-is-truncating-emojis-and-text/ #mysql #database #devops
📚 Deploy #Koha on #Debian #VPS for Self-Hosted Library Management System This article provides a guide to deploy Koha on Debian VPS to ...
Continued 👉 #ufw #letsencrypt #fail2ban #selfhosting #mariadb #mysql #opensource #selfhosted #integratedlibrarysystem #zebraserver #librarymanagementsoftware
Normalisierung der Datenbank - warum es nur immer wieder Entwickler gibt, die meinen, so was brauche man nicht. Die haben wohl auch noch nie an so einer DB arbeiten müssen.
Tengo publicado en YouTube un tutorial de instalación de la base de datos MySQL en Linux Ubuntu (conocida por facilidad de uso y la alta disponibilidad).
#MySQL #BBDD #Gratis #Free #SiguemeYTeSigo #followback
Nota: imagen generada con IA.
ProxySQL rewrites SQL in RAM using match_pattern/replace_pattern regex rules in mysql_query_rules before queries hit backends. Zero client changes. https://www.valtersit.com/vault/implementing-realtime-sql-query-rewriting-via-match-and-repl-245c82/ #mysql #proxysql #ValtersIT
Percona Releases Galera Cluster for Percona Server/MySQL Version 9.7
The story behind it and why it is so important for #MySQL #Galera Cluster users: www.fromdual.com/blog/percona...