Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ innodb storage engine backup tool --Xtrabackup     - You need to know 12 Git High Command (Linux)

- SecureCRT session buffer size settings (Linux)

- Nginx reverse proxy and self-signed https (Server)

- Yii PHP Framework Getting Started tutorial (Linux)

- Three kinds of implementation model of the Linux thread history (Programming)

- MySQL Authorized a recovered (Database)

- How to prevent page five invisible killer (Linux)

- MySQL + Corosync + Pacemaker + DRBD build highly available MySQL (Server)

- Debian SSD ext4 4K aligned (Linux)

- Install FFmpeg compiling from source in Mac OS X environment (Linux)

- Linux system security configuration (Linux)

- Shell Programming points to note about the function (Programming)

- Install the free open source financial software GnuCash 2.6.6 under Ubuntu (Linux)

- CentOS 5.x install Lua 5.2.3 error (LIBS = -lncurses) (Linux)

- File compression and packaging commands under Linux (Linux)

- Overall Physical Migration of Oracle Database with (Database)

- C ++ Fundamentals study notes (Programming)

- Vim custom color (Linux)

- Getting Started with Linux system to learn: How to compress JPEG images on the command line (Linux)

- Use Linux built-in firewall to improve network access control (Linux)

 
         
  innodb storage engine backup tool --Xtrabackup
     
  Add Date : 2018-11-21      
         
         
         
  Xtrabackup do with InnoDB is a data backup tool that supports online hot backups (backups do not affect the data when reading and writing), is a commercial backup tools InnoDB Hotbackup a good substitute.

Xtrabackup There are two main tools: xtrabackup, innobackupex

(1) xtrabackup only back up InnoDB and XtraDB two data tables, and can not back up MyISAM tables

(2) innobackupex-1.5.1 is encapsulated xtrabackup, is a script package, it is possible to simultaneously backup processing innodb and myisam, but when dealing with myisam need to add a read lock

./innobackupex --defaults-file = / etc / my.cnf --user = root --password = 123 --socket = / tmp / mysql.sock3 / tmp /

5.7 does not support it

[Root @ MyO bin] # ./innobackupex --defaults-file = / etc / my.cnf --user = root --password = 123 --socket = / tmp / mysql.sock / tmp /

151230 10:01:39 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.
          At the end of a successful backup run innobackupex
          prints "completed OK!".

151230 10:01:39 version_check Connecting to MySQL server with DSN 'dbi: mysql:; mysql_read_default_group = xtrabackup; port = 3300; mysql_socket = / tmp / mysql.sock' as 'root' (using password: YES).
151230 10:01:39 version_check Connected to MySQL server
151230 10:01:39 version_check Executing a version check against the server ...
151230 10:01:39 version_check Done.
151230 10:01:39 Connecting to MySQL server host: localhost, user: root, password: set, port: 3300, socket: /tmp/mysql.sock
Error: Unsupported server version: '5.7.9-log' Please report a bug at https://bugs.launchpad.net/percona-xtrabackup.
 
[Root @ MyO bin] # ./innobackupex --defaults-file = / etc / my.cnf --user = root --password = 123 --socket = / tmp / mysql.sock3 / backup /
151230 10:07:33 innobackupex: Starting the backup operation


IMPORTANT: Please check that the backup run completes successfully.
          At the end of a successful backup run innobackupex
          prints "completed OK!".


151230 10:07:34 version_check Connecting to MySQL server with DSN 'dbi: mysql:; mysql_read_default_group = xtrabackup; port = 3300; mysql_socket = / tmp / mysql.sock3' as 'root' (using password: YES).
151230 10:07:34 version_check Connected to MySQL server
151230 10:07:34 version_check Executing a version check against the server ...
151230 10:07:34 version_check Done.
151230 10:07:34 Connecting to MySQL server host: localhost, user: root, password: set, port: 3300, socket: /tmp/mysql.sock3
Using server version 5.6.27-log
Error: option 'datadir' has different values:
  '/ Data / mysql_data' in defaults file
  '/ Data3 /' in SHOW VARIABLES
     
         
         
         
  More:      
 
- Use JMS listener Oracle AQ, trigger the execution of Java programs in the database changes (Database)
- The Java way to stop a thread of execution (Programming)
- Linux and Unix systems really do network more secure (Linux)
- PHP CURL get cookies simulated login (Database)
- Docker build private warehouse (Server)
- 10 Linux in the passwd command examples (Linux)
- Understand ASP.NET 5 running the command: DNVM, DNX, and DNU (Server)
- RedHat Redis Linux installation (Database)
- Using Linux command line and execute PHP code (Programming)
- top command causes the system load increases (Linux)
- Introduction and bash history command to quickly call (Linux)
- Ubuntu firewall installation and configuration (Linux)
- Udev: Device Manager for Linux Fundamentals (Linux)
- MogileFS system installation configuration example (Server)
- Novice Advanced Ubuntu7.10 configured IP address (Linux)
- Spring-depth understanding of the various annotations (Programming)
- RedHat / CentOS ext4 partition can not be formatted large supplementary ext4 formatting (Linux)
- Use window.name + iframe cross-domain access to data Detailed (Programming)
- Java annotations entry automatically generates SQL statements (Programming)
- Can not empty the Recycle Bin to repair problems in Ubuntu 14.04 (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.