| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 4 months |
| seen | Feb 17 at 9:13 | |
| stats | profile views | 10 |
|
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 |
|
Apr 24 |
comment |
MySql 5.5 in ubuntu repository sorry, the same, dpkg-query --status mysql-5.5.23 Package `mysql-5.5.23' is not installed and no info is available. |
|
Apr 24 |
comment |
MySql 5.5 in ubuntu repository Sorry, dpkg-query --status mysql-5.5.23-debian5.0-i686 Package `mysql-5.5.23-debian5.0-i686' is not installed and no info is available. |
|
Apr 24 |
comment |
MySql 5.5 in ubuntu repository dpkg-query --status mysql-5.5.23-debian5.0-i686.deb - Package `mysql-5.5.23-debian5.0-i686.deb' is not installed and no info is available. |