Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - DM9000 bare Driver Design (Programming)

- Disk storage structure and file recovery experiment (FAT file system) (Linux)

- Zabbix installation under Linux (Server)

- To install Samba server on CentOS 6.6 (Server)

- iOS development -Launch Image and Launchscreen (Programming)

- SSH automatic disconnection problem solving (Linux)

- Zookeeper Rights Management and Quota Management (Server)

- Repair CentOS 6.4 Grub boot (Linux)

- Raspberry Pi 2 to install the latest version of the FPC and Lazarus 1.5 (Linux)

- C # using the HttpClient Note: Preheat the long connection (Programming)

- Ubuntu 14.04 jdk Installation and Configuration (Linux)

- pscp use Detailed Windows and Linux each file transfer tool (Linux)

- Amazon EC2 server using Rsync + Inotify real-time synchronization (Server)

- Oracle Database Delete Delete million or more common method of heap table data (Database)

- openSUSE 13.1 / 13.2 installation SoundConverter 2.1.2 (Linux)

- MongoDB replication instance (Database)

- Varnish configuration language VCL and its built-in variables (Server)

- Elaborate .NET Multithreading: Thread Pool (Programming)

- Add your own kernel and ramfs based on an existing Linux LiveCD (Linux)

- Linux, security encryption to transfer files between machines (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:      
 
- Extended use of the swap file swap space on Linux (Linux)
- VMware Workstation virtual machine Ubuntu achieve shared with the host (Linux)
- Ubuntu amend resolv.conf restart failure problem (Linux)
- ORA-30926 and MERGE tables empty the temporary occupation problem (Database)
- iostat command Detailed (Linux)
- CentOS 7.0 running Docker kernel error solution (Server)
- Elasticsearch 2.20 Beginners: aggregation (Server)
- linux network security experience (Linux)
- shell script: the number of characters in the text to print no more than 6 words (Programming)
- Simple to install Tor browser to Ubuntu 14.04 and Linux Mint 17 (Linux)
- How to install Ubuntu California - the calendar application (Linux)
- Linux Network Programming - raw socket instance: MAC Address Scanner (Programming)
- C ++ Supplements - malloc free and new delete the same and different (Programming)
- To build Spring RestTemplate use HttpClient4 (Programming)
- Java objects are taking up much space (Programming)
- Linux rename command usage in learning to modify the file name (Linux)
- Print Linux system error codes (Linux)
- Autojump: an advanced cd command in the Linux file system fast navigation (Linux)
- Present Situation and Development Trend of firewall products (Linux)
- CentOS card fails to start at boot progress bar certmonger solve (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.