I'm using Mysql Server 5.6. I've setup master-slave replication and its working fine. The only problem is, when i get the master server up the data from the slave is not updated automatically to the master.
How to update master database with data of slave database after failover in mysql
1k Views Asked by Lakshya At
1
There are 1 best solutions below
Related Questions in JAVA
- Add image to JCheckBoxMenuItem
- How to access invisible Unordered List element with Selenium WebDriver using Java
- Inheritance in Java, apparent type vs actual type
- Java catch the ball Game
- Access objects variable & method by name
- GridBagLayout is displaying JTextField and JTextArea as short, vertical lines
- Perform a task each interval
- Compound classes stored in an array are not accessible in selenium java
- How to avoid concurrent access to a resource?
- Why does processing goes slower on implementing try catch block in java?
- Redirect inside java interceptor
- Push toolbar content below statusbar
- Animation in Java on top of JPanel
- JPA - How to query with a LIKE operator in combination with an AttributeConverter
- Java Assign a Value to an array cell
Related Questions in MYSQL
- MySQL Select Rank
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Push mysql database script to server using git
- Why does mysql stop using indexes when date ranges are added to the query?
- Google Maps API Re-size
- store numpy array in mysql
- Whats wrong with this query? Using ands
- MySQL-Auto increment
- show duplicate values subquery mysql
- Java Web Application Query Is Not Working
- microsoft odbc driver manager data source name not found and no default driver specified
- Setting foreign key in phpMyAdmin
- No responses from google places text search api
- Adding to MAMP database in SQL/PHP
- I want to remove certain parent- and child-divs in all my wordpress posts with php or some other script
Related Questions in REPLICATION
- How to handle sequences in Bucardo Postgresql multi master
- percona replication -slave does not follow the master
- sql server for replication and web application
- does slave-skip-errors avoid remove errors from the logs
- MySQL Replication tables needed to be replicated is working except for 2 tables
- Cancel DELETE on MySQL REPLICATE
- How to fix jobs conflict in transactional replication
- Trigger to update a table when data in other table is updated
- Replicating Master-slave on mysql using gtid in mysql-5.6
- Where I can find MariaDB protocol document that different from MySQL
- Create Trigger does not replicate in mysql
- How to delete replication slot in postgres 9.4
- Performance/Latency when using mysql replication
- What connection string to use for Azure SQL DB using Active Geo Replication?
- how hdfs removes over-replicated blocks
Related Questions in MASTER-SLAVE
- Deployment of multiple Jenkins slaves on a Mac
- percona replication -slave does not follow the master
- does slave-skip-errors avoid remove errors from the logs
- Stm32f407IG SPI communication
- Jenkins jobs running on slaves
- Jenkins jobs configuration checking before run it
- Is it a bad idea to use a web api instead of a tcp socket for master/slave communication?
- Sync two FPGAs to generate same Sine Wave
- Is it possible to provide write permissions for slave/standby servers in postgresql in a cluster?
- Switch MySQL slave to master - BINLOG_FORMAT
- How to know the input buffer of the serial port has information, in C#?
- MySQL poor performance in Centos 7
- Build Apache Hadoop 2.5.1 in windows
- MySQL Master-Slave Replication "Unknown database" error
- Dealing with Master-Slave (MySQL) Replication Delay with Symfony2
Related Questions in AUTOMATIC-FAILOVER
- Should we have to use Failover Group server name or Primary server name in SQL Server managed instance connection string
- PostgreSQL/PostDock: Auto recovery failed in master node
- Recover connection after failover as HikariCP doesn't detect DB DNS change
- Zookeeper Leader Auto Failover
- Can i use EDB postgres failover manager without having a witness node >
- add failover in HA proxy in kubernetes
- Running Kafka cost-effectively at the expense of lower resilience
- Pacemake not failover when nginx service down
- How to update master database with data of slave database after failover in mysql
- MYSQL HA on kubernetes (vmware)
- How SailsJS connects to mysql with replication failover?
- Grails Support to Handle Datasource Failure
- How to manage failover in ZooKeeper across datacenters using observers
- How do you update TableServiceClient in ASP.NET Core, to point to a secondary region, when using Azure geo redundant (RA-GRS) table storage?
- Percona cluster automatic fail-over not working
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
What you need to do to shutdown your Master correctly is:
STOP SLAVE;For starting your system again:
START SLAVE;EDITED When you use a DB replica, it is suposed to copy from your MASTER instance to your SLAVE instance, never the other way. You shouldn't be updating your replica (SLAVE) when your MASTER get's down.
You may need to read this Mysql Switching Master to configure your system so you can make a Slave as new Master once your old Master gets down