xtdb

tatut 2024-08-21T06:38:51.873619Z

so XTDB v2 is mainly meant for cloud deployment? any plans to have it run with typical on-prem stuff (no S3, but a hosted traditional sql cluster)

refset 2024-08-22T09:56:49.714289Z

> a local disk version would work for a single machine deployment so we definitely already have this local-only, filesystem-backend, single-node option, but it's mainly intended for development as we assume most people want HA

tatut 2024-08-22T09:58:38.619739Z

ok, so even if a local filesystem is diligently backed up, it isn’t considered production grade?

refset 2024-08-22T10:10:40.857169Z

in reality we could definitely support that setup as production grade, because the code should be production-worthy regardless**, it's more that so far it simply hasn't yet become a priority to consider & review seriously. Always happy to have the conversations though if you have an XT-shaped problem that needs solving 🙂 **although we would definitely want to double-check our fsync's etc. before documenting the option and giving it the green light to deploy, so please talk to us first

tatut 2024-08-22T10:11:28.259569Z

roger that

👍 1
😄 1
lispyclouds 2024-08-22T10:11:52.005439Z

My experience as an SRE, I would be very hesitant to deploy something that’s not HA into production.

dharrigan 2024-08-22T15:26:23.347819Z

Would you consider a S3 compatible locally hosted solution? I've heard good things about https://github.com/seaweedfs/seaweedfs

dharrigan 2024-08-22T15:26:41.047219Z

(coupled with your own kafka cluster)

lispyclouds 2024-08-22T17:37:16.425429Z

There’s also a dependency on SNS and SQS as of now. But that would go away as I understand

🤞 2
refset 2024-08-22T17:42:51.574259Z

> Would you consider a S3 compatible locally hosted solution? yes, as long as no code changes are required it should be okay to support 👍

tatut 2024-08-23T04:38:06.287049Z

also had a possibly crazy idea, what about something like hazelcast which provides clustered java collections

1
lispyclouds 2024-08-21T07:25:40.637699Z

I had a somewhat related question sometime back: https://clojurians.slack.com/archives/CG3AM2F7V/p1718782037739449 some of the replies are relevant

✅ 1
jarohen 2024-08-21T09:11:00.455819Z

Hey @tatut 👋 the two main components we need are the tx-log and the object-store - we've implemented these atop each of the cloud providers' services, but the idea (same as for XT1) is that they're also open to extension to whatever you have available on-prem. If you'd like, let us know what that might be (feel free to DM if you'd prefer), and we'll see what we can do 🙂

tatut 2024-08-21T09:24:06.060939Z

no concrete plans, just curious if xt2 is something to consider for an on-prem case in the future

tatut 2024-08-21T10:21:34.376609Z

what’s the “golden stores” equivalent for xt2 that needs to be available for recovery if everything is lost?

jarohen 2024-08-21T10:23:02.347669Z

both the tx-log and object-store are still golden stores in XT2. the difference to XT1 is that the tx-log is now transient rather than infinite retention - we essentially mirror it (albeit in indexed form) in the obj-store

✅ 1
tatut 2024-08-22T05:20:50.857619Z

managed kafka and S3 are hassle free in a cloud environment, but I wouldn’t want to run kafka myself on-prem and operate some S3 work alike on top of it… but a local disk version would work for a single machine deployment

👍 1
jarohen 2024-08-23T13:06:25.921869Z

FYI: we've started work on https://github.com/xtdb/xtdb/issues/3631 today, removing the need for the extra SNS/SQS and their equivalents

🎉 1