Not the answer you need?
Register and ask your own question!

innobackupex

gozigomilisgozigomilis EntrantInactive User Role Beginner
Dear all,

I have server A and B .
server A I install "Percona-Server 55-5.5.27".

I want to full backup database on server B (/var/lib/mysql) with command this below

/usr/bin/innobackupex --parallel=4 --host=${IP_SERVER_B} --user=dbuser--password=dbpassword--no-timestamp /home/percona/innobackup/2012-10-15

After full backup is finish, I check dir "/home/percona/innobackup/2012-10-15" is not backup dir /var/lib/mysql on server B. But it's backup /var/lib/mysql on server A.

why this could happen, but I've replaced --host=${IP_SERVER_B} by ip address server B

Thank You

Moses

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi Moses,

    What you are trying to do, won't work with --host option. For your purpose, I guess you should use streaming backup. As per your scenario, if you want to take backup of B server and transfer it to A server, you should run backup command on B server with --stream/xbstream option to transfer it to A server. (rather then running backup on A server)

    You can get more information here.
    http://www.percona.com/doc/percona-xtrabackup/howtos/recipes _ibkx_stream.html
  • gozigomilisgozigomilis Entrant Inactive User Role Beginner
    Hi niljoshi,

    IP SERVER A : 192.168.0.121

    IP SERVER B : 192.168.0.140

    I Run command on server B

    [[email protected] ~]# innobackupex --host=localhost --user=myuser --password=mypassword --stream=tar ./ | ssh -q [EMAIL="root@192.168.0.121"][email protected][/EMAIL] "cat - > /tmp/test/backup.tar"

    My Questios is :

    1. Whether during the backup process will use temporary storage on server B?
    2. If i check ,the command above is full backup. if the above command already include function "apply-log"?

    Thank You
  • gozigomilisgozigomilis Entrant Inactive User Role Beginner
    Dear Team Percona,


    I try to install percona on centos 6.3 (64 bit)

    [[email protected] mysql]# rpm -aq | grep Percona-*
    Percona-Server-server-55-5.5.30-rel30.1.465.rhel6.x86_64
    Percona-Server-client-55-5.5.30-rel30.1.465.rhel6.x86_64
    Percona-Server-shared-compat-5.5.30-rel30.1.465.rhel6.x86_64
    Percona-Server-devel-55-5.5.30-rel30.1.465.rhel6.x86_64
    Percona-Server-shared-55-5.5.30-rel30.1.465.rhel6.x86_64
    Percona-Server-test-55-5.5.30-rel30.1.465.rhel6.x86_64

    I didn't find default configuration on /etc/my.cnf but after i start service mysql can running well

    [[email protected] mysql]# /etc/init.d/mysql start
    Starting MySQL (Percona Server).. SUCCESS!

    I try to generate conguration my.cnf using wizard and copy to dir /etc/my.cnf. After i restart the service mysql, i found error like this bellow

    [[email protected] mysql]# /etc/init.d/mysql start
    Starting MySQL (Percona Server).. ERROR! The server quit without updating PID file (/var/lib/mysql/wom-moses.pid).

    How to solve this problem?

    I put my.cnf on attachment generate from wizard web percona.
    Thanks
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.