[Ended] Round 10 | Technical Document Scavenger Hunt
  

Sangfor Jojo Lv5Posted 2024-Nov-12 14:21


Dear members,
We are excited to announce the launch of our Technical Document Scavenger Hunt! This activity aims to encourage all users to dive deeper into our newly published technical document in the Knowledge Base, enhancing your understanding and engagement with the material.

By participating, you'll not only sharpen your skills but also have the chance to collaborate and share insights with fellow users.
Happy hunting, and may the best reader win!


1. Activity Rules                                                                                                                     

1)  All community users are invited to participate in the scavenger hunt.
2)  There will be a total of 6 questions related to the three documents.
3)  Participants must submit their answers under this post by Nov. 18.
4)  Winners will be announced next Tuesday on the community platform.


2. Activity Duration                                                                                                               

Nov. 12 - Nov. 18

3. How to Participate                                                                                                                                                                                                                
1) Browse the Questions:
We have provided a list of questions based on the document's content. Your goal is to find the
answers within the text.

2) Read the Documents:
Start by simply reading the catalog. Taking your second reading thoroughly with the given questions
which will make you read more efficiently.

3) Use the Search Function:
Most digital documents have a search feature. Use keywords from the questions to locate quickly
relevant sections.

4) Submit Your Answers:
Once you have your answers, post them in the designated thread by the deadline.

5) Collaborate:
Feel free to discuss your findings in the forum and win 100 coins. Sharing thoughts and interpretations can lead to a deeper understanding and may help others in their search.



4.  Rewards                                                                                                                             

1) Correct Answers: 100 coins for each correct answer.

2) All Correct: An additional 100 coins for those who answer all questions correctly.


5. Scavenger Hunt Questions                                                                                             

Read these documents on the left side and answer the questions below.

MySQL full and incremental migration guide based on DMPQ1: Which versions of MySQL can be supported with two transmission types (Full, Full + Incremental)?
Q2: What are the recommended actions for preparing the target database before migration?
Introducing Our SASE Latest Product Features by 24 October 2024Q3: Which of the following features are supported in the latest version of SASE? (multiple-choice)
A. App Connector deployment guide
B. Added monitoring of connectors
C. Enabling server-to-client connectivity
D. Internal application supports sorting by name
MCS_SCMT_HA_Backup_Migration_For_UserQ4: What are the key network requirements for the HA backup migration process?  (multiple-choice)
A. Network Latency:
The latency between the source machine and the HCI platform should be within 50ms.
B. Packet Loss: The packet loss rate must be within 5%.
C. Port Configuration: Required ports (80, 20000-20047, and 3345 for TCP) must be accessible, considering any firewalls or DNAT configurations.
Q5: What steps should be taken to prepare the source system for migration? (multiple-choice)
A. Turn Off Firewall and Anti-virus
B. Install Migration Agent
C. Verify System Compatibility


6. How to Reply This Post                                                                                                   

Try to make it simple! Do not repeat the questions when typing your answers.


--------------------------------------------------------------------------------------------------------------------------------------


Recommended Reading                                                                                                         
CLELUQMAN Lv4Posted 2024-Nov-12 14:46
  
Q1: MySQL 5.7 and MySQL 8.0
Q2: Requirement align > Information collect > Resource Prepare > Migration execution > Verification > Standby & Summary
Q3: ABCD
Q4: AC
Q5: ABC
Humayun Ahmed Lv2Posted 2024-Nov-12 15:04
  
Q1: The supported MySQL versions for the two transmission types (Full and Full + Incremental) are:

Source database version:
* MySQL 5.6.X.Y
* MySQL 5.7.X.Y
* MySQL 8.0.X.Y

Destination database version:
* MySQL 5.7.44
* MySQL 8.0.37

These versions are applicable to the Data Transmission Service (DTS) used in DMP.

Q2: The recommended actions for preparing the target database before migration include:

1. Requirements Alignment: Confirm requirements with the customer regarding the destination database version, database machine specifications, load balancer, network and IP segments, time windows for full and incremental transmissions, service shutdown, cutover, and database backup requirements.

2. Information Collection: Conduct a survey to collect information about the machine of the source database and the database itself, which can inform the target database planning.

3. Resource Preparation: Ensure that the on-premises cloud and DMP are ready for migration.

4. Target Database Plan: Prepare the target database with sufficient resources:
* CPU Plan: Ensure the CPU specifications meet or exceed those of the source database.
* Memory Plan: Ensure the memory size is adequate compared to the source database.
* Disk Plan: Ensure the total data and log disk size is sufficient, with backups accounted for.
* Database Parameters: Customize parameter templates to match those of the source database.

5. Network Plan: Plan the network and IP segments to ensure connections between the source database, the DTS-VM, and the target database are reachable.

6. Load Balancer Plan: If the source database has heavy read loads, associate the target database with a layer 7 load balancer to manage access efficiently.

7. Quota Plan: Create necessary users with the right number of quotas for the database instance resources if the target database is not owned by the admin user.

These preparations will help ensure a smooth migration process when transitioning to the target database.

Q3: All options.

Q4: All options.

Q5: All options.
Enrico Vanzetto Lv4Posted 2024-Nov-12 15:52
  
Q1:MySQL 5.7 and MySQL 8.0
Q2:check cpu/ram/disk resources of destination database that there must be equal than source database's resources, check if you have all the required parameters about target database connection
Q3:A,B,C,D
Q4:A,B,C
Q5:A,B
Newbie517762 Lv5Posted 2024-Nov-12 16:11
  
Q1: DMP and DTS support Full and Full+Incremental transmission types for MySQL 5.6.x.y, MySQL 5.7.x.y, and MySQL 8.0.x.y versions.

Q2: Before migration, it is recommended to confirm the key parameters of the source database and make sure the destination database is a new created database without user data. Also, it is recommended to disable the long query of the source database before data transmission to prevent transmission failure.

Q3: A, B, C & D.

Q4: A, B & C.

Q5: A, B & C.
pmateus Lv2Posted 2024-Nov-12 18:19
  
Q1: MySQL 5.6.X.Y, MySQL 5.7.X.Y, MySQL 8.0.X.Y
Q2: increasing disk size, CPU and memory size of the target database
Q3: A, B, C, D
Q4: A, B, C
Q5: A, B
Christ Lee Lv2Posted 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
Dwi Nur Lv2Posted 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
Clarence Roque Lv1Posted 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
Beru Lv2Posted 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