Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - Some common regular expressions (Linux)

- installation of Piwik under Ubuntu (Programming)

- Let 32 Linux / CentOS system to support more than 4G memory (Linux)

- Oracle Database ORA-01555 snapshot too old (Database)

- Use Tmux and Vim to make IDE (Linux)

- UUID in Java (Programming)

- Linux environment variable settings methods and differences (Linux)

- Lucene Getting Started Tutorial (Server)

- Security: set limits on password (Linux)

- Role Object of registerNatives () method (Programming)

- Puppet centralized configuration management system (Server)

- C ++ based socket communication TCP and UDP (Programming)

- Linux System Getting Started Tutorial: Installing Brother printer in Linux (Linux)

- MySQL EXPLAIN SQL output description (Database)

- Phoenix agents use P2P WebRTC development (Programming)

- Installation Yarock 1.1.4 Music Player in Ubuntu (Linux)

- wget command examples (Linux)

- Ubuntu 12.04 64-bit installation Redmine + Git + ReviewBoard (Linux)

- CentOS 6.5 can not connect to the network under VMware (Linux)

- How to enhance the security of Linux systems (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:      
 
- Spring AOP (Programming)
- Executable file format Explanation under Linux (Linux)
- Five kinds of IO Model under Linux (Programming)
- Hard disk encryption to protect data security (Linux)
- How to add any of a Linux distribution beautiful fonts (Linux)
- Linux non-graphical interface to install Oracle Database (Database)
- To compile and install Redis Linux and master-slave replication configuration (Database)
- Making Linux root file system problems on-link library (Programming)
- To obtain installation package (RPM) under RHEL6 (Linux)
- To install PXE + Kickstart under CentOS 6.x operating system (Linux)
- Redmine Installation (Linux)
- With screenfetch linux logo and basic hardware information display with cool Linux logo (Linux)
- Analysis of Java keyword final (Programming)
- Java Virtual Machine Basics (Programming)
- The top command under Linux (Linux)
- Oracle 11g on Linux system boot from the startup settings (Database)
- Linux Command - ps: a snapshot of the current process (Linux)
- Php and MySQL command add to the environment variable method in Linux system (Linux)
- Android LayoutInflater source parsing (Programming)
- Nginx version of helloworld (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.