List:General Discussion« Previous MessageNext Message »
From:Joey L Date:June 6 2012 4:14am
Subject:Re: I am trying to setup a multi master mysql setup.
View as plain text  
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
>>
>
Thread
I am trying to setup a multi master mysql setup.Joey L5 Jun
  • Re: I am trying to setup a multi master mysql setup.Andrew Moore5 Jun
    • Re: I am trying to setup a multi master mysql setup.Joey L6 Jun