Hi,
I've the following database structure of 4 tables for geographical
information
CREATE TABLE IF NOT EXISTS `mydb`.`country` (
`country_id` INT NOT NULL ,
`country_code` CHAR(2) NOT NULL ,
`name` VARCHAR(255) NOT NULL ,
PRIMARY KEY (`country_id`) ,
UNIQUE INDEX
Hello Manuel,
Thank you for your reply. Could I do the following?:
1) Enable log-bin on master2 (slave that will be converted to a master)
2) Enable log-slave-updates on master2
3) Execute CHANGE MASTER to on another existing slave so that it gets
it's updates from master2 instead of master1.
If you're able to use MySQL 5.6 and enable GTIDs then it gets a whole lot
simpler as you don't need to worry about finding the correct positions in the
binary logs. Take a look at
http://www.mysql.com/why-mysql/white-papers/mysql-replication-high-availability/
and
1) Enable log-bin on master2 (slave that will be converted to a master)
That does not 'convert' it -- it makes it both a Master and a Slave (a Relay).
The CHANGE MASTER is probably correct, but it is difficult to find the right
spot.
A simple way is to
1. Stop all writes everywhere.
2. Wait
You want to say either Germany or Deutschland, depending on a
language_code somewhere?
*Yes, this is the exact issue I'm on on about. *
I like your idea. Does anyone else have any thoughts before I try this way
?
On Wed, May 1, 2013 at 4:19 PM, Rick James rja...@yahoo-inc.com wrote:
You
You want to say either Germany or Deutschland, depending on a
language_code somewhere?
Remove the strings you have in those tables now; add about 4 new tables, each
one paralleling the existing tables, but more rows and these columns:
* id (the PK of the existing table)
* language code (ENUM or