Author

Vadim Tkachenko

Vadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. Vadim leads Percona Labs, which focuses on technology research and performance evaluations of Percona’s and third-party products. Percona Labs designs no-gimmick tests of hardware, filesystems, storage engines, and databases that surpass the standard performance and functionality scenario benchmarks.

Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. Oracle Corporation and its predecessors have incorporated Vadim’s source code patches into the mainstream MySQL and InnoDB products.

He also co-authored the book High Performance MySQL: Optimization, Backups, and Replication 3rd Edition.

Comments (9)

• Peter Laursen

  I was able to install XtraBackup on “bash in Windows” directly/natively from Ubuntus repository (“sudo apt-get install ..” or use “Synaptic” GUI softare management tool). But I haven’t tested if it works. Have you?

  If you don’t know “bash in Windows” you can start here:
  https://blog.webyog.com/how-to-add-a-gui-to-the-new-bash-console-in-windows-10/

  March 21, 2017 at 10:39 am
• Peter Laursen

  It does not seem so:

  C:\Users\jazcy>bash
  peter@SH-WIN10:/mnt/c/Users/jazcy$ xtrabackup –user=root –password=secret -host=127.0.0.1 –port=3308 –backup –target-dir=\test
  prctl() failed with errno = 22
  peter@SH-WIN10:/mnt/c/Users/jazcy$

  No diference if I install rpctl. Maybe “bash in Windows” will not be allowed to get the information from the system it needs or rpctl is simply incompatible with Windows and not translated to Windows system calls on this environment . It would be nice to avoid Docker, so if there is a solution it would be nice

  Thoughts?

  March 21, 2017 at 11:07 am
  • Vadim Tkachenko

    Peter,

    I did not try bash in Windows, but I will try to see if we can make it running

    March 21, 2017 at 5:43 pm
  • Vadim Tkachenko

    Apparently the current bash for Windows does not support prctl system call, but supposedly it will be fixed in Windows 10 Creators Edition
    https://msdn.microsoft.com/en-us/commandline/wsl/release_notes
    So hopefully it will work better then.

    March 22, 2017 at 6:44 pm
  • Vadim Tkachenko

    Peter,

    I’ve just tested in Windows 10 Creators Edition and the problem is resolved. Windows added support for prctl system call.

    April 7, 2017 at 10:39 am
• Peter Laursen

  correction. no diference if I install prctl

  March 21, 2017 at 11:36 am
• Vadim Tkachenko

  UPDATE for using percona-xtrabackup image for 2.4.11 version.

  The following parameter should be added to the command line:
  --innodb-undo-directory=/var/lib/mysql

  so the full command looks like:

  docker run --rm -it -v //C/mysqldata:/var/lib/mysql -v //C/mysqlbackup:/xtrabackup_backupfiles perconalab/percona-xtrabackup --backup --host=192.168.1.122 --user=xtrabackup --password=xtrapassword --innodb-undo-directory=/var/lib/mysql

  May 13, 2018 at 2:54 pm
• LongFly

  Is incremental backup supported?

  September 18, 2018 at 5:45 am
• Amine

  PS C:\Users\Dell> docker run –rm -it -v //C//DATA:/var/lib/mysql -v //C/mysqlbackup:/xtrabackup_backupfiles perconalab/percona-xtrabackup –backup –host=localhost –user=xtrabackup –password=xtrapassword
  Unable to find image ‘perconalab/percona-xtrabackup:latest’ locally
  C:\Program Files\Docker\Docker\Resources\bin\docker.exe: Error response from daemon: Get https://registry-1.docker.io/v2/perconalab/percona-xtrabackup/manifests/latest: unauthorized: incorrect username or password.
  See ‘C:\Program Files\Docker\Docker\Resources\bin\docker.exe run –help’.

  can you help me please

  May 31, 2019 at 3:41 am

Comments are closed.

Use Percona's Technical Forum to ask any follow-up questions on this blog topic.