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 ?
Tnx all
Mozzi
Dicky Wahyu Purnomo wrote:
> can you show us, your my.cnf configuration for replication only ....
> master and slave ... ;-)
>
> my first guest is : the slave working db is not being set properly ... so when
>master doing query on DB A on table B, the slave try to look at DB "blank" on table B.
>
> see on Replicate-do-db column on show slave status : empty .... ;-)
>
> --
> Write clearly - don't be too clever.
> - The Elements of Programming Style (Kernighan & Plaugher)
>
> MySQL 3.23.51 : up 73 days, Queries : 357.128 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
