- Database Back-ups Discussion Board

User Generated

nhevffvzn

Programming

Description

Review the following websites for open source databases, such as PostgreSQL and MySQL

  • Identify the open source databases back-up and recovery strategies
  • Address the major differences in database back-ups and recovery between open source databases and other DBMS system like Oracle, SQL Server or DB2.

How might these differences affect the decision when choosing a database platform?

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please, let me know in case of anything

Hello everyone,
Identify the open source databases back-up and recovery strategies
MySQL
Backing up of the database is essential in cases problems occurs such as deletion of
data by mistake, hardware failure, and system crashes. The back-ups ensure the user recovers
the lost data and is able to run its activities consistently. Additionally, the back-up ensures an
individual as able to safeguard the database while making upgrades to the system and when
setting up replication slave servers. A variety of backup strategies are offered by MySQL
enabling an organization to choose the most viable method that meets their requirements and
needs. The strategies employed are based on various section including the types of backups,
methods of creating backups, table maintenance and backup encryption, compression, and
scheduling.
The different types of backups consist of:
Physical vs Logical backups
Physical Backups are suitable for bulky significant databases since they comprise of
raw replicas of files and directories used to store the contents of the database. They offer
quick recovery measures in case of problems. The MySQL Enterprise Backup products
accomplish physical backups since their backup compactness and speeds are essential for
busy as well as important databases. The backup and recovery approaches employed in
physical backups varies between the individual files up to the whole data directory. For
instance, the InnoDB tables can either be separated or share file storage tables. Besides, the
backup can only be performed when the database is not running, however, if running it is
locked to ensure the consistency of the data. The backup tools incorporate mysqlhotcopy for
MyISAM tables or mysqlbackup for InnoDB tables. In restoration, InnoDB and other tab...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags