Now I remember one more thing that went wrong with this method.
Sometimes during the restoration process nagios monitoring managed to change ownership of replica db .lg file to "nagios" user.
Database was restored with a separate db user. So at some point (in the end of restoration), prorest...
I've been in similar situation. We had a 2.5 TB database. I needed to set up replication for it.
We didn't have fast shared filesystem between source and target servers. I didn't want to spend all day on it. So I tried different method.
I did something like this
# On source server
mkfifo -m...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.