321 reputation
112
bio website
location
age
visits member for 2 years, 6 months
seen Feb 17 '13 at 9:13

Jul
2
awarded  Curious
May
10
awarded  Popular Question
Mar
20
awarded  Popular Question
May
6
awarded  Popular Question
Apr
16
awarded  Popular Question
Feb
14
awarded  Popular Question
Jan
17
awarded  Yearling
Nov
14
awarded  Critic
Nov
13
asked measure the traffic throughput on mysql table
Oct
16
accepted Will changing server_id on master break replication?
Oct
14
accepted Safely promoting master to slave
Oct
14
accepted Using Replication for Scale-Out
Oct
14
accepted Reviewing all new MySql queries on staging environment
Oct
14
asked Will changing server_id on master break replication?
Sep
4
comment Safely promoting master to slave
Thank you very much for the answer. How exactly can I cause Master 2 to forget it's previous slave role? Because, SHOW SLAVE STATUS on Master 2 still will be showing some slave related info. Unfortunately, my Cloud provider doesn't allow me to change network interfaces.
Sep
4
asked Safely promoting master to slave
Sep
4
comment MySql Switching Masters During Failover with log-slave-updates
Thank you very much for the answer. I found in the manual that "STOP SLAVE and RESET MASTER" should be started on new master (Master 2), but in the manual of (dev.mysql.com/doc/refman/5.0/en/reset-master.html)[RESET MASTER Syntax] is written that "This statement is intended to be used only when the master is started for the first time." but it's not exactly the truth, the master was master, I just need to STOP SLAVE and somehow reset slave setting of the new master. How can I do this?
Aug
21
asked mysql “Unsafe statement”
Jul
20
revised Reviewing all new MySql queries on staging environment
edited body
Jul
20
asked Reviewing all new MySql queries on staging environment