Unsolved

This post is more than 5 years old

1099

February 18th, 2015 06:00

MYSQL backup failure using Networker & Avamar integration.

Need help on  MYSQL backup failure using Networker & Avamar integration.

Environment information

Networker Server,
1) OS - RHEL 6.2
2) Networker version - 8.1.1.9

Networker Client,
1) OS - RHEL 6.2
2) Networker version - 8.1.1.9
3) Networker NMDA - 1.6

Networker & Avamar Integration,
On Avamar Server,
1) Installed Networker Client Setup (RHEL)
2) Edit mcserver.xml File with entry key="allow_duplicate_client_names" value="true"
3) Create Domain in Avamar named "NetWorker"

On Networker Server,
1) Create AFTD in Networker Server & Configured in Networker
2) Created Avamar Node in NMC.

Backup Flow: Changes are being replicated from primary to slave Server using MY SQL native command line tool and we are backing up same using NMDA.

First backup was successful but 2nd backup got failed with below error.

91989:nsrdasv: The database objects being backed up are inconsistent.

The 'MYSQL_DATABASES' value has changed between the last full backup (dbteam_temp.tbl_addata) and the current backup ().

Change the backup configuration to match the last full backup. 

Alternatively, change either the save set name for scheduled backup or 'MYSQL_BACKUP_NAME' for manual backup.

110-mumbai.justdial.com:MYSQL:/MySQL: retried 1 times.

When tried with specifying database , some gets backup without any error and some fails. Is this error due backup from slave server. Customer says slave server as good as production.

In replication, it only updates some of databases/tables. No configuration changes. This server can be made production just by changing it IP.

Any suggestions? Is it supported to backup from slave server?

4 Operator

 • 

1.3K Posts

February 18th, 2015 23:00

Are you trying to do an incremental backup or a full backup on this system? Also, is there any tool used to do a backup of the primary MYSQL database ?

February 19th, 2015 02:00

Its a full backup and backup has to be taken from Slave server.

4 Operator

 • 

1.3K Posts

February 19th, 2015 03:00

I am assuming it has to be do something with the LSN number on the replicated MYSQL db. Have you tried reaching out to the support on this.

Please share the cfg file that you are using, also try taking a backup of the DB using "mrsqlbackup" tool.

No Events found!

Top