replication problem
am 24.06.2009 13:45:51 von tyzhaoqi
--000e0cd28d522f7171046d16a6a6
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
hi all:
I have three mysql database,tow run as master and the other one runs as
slave.
Some tables in the database have an autoincreament field named as 'rowid'.
These
tables have 1000000 records on master, but some of these tables on the
slave only have thousands
of record. The tables on the slave are not the same as those on master.
When i use 'show slave status', i find that Last_Errno equals to 0.
How to solve this problem.
--000e0cd28d522f7171046d16a6a6--
Re: replication problem
am 26.06.2009 11:05:02 von yueliangdao0608
--0016e6475cfcc3f0f5046d3ca294
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable
Hi.
Can you give me a flow of your master/slave?
On Wed, Jun 24, 2009 at 7:45 PM, ÕÔçù wrote:
> hi all:
> I have three mysql database,tow run as master and the other one runs a=
s
> slave.
> Some tables in the database have an autoincreament field named as 'rowid'=
..
> These
> tables have 1000000 records on master, but some of these tables on the
> slave only have thousands
> of record. The tables on the slave are not the same as those on master.
> When i use 'show slave status', i find that Last_Errno equals to 0.
> How to solve this problem.
>
--=20
David Yeung,
MySQL Senior Support Engineer,
Sun Gold Partner.
My Blog:http://yueliangdao0608.cublog.cn
--0016e6475cfcc3f0f5046d3ca294--