Re: when should I start master's binlog?

2007-07-17 Thread Jen mlists 

Hello Baron,

2007/7/17, Baron Schwartz [EMAIL PROTECTED]:

Are you sure the master and slave had the same data at the time you started the
slave replicating from the master?  It looks to me like the slave had different
data and you need to re-initialize the slave.


I'm not so  sure.The order I made is:

in master:
flush tables with read lock;
show master status;
shutdown master mysqld.
tar master db files.
start master mysqld.

in slave:
shutdown slave mysqld.
untar master db files into right directory.
start slave mysqld.
change master to ...
start slave.



You may be able to use mysql-table-checksum and mysql-table-sync to synchronize
the slave with the master without completely re-snapshotting it from the master,
if that is an issue.  (http://mysqltoolkit.sourceforge.net)



Thank you for the good info.would go to try it.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

when should I start master's binlog?

2007-07-16 Thread Jen mlists 

Hello members,

One of our master dbs didn't have binlog enabled.But I need to do
replication on it.
So I add the lines,

[mysqld]
log-bin
server-id=1

in /etc/my.cnf and restart mysqld.Then I follow the general operation
to do the master/slave replication.
My question is,I only enable binlog before the replication
operation,is it too late?
Because I saw the replication had problems when I START SLAVE on slave
mysqld,the error message is:


070717  5:12:22  Slave SQL thread initialized, starting replication in
log 'GZDB1-bin.149' at position 103420, relay log
'./mysqlrep-relay-bin.001' position: 44
ERROR: 1062  Duplicate entry '62858' for key 1
070717  5:12:22  Slave: Error 'Duplicate entry '62858' for key 1' on
query. Default database: 'movie'. Query: 'INSERT INTO
v_movie_search_results
(userid,condition,keyword,results,dateline,expiry)
   VALUES
('0','a:3:{s:9:\condition\;a:0:{}s:10:\condition2\;a:4:{i:0;s:48:\
m.movieid IN (0,13097,39357,43318,47080,47081) \;i:1;s:19:\
m.vnet_status=\'3\' \;i:2;s:17:\ m.importance1 \;i:3;s:95:\
m.type IN 
(\'movie\',\'music_live\',\'special_cartoon\',\'special_mtv\',\'special_tv\',\'special_movie\')
\;}s:10:\condition3\;a:1:{i:0;s:12:\xx:
xxx\;}}','','a:3:{s:5:\total\;s:1:\3\;s:8:\movieids\;s:17:\47081,47080,39357\;s:9:\condition\;a:3:{s:9:\condition\;a:0:{}s:10:\condition2\;a:4:{i:0;s:48:\
m.movieid IN (0,13097,39357,43318,47080,47081) \;i:1;s:19:\
m.vnet_status=\'3\' \;i:2;s:17:\ m.importance1 \;i:3;s:95:\
m.type IN 
(\'movie\',\'music_live\',\'special_cartoon\',\'special_mtv\',\'special_tv\',\'special_movie\')
\;}s:10:\condition3\;a:1:{i:0;s:12:\xx: xxx\;}}}','118',
Error_code: 1062
070717  5:12:22  Error running query, slave SQL thread aborted. Fix
the problem, and restart the slave SQL thread with SLAVE START. We
stopped at log 'GZDB1-bin.149' position 103420


Both master and slave are mysql-4.0.20.Due to the history reasons,they
don't like to use new version,no way.
Please help me,thanks.

--jen

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: when should I start master's binlog?

2007-07-16 Thread Baron Schwartz 

Hi,

Jen mlists wrote:

Hello members,

One of our master dbs didn't have binlog enabled.But I need to do
replication on it.
So I add the lines,

[mysqld]
log-bin
server-id=1

in /etc/my.cnf and restart mysqld.Then I follow the general operation
to do the master/slave replication.
My question is,I only enable binlog before the replication
operation,is it too late?
Because I saw the replication had problems when I START SLAVE on slave
mysqld,the error message is:



Are you sure the master and slave had the same data at the time you started the 
slave replicating from the master?  It looks to me like the slave had different 
data and you need to re-initialize the slave.


You may be able to use mysql-table-checksum and mysql-table-sync to synchronize 
the slave with the master without completely re-snapshotting it from the master, 
if that is an issue.  (http://mysqltoolkit.sourceforge.net)




070717  5:12:22  Slave SQL thread initialized, starting replication in
log 'GZDB1-bin.149' at position 103420, relay log
'./mysqlrep-relay-bin.001' position: 44
ERROR: 1062  Duplicate entry '62858' for key 1
070717  5:12:22  Slave: Error 'Duplicate entry '62858' for key 1' on
query. Default database: 'movie'. Query: 'INSERT INTO
v_movie_search_results
(userid,condition,keyword,results,dateline,expiry)
   VALUES
('0','a:3:{s:9:\condition\;a:0:{}s:10:\condition2\;a:4:{i:0;s:48:\
m.movieid IN (0,13097,39357,43318,47080,47081) \;i:1;s:19:\
m.vnet_status=\'3\' \;i:2;s:17:\ m.importance1 \;i:3;s:95:\
m.type IN 
(\'movie\',\'music_live\',\'special_cartoon\',\'special_mtv\',\'special_tv\',\'special_movie\') 


\;}s:10:\condition3\;a:1:{i:0;s:12:\xx:
xxx\;}}','','a:3:{s:5:\total\;s:1:\3\;s:8:\movieids\;s:17:\47081,47080,39357\;s:9:\condition\;a:3:{s:9:\condition\;a:0:{}s:10:\condition2\;a:4:{i:0;s:48:\ 


m.movieid IN (0,13097,39357,43318,47080,47081) \;i:1;s:19:\
m.vnet_status=\'3\' \;i:2;s:17:\ m.importance1 \;i:3;s:95:\
m.type IN 
(\'movie\',\'music_live\',\'special_cartoon\',\'special_mtv\',\'special_tv\',\'special_movie\') 


\;}s:10:\condition3\;a:1:{i:0;s:12:\xx: xxx\;}}}','118',
Error_code: 1062
070717  5:12:22  Error running query, slave SQL thread aborted. Fix
the problem, and restart the slave SQL thread with SLAVE START. We
stopped at log 'GZDB1-bin.149' position 103420


Both master and slave are mysql-4.0.20.Due to the history reasons,they
don't like to use new version,no way.
Please help me,thanks.

--jen



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]