Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - Virtualbox virtual machine can not copy CentOS Network (Linux)

- Manually generate AWR reports (Database)

- Shell programming entry (Programming)

- 10046 trace only open for a particular SQL statement (Database)

- VMware virtual machine to install CentOS 7 (Linux)

- Mutt - an email client that sends messages through the terminal (Linux)

- Changes in C # asynchronous programming model (Programming)

- Is Linux the most secure operating system (Linux)

- Go constructed using an interpreted language (Programming)

- Python implementation Bursa transition model (Programming)

- iptables using summary (Linux)

- Analysis: Little Notebook facing a major security threat secure online (Linux)

- RabbitMQ tutorial examples: RabbitMQ installation under Windows (Linux)

- Linux character device - a simple character device model (Linux)

- Single list summarizes the basic operation (Programming)

- Getting Started with Linux system to learn: how to check in a package is installed on Ubuntu (Linux)

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

- Static member variable modified (Programming)

- Linux package management (Linux)

- Configuring Haproxy log support (syslog logging support) (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:      
 
- How to set cache valid time in Apache (Server)
- Ubuntu Tutorial - Manually install Oracle Java JDK 8 (Linux)
- Oracle 11gr2 new APPEND_VALUES tips (Database)
- ASM learning overview (Database)
- awk pattern matching (Programming)
- To build PHP environment (Nginx + MariaDB + PHP7) under CentOS 6.5 (Server)
- How to use systemd timer (Linux)
- Linux common network tools: ping host sweep (Linux)
- Linux systems use IP masquerading anti-hacker (Linux)
- Sturdy build secure Linux server (Linux)
- Let your PHP 7 faster the Hugepage (Linux)
- Java eight new features 8 (Programming)
- Ubuntu 14.04 and derivative version of the user on how to install cURL 7.37.1 (Linux)
- MongoDB Installation under CentOS 6.6 (Database)
- Not safe procedure under Linux (Linux)
- Intrusion prevention network server security maintenance tips (Linux)
- Why you should choose Python Programming (Programming)
- CentOS permanently banned from running in the background PackageKit (Linux)
- Linux Getting Started tutorial: hard disk partition and to deal with traps (Linux)
- How linux network security configuration (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.