README.md

go-sync utility

Easy project file and database synchronization for developers

Successor for CliTools Sync written on Golang

Features

General:

• Yaml based configuration files (gosync.yml or .gosync.yml)
• Automatic cleanup of schemas before restore

Sync:

• Filesync (rsync) from remote servers using SSH
• Create file stubs instead of fetching files from remote (with real images, see options.generate-stubs = true)
• Dump MySQL schemas from remote servers using SSH, Docker and SSH+Docker
• Restore MySQL schema to local MySQL servers or Docker/Docker-Compose containers
• Filtering databases tabes with regexp
• Rsync filters
• Custom exec scripts (startup/finish) on local or remote machine (using SSH)

Deployment:

• Filesync (rsync) from local to remote servers using SSH
• Dump MySQL schemas from local MySQL servers or Docker/Docker-Compose containers
• Filtering databases tabes with regexp
• Rsync filters
• Custom exec scripts (startup/finish) on local or remote machine (using SSH)

Help

Usage:
  gosync [OPTIONS] <command>

Application Options:
  -v, --verbose  verbose mode

Help Options:
  -h, --help     Show this help message

Available commands:
  deploy       Deploy to server
  list         List server configurations
  self-update  Self update
  sync         Sync from server
  version      Show version

Example

> gosync sync production

:: Initialisation
   -> found configuration file /Users/xxxxxx/Projects/examples/gosync.yml
   -> using production server
   -> using connection Exec[Type:ssh SSH:[email protected]]
:: Starting exec mode "startup"
   -> executing >> Exec[Type:local Command:date +%s]
   -> executing >> Exec[Type:local Command:date +%s]
   -> executing >> Exec[Type:local Workdir:/ Command:date]
   -> executing >> Exec[Type:local Workdir:/ Command:date]
   -> executing >> Exec[Type:remote Workdir:/ Command:date]
:: Starting sync of Filesystem[Path:/home/xxxxxx/application1/ -> Local:./application1/]
:: Starting sync of Filesystem[Path:/home/xxxxxx/application2/ -> Local:./application2/]
:: Starting sync of Database[Schema:application1 User:mysql-user Passwd:***** -> Schema:test-local]
   -> dropping local database "test-application1"
   -> creating local database "test-application1"
   -> syncing database structure
   -> get list of mysql tables for table filter
   -> syncing database data
:: Starting sync of Database[Schema:application2 User:mysql-user Passwd:***** -> Schema:test]
   -> dropping local database "test-application2"
   -> creating local database "test-application2"
   -> syncing database structure
   -> get list of mysql tables for table filter
   -> syncing database data
:: Starting exec mode "finish"
   -> executing >> Exec[Type:remote Workdir:/ Command:date]
-> finished