DX NetOps Manager

Convert MyISAM to InnoDB & to use MySQL Enterprise Backup solution 

05-02-2019 01:54 AM

CA Spectrum mandates to convert Archive Manager Distributed Data Manager (DDM) database engine from MyISAM to InnoDB before upgrading to 10.4 for better performance. CA Spectrum 10.3 and above supports InnoDB engine for DDM database.

 

Refer the doc for converting DDM database engine from  MyISAM to InnoDB  https://docops.ca.com/ca-spectrum/10-3-0/en/installing-and-upgrading/upgrading#Upgrading-PostUpgradeTasks 

 

After conversion use ddm_save.pl & ddm_load.pl which uses MySQL Enterprise Backup solution to take backup and restore DDM database for better performance. These utilities are supported from CA Spectrum 10.3.1 and above.

 

 

Note: Classic utilities for saving /restoring DDM DB (ddm_save, ddm_load & ddm_backup ) will not be supported from CA  Spectrum 10.4

 References :

 

MySQL Enterprise Backup performs hot backup operations for MySQL databases. The product is architected for efficient and reliable backups of tables created by the InnoDB storage engine: https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html

 

MySQL Enterprise Backup performance results: https://www.mysql.com/products/enterprise/backup.html 

 

Thanks,

Spectrum Product Management 

Statistics
2 Favorited
17 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

06-05-2019 07:32 AM

Will this then also affect the "post_olb_script" logic for Spectrum to save the "ddmdb" within a OLB processing cycle then? It appears this is affected as it is using the ddm_backup tool. - Joerg

Related Entries and Links

No Related Resource entered.