On Sun, Apr 18, 2010 at 9:35 PM, Eric Bergen wrote:
> This can become a problem when using replication. For example if you do:
>
> begin;
> insert into innodb_table;
> insert into myisam_table;
> insert into innodb_table;
> rollback;
>
> The innodb rows won't be replicated but the myisam row will
This can become a problem when using replication. For example if you do:
begin;
insert into innodb_table;
insert into myisam_table;
insert into innodb_table;
rollback;
The innodb rows won't be replicated but the myisam row will. There is
more info at:
http://dev.mysql.com/doc/refman/5.0/en/innod
Tompkins Neil wrote:
Just looking for some confirmation that under a single database - I assume
it is perfectly normal to have both MyISAM and InnoDB engines for different
tables ? Is there anything I need to be aware of ?
In most case no problems. MySQL can mix engines without problems.
Every
