Start replication from the last dump

Registered by bigbes

Currently, replication slave needs to be manually "seeded" with a snapshot to be able to read .xlog files from the master. If the snapshot is not too recent, and some .xlog files created after this snapshot was taken are missing on the master, replication won't work.
The "seeding" is copying (via "scp", "ftp" or alike) the snapshot from the master.

From system administration point of view, it would be nice to be able to create a new replica by simply initializing it and pointing at the master. The master should be able to find the most recent snapshot automatically, feed it to the replica, and then continue with subsequent .xlog files.

There is another use case, when replica's .xlog file already contains records, but the master is missing .xlog files necessary to bring the replica up to date. Since there is no way to find out whether or not the data in the .xlog files on the replica corresponds to the data on the master, this case will need to be addressed by a separate task.

Blueprint information

Status:
Complete
Approver:
Kostja Osipov
Priority:
Medium
Drafter:
Kostja Osipov
Direction:
Needs approval
Assignee:
Aleksandr Lyapunov
Definition:
Approved
Series goal:
Accepted for 1.6
Implementation:
Implemented
Milestone target:
milestone icon 1.6.1
Started by
Kostja Osipov
Completed by
Kostja Osipov

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.