Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - Debian (Wheezy) Install Redmine 2.6 (Programming)

- Understand the profound discussion of some of the options for wireless encryption (Linux)

- Bad name two variables (Linux)

- The Oracle VM VirtualBox use U disk under ubuntu (Linux)

- CentOS6 install Redis (Database)

- CentOS install SystemTap-2.6 (Linux)

- To install PXE + Kickstart under CentOS 6.x operating system (Linux)

- pga_aggregate_target and _pga_max_size can not use absolute limit actual PGA (Database)

- using the ssh command to check the socket / Network Connections (Linux)

- The Linux disguised as windows to make the system more secure (Linux)

- Security of data to create a safe .mdb database (Linux)

- Linux security settings (Linux)

- J2EE Example of Filter (Programming)

- Articles do not resolve after opening under Ubuntu WordPress setting a fixed link (Server)

- Ubuntu install driver manager Mint Driver Manager and Device Driver Manager (Linux)

- Git large file storage will help handle large binary files (Linux)

- MongoDB slice simple example (Database)

- Git delete files (Linux)

- How to use Aptik to backup and restore Apps/PPAs under ubuntu (Linux)

- Tmux Getting Start (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:      
 
- Linux performance monitoring - CPU, Memory, IO, Network (Linux)
- Ubuntu install Tonido private cloud services (Server)
- Close common port to protect server security (Linux)
- MySQL 5.6 database code changes (Database)
- Ubuntu 14.04 installed NVIDIA graphics driver (Linux)
- SSH configuration under Linux (Linux)
- Git 2.5 increase in the working tree, triangle improved workflow performance (Linux)
- Source code is installed MySQL 5.6.28 (Database)
- Linux environment Duplex (multi-machine) automatic mutual backup scheme (Linux)
- How to allow users to access only a specific database (MSSQL) (Database)
- PLSQL Developer synchronization table tools (Database)
- How to merge two pictures in Cacti (Linux)
- Use web2py + uWSGI + Nginx Web server built on Linux (Server)
- xCAT install and update software (Linux)
- Linux installed and tested the deployment of Kafka distributed cluster (Server)
- Summary Linux operating system some tips to prevent attacks (Linux)
- CentOS 6.4 installation environment to build Scrapy 0.22 (Linux)
- MySQL password on those things you should know (Database)
- Java generate two-dimensional code by Zxing (Programming)
- Struts2 form of non-use component tags (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.