enterprise-support team mailing list archive

[Terrac Skiens <tskiens@xxxxxxxxxxx>]

Public bug reported:

MyLvmBackup seems to be picking up ALL instances in a mysql_multi
configuration

For example (porposely truncated config file)
Here's a my.cnf from mysql_multi configuration  
(running multiple mysql instances on same host, one config file)

[mysqld1]
# GENERAL #
user                           = mysql
default_storage_engine         = InnoDB
socket                         = /var/run/mysqld/mysqld.sock
pid_file                       = /var/run/mysqld/mysqld.pid
port                           = 3306
bind_address                   = 0.0.0.0
# DATA STORAGE #
datadir                        = /var/lib/mysql

[mysqld1]
# GENERAL #
user                           = mysql
default_storage_engine         = InnoDB
socket                         = /var/run/mysqld/mysqld-3305.sock
pid_file                       = /var/run/mysqld/mysqld-3305.pid
port                           = 3305
bind_address                   = 0.0.0.0
# DATA STORAGE #
datadir                        = /var/lib/mysql-restore-db


However, when I run mylvmbackup, it returns an error (although still doing the required steps to produce a backup)

mylvmbackup --configfile=/etc/mylvmbackup.conf
ERROR: datadir: /var/lib/mysql
 /opt/backup/mysql-restore-db/ is not a directory
  Logical volume "data_snapshot" created.
160829 18:18:11 mysqld_safe Logging to '/tmp/mylvmbackup_recoverserver.err'.
160829 18:18:11 mysqld_safe Starting mysqld daemon with databases from /var/tmp/mylvmbackup/mnt/backup/mysqld_safe mysqld from pid file /var/tmp/mylvmbackup_recoverserver.pid ended
backup/
backup/mysql/
backup/mysql/help_category.frm
backup/mysql/help_category.MYI
backup/mysql/help_category.MYD


I am curious how to properly setup mylvmbackup in combination with
mysql_multi - or if this is actually a bug.

** Affects: mylvmbackup
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1618169

Title:
  mylvmbackup and mysqld_multi

To manage notifications about this bug go to:
https://bugs.launchpad.net/mylvmbackup/+bug/1618169/+subscriptions