Today, I had an alert on a #servicenow self-hosted database running on #MySQL with 1TB of RAM and 18TB of NVMe (in RAID10-like). 100% i/o write usage. 3k connections. Why on earth do we need that amount of resources? There must be something wrong in the design.
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.
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/
An instance of a popular CMS is used for a website. While analyzing I'm coming across a a table in it's MySQL database where a column called "deleted" is defined as such:
deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted‘
🤦♂️
There should be a license allowing allowed to write software used by someone else. Like with drivers licenses it needs a points system for violations and license revocation. #WebDevelopment#PHP#MYSQL#SQL
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...
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?
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
Hmmm so question for you #MySQL/#AWS folk out there:
I always thought that, at least for databases that are less than gigantic, "mysqldump --single-transaction" was a good backup option.
Turns out that that doesn't work on AWS Aurora, apparently because it doesn't give you the necessary privileges for FLUSH TABLES WITH READ LOCK.
What am I missing? Is that option obsolete or no longer needed to get a consistent backup? Do people use completely different means to back up Aurora databases?
Does anyone have tips for installing #MySQL alongside and existing #MariaDB server in #Ubuntu 22.04? I am using a bunch of MariaDB exclusive field types and functions for geosearches, but would also like to try out Ghost which requires MySQL.
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...