MySQL Forums
Forum List  »  Replication

Require suggestion for changing character set in Master master replication setup
Posted by: Satish Kumar P
Date: December 28, 2009 05:55AM

Hi,

We have an application (openfire) in our environment and we are using Mysql master master replication, so that the application writes only to one instance at any point. The application is using utf8 character set and the Mysql DB is using the default 'latin1' character set. Because of this mis-match we are having issues in storing some data in the database. So we were advised by the application folks to change the default character set of the Mysql DB to utf8.

What is the recommended way to do this?? And also, is there any way to do this by not shutting down the application at any point?

We are using mysql-server-5.0 (5.0.51a-3ubuntu5.4) on both the masters.

Thanks in advance.

Thanks,
Satish

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.