Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - Java abstract class instantiation (Programming)

- extundelete: the Linux-based open source data recovery tools (Linux)

- Ubuntu and derivatives installation Atom 0.104.0 (Linux)

- Upgrading to Debian 7.6 glibc 2.15 (Linux)

- Linux in order to make NMAP hide and seek with the firewall (Linux)

- Linux systems for entry-learning: Install closed-source packages in Debian (Linux)

- RCU lock in the evolution of the Linux kernel (Linux)

- Android View event delivery (Programming)

- Openfire achieve load balancing cluster by Nginx (Server)

- Integrated security administrator Linux accident management (Linux)

- Linux Security Module (LSM) Introduction (Linux)

- Executable file format Explanation under Linux (Linux)

- Do you know how to build the Linux kernel (Programming)

- Linux input and output redirection (Linux)

- C ++ virtual functions Classic Insights (Programming)

- C ++ you can become a new scripting language (Programming)

- Nginx introduced Dynamic Module Architecture (Server)

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

- MongoDB version 3.2 WiredTiger storage engine performance tests (Database)

- JBPM6 Tutorial - taught you how to install JBPM (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:      
 
- RPM package management under Linux (Linux)
- Seven kinds of NIC binding mode Detail (Linux)
- How to configure SNMPv3 on Ubuntu, CentOS and Cisco systems (Linux)
- 256 with rich colors decorate your terminal (Linux)
- Let 32 Linux / CentOS system to support more than 4G memory (Linux)
- Intrusion prevention network server security maintenance tips (Linux)
- Oracle 11g statistics collection - collection of multi-column statistics (Database)
- Asynchronous JavaScript loading (Programming)
- Linux Network Programming - non-blocking program (Programming)
- MySQL script incremental backups (innobackupex) (Database)
- Git Experience Sharing - Using a remote repository (Linux)
- Expand an existing RAID arrays and remove the failed disk in a RAID (Linux)
- CentOS6.5 installation Docker (Linux)
- Open MySQL slow query log (Database)
- Linux Man Page Installation (Linux)
- JSON Introduction and Usage Summary (Programming)
- Linux iptables: basic principles and rules (Linux)
- TypeScript basic grammar (Programming)
- wget command examples (Linux)
- Using PHP MySQL library (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.