Giter Club home page Giter Club logo

Comments (3)

GoogleCodeExporter avatar GoogleCodeExporter commented on August 16, 2024
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.

GoogleCodeExporter avatar GoogleCodeExporter commented on August 16, 2024
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.

GoogleCodeExporter avatar GoogleCodeExporter commented on August 16, 2024
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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.