Speed for copying data
Written by
Updated at September 27, 2024
The speed for copying data can reach 15 MBps. It usually takes 2-3 hours to copy a 100 GB database. The exact time depends on:
- Target and source settings
- Number of workers and threads
- Parallel copy capabilities of the source
- Connection stability
When you replicate PostgreSQL and MySQL data, the bandwidth may be up to 20-30 thousand write transactions per second.
If the target endpoint cleanup policy is set to Do not cleanup
and the transfer has already been activated, i.e., the tables being transferred to the targets are not empty, the transfer speed will be significantly reduced due to repeated insert attempts and errors they cause.