I am doing a full backup using PgBackRest from a production server to Reposerver.
My connection is IPSec VPN over ILL ( 8 Mbps link) between the Production DB Server and the remote RepoServer.
I understood the bottleneck of 8 Mbps between servers. (Server NICs 10Gbps and switch 10G)
The current size of the production DB data dir 500GB can grow upto 1 TB to 2 TBs during a time span of one year from today.
Query : I have started the backup command and it is running (may go for hours and days as link speed is minimal, right now it is achieved only 25GB/500 GB copied from 10:55 Hrs to 22:00 Hrs) .
What should be the ideal connectivity without over provisioning the bandwidth, but doing a full backup must finish within acceptable time duration.
I mean the connectivity btw. production server to Repo server
i) ILL with SSL VPN btw servers
ii) OR MPLS between servers ?
iii) what should be the ideal bandwidth required considering the data dir size mentioned above to do a reasonable backup (Full). within a reasonable time window
iv) without over provisioning and underprovisioning what should be the ideal connectivity and its bandwidth requirement to avoid network errors and intermittent disconnection of links if any?
v ) Need to perform at least one full backup in a week
Any suggestions much appreciated
Thank you ,
Krishane
