PREVENTING DATA LOSS
MEMBER GROUP:
JESSYLIANA ANAK JOSEPH
SANDRA ELIZABETH ANAK PHILIP
LEORNARD LIM LEE LEONG
ERRA FAZIRA ...
WHAT IS PHYSICAL BACKUP???
 consists of exact copies of database directories and files.
 Typically, this is a copy of al...
 can be performed using utilities and tools, but also manually by
copying data files to a backup storage device .
 Raw b...
WHAT IS LOGICAL BACKUP???
 executed by querying the MariaDB or MySQL server to obtain the
database structure and the cont...
ADVANTAGES
 SQL dumps have the advantage of being easy to use and flexible, as the
SQL statements can be manipulated as r...
BACKUP METHODS
 Backups can have an impact on the activity of a live server and
sometimes a backup or a restore activity ...
HOT BACKUP
ADVANTAGES
1. Tablespace or data file-level backup, the backup time is short.
2. Backup of the database can sti...
COLD BACKUP
ADVANTAGES
1. Very fast backup method (just copy files)
2. Easy to archive (can simply copy)
3. Easy to restor...
THANK YOU!!!
Preventing data loss OS
of 10

Preventing data loss OS

goodluck....
Published on: Mar 4, 2016
Published in: Technology      
Source: www.slideshare.net


Transcripts - Preventing data loss OS

  • 1. PREVENTING DATA LOSS MEMBER GROUP: JESSYLIANA ANAK JOSEPH SANDRA ELIZABETH ANAK PHILIP LEORNARD LIM LEE LEONG ERRA FAZIRA BINTI RAZALI SUZY ANAK SIBA
  • 2. WHAT IS PHYSICAL BACKUP???  consists of exact copies of database directories and files.  Typically, this is a copy of all or part of the MariaDB or MySQL data directory.
  • 3.  can be performed using utilities and tools, but also manually by copying data files to a backup storage device .  Raw backups are usually faster to restore  The restore procedure is basically a simple copy of the binary files. ADVANTAGES DISADVANTAGES  portable only to other machines that have identical or similar hardware characteristics.
  • 4. WHAT IS LOGICAL BACKUP???  executed by querying the MariaDB or MySQL server to obtain the database structure and the content information.  Usually, a logical backup is generated by a tool that writes all the SQL queries required to create the tables of that database, as well as all the insert queries required to place the information back into the database tables.
  • 5. ADVANTAGES  SQL dumps have the advantage of being easy to use and flexible, as the SQL statements can be manipulated as required using standard text tools.  It is easy to restore only certain records or tables.  They are machine independent and highly portable. DISADVANTAGES  Backups in logical format are large particularly when saved in text format  often slow to create and restore
  • 6. BACKUP METHODS  Backups can have an impact on the activity of a live server and sometimes a backup or a restore activity can cause services disruption. Two type is major to use :-1) HOT BACKUP 2) COLD BACKUP
  • 7. HOT BACKUP ADVANTAGES 1. Tablespace or data file-level backup, the backup time is short. 2. Backup of the database can still be used. 3. Can reach the second level recovery (return to a certain point in time). 4. Can recover almost all database entities. 5. Recovery is fast recovery in most cases in the database is still working. DISADVANTAGES 1. Can not go wrong, otherwise the consequences could be serious. 2. If the backup fails, the results can not be used for point in time recovery. 3. Difficult to maintain, so be particularly careful not allowed to fail in the end.
  • 8. COLD BACKUP ADVANTAGES 1. Very fast backup method (just copy files) 2. Easy to archive (can simply copy) 3. Easy to restore to a point in time (just the file and then copy it back again) 4. Combined with the archive, for database "recovery”. 5. Low maintenance, high security. DISADVANTAGES 1. When used alone, can only be provided to a certain point in time "recovery”. 2. In the whole process of implementation of the backup, the database must be backed up and can not be used for other work. In other words, the database must be turned off. 3. If disk space is limited, can only copy to tape or other external storage device, the speed will be very slow. 4. Not by table or by the user to restore.
  • 9. THANK YOU!!!

Related Documents