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).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com
---------------------------------------------------------------------
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
