Mastodawn

Dear #lazyweb,
I'm finding myself in a discussion that a partner expects their system to run in local timezone (Europe/Berlin), while we sysadmins have configured the whole fleet as UTC (as one should do).
I remember an article that explains why, for SQL servers, #UTCorGTFO. The latter has obviously a wide audience ( https://wiert.me/2022/11/08/utc-and-iso-8601-or-gtfo/, https://www.netmeister.org/blog/ops-lessons.html), but I fail to find any structured reasoning why UTC is the best choice.

Can you help me out?

#UTC #MySQL #sysadmin

UTC and ISO 8601, or GTFO

Always schedule your meetings in UTC, and use ISO-8601 date and time notation. Because time zone conversions are hard, especially with so many daylight saving time conventions. I want not just a &#…

The Wiert Corner - irregular stream of stuff

Meteora Web 23h ago

🚨 NEWS: PostgreSQL vs MySQL: quando scegliere Postgres per la tua applicazione

Ecco i punti chiave in breve:
💡 Ti è mai capitato di dover scegliere un database e di finire su MySQL per pura abitudine? O di sentirti dire che Postgres è troppo complesso e che MySQL fa il suo dovere? Noi di...

🚀 LINK: https://meteoraweb.com/analisi-dei-dati-e-metriche/postgresql-vs-mysql-quando-scegliere-postgres-per-la-tua-applicazione

#guidaOperativa #postgreSQL #mySQL #confrontoDatabase #jSONB

mastodon.raddemo.host 1d ago

Top 25 #Ubuntu 26.04 LTS Admin Changes

Here are the Top 25 Ubuntu 26.04 LTS admin changes that you will notice almost immediately after first boot or first upgrade.
About Ubuntu 26.04 LTS
Ubuntu 26.04 LTS (“Resolute Raccoon”) is the newest long-term support release from Canonical, focused heavily on security, newer hardware support, Wayland/NVIDIA improvements, and long-term enterprise stability.
Major Highlights
Linux Kernel 7.0
Ubuntu ...
Continued 👉 https://blog.radwebhosting.com/top-25-ubuntu-26-04-lts-admin-changes/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #mysql

AskUbuntu 1d ago

Error: trying to start over with LAMP stack #apt #packagemanagement #mysql #lamp #phpmyadmin

https://askubuntu.com/q/1567401/612

Error: trying to start over with LAMP stack

I tried to install the LAMP stack and everything went OK until I tried to install phpmyadmin. My package management just broke with some dbconfig-common and dbconfig-mysql. I tried purge phpmyadmin,

Ask Ubuntu

mastodon.raddemo.host 1d ago

🛠 Guide to Using #phpMyAdmin in #cPanel This article provides a guide to using phpMyAdmin in cPanel servers. The guide will walk you through everything you need to know to confidently use phpMyAdmin within your cPanel hosting account.
📌 Introduction
phpMyAdmin is a free, web-based tool that allows you to manage #MySQL and #MariaDB databases without needing to use the command line. The phpMyAdmin feature is included with all shared hosting services. ...
Continued 👉 https://blog.radwebhosting.com/using-phpmyadmin-in-cpanel/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host

Rad Web Hosting 1d ago

🛠 Guide to Using #phpMyAdmin in #cPanel This article provides a guide to using phpMyAdmin in cPanel servers. The guide will walk you through everything you need to know to confidently use phpMyAdmin within your cPanel hosting account.
📌 Introduction
phpMyAdmin is a free, web-based tool that allows you to manage #MySQL and #MariaDB databases without needing to use the command line. The phpMyAdmin feature is included with all shared hosting services. ...
Continued 👉 https://blog.radwebhosting.com/using-phpmyadmin-in-cpanel/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social

Marcel SIneM(S)US 1d ago

Kein Vertrauen mehr in #Oracle: Community-Stiftung will #MySQL-Kurs korrigieren | Developer https://www.heise.de/news/Kein-Vertrauen-mehr-in-Oracle-Community-Stiftung-will-MySQL-Kurs-korrigieren-11310815.html #OpenSource #OurSQL

Kein Vertrauen mehr in Oracle: Community-Stiftung will MySQL-Kurs korrigieren

Oracles Chaoskurs bei MySQL zwingt die Community zum Handeln. Sie hat jetzt die OurSQL Foundation gegründet, um MySQL selbst zu fördern und weiterzuentwickeln.

heise online

InfoQ 1d ago

Learn how #Meta migrated a data ingestion platform that transfers several petabytes of MySQL social graph data every day to improve reliability and operational efficiency.

The team used techniques such as reverse shadowing and continuous checksum monitoring to execute the migration with zero downtime.

🔗 Discover more: https://bit.ly/3RwcYsZ

#AI #MySQL #Migration #Scalability #InfoQ

Rad Web Hosting 1d ago

Top 25 #Ubuntu 26.04 LTS Admin Changes

Here are the Top 25 Ubuntu 26.04 LTS admin changes that you will notice almost immediately after first boot or first upgrade.
About Ubuntu 26.04 LTS
Ubuntu 26.04 LTS (“Resolute Raccoon”) is the newest long-term support release from Canonical, focused heavily on security, newer hardware support, Wayland/NVIDIA improvements, and long-term enterprise stability.
Major Highlights
Linux Kernel 7.0
Ubuntu ...
Continued 👉 https://blog.radwebhosting.com/top-25-ubuntu-26-04-lts-admin-changes/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #mysql