search

kalamuna / kalastack

Local development environment for drupal
Other
43 stars 21 forks source link

investigate sql-sync-pipe to speed up DB sync #14

Closed pirog closed 11 years ago

pirog commented 11 years ago

Interesting approach to Db sync from pantheon that pipes the output into gzip for faster transfer:

https://github.com/markcarver/sql-sync-pipe

also

some overlap with pandarus but seems better.

andrewmallis commented 11 years ago

This pantheon helpdesk issue points to sql-sync being supported now with updated alias files.

We can install the drush extension in the stack once we upload drush with something like:

drush dl drush_sql_sync_pipe --destination=$HOME/.drush
andrewmallis commented 11 years ago

from the project page: https://drupal.org/project/drush_sql_sync_pipe

If you have Pipe Viewer installed, you can pass the --progress option to show syncing progress between the source and destination.

pirog commented 11 years ago

this will be in beta1... we will need to test it ... not sure it is that much faster yet