Database Cluster Administration and Security
Teacher
G.Narasimha Rao
Category
Core Courses
Course Attendees
Still no participant
Course Reviews
Still no reviews
Course Name : Database Cluster Administration and Security
Code(Credit) : CUTM1034(2-1-1)
Course Objectives
- To teach students about managing access rules and configurations for computing clusters for internal and external clients.
- To provide knowledge on manage cluster deployment.
- To provide hands-on experience of monitor capacity, performance and database security.
Course Outcomes
| COs | Course outcomes | Mapping COs with POs (High-3, Medium-2, Low-1) |
| CO1 | Gain knowledge about concepts of Construction of Clusters | PO1 (3)- Engineering Knowledge. |
| CO2 | Solving the problems of different database cluster securities. | PO2(3)- Problem Analysis |
| CO3 | Students will develop skill of developing new techniques in cluster deployment in real world Applications | PO3 (3)- Design/Development of Solution |
Course Syllabus
Module I: Construction of Clusters
Define the size of the cluster based on data to be stored, Identify quicker ways to add or remove nodes using cluster monitoring tools, Deploy and manage clusters, Setup cluster configurations using cookbooks.
Practice:
1. Different functions to update or delete data from the databases such as CRUD (Create Read Update Delete)
2. Organizational policies, procedures and guidelines which relate to maintaining existing databases.
Module II: Manage cluster deployment
Define encryption standards at rest and in motion for data stored on the cluster, create documentation on computing clusters, Validate computing clusters, Administer cluster access.
Practice:
3. Different databases, including: relational (MySQL, PostgreSQL),
4. NoSQL (Redis, Amazon DynamoDB)
Module III: Monitor capacity and performance
Evaluate cluster requirement estimates through capacity planning, Monitor cluster connectivity and performance and recommend efficiencies, Troubleshoot issues with cluster connectivity and performance with appropriate people.
Practice:
5. How to migrate a database to a new architecture
6. How to automate database maintenance
Module IV: Database Security
Secure a Database System applying Information Security, Security Threats, Security Vulnerabilities and Risk Management.
Practice:
7. How to store and retrieve information
8. How to provide the security in databases
Module V: Database backup
Implement Database System backup and restoring backup, Implement Database System security by creation of roles and functions for Database Users.
Practice:
9. Write a program for database backup maintenance.
10. Write a program for database recovery.
Module-VI: Message Transfer
Operations browsing, downloading messages, pictures from internet, sending and receiving
Emails, sending attachments of pictures and text information, E-chatting.
Practice:
11. Write a program for message transfer between databases
Module-VII: Cluster Management
Master-Master, Master-Slave, Multimaster, Master-Multislave
Practice: Using MySQL, PostgreSQL
12. Write a program to configure master slave communication
Projects
1.Configuring master-slave server in MySQL without delay
2.Configuring master-slave server in MySQL with time constraint
3.Configuring single master and 2 slaves with one as RO and other as RW
4.Network Communication Optimization
5.Cluster File system and Parallel I/O
6.Cluster Scheduling at Server level
Textbooks:
1. Implementing database security and auditing, Author: Ron Ben-Natan
2. Database Security, Authors: Silvana Castano, Giancarlo Martella, M. Fugini.
3. Fundamentals of Database Systems, Author: Ramez Elmasri.
Session Plan
Session 1
Session 4
Add New Worker Nodes to Existing Cluster,Setup cluster configurations using cookbooks
https://www.youtube.com/watch?v=mAaSZwPfKA0
https://cloud.ibm.com/docs/openshift?topic=openshift-add_workers
https://www.youtube.com/watch?v=glWoRinJqlg
https://www.digitalocean.com/community/tutorials/how-to-create-simple-chef-cookbooks-to-manage-infrastructure-on-ubuntu
Session 5
Projects:
1.Configuring master-slave server in MySQL without delay
2.Configuring master-slave server in MySQL with time constraint
3.Configuring single master and 2 slaves with one as RO and other as RW
4.Network Communication Optimization
5.Cluster File system and Parallel I/O
6.Cluster Scheduling
Practice:
1. Different functions to update or delete data from the databases such as CRUD (Create Read Update Delete)
2. Organizational policies, procedures and guidelines which relate to maintaining existing databases
Session 6
Session 10
Define encryption standards at rest and in motion for data stored on the cluster
https://www.youtube.com/watch?v=7EGSUuJL2xI
https://digitalguardian.com/blog/data-protection-data-in-transit-vs-data-at-rest
https://www.slideshare.net/AnkitMehta24/datainmotion-dataatrest-and-gpg
Session 12
Create documentation on computing clusters
https://www.youtube.com/watch?v=O7EzPyET4IY
http://www.123seminarsonly.com/CS/Cluster-Computing.html
https://www.slideshare.net/anjalibhandari11011995/cluster-computing-53768699
Session 13
Validate computing clusters,Cluster access administer
https://www.youtube.com/watch?v=8BBDxzJL6fY&t=57s
https://www.datanovia.com/en/lessons/cluster-validation-statistics-must-know-methods/
https://www.slideshare.net/UdayaArangala/cluster-validation
https://www.youtube.com/watch?v=9TxpqWaDA50
https://cloud.google.com/kubernetes-engine/docs/how-to/cluster-admin-overview
https://www.slideshare.net/itsec/clustering-and-high-availability
Session 14
Practice:
3. Different databases, including: relational (MySQL, PostgreSQL),
4. NoSQL (Redis, Amazon DynamoDB
Session 15
Monitor capacity and performance
https://www.youtube.com/watch?v=nAtlan1qgso
https://www.appdynamics.com/blog/engineering/top-6-database-performance-metrics-to-monitor-in-enterprise-applications/
https://www.slideshare.net/opmanagerteam/applications-performance-monitoring-with-applications-manager-part-1
Session 16
Evaluate cluster requirement estimates through capacity planning
https://www.youtube.com/watch?v=1AN_L_8-x84
https://dzone.com/articles/hadoop-cluster-capacity-planning
https://www.slideshare.net/mongodb/capacity-planning-57242648
Session 17
Monitor cluster connectivity and performance and recommend efficiencies,Troubleshoot issues with cluster connectivity and performance with appropriate people
https://www.youtube.com/watch?v=b-W96sn3gdY
https://docs.netapp.com/us-en/ontap/task_cp_monitor_cluster_performance_ci.html
https://www.youtube.com/watch?v=U00k1vQrOmg
https://www.slideshare.net/HadoopSummit/simplified-cluster-operation-troubleshooting
Session 18
Practice:
5. How to migrate a database to a new architecture
6. How to automate database maintenance
Session 19
Secure a Database System applying Information Security
https://www.youtube.com/watch?v=62rjWHqyZpk
https://www.slideshare.net/amirkhanzada33/database-security-38334769
https://www.ibm.com/cloud/learn/database-security
Session 22
Practice:
7. How to store and retrieve information
8. How to provide the security in databases
Session 24
Session 26
Implement Database System security,Database System security by creation of roles and functions for Database Users
https://www.youtube.com/watch?v=wAEL5RnX_Yc&t=221s
https://www.slideshare.net/ERSHUBHAMTIWARI/db-security
https://www.youtube.com/watch?v=c9zR90MU51s
https://www.dbta.com/Editorial/Think-About-It/How-to-Improve-Database-Security-110197.aspx
Session 27
Practice:
9. Write a program for database backup maintenance.
10. Write a program for database recovery.
Session 28
Operations browsing, downloading message
https://www.youtube.com/watch?v=RdNErie6dKU
https://www.tutorialspoint.com/web_developers_guide/web_browser_types.htm
https://www.slideshare.net/gr8rishabh/operations-of-dbms
Session 29
Pictures from internet
https://www.youtube.com/watch?v=Ipa9xAs_nTg
https://www.shutterstock.com/search/sending+and+receiving+emails?section=1&image_type=photo&commercial=true&safe=true&search_source=base_related_searches&language=en&saveFiltersLink=true
https://www.slideshare.net/kilgore5454/email-basics2-jw
Session 33
Practice:
11. Write a program for message transfer between databases
Session 38
Practice:
12. Write a program to configure master slave communication Using MySQL, PostgreSQL
Session 40
Cluster File system and Parallel I/O
https://www.youtube.com/watch?v=cXbEVsExU9c
http://etutorials.org/Linux+systems/cluster+computing+with+linux/Part+III+Managing+Clusters/Chapter+19+Parallel+I+O+and+the+Parallel+Virtual+File+System/19.1+Parallel+I+O+Systems/
https://www.slideshare.net/RaheemUnnisa1/parallel-file-system-for-linux-clusters
Our Main Teachers
Prof. Susanta Kumar Nayak Working as Assistant Professor in Department of Computer Science & Engineering, Centurion University of Technology & Management, paralakhemundi,odisha . He completed MCA, MBA(HR), Ph.D. [(Pursuing). He has been an Academician from last 16.5 years. Previously he Worked as Assistant Professor in MCA Programme in Bharati Vidyapeeth Deemed University, Pune, Institute of Management Kolhapur […]