It was. Now compare the benchmark of OLTP tasks and you will be surprised

It does. And that’s why I am afraid of that. Operational costs are important as well. I’d rather have those components individually than integrated into a whole ecosystem. This way I can more easily replace components, which is going to be necessary at some point.

Smear campaign with an open source product? Are you sure you still have a working organ between your ears?

That being said, my recommendation is based on using databases in big data environments for 15 years. But I am glad that your home lab is working fine with MariaDB. Does not mean it is a good product. And your comment just proves my point.

While there was a time, where those databases were considered “good”, they are only this famous because they have been free or open source for ages. Professors love open source stuff. This does not necessarily mean it is a good product in terms of database functionality. They have been stuck in the old age and simply get outperformed by almost anything. Professors also hate to change their slides and to learn something new. Because their priority is on functionality, not on real world use. And when you want to use a product in the real world, non-functional properties gain a lot of value. One of them is performance.

If you want to have a fast, reliable, open source database, use ClickHouse.

Avoid MySQL and MariaDB at all cost.

And how would you even remotely know, what I have been through. Again, it is easy to complain.

I can see that. How about not living in a country with laws like that? It is always easy to complain, but what is it that you have done so far?

I blocked blahaj.zone voluntarily. Same as the tankie-zone.

It looks nice, but honestly, once I set up everything (which I do on each of the *arr anyways), there is nothing left to be managed. That‘s the whole point of this setup, to get rid of managing things manually.

So even if I love that project and am very appreciative for all the work, I don’t have any use case in my setup that would want me to use this.

@[email protected] why on earth would you use a title like that? It‘s just plain wrong. The project switched to a different license. It is still free and still open source.

system32 is legacy crap anyways and is not used anymore. Everything important is stored in system64

By the way OP, similar but worse is the ability to handle 25Gbits. But someone made a working router for that as well and CPU was also a factor: https://michael.stapelberg.ch/posts/2022-04-23-fiber7-25gbit-upgrade/

True. But since OP is using a benchmark anyways, I don‘t know how close to real world that is. If they are doing lots of filesharing, let‘s say with P2P networks, it could be way worse because of the number of connections. So I agree with you - I was just working with the info I had :)

And he is currently at 1/3 of the potential speed and 3*60% = 180% CPU load for 1Gbits. So I wouldn’t even bother troubleshooting further when you already know the hardware will be an issue sooner or later.

The question is what you do with your pfsense. IDS/IPS are quite CPU hungry and Celerons are not really fast CPU’s.

Removed by mod

DNS? Why so complicated? Just edit your hosts file 😏

Agree. I just got it for fun and because it was cheap. I used it for my disposable e-mail addresses but now switched to .org

Also, don‘t use it for any mail servers. Spam Assassin gives a negative score by default on *.xyz domains. Stupid as shit, but I had to learn the hard way.

My HA is running in docker. It is easier than you might think. Forget about LXC. And just take your time migrating the stuff and only when the service works in docker, you can shut off the VM. Believe me, management of docker is way easier than 5 VM‘s with different OS‘s. Docker Compose is beautiful and easy.

If you need help, just message me, I might be able to give you a kickstart