Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - MongoDB replication instance (Database)

- GRUB2 boot Ubuntu Manual (Linux)

- iSCSI + multipath achieve DM multipath storage (Server)

- Taught you how to build your own VPS server (Server)

- Linux command binlog by filtering out the complete SQL statement (Database)

- Five strokes to find out the IP address you want to know (Linux)

- About Hibernate cache, you want the latest data have trouble even session.clear (Database)

- Java to create a table in the database SYBase (Database)

- Oracle capability i / o (stress test database server i / o performance) (Database)

- How to limit network bandwidth usage in Linux (Linux)

- Linux kernel log --dmesg (Linux)

- Java Access Control (Programming)

- Java coding conventions (Programming)

- Linux fast set ip bond (Linux)

- Linux Security Raiders SSH tools SCP uses examples to explain in detail (Linux)

- How to display a dialog Bash Shell script (Programming)

- Java Foundation - The relationship between abstract classes and interfaces (Programming)

- RHEL7.0 log system (Linux)

- Analysis of MySQL Dockerfile 5.6 (Database)

- CentOS 7 hard disk expansion toss record (Linux)

 
         
  MySQL master recovery from failure using binlog
     
  Add Date : 2018-11-21      
         
         
         
 

MySQL master-slave failure when the first view from the database
mysql> show slave status G;

Remember bin-log of pos and binlog file (usually selected on a point nearest to recover pos) or check the time point mysql error diary,

The mysql-binlog converted to txt, you can view each database operation

mysqlbinlog   / path /mysql-bin.000xxx  > txt1.txt

use change master to master_host = 'xxxx', master_user = 'mysync', master_password = 'q123456',

master_log_file = 'mysql-bin.xxx', master_log_pos = xxx;

key in the main library and can not find the mysql synchronization pos and pos where bin-log file.

     
         
         
         
  More:      
 
- Android graphic introduction NDK installation and simple jni demo implementation (Linux)
- CentOS7 iptables (Linux)
- Linux Man Page Installation (Linux)
- OpenGL Programming Guide (8th edition of the original book) - compute shader (Programming)
- How to display a dialog Bash Shell script (Programming)
- Virt Related Command Summary (Linux)
- CentOS 6.5 installation VNCServer implement graphical access (Server)
- Fedora 20 installation source Xen4.3.0 (Linux)
- Linux iptables: combat scenes (Linux)
- SSH mutual trust configuration (Server)
- Oracle GoldenGate tutorial Second, configure and use (Database)
- CentOS 5.8 (64) Python 2.7.5 installation error resolved (Linux)
- How to create a secure and easy to remember password (Linux)
- Win8 mount disk partitions under Ubuntu (Linux)
- CentOS 6.6 x64 Oracle Database 11gR2 RAC automated installation scripts (Database)
- Linux NIC driver and version information (Linux)
- PostgreSQL procedural language learning (Database)
- Python KNN algorithm of actual realization (Programming)
- PHP CURL get cookies simulated login (Database)
- Explore Android SQLite3 multithreading (Programming)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.