› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
Livid
396.81D
539.34D
V2EX  ›  MySQL

Build latest xtrabackup on Mac OS X

  •  
  •   Livid ·
    PRO
    · May 24, 2014 · 8903 views
    This topic created in 4512 days ago, the information mentioned may be changed or developed.
    Since Percona doesn't provide recent builds of xtrabackup for OS X, I decided to try to build my own. It turned out to be pretty easy once you have all the tools needed.

    Things you will need:

    Xcode, Command Line Tools, Homebrew

    Steps:

    1. brew install libgcrypt , you may need to `ln -s 1.13 1.12` under /usr/local/Cellar/libgpg-error if you saw libgpg-error related error during build.

    2. Get latest source code of xtrabackup from:

    http://www.percona.com/downloads/XtraBackup/LATEST/source/

    3. tar zxvf percona-xtrabackup-2.1.9.tar.gz and run:

    AUTO_DOWNLOAD="yes" ./utils/build.sh innodb55

    If you need other support than InnoDB 5.5, please look into docs here:

    http://www.percona.com/doc/percona-xtrabackup/2.1/installation/compiling_xtrabackup.html

    4. Copy innobackupex / xtrabackup_55 / xbstream from ./ and ./src/ to /usr/local/bin/

    You can download my compiled binaries here:

    http://static.v2ex.com/xtrabackup/osx/
    5 replies  •  2014-05-26 13:36:04 +08:00
    julyclyde
        1
    julyclyde  
       May 24, 2014
    你现在用os x做mysql服务器了?
    caonan
        2
    caonan  
       May 24, 2014
    @julyclyde V站现在跑在一台垃圾桶里。
    Livid
        3
    Livid  
    MOD
    OP
    PRO
       May 25, 2014
    @julyclyde 有的时候,为了试验,把 OS X 上的数据库备份后导入 Vagrant 也会需要这个工具。
    lm902
        4
    lm902  
       May 25, 2014
    @Livid 为何不直接复制数据
    time | cp /path/to/mysql/data/file
    julyclyde
        5
    julyclyde  
       May 26, 2014
    @lm902 你那样得关闭数据库服务才能安全复制
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   846 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 19:47 · PVG 03:47 · LAX 12:47 · JFK 15:47
    ♥ Do have faith in what you're doing.