I need to deploy a multi data center cluster. Exactly 2 data centers. Two clusters with bidirectional replication are not suitable, since we have many tables that need to be replicated. And in the setup_universe_replication command you need to specify the IDs of all tables. It seems there is no way to specify that certain databases need to be replicated.
Would it be ok to do the following setup instead? 3 nodes in one data center and 3 nodes in another data center in one cluster. On each node there is a master + tserver. Set the replication factor to 6. We need that if the connection between the data centers is lost, both clusters continue to work. Also, if one data center is lost, another cluster could service client requests.
Will this option be fault-tolerant and is it normal to use this approach?
It is not convenient that you need to manually or using a script get the IDs of all tables and list them in the setup_universe_replication command. Also, when changing the database schema, you will have to constantly add new tables to replication.
I would like to be able to replicate all databases with all schemas and tables without having to list all the IDs of all tables.