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

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
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?
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.
Apr
24
comment MySql 5.5 in ubuntu repository
I tried one, it takes 20 sec to run installation and at the end it exists without error messages, Setting up mysql (5.5.23) ...
Apr
24
comment MySql 5.5 in ubuntu repository
5.5.13 it is old version
Apr
24
comment MySql 5.5 in ubuntu repository
@Phil, sorry of couse, Ubuntu 10.04.3 LTS
Apr
13
comment Mysql Replication Automation Script
Thanks for the idea, why we should disable innodb?
Apr
4
comment Seconds Behind Master in Cloud Service
Thanks, I've done it, also I'll take a look at network. Thanks again
Apr
4
comment Seconds Behind Master in Cloud Service
Regarding high load, I don't know, it's master on the second level of masterts, I wish I have a log of all replication queries, but there is not.
Apr
4
comment Seconds Behind Master in Cloud Service
traceroutes are not the same, traceroute to the troublesome server is much longer and ping is as much as 3 times than ping to normal server. Ping flood without losses. Looks like network issues.
Apr
4
comment Seconds Behind Master in Cloud Service
No, the replication was established a week ago by copying raw data as many stable slave servers.
Apr
4
comment Seconds Behind Master in Cloud Service
There was a difference of 3 sec, now there are completely synced, still I have spikes on slave
Apr
4
comment Seconds Behind Master in Cloud Service
Seconds_Behind_Master is around 20-50 all the time
Jan
31
comment mysql change schema on the fly
Thanks, glad to know!
Jan
19
comment Which version of MySQL should I use?
Thanks, moving to 5.5, should I consider changing my.cnf or code with queries?
Jan
19
comment MySql replication with Raw Data and InnoDB tables
Thank you very much for the answer!!!
Jan
19
comment MySql replication with Raw Data and InnoDB tables
@DTest, looks like you are right, Thanks you very much!!!
Jan
18
comment mysql implementation of ORDER command
Thanks for the answer, I've edited the post, please take a look at EXPLAIN