Re: mysql replication table with different charsets UTF8 and UTF8MB4

On 6-11-2014 19:37, t.v.santhoshkumar_at_gmail.com wrote:
> We have mysql cluster which includes master, slave and hot standby. There is a table which has 30 million records and the charset of the table is utf8. I want to update the charset of these tables to utf8mb4 charset without taking the downtime and without breaking the replication also. Please let me know if there is anyway to perform this activity. Thanks in advance.
>

create new table with wanted/needed charset and do:

insert into newtable select * from oldtable;

i'm not sure, but this should work.....

you can test it yourself, because you have some data that needs to be converted........ Received on Thu Nov 06 2014 - 21:35:10 CET