From: Joey L
Date: June 6 2012 4:14am
Subject: Re: I am trying to setup a multi master mysql setup.
List-Archive: http://lists.mysql.com/mysql/227596
Message-Id: <CAK3ER7v5oEYbxvBwwyKc-B0o4pmynT-x894GoNEK41T+DMMJ+g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 yo=
ur
> 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 =A0 =A0 =A0 =A0 =A0 =A0 | Position | Binlog_Do_DB | Binlog_Ignore=
_DB |
>> +------------------+----------+--------------+------------------+
>> | mysql-bin.000035 | =A0 =A0 =A0106 | mailserver =A0 | =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0|
>> +------------------+----------+--------------+------------------+
>> 1 row in set (0.00 sec)
>>
>> mysql> show slave status\G;
>> *************************** 1. row ***************************
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Slave_IO_State: Waiting for master to send e=
vent
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_Host: 192.168.2.121
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_User: slave1_user
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_Port: 3306
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Connect_Retry: 60
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_Log_File: mysql-bin.000024
>> =A0 =A0 =A0 =A0 =A0Read_Master_Log_Pos: 106
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Relay_Log_File: relay-bin.000025
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Relay_Log_Pos: 251
>> =A0 =A0 =A0 =A0Relay_Master_Log_File: mysql-bin.000024
>> =A0 =A0 =A0 =A0 =A0 =A0 Slave_IO_Running: Yes
>> =A0 =A0 =A0 =A0 =A0 =A0Slave_SQL_Running: Yes
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Replicate_Do_DB: mailserver
>> =A0 =A0 =A0 =A0 =A0Replicate_Ignore_DB:
>> =A0 =A0 =A0 =A0 =A0 Replicate_Do_Table:
>> =A0 =A0 =A0 Replicate_Ignore_Table:
>> =A0 =A0 =A0Replicate_Wild_Do_Table:
>> =A0Replicate_Wild_Ignore_Table:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Last_Errno: 0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Last_Error:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Skip_Counter: 0
>> =A0 =A0 =A0 =A0 =A0Exec_Master_Log_Pos: 106
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Relay_Log_Space: 545
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Until_Condition: None
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Until_Log_File:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Until_Log_Pos: 0
>> =A0 =A0 =A0 =A0 =A0 Master_SSL_Allowed: No
>> =A0 =A0 =A0 =A0 =A0 Master_SSL_CA_File:
>> =A0 =A0 =A0 =A0 =A0 Master_SSL_CA_Path:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_SSL_Cert:
>> =A0 =A0 =A0 =A0 =A0 =A0Master_SSL_Cipher:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Master_SSL_Key:
>> =A0 =A0 =A0 =A0Seconds_Behind_Master: 0
>> Master_SSL_Verify_Server_Cert: No
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Last_IO_Errno: 0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Last_IO_Error:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Last_SQL_Errno: 0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Last_SQL_Error:
>> 1 row in set (0.00 sec)
>>
>> ERROR:
>> No query specified
>>
>>
>> On Server2:
>>
>> mysql> show master status ;
>> +------------------+----------+--------------+------------------+
>> | File =A0 =A0 =A0 =A0 =A0 =A0 | Position | Binlog_Do_DB | Binlog_Ignore=
_DB |
>> +------------------+----------+--------------+------------------+
>> | mysql-bin.000024 | =A0 =A0 =A0106 | mailserver =A0 | =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0|
>> +------------------+----------+--------------+------------------+
>> 1 row in set (0.00 sec)
>>
>> mysql> show slave status\G;
>> *************************** 1. row ***************************
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Slave_IO_State:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_Host: 192.168.2.121
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_User: slave2_user
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_Port: 3306
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Connect_Retry: 60
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_Log_File:
>> =A0 =A0 =A0 =A0 =A0Read_Master_Log_Pos: 4
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Relay_Log_File: relay-bin.000001
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Relay_Log_Pos: 4
>> =A0 =A0 =A0 =A0Relay_Master_Log_File:
>> =A0 =A0 =A0 =A0 =A0 =A0 Slave_IO_Running: No
>> =A0 =A0 =A0 =A0 =A0 =A0Slave_SQL_Running: No
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Replicate_Do_DB: exampledb,mailserver
>> =A0 =A0 =A0 =A0 =A0Replicate_Ignore_DB:
>> =A0 =A0 =A0 =A0 =A0 Replicate_Do_Table:
>> =A0 =A0 =A0 Replicate_Ignore_Table:
>> =A0 =A0 =A0Replicate_Wild_Do_Table:
>> =A0Replicate_Wild_Ignore_Table:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Last_Errno: 0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Last_Error:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Skip_Counter: 0
>> =A0 =A0 =A0 =A0 =A0Exec_Master_Log_Pos: 0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Relay_Log_Space: 125
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Until_Condition: None
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Until_Log_File:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Until_Log_Pos: 0
>> =A0 =A0 =A0 =A0 =A0 Master_SSL_Allowed: No
>> =A0 =A0 =A0 =A0 =A0 Master_SSL_CA_File:
>> =A0 =A0 =A0 =A0 =A0 Master_SSL_CA_Path:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0Master_SSL_Cert:
>> =A0 =A0 =A0 =A0 =A0 =A0Master_SSL_Cipher:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Master_SSL_Key:
>> =A0 =A0 =A0 =A0Seconds_Behind_Master: NULL
>> Master_SSL_Verify_Server_Cert: No
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Last_IO_Errno: 0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Last_IO_Error:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Last_SQL_Errno: 0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 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: =A0 =A0http://lists.mysql.com/mysql
>>
>