hi thanks for the quick answer ! these 2 servers are in different timezones
- do i need to set the slave server to the master slave's timezone?
i'm giong to research implementing that right away - in the meantime i
thought this might help show some information
i have this on the master:
mysql> show master status;
+----------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+----------------+----------+--------------+------------------+
| dp3-bin.000002 | 5382028 | ***** | |
+----------------+----------+--------------+------------------+
1 row in set (0.00 sec)
and this on the slave:
mysql> show slave status;
+----------------+--------------+-------------+-------------+---------------+-----------------+---------------------+----------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+
| Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry
| Master_Log_File | Read_Master_Log_Pos | Relay_Log_File |
Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running
| Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table |
Replicate_Ignore_Table | Replicate_Wild_Do_Table |
Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | Skip_Counter |
Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File |
Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_SSL_CA_Path
| Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key |
Seconds_Behind_Master |
+----------------+--------------+-------------+-------------+---------------+-----------------+---------------------+----------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+
| | ***** | ***** | 13306 | 60 |
dp3-bin.000002 | 4126670 | *****-sql-relay-bin.000002|
233 |
dp3-bin.000002 | No | Yes | *****
; | |
| |
| | 0 | | 0
| 4126670 | 233 | None |
| 0 | No |
| | | |
| |
+----------------+--------------+-------------+-------------+---------------+-----------------+---------------------+----------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+
1 row in set (0.00 sec)
On 1/18/08, Saravanan <[EMAIL PROTECTED]> wrote:
>
> did you check time in master and slave servers?
>
> saravanan
>
>
> --- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote:
>
> > From: Paul Berry <[EMAIL PROTECTED]>
> > Subject: another slave loading question
> > To: "MySql" <[email protected]>
> > Date: Saturday, January 19, 2008, 7:56 AM
> > i have this State when I start a slave: Has read all relay
> > log; waiting for
> > the slave I/O thread to update it
> >
> > mysql> show processlist;
> >
> +----+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------+------------------+
> > | Id | User | Host | db | Command | Time |
> > State
> > |
> > Info |
> >
> +----+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------+------------------+
> > | 17 | root | localhost | **** | Query | 0 |
> > NULL
> > | show
> > processlist |
> > | 23 | system user | | NULL | Connect | 2057
> > | Has read all
> > relay log; waiting for the slave I/O thread to update it |
> > NULL
> > |
> >
> +----+-------------+-----------+-------+---------+------+-----------------------------------------------------------------------+------------------+
> > 2 rows in set (0.00 sec)
> >
> >
> > it was started with a mysqldump and is now many hours
> > behind the master
> > it seems from what i've researched that its now off on
> > the start points and
> > so it won't ever get through it
> > can i LOAD DATA FROM MASTER; to have it clean up, or is
> > there a method or
> > something i'm missing
> > thanks!
> > paul
>
>
>
>
> ____________________________________________________________________________________
> Never miss a thing. Make Yahoo your home page.
> http://www.yahoo.com/r/hs
>
