--- On Fri, 25/9/09, roctaiwan <nettreeinc at gmail.com> wrote:

> Here is my concern. I copying both 10k and 1million of
> records with success,
> but why can't 10Million records? Is this has something to
> do with my memory
> size, which loading 10Million of records is too much for my
> server to
> handle?
> 

If you're subscribing the slave to tables on the master that are already populated then the subscribe will use COPY so you'll only see anything on the slave when the entrie copy transaction is complete.

If you want to see them replicated in bite size chunks subscribe before populating the table on the master.