Sangfor Community»Categories General Activity & Notice [Ended] Round 10 | Technical Document Scavenger Hunt

[Ended] Round 10 | Technical Document Scavenger Hunt

views: 63 | comments: 15 | added to Favorites 0
Lights on | 提示:支持键盘翻页<-左 右->
    组图打开中,请稍候......
Created: 2024-Nov-12 14:21

Summary:

Reply

Dwi Nur Posted 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
ND Posted 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
pbeugenio Posted 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

Noviyanto Posted 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
JJ Teoh Posted 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
Rotring Posted 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
Beru Posted 2024-Nov-13 10:52
Q1: version 5.6, 5.7, 8.0
Q2: performing a pre-transmission check that verifies various entities
Q3 : A, C , D
Q4 : A, B, C, D
Q5 : A, B, C
Clarence Roque Posted 2024-Nov-13 09:04
Last edited by Clarence Roque 13 Nov 2024 09:22.

Q1: MySQL 5.7 and MySQL 8.0
Q2: CPU plan, Memory plan, Disk plan, Database parameters.
Q3: A, B, C, and D,
Q4: A, B, and C
Q5: A and B
Dwi Nur Posted 2024-Nov-12 23:56
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: A, B, C, D
Q4: A, B, C
Q5: A, B, C
Christ Lee Posted 2024-Nov-12 20:51
Q1: MySQL 5.7 and MySQL 8.0
Q2: Requirements alignment, Information collection and Resource Prepare
Q3: B & C
Q4: A & B
Q5: B