Hello Mozzi wrote:
> Don't understand it still > It doesn't give me errors in logfile orf when I type show server stutus. > Yet it isn't replicating !! > Any ideas ? > I even tryed checking file sizes between servers on the .MYD file and > it isn't working 1. On the server do a: mysqlbinlog /path/to/your/data-dir/ais-rad02-bin.001 | grep '#2575635' 2. If the position exists you have some trouble I cannot help you with ;-) 3. If there is no such position look, if there is a position around that; adjust the slave to read the right position (I had some occurences of a position pointing beyond the end of the binlog file) Like: slave stop; change master to master_log_file='ais-rad02-bin.002' master_position=4; slave start; show slave status; Greetings Ralf > > Mozzi > > Dicky Wahyu Purnomo wrote: > >> Pada Mon, 02 Sep 2002 12:51:50 +0200 >> Mozzi <[EMAIL PROTECTED]> menulis : >> >> >>> Heya Dicky >>> How are you ? Havn't seen you in a while ;-) >>> >>> kay what I did was >>> >RESET MASTER and RESET SLAVE >>> And restartted slave >>> That worked!!! >>> >>> Now what I want to know is when I give the command >show slave status I >>> get the following >>> mysql> show slave status; >>> >+---------------+-------------+-------------+---------------+-------------------+---------+---------------+-----------------+---------------------+------------+------------+--------------+ > >>> >>> | Master_Host | Master_User | Master_Port | Connect_retry | Log_File >>> | Pos | Slave_Running | Replicate_do_db | >>> Replicate_ignore_db | Last_errno | Last_error | Skip_counter | >>> >+---------------+-------------+-------------+---------------+-------------------+---------+---------------+-----------------+---------------------+------------+------------+--------------+ > >>> >>> | 196.25.84.193 | replicate | 3306 | 60 | >>> ais-rad02-bin.001 | 2575635 | Yes | | >>> | 0 | | 0 | >>> >+---------------+-------------+-------------+---------------+-------------------+---------+---------------+-----------------+---------------------+------------+------------+--------------+ > >>> >>> 1 row in set (0.01 sec) >>> >>> Is it actually replicating ? >>> my my.cnf files look like this >>> SLAVE---> >>> [mysqld] >>> socket=/var/lib/mysql/mysql.sock >>> server-id=2 >>> master-host=<myip> >>> master-user=<user> >>> master-password=<passwd> >>> replicate-do-table=radius.radcheck >>> replicate-do-table=radius.usergroup >>> >>> log=/var/log/mysqld.log >>> ---<end>---- >>> >>> MASTER------> >>> [mysqld] >>> socket=/var/lib/mysql/mysql.sock >>> server-id=1 >>> >>> log=/var/log/mysqld.log >>> log-bin >>> ----<end>---- >>> >>> How long does it take normally ? >> >> >> >> normal to me :D >> >> usually i use binlog-do-db=.... and replicate-do-db=.... that's why i >> found your slave status is a little not "normal" to me :D >> >> as long as what you need is working, then everything is ok ;-) >> >> -- >> Let's call it an accidental feature. >> -- Larry Wall >> >> MySQL 3.23.51 : up 73 days, Queries : 357.245 per second (avg). >> -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH & Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
