Web lists-archives.com

Re: Changing storage engine in dump file.




Thanks everyone for their reply.



Best Regards,
Geetanjali Mehra
Senior Database Administrator


On Wed, Aug 12, 2015 at 7:07 PM, Reindl Harald <h.reindl@xxxxxxxxxxxxx>
wrote:

>
> Am 12.08.2015 um 15:07 schrieb geetanjali mehra:
>
>> I am in the process of creating a new slave. On my master, there is a mix
>> of innodb and myisam tables. I want all my tables to be created in innodb
>> on slave.
>>
>> I have planned to change the value of storage engine from innodb to myisam
>> in dump file itself using sed .
>>
>> Running that dump file on the slave will create all my tables with innodb.
>>
>> Is there any implications in doing so. Is this approach correct? Will I
>> face any problem in syncing the slave?
>>
>
> if you are asking for trouble do so
> otherwise replication is designed to be identical
>
> how do you imagine that working if there is only a single "alter table" on
> the master? how do you imagine row-based replication working in such a
> setup while statement-based replication is unsafe in many cases?
>
> sorry, but that sounds just crazy
>
>