List:Internals« Previous MessageNext Message »
From:Jan Lindström Date:October 31 2007 5:47am
Subject:Row based replication and plugins
View as plain text  
Hi,

We have been trying to do basic row based replication tests using
solidDB Storage Engine for MySQL 5.1. For example we used following kind
of test in mysql_test/suite/rpl/t/rpl_row_basic_3soliddb.test

--disable_warnings
install plugin soliddb soname 'libsoliddb.so';
--enable warnings

--source include/have_soliddb.inc
--source include/have_binlog_format_row.inc
--source include/master-slave.inc

let $type=soliddb;
let $extra_index= ;
--source extra/rpl_tests/rpl_row_basic.test

However, it seems that install plugin is not replicated, this I can
verify from slave.log:

jan@midearth:~/mysql-5.1.22-rc/mysql-test/var/log$ more slave.log
/home/jan/mysql-5.1.22-rc/sql/mysqld, Version: 5.1.22-rc-debug-log
(Source distribution). started w
ith:
Tcp port: 9308  Unix
socket: /home/jan/mysql-5.1.22-rc/mysql-test/var/tmp/slave.sock
Time                 Id Command    Argument
071031  8:26:15    1 Connect    root@localhost on test
                    2 Connect   root@localhost on test
                    1 Query     stop slave
                    1 Query     show status like 'Slave_running'
                    1 Query     reset slave
                    1 Query     drop table if exists
t1,t2,t3,t4,t5,t6,t7,t8,t9
                    1 Query     start slave
                    3 Connect Out       root@stripped:9306
                    1 Query     select
master_pos_wait('master-bin.000001', 238)
                    4 Query     CREATE TABLE t1 (C1 CHAR(1), C2 CHAR(1),
INDEX (C1)) ENGINE = soliddb

and from slave.err:

071031  8:26:16 [Warning] Slave: Unknown table engine 'soliddb'
Error_code: 1286

How we can fig the setup so that slaves would also install plugin needed
for test execution ?

R: Jan Lindström
Solid Information Technology Ltd


Thread
Row based replication and pluginsJan Lindström31 Oct
  • Re: Row based replication and pluginsStewart Smith2 Nov
  • Re: Row based replication and pluginsPaul McCullagh2 Nov