• Percona XtraBackup介绍


    Percona XtraBackup开源的、免费的mysql热备软件,可以执行无阻塞备份InnoDB和XtraDB数据库。

    Percona XtraBackup有以下优点:

    ·备份快速、可靠 ·备份期间,不影响事务连续性

    ·节省磁盘空间和网络带宽

    ·自动验证备份

    ·快速还原,降低系统停机时间

    Percona XtraBackup支持Percona Server, MySQL, 和MariaDB所有版本的热备。支持流、压缩和增量mysql备份。

    Percona XtraBackup的一些特性:

    ·创建innodb的hot备份,不需要停数据库

    ·增量备份mysql

    ·支持流压缩,将mysql并备份到其他服务器上

    ·在不同mysql服务器上,在线移动表

    ·易于创建mysql复制slaves

    ·备份mysql时,不会增加负载

    Percona XtraBackup包含以下工具:

    ·innobackupex : 提供了一个脚本集合,可以备份整个mysql数据库实例(包含myisam、innodb和xtradb表的数据库)。

    ·xtrabackup : 编译过的c二进制文件,只能copy innodb和xtradb的数据

    ·xbcrypt : 加密和解密备份文件

    ·xbstream : 支持stream和文件抽取的工具(以xbstream格式抽取)

    Percona XtraBackup和MySQL Enterprise Backup特性比较

    FeaturesPercona XtraBackupMySQL Enterprise Backup (InnoDB Hot Backup)
    License GPL Proprietary
    Price Free $5000 per server
    Open source Yes  
    Streaming and encryption formats Open source Proprietary
    Supported MySQL flavors Percona Server, MySQL, MariaDB MySQL
    Non-blocking InnoDB backups [1] Yes Yes
    Blocking MyISAM backups Yes Yes
    Incremental backups Yes Yes
    Full compressed backups Yes Yes
    Incremental compressed backups Yes  
    Fast incremental backups [2] Yes  
    Incremental backups with archived logs Yes  
    Encrypted backups Yes Yes [3]
    Streaming backups Yes Yes
    Parallel local backups Yes Yes
    Parallel streaming backups Yes  
    Parallel compression Yes Yes
    Parallel encryption Yes Yes
    Parallel apply-log Yes  
    Parallel copy-back   Yes
    Partial backups Yes Yes
    Throttling [4] Yes Yes
    Point-in-time recovery support Yes Yes
    Safe slave backups Yes  
    Compact backups [5] Yes Yes
    Buffer pool state backups Yes  
    Individual tables export Yes Yes [6]
    Individual partitions export Yes  
    Restoring tables to a different server [7] Yes Yes
    Data & index file statistics Yes  
    InnoDB secondary indexes defragmentation Yes  
    rsync support to minimize lock time Yes  
    Improved FTWRL handling Yes  
    Backup history table   Yes
    Backup progress table   Yes
    Offline backups   Yes
    Tape backups with Oracle Secure Backup   Yes
  • 相关阅读:
    互联网协议
    TCP/IP协议三次握手_四次挥手
    nginx重定向rewrite
    创建第一个django工程
    Anaconda-用conda创建python虚拟环境
    数组
    StringBuilder
    杨辉三角
    数据类型和变量
    .net框架中的一些接口
  • 原文地址:https://www.cnblogs.com/abclife/p/4615192.html
Copyright © 2020-2023  润新知