使用多个主机ip迁移cassandra的库实现

Question

I am trying to use golang-migrate library for cassandra migrations.

In the Docs, they have mentioned to use cassandra url like this

cassandra://host:port/keyspace?param1=value&param2=value2

We will be having more than one host for cassandra.

Do I need to loop for each host and run migrations separately? or is there is any other way?

Answer 1

The ALTER should be realised / replicated across the cluster. Migrate uses the highest level of consistency (ALL / https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlshConsistency.html) so it's the best choice if your hosts are within a cluster.

If the hosts aren't in a cluster, then hand rolling and applying the migrations for each host is the only option.