Blog: optimizedbyotto.com
- 55 Posts
- 26 Comments
Otto@programming.devOPto
Selfhosted@lemmy.world•Stop using MySQL in 2026, it is not true open sourceEnglish
1·22 days agoIn case you are Czech, there is a translation at https://www.root.cz/clanky/prestante-uz-pouzivat-mysql-neni-to-skutecny-open-source/?nahled=1
Glad to see more translations show up!
Otto@programming.devOPto
Debian operating system@lemmy.ml•Could the XZ backdoor have been detected with better Git and Debian packaging practices?
2·4 months agoThere was a bunch of luck involved that Andres Freund detected this. Give more time, it would have ended up in stable releases eventually if not detected.
Otto@programming.devOPto
Linux@programming.dev•Fireship’s latest vid spreading the Linux desktop to 500k+ viewers
33·4 months agoExactly. I don’t use Omarchy, but I think it is good someone did a polished distro for a specific use case, and some web dev Windows users will surely find it more appealing than a generic distro where they need to figure out a lot of stuff from scratch.
Otto@programming.devOPto
Selfhosted@lemmy.world•Which open alternative apps list is the best?English
1·5 months agoTo me it is hard to find the best apps in their directory as they don’t have a good ranking system. The other sites that rank by GitHub stars do a pretty good job of surfacing what are the truly most popular and successful apps.
Otto@programming.devOPto
Sysadmin@lemmy.world•MariaDB 11.8's zero-configuration TLS requires no manual setup
41·5 months agoTLS is good *only’ if you are also validating those certs. And that is what MariaDB 11.8 is now doing.
Otto@programming.devOPto
Technology@lemmy.world•I got hooked on browsing openalternative.co is "Most Popular" listEnglish
1·5 months agodeleted by creator
Otto@programming.devOPto
Technology@lemmy.world•I got hooked on browsing openalternative.co is "Most Popular" listEnglish
6·5 months agoSeems there are also https://www.opensourcealternative.to/, https://euroalternative.co/ and https://european-alternatives.eu/
“Unicode as default character set” - finally, nice!
Otto@programming.devtoMariaDB / MySQL@programming.dev•MariaDB 11.8 LTS is now officially available (GitHub Link)English
1·8 months agoBlog is better than reading GitHub: https://mariadb.org/11-8-lts-released/
Otto@programming.devOPtoMariaDB / MySQL@lemmy.ml•MariaDB 11.8 LTS is now officially available
1·8 months agoAlso, if you like MariaDB, show your support and help it get to 10k stars at https://github.com/MariaDB/Server
Otto@programming.devOPtoDatabase@lemmy.ml•MariaDB 11.8 LTS released, has vector support, automatic TLS and more
1·8 months agoAlso, if you like MariaDB, show your support and help it get to 10k stars at https://github.com/MariaDB/Server
Otto@programming.devOPto
Debian operating system@lemmy.ml•What do users of MariaDB in Debian want to see in future versions?
2·9 months agoI can’t setup a ‘default user’ (only root), but there is now a MR adding exact commands you can copy-paste in a README: https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/115
Otto@programming.devOPto
DevOps@programming.dev•Stategies for scaling out MySQL/MariaDB when database gets too large for a single host?
2·9 months agoI am asking for general strategies, not for a solution to a specific case.
Otto@programming.devOPto
Sysadmin@lemmy.world•What to do when a MySQL/MariaDB database gets too large for a single host?
4·9 months agoBy UV 3000 you probably don’t mean the ultraviolet lamp that is the first page of Google is full of when searching with this term…? I doubt UV - whatever it is - is a common approach.
Otto@programming.devOPto
Debian operating system@lemmy.ml•What do users of MariaDB in Debian want to see in future versions?
3·9 months agoWhat do you mean a default user? You can just run ‘mariadb’ to access to console with the same user that had permissions to run ‘apt install’.
For your actual application you need to plan what database name to use, what user, what permissions it needs, potentially remote connection and TLS etc. This indeed is some work and could perhaps be automated a bit, but it also needs sysadmin to make some decisions.
Otto@programming.devOPtoMariaDB / MySQL@lemmy.ml•What do users of MariaDB in Debian/Ubuntu want to see in future versions?
2·9 months agoYes, increasing the InnoDB buffer pool to use all available memory is the most important configuration change a sysadmin can do. But in order to do it, you need to know if the host is dedicated to one MariaDB instance or if there are multiple servers on the same host. Otherwise you would just have processes each hogging more memory when they can and not giving it up to others.
I could think about having a dialog during the installation that asks something like “Is host dedicated to this MariaDB instance? If yes, automatically configure it to use most of the system RAM available.”
Otto@programming.devOPto
Ubuntu Linux@lemmy.ml•What do users of MariaDB in Ubuntu want to see in future versions?
1·9 months agoMariaDB supports Galera clustering out-of-the-box, and also traditional primary/replica setups. But you need to have something that spans multiple hosts to monitor and manage it, and that is outside of what a single-host OS package management system can do.
Otto@programming.devOPto
Open Source@lemmy.ml•What local LLMs are you using to create embeddings for RAG?
1·9 months agoYou mean ollama? There are so many options, any favorites?




















I welcome more paid schemes, such as Ubuntu Pro, as I believe it is beneficial for the whole ecosystem.