Comments (3)
Is MySQL replication user (repl_use and repl_password, with REPLICATION SLAVE
privilege) created on the new master 10.236.114.128?
Original comment by [email protected]
on 5 Feb 2015 at 1:04
from mysql-master-ha.
Appreciate your input, sir. After I ran grant replication client on *.* to repl
identified by 'repl'; and got the below output. I reran the failover test but
still got the same error of "but recovery on slave partially failed". see most
bottom for the output of the privilege setting in my dbs (FYI, have confirmed
the output is the smae from all 3 master/master/slave dbs).
----- Failover Report -----
app1: MySQL Master failover 10.236.114.128 to 10.236.70.129
Master 10.236.114.128 is down!
Check MHA Manager logs at MHA1DBA for details.
Started automated(non-interactive) failover.
The latest slave 10.236.70.129(10.236.70.129:3306) has all relay logs for
recovery.
Selected 10.236.70.129 as a new master.
10.236.70.129: OK: Applying all logs succeeded.
10.236.70.131: This host has the latest relay log events.
Generating relay diff files from the latest slave succeeded.
10.236.70.131: WARN: Applying all logs succeeded. But starting slave failed.
Master failover to 10.236.70.129(10.236.70.129:3306) done, but recovery on
slave partially failed.
mysql> SELECT Repl_slave_priv,Repl_client_priv FROM mysql.user where
user='repl';
+-----------------+------------------+
| Repl_slave_priv | Repl_client_priv |
+-----------------+------------------+
| Y | Y |
+-----------------+------------------+
1 row in set (0.00 sec)
Original comment by [email protected]
on 6 Feb 2015 at 12:00
from mysql-master-ha.
I don't have shutdown_script specified. Will that be the problem? I have very
limited knowledge on Perl. Is there any further guide on what value or
parameter we should set for shutdown_script and master_ip_online_change_scrip.
Thanks a lot
Original comment by [email protected]
on 12 Feb 2015 at 12:17
from mysql-master-ha.
Related Issues (20)
- Not support for detecting poor perfomance masters HOT 1
- Manual switching | alive Old master does't become new slave HOT 3
- MHA automatic failover stop when I shutdown Master machine
- If Active Master goes Down, Slave running MHA manager can become Master?. HOT 2
- MHA IP failover / firewall issues
- masterha_check_repl skips all slave checks on MySQL 5.6 with GTID enabled HOT 3
- Do mysql master failover only when there are more than one slaves HOT 3
- Maunal purge_relay_logs crash my replication HOT 2
- Failover aborts due to 1053 - Query partially completed on the master HOT 2
- masterha_manager can not start on 3306 ,but 3313 ok
- Does mysql-master-ha work if I already have traditional mysql replication running? HOT 1
- masterha_check_repl says ssh config failed, BUT masterha_check_ssh was okay HOT 1
- alert-only mode instead of failover
- Master Failover completed successfully. Error Establishing Database Connection. HOT 2
- Documentation not available HOT 1
- masterha_check_repl crashing HOT 2
- MHA Scalability HOT 1
- mysql innodb locks during checks on slaves
- Plaintext password in output HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql-master-ha.