I have a requiremnet wherein i have to add/drop partition of tables which is replication. I will be excuting the add/drop of the partitions by cronjob. will the add/drop propogate to the other sites.
and i can't suspend and resume the replication (as there will be continious data logging which has to propagated to the other sites), so i have to see that add/drop partition has to done when the replication setup is in normal mode. as if we put in quisce state the other module will not log data.