Migrate transactions for multiple shards

[musinit]

It would be nice to support multiple hosts for migration, so it's possible to apply migration for sharded databases.

[musinit]

@rubenv what do you think? :) I can suggest the MR

[rubenv]

How will that impact existing users?

[musinit]

I would make this feature optional, so no impact on those who don't need it

[rubenv]

What would we need to add/change?

The thing I'm trying to evaluate is whether this should be part of sql-migrate, or part of something that uses sql-migrate as a building block.

[musinit]

What if we do it the same way, as multihost connection string works? datasource: postgresql://node1:port1,postgresql://node2:port2

than would allow multihosting for master/slave PG migrations + can work the same way for all shards. I am not sure that it's good to mix multihost connection string with different shards, maybe it's better to implement it with separate config option, like datasources: source1, source2, ...