RE: problem with replication

2002-12-12 Thread Maxime LEMAIRE
hi, try this : mysql > SHOW MASTER STATUS; +--++--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--++--+- + | some-file| XX | | |

RE: problem with replication

2002-12-14 Thread Maxime LEMAIRE
: RE: problem with replication Hi ... i have just tried by nothing's changed! ... i mean ... now in the "show slave status" i can see the right master_log_filename, log_position etc. but the error persists! What's wrong? help me please! Thanks and bye --- Maxime LEMAIRE <[

replication and auto_increment

2002-12-19 Thread Maxime LEMAIRE
hi, i would like to create a dual master/slave replication with mysql i think i wouldn't have any problem but i wonder how mysql manage auto_increment id ... how it works ? maxime - Before posting, please check: http://ww

RE: replication and auto_increment

2002-12-19 Thread Maxime LEMAIRE
TED] Objet : Re: replication and auto_increment Do not allow inserts on both machines. Maxime LEMAIRE wrote: >hi, > >i would like to create a dual master/slave replication with mysql >i think i wouldn't have any problem but i wonder how mysql manage >auto_increment

replication

2002-12-29 Thread Maxime LEMAIRE
Hi, I would like to know how mySQL manage the identity (auto increment counter) in a replication environment when 2 servers are both master on the same database. Here's a sample of my problem. We have 2 servers running mySQL. Server1 replicate data on server2 and server2 replicate data on server