All,
I have a situation. We have a very large database(gigabytes). When we
load the data in to the table, it will be huge again (20 million rows).
So in order to get good backup we set up a replication(master-slave
setup). But now, because of this setup, loading into the table takes
hours which will be generally done in a few minutes otherwise.
Is there a workaround for this? We really don't want to wait for hours
for the table to be loaded. Should we abandon replication for this? Any
pointers ?
--
Thanks,
Sairam Krishnamurthy
+1 612 859 8161