List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:June 5 2012 7:35pm
Subject:Re: I am trying to setup a multi master mysql setup.
View as plain text  
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