Donate to ISKME

Resources
Collections
Providers

Sign in to see your Hubs
Login
Featured Hubs
2022 OER Partner Summit
Open Textbooks
#GoOpen
Professional Learning
Climate Education
OERizona
See all Hubs

Sign in to see your Groups
Login
Featured Groups
Adult Education Open Community of Resources
OpenStax Biology 2e
PA STEM Toolkit
Pathways Project | Language Teaching Repository @ Boise State
Student Advocacy
See all Groups

About
Help Center
About Hubs
Services
OER 101

Open Author

Create a standalone learning module, lesson, assignment, assessment or activity

Submit from Web

Submit OER from the web for review by our librarians

Learn more about creating OER

Add Link
About creating OER

Advanced Search

Sign In/Register

Please log in to save materials. Log in

Export to Google Docs
Report

Summary
Table of Contents

This covers the implementation of database clustering through Open Source technologies. It is designed to teach the students on how to get, install and configure the required software and eventually set-up the cluster. It also provides an example on how a web application connects randomly to any database server in the cluster and still gets the same data. Through this example, high data availability solution is clearly demonstrated in the sense that if and when one database server in the cluster is down, the other database server can continue providing the needed data.

title "Distributed Database Systems through Database Clustering" 2024 by Gregorio dela Cruz, Jr.
under license"Creative Commons Attribution Non-Commercial"

Version History

Cite this work

The MySQL NDB Cluster and its Prerequisites

Requirements to Setup MySQL NDB Cluster

Downloading Oracle VirtualBox

Downloading Ubuntu 16.04 (A Linux Distribution)

Downloading the MySQL NDB Cluster Installer

Creating a Virtual Machine on Oracle VirtualBox

Installing Ubuntu 16.04 on a Virtual Machine

Enabling “root” user in Ubuntu

Updating and Upgrading the Linux VM and Installing Software

Updating the Linux VM

Upgrading the Linux VM (Optional)

Basic Linux Commands

Sharing Files between Windows and Linux

Setting-up a MySQL NDB Cluster

MySQL NDB Cluster Architecture

Creating the Virtual Machines (VMs)

Networking the Virtual Machines

Installing, Configuring and Starting the Cluster Management Node

Installing the Cluster Management Node

Configuring and Starting the Cluster Manager

Installing, Configuring and Starting the Data Node

Installing the Data Node

Configuring and Starting the Data Nodes

Configuring and Running the SQL Node

Configuring the SQL Node

Running the SQL Node

Testing the MySQL NDB Cluster

Implementing the Cluster in a Web Application

Distributed Database Systems through Database Clustering

Created Feb. 7, 2024 by Gregorio dela Cruz, Jr.

Subject:: Career and Technical Education
Level:: College / Upper Division, Graduate / Professional, Career / Technical
Material Type:: Activity/Lab, Diagram/Illustration, Lecture Notes, Module, Reading

Standards

No Alignments yet.

Delete Resource?

Cite this work

MLA
APA

dela Cruz, Jr., Gregorio. "Distributed Database Systems through Database Clustering". OER Commons. Institute for the Study of Knowledge Management in Education, 23 Oct. 2017. Web. 23 Nov. 2024. <https://oercommons.org/authoring/25110-distributed-database-systems-through-database-clus>.

dela Cruz, Jr., G. (2017, October 23). Distributed Database Systems through Database Clustering. OER Commons. Retrieved November 23, 2024, from https://oercommons.org/authoring/25110-distributed-database-systems-through-database-clus.

copy citation

History

Updated Jun 21, 2018 by Gregorio dela Cruz, Jr.

Updated Jun 21, 2018 by Gregorio dela Cruz, Jr.

Updated Jun 4, 2018 by Gregorio dela Cruz, Jr.

Updated May 14, 2018 by Gregorio dela Cruz, Jr.

Updated Dec 13, 2017 by Gregorio dela Cruz, Jr.

Updated Dec 13, 2017 by Gregorio dela Cruz, Jr.

Updated Nov 7, 2017 by Gregorio dela Cruz, Jr.

Updated Oct 23, 2017 by Gregorio dela Cruz, Jr.

Created Oct 23, 2017 by Gregorio dela Cruz, Jr.

Discover

Resources
Collections
Providers

Community

All Hubs
All Groups

Create

Submit a Resource

Our Services

About Hubs
About OER Commons
OER 101
Help Center

My Account

My Items
My Groups
My Hubs

Subscribe to OER Newsletter

Connect with OER Commons Facebook, Opens in new window Twitter, Opens in new window

Donate to ISKME

Powered By

Privacy Policy Terms of Service Collection Policy DMCA

© 2007 - 2024, OER Commons

A project created by ISKME. Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 License.

Sign in / Register

Your email or username: *

Did you mean ?

Password: *

Forgot password? Show password

or

Sign In through your Institution

Create an account Register

or

Sign In through your Institution