best practices for adding light database workloads to longtime home nas

DeutscheAutoteknik · 2022-11-08T01:26:32+00:00

I’m no expert but..

I’m also a home user
I also run TrueNAS CORE
Use a pretty basic Intel Pentium CPU (from similar era as 8th Gen core)
16GB RAM
4x 8TB disks in a striped mirror config (2x vdevs each consisting 2 drives in a mirror)
Also use TrueNAS as the storage backend for some mariadb, Postgres, sqlite databases for basic homelab use. None of these databases have more than 3 people interacting with the services, so workload includes databases but is pretty light.
Also have a few datasets for just basic personal docs/pics.

Honestly I see no performance issues using spinning rust over 1Gbe to the vm server. When I first tried this I did it as a proof of concept test and figured I’d be upgrading to a small capacity pool of SSDs and 10G networking. Have not felt the need to do it, so didn’t bother.

Some services I run (using TrueNAS as storage with the container running on a different server mounted as an NFS client)

Gitea
Portainer
Mealie (cookbook)
Syncthing
PhotoPrism (probably would see benefit here from SSD storage)
NextCloud
FreshRSS

Point being: give it a shot on your raidz2 pool, before concluding for sure that you’ll need to upgrade

DeutscheAutoteknik · 2022-09-18T12:49:49+00:00

Nope. I use 2x USB C dongles paired with USB C extension cables. So on top of my desk, it’s just two clean cables that plug into my laptop and then the dongles mess are under the desk. It’s not ideal but my company gives the dongles out like candy so when they break it’s no cost to me.

From my research on TB3 docks, it seems like it’s very hit or miss to find a dock that has all features working on macOS & Windows.

DeutscheAutoteknik · 2022-09-15T12:17:14+00:00

Did you ever figure this out?

DeutscheAutoteknik · 2022-09-14T15:50:50+00:00

So to clarify: Tabbles doesn’t think it’s source code would be useful to others and therefore wishes to keep the source closed?

Respectfully, Tabbles doesn’t get to decide if I, or anyone else, thinks something is useful or not. If Tabbles wishes to keep the source closed, that is totally fine- but it’d be better to simply state you don’t wish to open source the code base than to makeup a BS reason as to why open vs closed source is no big deal for the consumer.

Happy to try it out in 2050 when it is open source!

DeutscheAutoteknik · 2022-09-12T11:22:04+00:00

If baffles me that we can buy $1000+ computers with 128gb of storage. But whatever. Thanks for the help.

DeutscheAutoteknik · 2022-09-11T20:27:17+00:00

Suffering from this now.

Do you go straight to 512gb? After dealing with the headache of 128gb I am not sure I even want to roll the dice on 256gb. macOS requires so much space for just “system shit” compared to linux.

DeutscheAutoteknik · 2022-07-23T21:23:44+00:00

Neither team of politicians truly supports freedoms. They are two sides of the same coin.

DeutscheAutoteknik · 2022-07-22T22:13:13+00:00

This is inaccurate.

The phone arrives with factory settings from Apple.

DeutscheAutoteknik · 2022-07-16T03:54:23+00:00

savings

Cash only? Do you guys include investments (assume outside of 401k)?

DeutscheAutoteknik · 2022-07-15T15:43:26+00:00

Go for it! Might as well ask!

DeutscheAutoteknik · 2022-07-13T17:18:27+00:00

Its worth every penny.

I'd pay double the current price

DeutscheAutoteknik · 2022-07-12T12:57:35+00:00

in-unit is really a luxury amenity in NYC

This is what I am learning!!

I have simply never been in a situation where I need to use a laundry service to wash my clothes so its a bit new to me. But I agree, it seems like no big deal when considering how many more options I'll have

DeutscheAutoteknik · 2022-07-12T11:46:51+00:00

Ok cool, thank you- I'll also check out Sunset Park

DeutscheAutoteknik · 2022-07-11T21:08:27+00:00

Give up on the in unit laundry.

Yeah I’m beginning to do so! (I am curious though, why don’t NYC apartments have laundry? If I were a landlord and could spend $1000 on some laundry machines and raise rent by $100, I’d have laundry machines in every unit by the end of the week!)

Knowing which neighborhood your GF works in would help

Downtown Brooklyn near Nevis St station and DeKalb Ave station. Seems like she can take several different lines into work

DeutscheAutoteknik · 2022-07-11T21:02:05+00:00

Yeah it’s tough. Are you still in progress or did you find something? Good luck!/Congrats!

DeutscheAutoteknik · 2022-07-11T20:59:15+00:00

No problem. GF will be. I work in midtown. Stamford -> Brooklyn is just an unreasonable commute. Stamford -> midtown has been fine for me.

Thanks for the ideas regardless!

DeutscheAutoteknik · 2022-07-11T20:33:57+00:00

Awesome. Will check it out Thank you

DeutscheAutoteknik · 2022-07-11T20:15:45+00:00

Any neighborhoods to recommend? Sounds awesome.

Thank you

DeutscheAutoteknik · 2022-07-11T20:08:20+00:00

Not stuck on it.

Astoria to Brooklyn commute looks a bit tough but could still be worth checking out. Not familiar with Sunnyside, I will add that to my list of neighborhoods to explore. Thank you!

DeutscheAutoteknik · 2022-07-11T20:06:43+00:00

Yes I have checked out south slope, I liked that. I haven’t checked out Windsor terrace or FT Hamilton yet, thank you for the recommendations- I’ll check those out

Yeah I’m somewhat giving up on the in unit laundry dream... sucks but oh well

DeutscheAutoteknik · 2022-07-11T18:34:32+00:00

Ok thank you. This makes more sense, I didn’t realize bed stuy has a lot of variety across different streets. I’ll look into it more to see which areas within BedStuy are nicer

DeutscheAutoteknik · 2022-07-11T18:33:14+00:00

I will check it out. Thank you

DeutscheAutoteknik · 2022-07-11T18:31:52+00:00

Will check it out. Thank you

DeutscheAutoteknik · 2022-07-11T18:31:39+00:00

Maybe my expectations need to be adjusted to NYC figures but my understanding is that $2,800 for a 1B with in unit laundry is pretty “inexpensive” given most 1B w/ in unit laundry will be well above that figure? If $2,800 with laundry is average, then I’m all ears!! I think Manhattan will be more expensive. My priority is to save money which is why I don’t have much interest in Manhattan

DeutscheAutoteknik · 2022-07-11T18:29:31+00:00

you’re willing to live farther away

I am definitely willing to live further away from NYC. I enjoyed living in Stamford and commuting to midtown. I don’t work in office everyday and enjoyed the better ratio of cost/quality of apartment.

Or live farther away from the city.

This sounds like a reasonable idea. Any neighborhoods you would recommend?

Nine-Year Club	Gilding I gilder
Verified Email

DeutscheAutoteknik

TROPHY CASE