I have development mysql master and slave servers and a prod server. I need to set up regular (once a week) syncronization of dev and prod databases. It would be easy for me to use prod# mysqldump > dump.sql and dev-master# mysql < dump.sql as it won't break replication, but having a 170Gb base it is not very good idea. So the question is if there's a proper way to re-enable replication after re-writing database on master. Will it work if I just re-write database on both master and slave and hope no bin-log errors occure?
Upd: percona-server-server-5.6, InnoDB/Barracuda are used.