Are you saying that mass inserts go much slower now that you've set up replication? In that case, I suspect you have your binlogs on the same disk as your data.
Put the binary logs on separate disks, and you'll notice a dramatic increase in performance. On Mon, Dec 6, 2010 at 7:17 AM, Sairam Krishnamurthy <kmsram...@gmail.com>wrote: > 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 > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel