SQL Database support and XO HA
-
Hello,
As we know, XO uses Redis as its database for data storage. If something goes wrong at the Redis level, everything goes dark. You mentioned that we can back up the XO configuration and re-import it, but that’s not a complete solution.
If we are fully dependent on XO to manage a large infrastructure, there should be proper persistence at the XO level. Additionally, there should be official documentation on XO HA (High Availability) so that we can implement load balancing and ensure redundancy.
-
Hi,
XOA is meant to be disposable, every XCP-ng object is stored in memory only. With XOA, you even have a Cloud backup possible to quickly restore it.
Restore config on another XOA (eg you can leave a free XOA unused running somewhere, and ultra quickly restore).
For "true" HA, it might be better to wait for the next major modification, where we'll run a "real" database. Then, it would make more sense at some point
So it's a "no" on the short term, but this will likely change in the future -
@olivierlambert said in SQL Database support and XO HA:
wait for the next major modification
what about XO6 the full revamped version of XO?
-
XO 6 is mostly the new UI. Adding another DB is a separate process at the drawing board for now, meant to scale for very large infrastructure (10K+ VMs)
-
@olivierlambert PostgreSQL is good at scale, btw I'm opening an issue in the XO repo so that I'll be aware to any action to this feature either now or in future. Thank you.
-
We have very skilled people thinking about this, no need to go further, it's already in the works
-
@olivierlambert Happy to hear
