Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - Create several practical points of high security PHP site (Linux)

- Ubuntu install Geary (Linux)

- OGG-01496 OGG-01031 Error Resolution (Database)

- Create, modify, delete users, user groups under linux (Linux)

- The script Linux command (Linux)

- IIS virtual host of safety knowledge (Linux)

- To remove those IP is prohibited Fail2ban on CentOS 6/7 (Server)

- Java-- get the reflection object information (Programming)

- ORA-08102 errors (Database)

- IPTABLES configuration steps under Linux (Linux)

- Remote database using RMAN recovery test (RAC return to single-instance database) (Database)

- To install JDK1.7 and compiler Hadoop-2.7.1 under CentOS7 (Server)

- How to enable Software Collections (SCL) on CentOS (Server)

- C language macro definition #define Usage (Programming)

- Linux installation is larger than 2TB (UEFI interface) hard disk solution (Linux)

- Talk about Java in the collection (Programming)

- The most commonly used Linux commands (Linux)

- Five useful commands to manage file types and system time in linux (Linux)

- Slice MyCAT common fragmentation rules of enumeration (Database)

- Linux SVN installation and configuration graphic tutorials (Server)

 
         
  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:      
 
- Oracle 11g R2 RAC RMAN backup script example (Database)
- Android recyclerview cardview (Programming)
- Source MongoDB 3.2.1 installed on CentOS6.5 (Database)
- Practical Handbook: 130+ improve the efficiency of commonly used commands Vim (Linux)
- Java Concurrency - processes and threads (Programming)
- systemd-nspawn Quick Guide (Linux)
- Iptables in Ubuntu (Linux)
- Modify MySQL character encoding under Linux (Database)
- Network Security Basics Linux command (Linux)
- Hadoop 2.7.1 installation configuration based on availability QJM (Server)
- xCAT install and update software (Linux)
- Linux based exercises, interview questions (Linux)
- 10 Nginx safety tips (Linux)
- Ubuntu dual-card system configuration method (Server)
- SVN common commands (Linux)
- Linux System Getting Started Learning: DeVeDe installed on Linux to create a video DVD (Linux)
- C # DateTime structure common method (Programming)
- ActiveMQ-based shared file system HA solutions (Server)
- Wildcards and special symbols usage comments under Linux (Linux)
- Log4cplus logging facility configuration, installation, testing (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.