List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:July 18 2002 11:02pm
Subject:Re: Replication w/ InnoDB
View as plain text  
James,

I am sorry, the manual page at
http://www.mysql.com/doc/I/n/InnoDB_restrictions.html is not up-to-date.

Look at http://www.innodb.com/ibman.html#InnoDB_restrictions instead:
.....
* In the MySQL replication load table from master does not work yet for
InnoDB tables. A workaround is to alter the table to MyISAM in the master,
do then the load, and after that alter back to InnoDB in the master.
.....

But often you should replicate everything, not just a single table. Then it
is best to shut down the master and copy all relevant files to the slave. Or
use InnoDB Hot Backup, a non-free tool.

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com


----- Original Message -----
From: ""James Kelty"" <jamesk@stripped>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 18, 2002 9:49 PM
Subject: Replication w/ InnoDB


> Ok, ok, now that I know that I 'can' replicate InnoDB tables, it's time I
> got it to ACTUALLY replicate InnoDB tables, eh?
>
> This is my /etc/my.cnf file from the master server:
>
> [mysqld]
> log-bin=/storage/mysql/replication.log
> server-id=1
> default-table-type=innodb
>
>
> innodb_data_home_dir=/storage/innodb
> set-variable = innodb_mirrored_log_groups=1
> #
> #
> innodb_data_file_path=indata1:2000M;indata2:
> data5:2000M;indata6:2000M
> #
> #
> set-variable = innodb_buffer_pool_size=128M
> set-variable = innodb_additional_mem_pool_si
> innodb_log_group_home_dir = /storage/innodbl
> #
> #
> innodb_log_arch_dir = /storage/innodblogs
> innodb_log_archive = 0
> set-variable = innodb_log_files_in_group=3
> #
> #
> set-variable = innodb_log_file_size=100M
> set-variable = innodb_log_buffer_size=16M
> #
> #
> #
> innodb_flush_log_at_trx_commit=1
> set-variable = innodb_file_io_threads=4
> set-variable = innodb_lock_wait_timeout=50
>
> [mysql.server]
> user=mysql
> basedir=/usr/local/mysql
>
> [safe_mysqld]
> err-log=/storage/mysql/mysql_error_log
> pid-file=/storage/mysql/mysqld.pid
>
>
> And Here is my /etc/my.cnf file from the SLAVE:
>
> [mysqld]
> server-id=2
> master-host=192.168.10.49
> master-user=repl
> master-password=replicate
> master-connect-retry=5
> master-info-file=master.info
> replicate-do-db=everbase
> log-slave-updates
> #skip-slave-start
>
> default-table-type=innodb
>
> innodb_flush_log_at_trx_commit=0
> innodb_data_home_dir=/database/MySQL/innodb
> set-variable = innodb_mirrored_log_groups=1
> #
> #
> innodb_data_file_path=indata1:2000M:autoextend:max
> #
> #
> set-variable = innodb_buffer_pool_size=128M
> set-variable = innodb_additional_mem_pool_size=80M
> innodb_log_group_home_dir = /database/MySQL/innodb
> #
> #
> innodb_log_arch_dir = /database/MySQL/innodblogs
> innodb_log_archive = 0
> set-variable = innodb_log_files_in_group=3
> #
> #
> set-variable = innodb_log_file_size=100M
> set-variable = innodb_log_buffer_size=16M
> #
> #
> #
> innodb_flush_log_at_trx_commit=1
> set-variable = innodb_file_io_threads=4
> set-variable = innodb_lock_wait_timeout=50
>
>
> I have select, and file permissions for the 'repl' user,
> and when I try the sql query LOAD TABLE Users FROM MASTER on the slave,
> all I get is the replicated table is created, but NO data comes accross,
> and I get the 1189 Net Read Error on the slave. BUT! When I change the
type
> of
> table from InnoDB to MyISAM on the MASTER SERVER, the above LOAD TABLE
works
> REALLY well.
>
>
> Not sure why this is happening. Plus, NONE of the changes I make to the
> table after altering it
> to the MyISAM type, replicate? What am I missing. I would really like the
> replication to work well
> with InnoDB types instead of MyISAM.
>
> Please, can someone point me in the right direction?
>
> Thanks!
>
> -James
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread114985@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-mysql=freebsd.csie.nctu.edu.tw@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


Thread
Replication w/ InnoDBJames Kelty18 Jul
Re: Replication w/ InnoDBHeikki Tuuri19 Jul