It is exactly the same process. InnoDB and MyISAM are about the
storage engine, the replication is quite seperate.
Initializing it is a bit more challenging.. there are some quick
low-level approaches but the simplest way is to populate your slave
from a mysqldump file.
- michael dykman
On
hello list,
I'm not familiar with Innodb.I have done well on MyISAM replication.
Can you tell me how to replicate Innodb database?thanks.
--jennifer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] schrieb:
anyone know if there's any known issue with replication from InnoDB tables to
MyISAM tables?
I just switched a slave (mysql) to replicate from a different master that uses
InnoDB and now I'm seeing weird problems on the slave. Table corruption, apps
that can't
anyone know if there's any known issue with replication from InnoDB tables to
MyISAM tables?
I just switched a slave (mysql) to replicate from a different master that uses
InnoDB and now I'm seeing weird problems on the slave. Table corruption, apps
that can't connect etc.
thanks,
Jeff
I'm working on a new series of queries that share a temporary table.
I've tried using both create temporary table select and create
temp table then insert into t ... select from y. Both seem to
create a lock that (if the select portion runs long enough) causes a
deadlock with the replication
Mike,
- Original Message -
From: Mike Debnam [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, November 21, 2004 9:25 PM
Subject: temporary tables, replication, and innodb tables
I'm working on a new series of queries that share a temporary table.
I've tried using both
Hi!
Replication between MyISAM and and InnoDB tables should work, and actually
many people use it.
The only essential limitation in replication with InnoDB is that LOAD TABLE
FROM MASTER does not work. The workaround is to ALTER the table to MyISAM,
do LOAD TABLE..., and ALTER back.
Best
Hello,
I am trying to setup replication to be used basicaly as a hot backup.
My production database uses INNODB tables. I would like my Replication
database to just my MyISAM since I do not need transactions on that one.
Just a copy of the data. I followed the process to create the slave
DATA
FROM MASTER? That is how I updated my slave, and as I said it seemed to work
fine.
I need to Replicate InnoDB tables, but I am worried that the manual says
LOAD DATA FROM MASTER won't work. So is Replication ok with InnoDB, once you
get the servers synced?
Thanks,
Eric
At 12:48 AM 8/16
Hello,
I'm not sure I am still using 3.23.
Serge.
- Original Message -
From: Eric Frazier [EMAIL PROTECTED]
To: Serge Paquin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 10:05 PM
Subject: Re: Replication with INNODB
Hi,
I am confused. I just tried
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
: 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
I have a 3.23.51 server with InnoDB tables. I want to replicate
one of the databases over to some 3.23.49 servers with MyISAM tables.
The tables do have some auto-increment columns. I expect that only
valid data is going to be written to the binlog, so
Philip,
- Original Message -
From: Philip Molter [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, July 15, 2002 5:55 PM
Subject: Replication from InnoDB - MyISAM
I have a 3.23.51 server with InnoDB tables. I want to replicate
one of the databases over to some
How does transaction works in this scenario?. Is rollbacked transaction
written into bin-log files?.
Nilesh
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 1:30 PM
To: Philip Molter; [EMAIL PROTECTED]
Subject: Re: Replication from InnoDB
committed transactions.
: - Original Message -
: From: Philip Molter [EMAIL PROTECTED]
: Newsgroups: mailing.database.mysql
: Sent: Monday, July 15, 2002 5:55 PM
: Subject: Replication from InnoDB - MyISAM
:
:
: I have a 3.23.51 server with InnoDB tables. I want to replicate
: one
I am sorry. I should have paid more attention to Heikki email.
Nilesh
-Original Message-
From: Philip Molter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:43 PM
To: Nilesh Shah
Cc: [EMAIL PROTECTED]
Subject: Re: Replication from InnoDB - MyISAM
On Mon, Jul 15, 2002 at 02:40
Christian Jaeger writes:
At 16:17 Uhr +0300 13.7.2001, Sinisa Milivojevic wrote:
Hi!
We have been planning to use mysql/innodb with replication soon
(mid/end of august). http://www.mysql.com/doc/B/i/Binary_log.html
suggests that replication should work with transactional table(s
Hi,
I'm thinking about using MySQL with InnoDB and replication. Are there any
experiences with this configuration, esp. what about transactions? What will
happen on the slave if transactions are rolled back? What happens if the
master or the slave crashes while processing transactions.
Thanks
Jörg Beckmann writes:
Hi,
I'm thinking about using MySQL with InnoDB and replication. Are there any
experiences with this configuration, esp. what about transactions? What will
happen on the slave if transactions are rolled back? What happens if the
master or the slave crashes while
20 matches
Mail list logo