Advertisement
Guest User

Untitled

a guest
Aug 1st, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. [syncuser@Staging staging]$ cat sync.sh
  2. #!/bin/sh
  3. ProdDBHost="ProductionDB.local"
  4. ProdAlfrescoHost="ProductionAlfresco.local"
  5.  
  6. TomcatHome="/usr/local/apache-tomcat-6.0.18"
  7.  
  8. #Stop catalina and clean up
  9. "${TomcatHome}/bin/catalina.sh" stop -force
  10. rm -rf "${TomcatHome}/work/Catalina"
  11.  
  12. #Sync DB
  13. mysqldump --quick --max_allowed_packet=1G --extended-insert --user=u1 --password=p1 --host="${ProdDBHost}" db1 | mysql --user=u1 --password=p1 db1 &
  14. mysqldump --quick --max_allowed_packet=1G --extended-insert --user=u2 --password=p2 --host="${ProdDBHost}" db2 | mysql --user=u2 --password=p2 db2 &
  15. mysqldump --quick --max_allowed_packet=1G --extended-insert --user=u3 --password=p3 --host="${ProdDBHost}" db3 | mysql --user=u3 --password=p3 db3 &
  16. mysqldump --quick --max_allowed_packet=1G --extended-insert --user=u4 --password=p4 --host="${ProdDBHost}" db4 | mysql --user=u4 --password=p4 db4 &
  17.  
  18. #Sync Alfresco
  19. rsync -avz --delete "${ProdAlfrescoHost}":/alfresco/ /alfresco/ >> /var/staging/alfresco_rsync.log &
  20.  
  21. #Wait for all of the above to complete
  22. wait
  23.  
  24. #Resume catalina
  25. "${TomcatHome}/bin/catalina.sh" start
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement