thanks - i had to reset the whole db and the error went away - do not
know what i did wrong.
thanks
On Tue, Jun 5, 2012 at 3:35 PM, Andrew Moore <eroomydna@stripped> wrote:
> Joey, please consult your mysql error log. Something has gone wrong on your
> server where innodb is not started.
>
> On Tue, Jun 5, 2012 at 3:53 PM, Joey L <mjh2000@stripped> wrote:
>>
>> I am following or trying to follow this document:
>> http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
>>
>> I think it is running in a good state because when i query the show
>> slave state, I get awaiting connection from host, like :
>>
>> on server1:
>>
>> mysql> SHOW MASTER STATUS;
>> +------------------+----------+--------------+------------------+
>> | File | Position | Binlog_Do_DB |
> Binlog_Ignore_DB |
>> +------------------+----------+--------------+------------------+
>> | mysql-bin.000035 | 106 | mailserver |
> |
>> +------------------+----------+--------------+------------------+
>> 1 row in set (0.00 sec)
>>
>> mysql> show slave status\G;
>> *************************** 1. row ***************************
>> Slave_IO_State: Waiting for
> master to send event
>> Master_Host:
> 192.168.2.121
>> Master_User:
> slave1_user
>> Master_Port: 3306
>> Connect_Retry: 60
>> Master_Log_File:
> mysql-bin.000024
>> Read_Master_Log_Pos: 106
>> Relay_Log_File:
> relay-bin.000025
>> Relay_Log_Pos: 251
>> Relay_Master_Log_File: mysql-bin.000024
>> Slave_IO_Running: Yes
>> Slave_SQL_Running: Yes
>> Replicate_Do_DB: mailserver
>> Replicate_Ignore_DB:
>> Replicate_Do_Table:
>> Replicate_Ignore_Table:
>> Replicate_Wild_Do_Table:
>> Replicate_Wild_Ignore_Table:
>> Last_Errno: 0
>> Last_Error:
>> Skip_Counter: 0
>> Exec_Master_Log_Pos: 106
>> Relay_Log_Space: 545
>> Until_Condition: None
>> Until_Log_File:
>> Until_Log_Pos: 0
>> Master_SSL_Allowed: No
>> Master_SSL_CA_File:
>> Master_SSL_CA_Path:
>> Master_SSL_Cert:
>> Master_SSL_Cipher:
>> Master_SSL_Key:
>> Seconds_Behind_Master: 0
>> Master_SSL_Verify_Server_Cert: No
>> Last_IO_Errno: 0
>> Last_IO_Error:
>> Last_SQL_Errno: 0
>> Last_SQL_Error:
>> 1 row in set (0.00 sec)
>>
>> ERROR:
>> No query specified
>>
>>
>> On Server2:
>>
>> mysql> show master status ;
>> +------------------+----------+--------------+------------------+
>> | File | Position | Binlog_Do_DB |
> Binlog_Ignore_DB |
>> +------------------+----------+--------------+------------------+
>> | mysql-bin.000024 | 106 | mailserver |
> |
>> +------------------+----------+--------------+------------------+
>> 1 row in set (0.00 sec)
>>
>> mysql> show slave status\G;
>> *************************** 1. row ***************************
>> Slave_IO_State:
>> Master_Host:
> 192.168.2.121
>> Master_User:
> slave2_user
>> Master_Port: 3306
>> Connect_Retry: 60
>> Master_Log_File:
>> Read_Master_Log_Pos: 4
>> Relay_Log_File:
> relay-bin.000001
>> Relay_Log_Pos: 4
>> Relay_Master_Log_File:
>> Slave_IO_Running: No
>> Slave_SQL_Running: No
>> Replicate_Do_DB:
> exampledb,mailserver
>> Replicate_Ignore_DB:
>> Replicate_Do_Table:
>> Replicate_Ignore_Table:
>> Replicate_Wild_Do_Table:
>> Replicate_Wild_Ignore_Table:
>> Last_Errno: 0
>> Last_Error:
>> Skip_Counter: 0
>> Exec_Master_Log_Pos: 0
>> Relay_Log_Space: 125
>> Until_Condition: None
>> Until_Log_File:
>> Until_Log_Pos: 0
>> Master_SSL_Allowed: No
>> Master_SSL_CA_File:
>> Master_SSL_CA_Path:
>> Master_SSL_Cert:
>> Master_SSL_Cipher:
>> Master_SSL_Key:
>> Seconds_Behind_Master: NULL
>> Master_SSL_Verify_Server_Cert: No
>> Last_IO_Errno: 0
>> Last_IO_Error:
>> Last_SQL_Errno: 0
>> Last_SQL_Error:
>> 1 row in set (0.00 sec)
>>
>> ERROR:
>> No query specified
>>
>> On server1 - I am able to do a select statement to the table and get
>> back results.
>> On server2 - i get the error regarding no innodb.below:
>>
>>
>>
>> ERROR 1286 (42000): Unknown table engine 'InnoDB'
>> mysql> select * from virtual_users ;
>> ERROR 1286 (42000): Unknown table engine 'InnoDB'
>>
>>
>> can anyone assist ?
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql
>>
>
