1z0-908 Exam Dumps : MySQL 8.0 Database Administrator

general query log

audit log

slow query log

binary log

error log

Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

Logical upgrades are much faster because they do not require restarting the mysqld process.

Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

Physical upgrades are much faster because they do not require restarting the mysqld process.

Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

Replication can use only TCP/IP connections.

Any instance can have multiple slaves, but it can have only one master.

Each instance in a replication topology must have a unique server ID.

Binary logs contain only transactions originating from a single MySQL instance.

Each slave must have its own MySQL user for replication.

Binary logging must be enabled on the master in order to replicate to other instances.

A replication user must have the SELECT privilege for all tables that need to be replicated.