Uncover key lessons learned from managing MySQL in the cloud — from scaling challenges to performance tuning and high availability strategies with Igor Donchovski at #fossasiasummit2025

Click here https://youtu.be/5R6edJ1xXrU to watch on the FOSSASIA YouTube channel.

#Shaarli: How to Add Multiple Hosts in phpMyAdmin – TecAdmin - Méthode pour gérer plusieurs bases MySQL dans un même PhpMyAdmin.

Pour des bases en docker, installer le container PMA sur le même réseau docker et donner le nom du container pour afficher la base.

Permet en théorie de sélectionner des bases docker internes et des bases externes (hébergeur). : https://tecadmin.net/add-multiple-hosts-in-phpmyadmin/ #phpmyadmin #docker #bases #mysql

mysqldumpst Du noch oder zfssnapshotst Du schon?

Eine 20 GB mariadb Datenbank.
Backup:
Datenbank anhalten, zfs snapshot, Datenbank starten: 52 Sekunden.
Restore:
Datenbank ist angehalten. zfs rollback, Datenbank starten: 1,2 Sekunden (kein Typo!)

Has anyone setting up a #friendica instance for the #fediverse run into an issue where #php is unable to get authorized to log in to #mysql or #mariadb ? I am able to log in as those users in the cli and adminer webpages, and the user is given all privileges + has a wildcard for the host name.

https://blog.martinscloud.com/mariadb-use-docker-compose-for-mariadb/ #docker #docker-compose #compose #mysql #mariadb

Know Your Meme: April 2025 4chan Hack. “April 2025 4chan Hack refers to memes and jokes about the Soyjak.party community supposedly hacking 4chan, restoring the deleted /QA/ board, and leaking the emails of 4chan moderators, also known as ‘janitors.’ The attackers reportedly exploited outdated PHP code and deprecated MySQL functions in 4chan’s backend, particularly in a core script named […]

https://rbfirehose.com/2025/04/15/know-your-meme-april-2025-4chan-hack/

Oracle released #MySQL Workbench version 8.0.42. https://dev.mysql.com/downloads/workbench/

Getting MySQL Error 1175 when trying to update or delete? That’s Safe Update Mode kicking in. Learn how to disable it safely and run your queries smoothly.

Read the full guide: https://www.izoate.com/blog/how-to-fix-mysql-error-1175-disable-safe-update-mode-mysql/

PHP & MYSQL: 200 Solved Exercises and Projects for Practice https://leanpub.com/php-mysql-exercices-projects #books #ebooks #PHP #MYSQL

Question, my colleague want's a small database with only a few tables ( #Mariadb / #mysql #sql ) - Data pushed with PowerShell Scripts

He also wants a small Web UI to search in this database with "basic" filtering

I've found #Adminer (https://www.adminer.org/de/) which looks simpler then things like phpMyAdmin

Is this a good choice ? thx

Open Source Linux MySQL Tools!

Was ist MySQL?

MySQL ist ein weit verbreitetes, relationales Datenbankmanagementsystem (RDBMS), das auf der Structured Query Language (SQL) basiert. Es wird häufig für die Speicherung, Verwaltung und Abfrage von Daten in verschiedenen Anwendungen eingesetzt, von kleinen Websites bis hin zu großen Unternehmensanwendungen.

https://www.linuxlinks.com/mysqltools/

Upgrade from MySQL 8.0.33 to 8.0.41 this morning on production.

Everything went smoothly... until:

Lock timeout when upgrading an intermediate primary in a ClusterSet. It looks like https://bugs.mysql.com/bug.php?id=100242. I know that kill -9 has been used in the past (yes, MySQL can be challenging and it's the only solution), so let's re-initialize the host. 6TB of data, it's going to be long but we have no choice at this point.

The Percona Server version of MySQL Shell doesn't support the Javascript interface anymore. The official documentation has Javascript examples everywhere but not Python. I had to guess and learn the Python equivalent in emergency.

Then if we define a "localAddress" to "Cluster.add_instance", MySQL tries to use the deprecated "XCOM" communication stack instead of "MYSQL". If you have errors on port 33061, you should remove the localAddress and/or use the "MYSQL" communication stack https://dev.mysql.com/doc/mysql-shell/8.0/en/shell-admin-api-communication-stack.html

Every time the service is started, it takes 30 seconds to initialize the InnoDB buffer pool because the host has 1TB of RAM.

For an unknown reason, the mandb process takes multiple minutes when upgrading a package.

Time is really long when you do upgrades.

Hoy fueron buena onda en la uni y nos dieron una herramienta libre llamada HeidiSQL para aprender sobre creación de procedimientos en SQL.

I am throwing a fit trying to get the python mysql-connector installed.

pip gives me an error:
error: externally-managed-environment

× This environment is externally managed

How do I get this thing installed? So many of my programs use this.

#Hate Update: re prev toot ... today I hate #MySQL #information_schema because it tells great big dirty LIES. You need to `ANALYZE TABLE` on any table you're interested in immediately before you ask information_schema for its metadata.

MySQLとPostgreSQLのコマンドの違いまとめ
https://qiita.com/kojiro513/items/1ec19bdadddcf4c732c2?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

Sometimes mysql shuts down unexpectedly when using with XAMPP.

There is a workaround here to solve this:
https://stackoverflow.com/a/61859561

Kinda cool to create an AquaShell script to automate that task:

https://www.aquashell-scripting.com/examples#fix-xampp-mysql-shutdown-error

CookUnity is hiring Engineering Manager, Growth

#kotlin #swift #typescript #react #android #ios #aws #mysql #postgresql #engineeringmanager
Buenos Aires, Argentina
Full-time
CookUnity

Job details https://jobsfordevelopers.com/jobs/engineering-manager-growth-at-cookunity-com-dec-19-2024-4107a2?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring