What do you think about these backup / svn workflows I want to implement ?
Please see picture:.
Is this architecture good ? Or is there something wrong ? Missing ?
If you're open to commercial solutions WANdisco provides a clustering solution that may fit your requirements quite nicely. It will keep all the servers in sync at all times. If you put a load balancer in front of the clients it can also automatically fail them over to the backup node without intervention.
The only thing I can think of is the flow back and forward between DEV and PROD. Presumably the from from DEV to PROD is new tested software that is ready for production. For my system which is very similar in essence we also have a flow from PROD to DEV. It should be stated that this flow is entirely different from the DEV to PROD.