Announcement

Announcement Module
Collapse
No announcement yet.

Problems with SST

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems with SST

    Hi,

    I upgraded one node to the new version of XtraDB Cluster and because of this the node now tries to get a SST from a donor.
    Everything seems working smoothly (the donor doesn't report any errors and I can see the pipe with the xtrabackup-data with ps -Al).
    But it seems, that xtrabackup on the node which receives the the SST doesn't can work the data.
    innobackup.prepare.log says:

    InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona Inc 2009-2012. All Rights Reserved.xtrabackup: Error: Please set parameter 'datadir'innobackupex: fatal error: no 'mysqld' group in MySQL optionsinnobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options


    In /etc/mysql/my.cnf I have:

    [mysqld]datadir=/var/lib/mysqltmpdir=/tmpuser=mysql

    and of course many other options, but nothing overwrites these...

    I have no idea how to set the datadir-option for innobackupex.

    Thanks in advance!

  • #2
    You should have something like that in your node error log:

    120529 23:23:46 [Note] WSREP: Running: 'wsrep_sst_xtrabackup 'joiner' '192.168.0.3:3303' 'root:rootpass' '/tmp/galera2/mysql/var/' '/etc/my.cnf' '4693' 2>sst.err'

    Check that my.cnf path (5th argument) points to the right file.

    Comment


    • #3
      Thanks so much!!!
      The default config in the debian-package uses the /etc/mysql/conf.d/percona.cnf not the /etc/mysql/my.cnf
      After adding the datadir-param in this file everything works smoothly!

      Comment

      Working...
      X