MySQL Forums :: Replication :: Require suggestion for changing character set in Master master replication setup


Advanced Search

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


Subject Views Written By Posted
Require suggestion for changing character set in Master master replication setup 3304 Satish Kumar P 12/28/2009 05:55AM
Re: Require suggestion for changing character set in Master master replication setup 1601 Rick James 12/29/2009 10:09PM
Re: Require suggestion for changing character set in Master master replication setup 1615 Satish Kumar P 12/29/2009 10:44PM
Re: Require suggestion for changing character set in Master master replication setup 1549 Rick James 12/29/2009 11:52PM
Re: Require suggestion for changing character set in Master master replication setup 1635 Satish Kumar P 12/30/2009 12:04AM
Re: Require suggestion for changing character set in Master master replication setup 1534 Rick James 12/30/2009 12:23AM


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.