Events Calendar

«
<
September 2010
>
»
M T W T F S S
30 31 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 1 2 3

Select Language

Quick start Data Protector for MySQL PDF Print E-mail
Written by Tomas Dalebjörk   
Thursday, 26 March 2009 10:19

Quick Start Guide

for 

Data Protector for MySQL

using IBM Tivoli Storage Manager

 

 Linux

MySQL server

Install the MySQL server binaries

download

# rpm -i XX

TSM Client

Install the Tivoli Storage Manager (Backup Archive Client)

download

# rpm -i XXX

Install the Data Protector for MySQL

download 

# rpm -i XXX 

Configure the TSM server

Setup the copygroups, policysets, domains, and retention times.

Create the backup schedule

# dsmadmc

tsmserv>define domain mysql
tsmserv>define policyset mysql standard
tsmserv>define mgmt mysql standard 30days
tsmserv>def co mysql standard 30days dest=backuppool verd=nol vere=nol reto=30 rete=30
tsmserv>def co mysql standard 30days dest=backuppool retv=30 t=a
tsmserv>assign defmgmt mysql standard 30days
tsmserv>validate policyset mysql standard
tsmserv>activate policyset mysql standard
tsmserv>register node mysql secret domain=mysql
tsmserv>def sched mysql full action=command objects="/usr/local/bin/backup.sh" startt=21:00 startd=today dur=2 duru=hour
tsmserv>define assoc mysql full mysql 

Configure the TSM client

Filesystem setup

# vi /opt/tivoli/tsm/client/ba/bin/dsm.opt

SE filesystem

 # vi /opt/tivoli/tsm/client/ba/bin/dsm.sys

 

SE filesystem

TCPSERVERADDRESS 10.11.12.13

SCHEDLOGNAME /var/log/dsmsched.log

ERRORLOGNAME /var/log/dsmerror.log

PASSWORDACCESS generate

 

SE mysql

TCPSERVERADDRESS 10.11.12.13

SCHEDLOGNAME /var/log/dsmsched_mysql.log

ERRORLOGNAME /var/log/dsmerror_mysql.log

PASSWORDACCESS generate

NODENAME mysql
 
# ln -s /opt/tivol/tsm/client/ba/bin/dsm.sys /opt/tivoli/tsm/client/api/bin/dsm.sys
# vi /opt/tivoli/tsm/client/ba/bin/dsm.opt

SE filesystem

 
Try a connectivity test to the TSM server
 
# dsmc -se=mysql 
 
Create the backup scripts
 
# vi /usr/local/bin/backup.sh

#!/bin/bash

export PATH=$PATH:/opt/repostor/rdp4MySQL/bin

mysqlbackup -v -a >> /var/log/mysqlbackup.log 2>&1

 
# chmod a+x /usr/local/bin/backup.sh
 
Try to do a backup
 
# /usr/local/bin/backup.sh
 
Create the scheduler startup
# vi /etc/init.d/tsmmys

#!/bin/bash

export PATH=$PATH:/opt/repostor/rdp4MySQL/bin

case $1 in

   start)

            nohup dsmc -se=mysql quiet &

            ;;

esac

# chmod a+x /etc/init.d/tsmmys
# ln -s /etc/init.d/tsmmys /etc/rc2.d/S99tsmmys
 
Startup the service, and verify that the service gets a schedule
 
# /etc/init.d/tsmmys start
# cat /var/log/dsmsched_mysql.log

Setting up MySQL for: Transaction log backups (incremental backup)

Edit my.ini / my.cnf file:
 
# vi /etc/my.cnf

log-bin = /var/lib/mysql/log.bin

log-bin-index = /var/lib/mysql/log-bin.index

 
Restart the MySQL server:
 
# /etc/init.d/mysql restart
 
Veriify that the binary logging are enabled:
 
# mysql
mysql> show master logs;

+------------+-----------+
| Log_name   | File_size |
+------------+-----------+
| bin.000945 |  26527589 |
+------------+-----------+
 
Create the backup scripts
(set environment variable INDEXFILE to point to the location of the indexfile)
 
# vi /usr/local/bin/logbackup.sh

#!/bin/bash

export PATH=$PATH:/opt/repostor/rdp4MySQL/bin

export INDEXFILE=/var/lib/mysql/log-bin.index

mysqlbackup -v -s mysql -l >> /var/log/logmysqlbackup.log 2>&1

 
# chmod a+x /usr/local/bin/logbackup.sh
 
Try to do a backup
 
# /usr/local/bin/logbackup.sh
 
Last Updated on Wednesday, 02 September 2009 18:28
 
Repostor : Your recovery expert