Expertiza_Wiki - User contributions [en]

CSC/ECE 517 Fall 2023 - NTX-4 Extend NDB Operator capabilities to support Postgres HA

2023-11-01T22:29:09Z

Sayitha: Created page with "<h2>Kubernetes</h2> <h2>Nutanix Database Service</h2> <h2>NDB Kubernetes Operator</h2> The goal of NDB Operator, a Kubernetes operator, is to make the process of setting u..."

<h2>Kubernetes</h2>

<h2>Nutanix Database Service</h2>

<h2>NDB Kubernetes Operator</h2>
The goal of NDB Operator, a Kubernetes operator, is to make the process of setting up and maintaining database clusters within Kubernetes clusters easier. An application with operational knowledge of another application is called a Kubernetes operator. After deployment within the Kubernetes Cluster, it can start monitoring the endpoints of interest and modifying the application under management. An NDB Cluster can be deployed, managed, and modified with the least amount of human intervention thanks to the NDB Operator.

Using their K8s cluster, developers can now provision PostgreSQL, MySQL, and MongoDB databases directly, saving them days or even weeks of work. They can take advantage of NDB's complete database lifecycle management while using the opensource NDB Operator on their preferred K8s platform.

<h2>Problem Statement</h2>
The problem statement requires us to extend NDB operator capabilities to support Postgres HA (High Availability). Currently NDB has support for Posgres High Availability databases but the NDB operator cannot manage them. Our task is to identify what additions need to be made to the project to support Postgres HA and implement these additions. Moreover, we will perform end-to-end testing of the provisioning and deprovisioning processes to ensure their smooth functionality.

Postgres HA involves implementation of measures that ensure that a PostgreSQL database system remains operational and accessible even in the face of hardware failures, software issues, or other types of disruptions. This includes measures like replication, failover, load balancing and more.

<h2>Approach</h2>
- To start a hardcoded file containing basic config for Postgres HA can be made.<br>
- The hardcoded file will contain details such as databaseInstanceName, description, clusterId, credentialSecret, size.<br>
- Starting from ndb_api changes can be made to integrate Postgres HA support.<br>
- The flow of changes will be from ndb_api -> controller adapters -> controllers -> api.<br>
- In ndb_api, another method appendRequest for Postgres HA needs to be added to db_helpers.go. Within this method, additional specifications for this specific database type shall be provided.<br>
- Within api, the Instance struct needs to be updated to include parameters like copies of the instance, how often data will be copied from the primary and more.

<h2>References</h2>
[https://www.nutanix.com/products/database-service Nutanix Database Service]

[https://www.postgresql.org/docs/current/high-availability.html PostgreSQL High Availability]

<h2>Relevant Links</h2>
link to GitHub repository: [https://github.com/rithvik2607/ndb-operator https://github.com/rithvik2607/ndb-operator]

<h2>Team</h2>
<b>Mentor</b><br>
Nandini Mundra

<b>Student Team</b><br>
Sai Rithvik Ayithapu (sayitha@ncsu.edu)<br>
Sreehith Yachamaneni (syacham@ncsu.edu)<br>
Rushil Patel (rdpate24@ncsu.edu)

CSC/ECE 517 Fall 2023

2023-11-01T22:28:50Z

Sayitha:

* [[CSC/ECE 517 Fall 2023 - E2358. Refactor student_quizzes_controller.rb]]
* [[CSC/ECE 517 Fall 2023 - E2351. Finish mentor management for assignments without topics]]
* [[CSC/ECE 517 Fall 2023 - E2356. Refactor review_mapping_controller.rb]]
* [[CSC/ECE 517 Fall 2023 - E2359. Refactor user_controller.rb, user.rb, and its child classes]]
* [[CSC/ECE 517 Fall 2023 - E2367. Reimplement participants_controller.rb, participants.rb and its child classes]]
* [[CSC/ECE 517 Fall 2023 - E2355. Improving Search Facility In Expertiza]]
* [[CSC/ECE 517 Fall 2023 - E2365. Create a user interface for Questionnaire in ReactJS]]
* [[CSC/ECE 517 Fall 2023 - E2364. Create a UI for Course's & Assignment's "Add Participants" page]]
* [[CSC/ECE 517 Fall 2023 - E2361. Create a page to create and update a Questionnaire in ReactJS]]
* [[CSC/ECE 517 Fall 2023 - E2362. Create a page to edit an Assignment's due date in ReactJS]]
* [[CSC/ECE 517 Fall 2023 - E2363. Create a UI for Assignment Edit page "Etc" tab in ReactJS]]
* [[CSC/ECE 517 Fall 2023 - E2375. Reimplement Waitlists]]
* [[CSC/ECE 517 Fall 2023 - E2357. Refactor sign_up_sheet_controller.rb]]
* [[CSC/ECE 517 Fall 2023 - E2366. Reimplement assignment model and assignment controller]]
* [[CSC/ECE 517 Fall 2023 - E2368. Reimplement of due_date.rb]]
* [[CSC/ECE 517 Fall 2023 - E2370. Reimplement join team requests controller]]
* [[CSC/ECE 517 Fall 2023 - E2371. Reimplement quiz_questionnaires_controller]]
* [[CSC/ECE 517 Fall 2023 - E2369. Reimplement duties controller.rb and badges controller.rb]]
* [[CSC/ECE 517 Fall 2023 - E2353. Further refactoring and improvement of review mapping helper]]
* [[CSC/ECE 517 Fall 2023 - E2373. Reimplementation of teams controller]]
* [[CSC/ECE 517 Fall 2023 - E2374. Reimplement the Question hierarchy]]
* [[CSC/ECE 517 Fall 2023 - NTX-2 Observability and Debuggability]]
* [[CSC/ECE 517 Fall 2023 - E2350. Allow reviewers to bid on what to review]]
* [[CSC/ECE 517 Fall 2023 - NTX-4 Extend NDB Operator capabilities to support Postgres HA]]

CSC/ECE 517 Fall 2023 - NTX-4 Expand NDB Operator capabilities to support Postgres HA

2023-11-01T22:21:25Z

Sayitha: Created layout of the page and added content