Rotring Lv2Posted 2024-Nov-13 15:22
  
HI
Q1 : Full backups capture the entire database at a given point in time.
Incremental backups capture only the changes made since the last backup (either full or incremental).

Q2: 1. Assess Database Compatibility
•        Check for version compatibility.
•        Check for deprecated features.
2. Create Backup of Source Database
•        Full backup.
•        Test backup integrity.
3. Clean Up the Source Database
•        Remove unnecessary data.
•        Optimize tables and indexes.
•        Defragment tables.
4. Schema Review and Adjustments
•        Review schema structure.
•        Check for data types compatibility
•        Review triggers, stored procedures, and functions.
5. Prepare the Target Database
•        Create necessary tables and databases
•        Enable necessary configurations.
•        Configure user accounts and permissions.
6. Plan for Downtime and Data Synchronization
•        Schedule downtime.
•        Prepare for data synchronization.
7. Testing Before Migration
•        Test in a staging environment.
•        Validate data integrity.
•        Test application compatibility.
8. Prepare for Post-Migration Tasks
•        Monitoring and performance tuning.
•        Backup and disaster recovery plan.

Q3 : A,B
Q4 : All
Q5 : B,C
JJ Teoh Lv1Posted 2024-Nov-14 11:24
  
Q1: MySQL 5.7 and MySQL 8.0
Q2: Requirement align, information collect and resource prepare
Q3: A,C and D
Q4: A,B and C
Q5: B and C
Noviyanto Lv3Posted 2024-Nov-15 11:07
  
Q1 - MySQL Single Instance to MySQL Single Instance.
   - MySQL Single Instance to MySQL with replicas
   - MySQL with replicas to MySQL Single Instance
   - MySQL with replicas to MySQL with replicas
Q2 - Target database plan
   - Network plan
   - Time plan
   - Load Balancer plan
   - Quota plan
Q3 A,B,C,D
Q4 A,B,C
Q5 A and B
pbeugenio Lv1Posted 2024-Nov-18 10:01
  
Q1:  MySQL 5.7 and MySQL 8.0

Q2: 1. GTID has been
enabled for the source database.
2. Destination database servers are reachable
3. The version of the destination database cannot be lower than that of the
source database, and the destination database has enough free storage
space to store the data of the source database.

Q3: A, B, C, and D

Q4: A, B and C

Q5: A, B and C

ND Lv3Posted 2024-Nov-18 14:57
  
Q1: MySQL 5.7 and MySQL 8.0

Q2: Currently, increasing disk size, CPU and memory size of the target database in DMP is online operation without restart database.

Q3: B

Q4: C

Q5: C
Dwi Nur Lv2Posted 2024-Nov-23 01:00
  
Last edited by Dwi Nur 23 Nov 2024 01:01.

Hi Jojo,
for this round my account still not received coins
please give me advice