How to backup and restore the database in FlexMaster

Summary

FM has an option to backup and restore the database. It comes handy in case of any corruption either to the hosted OS or to the machine itself. There is also an alternate way to do this via Linux CLI. Both methods are covered in this article.

Question

How to backup and restore the FlexMaster's database?

Customer Environment

FlexMaster is used as an Element Management System (EMS) for Ruckus APs and Ruckus ZoneDirectors.

Root Cause

Standard backup and restore mechanism is part of FCAPS which provides a framework for network management.

Resolution

1. How to backup DB in Flexmaster

You can backup DB using FlexMaster UI. Go to Administer -> DB Backup/Restore.

DB backup will cause FlexMaster be restarted, and if DB is big, it can take a while for backup to be finished.

You can backup DB with linux commands too, if you do this way, you must shutdown FlexMaster before you start to take backup. Once the backup is done, restart the FM.

cd /opt/FlexMaster

./shutdown.sh

cd 3rdparty/mysql/mysql-enterprise-5.1.53-linux-x86_64-glibc23

tar –zcvf data_<sn_FM>.tgz data

Ex: tar –zcvf data_201006011115.tgz data Then you can find backup file under /opt/FlexMaster/3rdparty/mysql/mysql-enterprise-5.1.53-linux-x86_64-glibc23. The file name is data_201006011115.tgz

./startup.sh

2. How to restore DB?
You can restore DB using FlexMaster UI, go to Administer -> DB Backup/Restore.
The alternate way to restore is to use command line.

cd /opt/FlexMaster

./shutdown.sh

cd /opt/FlexMaster/3rdparty/mysql/mysql-enterprise-5.1.53-linux-x86_64-glibc23

rm –rf data (removes the current database)

tar –zxvf data_201006011115.tgz

cd /opt/FlexMaster

./startup.sh

3. How to perform auto backup of FM's db?
Go to Administer --> DB Backup/Restore. Enable the auto backup under the "Schedule Backup Task" section. Frequency and time values can be adjusted within this section.
Since the db backup makes FM unavailable for regular usage, it is suggested to do this backup during minimum usage time.
OR manual backup:

Use “./mysqldump -u root -p itms > [backupfilename.sql]” command to perform the backup from time to time.

To restore the server, install the FlexMaster software from the CD and then restore the MySQL database from the latest backups.

Notice FlexMaster needs to be shut down before running backup or restore:

/opt/FlexMaster/shutdown.sh --tomcat

... Do the backup/restore

/opt/FlexMaster/startup.sh --tomcat

Article Number:
000001440

Updated:
August 20, 2023 08:12 PM (over 1 year ago)

Tags:
Installation, System Network Management, FlexMaster UMM

Votes:
0

This article is:
helpful
not helpful