Re: [codership-team] Help Setting Up Xtrabackup SST

[seppo....@codership.com]

wsrep_sst_xtrabackup script was added in "wsrep development
repository" quite recently. It is not yet in any of Galera Cluster
builds, but it will be present in next build. If you can make source
builds, you can get it right away.

xtrabackup script has been in the Percona XtraDB Cluster releases for
quite some time.

-seppo

Quoting Shalom Levytam <slev...@gmail.com>:

> Hello,
>
> I have recently begun the setup of a Galera cluster and wanted to use
> xtrabackup for its non-blocking sync feature.
>
> Galera was installed using:
> - MySQL-server-5.5.23_wsrep_23.6-1.rhel5.x86_64.rpm
> - galera-23.2.2rc1-1.rhel5.x86_64.rpm
> - MySQL-5.5/MySQL-shared-compat-5.5.23-1.rhel5.x86_64.rpm
> - MySQL-5.5/MySQL-client-5.5.23-1.rhel5.x86_64.rpm
>
> Xtrabackup was installed using:
> - wget
> http://www.percona.com/redir/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
> - rpm -Uvh percona-release-0.0-1.x86_64.rpm
> - yum install xtrabackup --nogpgcheck
>
> When attempting to join a second node I get the following:
>
> 121019 5:56:11 [Warning] WSREP: Gap in state sequence. Need state transfer.
> 121019 5:56:13 [Note] WSREP: Running: 'wsrep_sst_xtrabackup 'joiner'
> '192.168.168.169' 'root:password' '/var/lib/mysql/' '/etc/mysql/wsrep.cnf'
> '11824' 2>sst.err'
> 121019 5:56:13 [ERROR] WSREP: Failed to read 'ready <addr>' from:
> wsrep_sst_xtrabackup 'joiner' '192.168.168.169' 'root:password'
> '/var/lib/mysql/' '/etc/mysql/wsrep.cnf' '11824' 2>sst.err
> Read: '(null)'
> 121019 5:56:13 [ERROR] WSREP: Process completed with error:
> wsrep_sst_xtrabackup 'joiner' '192.168.168.169' 'root:password'
> '/var/lib/mysql/' '/etc/mysql/wsrep.cnf' '11824' 2>sst.err: 2 (No such file
> or directory)
> 121019 5:56:13 [ERROR] WSREP: Failed to prepare for 'xtrabackup' SST.
> Unrecoverable.
> 121019 5:56:13 [ERROR] Aborting
>
> This is the message in sst.err:
>
> sh: wsrep_sst_xtrabackup: command not found
>
> If anyone could assist, I would greatly appreciate it...
>
> slevytam
>
> --

[Haris Zukanovic]

Hi,

Does this mean that xtrabackup can be used wih Galera running on
"normal" mysql server.
I though it was only possible to use it with Galera running on Percona
XtraDB server?

Haris

--
--
Haris Zukanovic

[Henrik Ingo]

It means it will be possible in a future "Codership Galera" release
(ie based on Oracle MySQL), but until now it has only been present in
Percona XtraDB Cluster.

henrik

> --
>
>



--
henri...@avoinelama.fi
+358-40-8211286 skype: henrik.ingo irc: hingo
www.openlife.cc

My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559

[Shalom Levytam]

Thanks for your reply!

I would definitely give compiling a try, I'm just unclear as to whether I should be compiling just: http://bazaar.launchpad.net/~codership/wsrep/trunk/files  Or, whether I would need to compile all of: http://bazaar.launchpad.net/~codership/galera/2.x/files

Also, I had a look at wsrep_api.h in both and was unable to find a mention of wsrep_sst_xtrabackup.  Am I looking in the right place? 

Pardon my newbieness...  (any links to tutorials/faqs would be great).

[Vadim Tkachenko]

Shalom,

I will go with a shameless advertisement, by why not just go ahead and download Percona XtraDB Cluster with xtrabackup SST

instead of figuring out what to compile ?

--
 
 

--
Vadim Tkachenko, CTO, Percona Inc.
Phone +1-925-400-7377,  Skype: vadimtk153
Schedule meeting: http://tungle.me/VadimTkachenko

Looking for Replication with Data Consistency?
Try Percona XtraDB Cluster!

[Shalom Levytam]

It's primarily that I don't really feel comfortable changing so much in my site's setup at once.  I only have two days to finish this cluster.

If I can just compile Galera or Wsrep without changing anything else, that would be ideal.  I'm just not sure whether compiling either of those two links I posted earlier is correct as I haven't been able to find the wsrep_sst_xtrabackup script in the source.

Thanks and I will definitely take a closer look at Percona.

[Freejack]

We were originally running codership's version of Mysql 5.5 but installed Percona 5.5 for xtrabackup functionality.  Been running without a hitch.  xtrabackup is so much faster than rsync and mysqldump and does not block in most cases so you can do a full SST without any downtime to your primary node.  We've done this several times already.

[Alex Yurchenko]

Hi

1) I would second Vadim's suggestion

2) xtrabackup SST will be included in the next MySQL-wsrep release. For
the impatient:

http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/download/3782/wsrep_sst_xtrabackup-20120827055340-1xdl88v3duvonkwy-1/wsrep_sst_xtrabackup.sh

3) for this thing to work you will need xtrabackup > 2.0.0

Regards,
Alex

On 2012-10-19 22:46, Vadim Tkachenko wrote:
> Shalom,
>
> I will go with a shameless advertisement, by why not just go ahead
> and
> download Percona XtraDB Cluster with xtrabackup SST
> instead of figuring out what to compile ?
>
> On Fri, Oct 19, 2012 at 12:42 PM, Shalom Levytam <slev...@gmail.com>
> wrote:
>
>> Thanks for your reply!
>>
>> I would definitely give compiling a try, I'm just unclear as to
>> whether I
>> should be compiling just:
>> http://bazaar.launchpad.net/~codership/wsrep/trunk/files

Just in case - that one. Galera is not responsible for provisioning of
new nodes, it only replicates opaque buffers.

>> Or, whether I
>> would need to compile all of:
>> http://bazaar.launchpad.net/~codership/galera/2.x/files
>>
>> Also, I had a look at wsrep_api.h in both and was unable to find a
>> mention
>> of wsrep_sst_xtrabackup. Am I looking in the right place?
>>
>> Pardon my newbieness... (any links to tutorials/faqs would be
>> great).
>>
>> --
>>
>>
>>
>
>
>
> --
> Vadim Tkachenko, CTO, Percona Inc.
> Phone +1-925-400-7377, Skype: vadimtk153
> Schedule meeting: http://tungle.me/VadimTkachenko
>
> Looking for Replication with Data Consistency?
> Try Percona XtraDB Cluster!

--
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011