Does NetOps Portal support use of mysqlbackup for live backups?
search cancel

Does NetOps Portal support use of mysqlbackup for live backups?

book

Article ID: 426570

calendar_today

Updated On:

Products

Network Observability CA Performance Management

Issue/Introduction

Are we able to use the mysqlbackup command for live backups, while the NetOps Portal web server services remain running, to create mysql backups?

Can we create a mysql DB backup on Portal while the services stay running?

Are there options for a mysql DB backup on Portal without shutting services down?

I was told in the past that for DB Backup and Restore there was NO need to stop the processes. Although I see the documentation indicates that for both we need to stop and start. Can you confirm the steps to backup and restore the NetOps Portal server DB?

Environment

All supported Network Observability DX NetOps Portal web server releases

Cause

Internal testing shows table locking problems when using mysqlbackup to generate MySql DB backups on NetOps Portal.

As a result the mysqlbackup tool is not included in the current NetOps MySql enterprise implementations on Portal.

Resolution

Ensure services are stopped before, and restarted after, running the supported and documented mysqldump command.

See the Back Up the NetOps Portal Database section of the Back Up NetOps Portal documentation topic for additional details.