|
|
|
|
Learning Objectives: - to introduce basic concepts on database replication, distribution and transactional models. Traditional definitions and classifications are presented in theory guide. Selected bibliography is recommended to the readers to study in depth these concepts. Advanced replication details for commercial products (Microsoft SQL Server, IBM DB2 and Oracle) are presented in “Replication of the Big Three” document. - to present working examples on the use of virtualization solutions to test distribution and replication database environments. - to introduce working examples on database cluster configuration. - to strengthen the motivation of the readers introducing additional material oriented to being able to generate their own virtual lab environment. Part A: Pre-Lab material Step-A1: Previous material introductions: Part I: This part includes basic theoretical concepts on virtualization, an introduction to Oracle VirtualBox virtualizer, a Debian operative system installation tutorial and MySQL, PostgreSQL and PgPool-II installation instructions. Recommended Bibliography View Download Pre-workshop material View Download Part II: Previous material Supporting Videos Step-A2: Optionally, network administrators can test if their network configurations allow virtual machines network to work properly. Testing Debian model in lab environment View Download Part B: Tutorial (Theoretical) Introduction Step-B1: Readers must read the Theory guide or optionally its corresponding presentation that introduce the key concepts. Theory guide presentation View Download Step-B2: Readers are invited to read (as post-lab material) the advanced replication details for commercial products (Microsoft SQL Server, IBM DB2 and Oracle). Replication of the Big Three View Download Part C: Hands-on Laboratory This laboratory is focused on cluster configuration using free software or software with known free versions. We use Oracle VirtualBox, Debian OS, MySQL, PostgreSQL and PgPool-II. Provided software: Debian VirtualBox virtual disk Download Step-C1: Starting with a model virtual machine, that the participant can create using previous material or simply using the one included in the lab material, a distributed environment is generated by cloning the virtual machines, and properly configuring the network of the clones Part I: Hands on Lab Part 1 – Cloning View Download Part II: Supporting videos: Deleting the model machine and making the immutable disk
Step-C2: The participant configures and tests one MySQL Cluster. Part I: Hands on Lab Part 2 – MySQL Cluster View Download Part II: Supporting videos: Step-C3: The participant configures and tests one PgPool-II Cluster. Part I: Hands on Lab Part 3 – PgPool-II Cluster View Download Part II: Supporting videos:
* The DBTech EXT project has been funded with support from the European Commission. This publication reflects the views only of the author(s), and the Commission cannot be held responsible for any use which may be made of the information contained therein |