The Mysql replication generally works very well. There are some things however, which can create a different result on the master than on the slave.
Which features are not replication safe? Assume MySQL >= 5.0.13
(Find all correct answers)
 

a) NOW()
b) UUID()
c) SYSDATE()
d) SET @my_uuid = UUID();
   INSERT INTO t VALUES(@my_uuid);

 
[ Scaling MySQL (10%) - Replication ]

(Find all correct answers)
 
a) A user-id on the master for the slave
b) Binlogs on the master
c) Unique server-ids
d) At least two mysql instances
e) A user-id on the slave for the master
f) Binlogs on the slave
 
[ Scaling MySQL (10%) - Replication ]

With Mysql it can be challenging to backup large databases without read-locking the tables.
One way of getting around the problem is to setup mysql replication.
What is the correct order of the steps necessary?
 
a) verify slave status & error log
b) issue change master command
c) create consistent backup on master server & write down binlog position
d) start slave
e) restore backup on slave-server
 
[ Data Backup and Recovery Methods (15%) - Replication as an Aid to Backup ]

a) mysqlhotcopy
b) bcp
c) mysqldump --single-transaction --master-data
d) ibbackup

 
[ Data Backup and Recovery Methods (15%) - Introduction ]

a) data pump
b) ibbackup
c) mysqldump  --master-data
d) flush tables with read lock;
   -- write down binlog position
   -- copy all files
   unlock tables;

 
[ Data Backup and Recovery Methods (15%) - Introduction ]

 
There are different backup types, for example:
- textual (logical) / binary (physical)
- online / offline
- full / incremental
 
The result of a textual backup are text files. They can be easily moved to other db-servers or to different applications.
But restoring those files can be CPU intensive, as indexes need to be recreated.
A binary backup makes copies of mysql’s own files. This kind of backup is very efficient, but internal knowledge and/or special tools are needed.
 
Pick two means of making textual backups with mysql.
 

a) mysqlhotcopy
b) mysqldump
c) ibbackup
d) select into outfile

 
[ Data Backup and Recovery Methods (15%) - Binary Versus Textual Backups ]

Pick from the statements below the most important areas of database administration.
(Find all correct answers)

a) Backup
b) Backup
c) Backup

 
[ Data Backup and Recovery Methods (15%) - Introduction ]

Imagine your Mysql instance runs on a linux server, and every night all the files of the server are copied to a NFS volume with a cp command.
Is such a backup enough to also act as a mysql backup?
 
(Find all correct answers)

a) No, without synchronization with the database,
    the copied files will all be from a different point in time
b) Yes, if really all files copied, than the cp is just fine
c) No, as the database needs mechanisms like log-buffers and log-files,
   a file backup will result in something, which cannot be restored
d) Yes, a file backup is fine, as backups aren't needed anyway

 
[ Data Backup and Recovery Methods (15%) - Introduction ]

(Select all correct answers)

a) .frm file
b) .dat file
c) db.opt file
d) .MYD file
e) .MYI file

 
[ MySQL Architecture (10%) - How MySQL uses Disk Space ]