DBA a life in the shadows
Database administration is weird. The job is a strange combination of theory and practice, strictness and loose rules mixed together in a magic blend.
The DBA is probably one of the most obscure and one of the less appreciated roles within the IT organisations.
I'm looking for a solution to branch-based previews for a #PHP / #MySQL stack. We have nearly 60 sites we want to set this up for (a lot of services I find either charge $1000s or don't even support that many).
I don't want anything fancy, I don't need to edit in the browser. I would like to push a branch to gitlab and have the option to spin up an environment to preview.
I have considered doing it myself, but I was hoping to not have to support my own infrastructure.
Had a chance to write up a little reflection on the 20th anniversary of WordPress, and its impact on open source + MySQL adoption.
WordPress has, IMO, done a lot towards advocating open source and helping it become mainstream. A lot of peeps who'd never have touched Linux or run OpenOffice.org or otherwise known about open source were introduced to open source early on thanks to WordPress.
Anyone here used both #MySQL and #Postgres a lot and could tell me how they compare for larger DBs? Mostly in terms of performance, assuming I don't need some advanced features - talking about 10s or 100s of GBs, a lot of writes but not that many reads. 🤔 #PostgreSQL
Hey Mastodon, what's a free hosting plan for a server-side Web app + DB you'd recommend? Should I pursue with good old #php and #mysql or is there something more modern? I have a small doodling idea for this three days week-end and maybe I should also learn a new language?
For my #blog, I also observed this problem. This is not very disturbing, but after publishing information about the new post, the site temporarily stops working and throws the error of exceeding the #MySQL query limit, because the blog is based, of course, on #Wordpress.
via #unknowNews https://news.itsfoss.com/mastodon-link-problem/
Post en français ici. TL;DR: Older versions of Drupal does not work with MySQL 8.0. Update now. Brace yourself, MySQL 8.0 is coming soon on the databases delivered with your web hostings, also called "SharedSQL" (more info soon). After my post on old Wordpress, this one is about old Drupal. Issue Whether you installed it...
i ran into some peculiar speedbumps building a very basic #drupal 10 site that would be showstoppers for novices:
😬#ckeditor 5 inline images and default admin themes don't apply height:auto, but do set image max-width to 100%, so my giant pixel art displays at the wrong aspect ratio before correcting it in both the admin and default themes
😬this haunted windows vs linux syntax issue with #mysql db config https://www.drupal.org/forum/support/post-installation/2024-03-09/error-drupalmysqldriverdatabasemysqlconnection-not-found
😬the generate-theme based theme ignores block layout order
There's like an entire class of open source project where you can no longer get support for them because they're old enough that the support channels are IRC rather than Discord or something but nobody's on IRC anymore (or rather hundreds of people are on the libera.chat channel, but no one is talking or reading questions)
Anyway I upgraded Ubuntu and now mysql is in a boot loop where it starts up, prints "Starting upgrade of data directory", prints "table SPECIFIC_TABLE_THAT_SHOULD_BE_THERE not found in InnoDB dictionary", then prints "aborting" and the process begins again. Most of the repair tools for mysql seem to assume the mysqld is already running rather than in a boot loop. There are 210 people in the #mysql irc channel on Libera and no one but me is talking. I'm not actually sure where to begin here!
MySQL 8.0: Prepare your old Drupal (community.ovh.com)
Post en français ici. TL;DR: Older versions of Drupal does not work with MySQL 8.0. Update now. Brace yourself, MySQL 8.0 is coming soon on the databases delivered with your web hostings, also called "SharedSQL" (more info soon). After my post on old Wordpress, this one is about old Drupal. Issue Whether you installed it...