![]() ![]() As a DBA you need to make sure that the databases are backed up regularly and timely recovery procedures are in place. Unfortunately, if you don t have an adequate database backup and recovery strategy and implementation in place then you are left with nothing to fall back on. Implementing proper database backup and disaster recovery plans to protect against accidental loss of data, database corruption, hardware/operating system crashes or any natural disasters has become one of the most important responsibilities of the Database Administrator (DBAs). ![]() At the same time, the volumes of data that need to be managed are growing exponentially putting added pressure on available storage and storage costs. Not only do they rely on database applications for every area of their business including sales, customer service, finance, marketing, manufacturing and human resources, but many of these applications needs to be available 24x7. 8! 2011, Oracle Corporation and/or its affiliates 2ģ Introduction Organizations are facing an expanding set of data protection challenges. MySQL Enterprise Backup performs hot backup operations for MySQL databases.1 MySQL Enterprise Backup Fast, Consistent, Online Backups A MySQL White Paper February,, Oracle Corporation and/or its affiliatesĢ Table of Contents Introduction. Note: Classic utilities for saving /restoring DDM DB (ddm_save, ddm_load & ddm_backup ) will not be supported from CA Spectrum 10.4 In post_olb_script use ddm_ to schedule backup of InnoDB DDM database.To restore DDM database refer “Loading the DDM Db” section.Take a backup of DDM database to refer “Save the DDM Db when Archive Manager is running” section.These utilities are supported from CA Spectrum 10.3.1 and above. Refer the doc for converting DDM database engine from MyISAM to InnoDB Īfter conversion use ddm_ & ddm_ which uses MySQL Enterprise Backup solution to take backup and restore DDM database for better performance. CA Spectrum 10.3 and above supports InnoDB engine for DDM database. ![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |