how to synchronize tables between clusters
Due to some reason(hardware failure and others), I have two vertica clusters, and have set up ETL from MySQL (and other systems) to send the same data to two clusters(6TB). But our users created lots of temp tables(under a different "temp" schema) to hold some intermediate data (600GB) and they will use these tables to join with other ETLed tables. These temp tables are changed very often. And users may create their temp table only in one of the cluster. How do I synchronize these data so that whenever users create tables in one cluster, I have this table automatically replicated to another cluster in real-time (or near real-time) ?