I have several servers rent in two datacenters. This is done to overcome DC outages (which is rare case but still happens), and so we'd like to have data from one DC to be copied to second one so we can use it to run reserved VMs with that data.
The data itself is Postgresql databases and todaye all we can afford is doing dumps or db binary backups and rsync it to second DC. Easy to understand scheme but quite dumb and time-consuming. Dump takes time and CPU power, rsync takes time and bandwidth, and the time delta is quite big.
What we'd like to test is to create PVE cluster, put DB server VM on ZFS volume and employ ZFS sync.
Sound nice and quite magical, but will this work? We can afford 1Gb internet links in both DC, but no direct 10Gb interconnect link. Postgres is ot too busy (so hope disks are not changing too fast), but this is the hope, not the fact.
Please advice, if we can rely on that approach, and, moreover, will it be useful for DB VM? DB keeps a lot of data in the RAM, so replicating disks may not be the silver bullet?
The data itself is Postgresql databases and todaye all we can afford is doing dumps or db binary backups and rsync it to second DC. Easy to understand scheme but quite dumb and time-consuming. Dump takes time and CPU power, rsync takes time and bandwidth, and the time delta is quite big.
What we'd like to test is to create PVE cluster, put DB server VM on ZFS volume and employ ZFS sync.
Sound nice and quite magical, but will this work? We can afford 1Gb internet links in both DC, but no direct 10Gb interconnect link. Postgres is ot too busy (so hope disks are not changing too fast), but this is the hope, not the fact.
Please advice, if we can rely on that approach, and, moreover, will it be useful for DB VM? DB keeps a lot of data in the RAM, so replicating disks may not be the silver bullet?