I want to know the best way to update an index in HA.
For example.
2 - N1QL servers
-
Both server have the same index but with different index names
On Server 1 - CREATE INDEX
by_type01ON test(type) WHERE (type` is valued)On Server 2 - CREATE INDEX
by_type02ON test(type) WHERE (type` is valued)
After in production, I need to add a new attribute to the indexes
CREATE INDEX by_type01 ON test(type,name) WHERE (type is valued)
Should we remove the index on server 1 and rebuild the new index on server 1, then go to the next server?
Or version off the new indexes such as by_type01_ver1, and once the new indexes are rebuilt delete the old indexes?