Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - CentOS 6.6 running level (Linux)

- Xshell upload files to achieve Windows host Linux (Linux)

- Teach you how to protect the Linux operating system security tips (Linux)

- The Linux-based security settings Ipchains Firewall (Linux)

- Using Libreoffice under ubuntu (Linux)

- Oracle 11g to create a second instance on Linux (Database)

- Linux, how to filter, split, and merge pcap file (Linux)

- Getting Started with Linux: Learn how to install and access CentOS 7 Remote Desktop on a VPS (Server)

- Log4j configuration file Explanation (Linux)

- RedHat Linux 6.5 Enterprise Edition installation Redis 3.0.3 (Database)

- Apache Web Security Linux systems (Linux)

- Linux modify environment variables method (Linux)

- Ubuntu Gnome and Fedora 22 Gnome desktop, extended to achieve global menu (Linux)

- 10 really interesting Linux command (Linux)

- Unetbootin make use U disk loading Linux system (Linux)

- Linux Shell Scripting multithreading (Programming)

- Linux and Unix systems really do network more secure (Linux)

- Xmanager Remote Desktop login CentOS 6.5 (Linux)

- Elaborate .NET Multithreading: Thread Pool (Programming)

- Ubuntu 14.04 CodeBlocks configuration manually compile Boost 1.57.0 (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:      
 
- Java reflection summary (Programming)
- Ubuntu 14.04 forget solution root password (Linux)
- Ubuntu modify locale problem solving (Linux)
- Advanced Linux security settings (Linux)
- MySQL 5.7 can not log in problem (Database)
- Build RubyMine + Ruby On Rails + MySQL development environment under Windows (Server)
- Linux uses shared memory communication process synchronization Withdrawal (Programming)
- C ++ pointer of the (error-prone model) (Programming)
- Examples 14 grep command (Linux)
- To share Linux script automatically change passwords (Linux)
- GitLab remote backup of Linux Shell Scripting (Linux)
- What is a logical partition management LVM, how to use in Ubuntu (Linux)
- Install RAID 6 (Striping double distributed parity) (Linux)
- Java interface (Programming)
- MySQL optimization of the relevant Group By (Database)
- Android Service Lifecycle and usage (Programming)
- How to set up FTP server on Linux (Server)
- Differences Shell scripting languages and compiled languages (Programming)
- C / C ++ language variable scope: local variables, global variables, file-level variables (Programming)
- MySQL and Oracle time zone settings compare (Database)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.