Skip to content

Horizontal Scaling Scripts #49

Open

Description

@singhalkarun

As a part of deployment config, user should be able to specify number of read replicas they want and requests should be automatically load balanced over read repicas.

User, at any point, should also be able to update number of read replicas and accordingy system should adjust.

Future Scopes:

Dynamic Scaling Configuration, where in user can specify minimum and maximum replicas and system should auto scale.

Reference: https://severalnines.com/blog/comparing-load-balancers-postgresql/

Activity

  1. PiyushRaj927 commented on Jun 5, 2023

    @PiyushRaj927
    Collaborator

    Hello @singhalkarun, can you provide further information regarding this issue. It would be helpful to know the specific orchestration we are targeting and any crucial project requirements that need to be addressed. Thank you!

  2. singhalkarun commented on Jun 6, 2023

    @singhalkarun
    CollaboratorAuthor

    Hello @singhalkarun, can you provide further information regarding this issue. It would be helpful to know the specific orchestration we are targeting and any crucial project requirements that need to be addressed. Thank you!

    Hi @PiyushRaj927 we are specifically targeting to scale read replicas horizontally as a first step where in user should be able to specify number of read replicas in the config itself and the requests should be automatically load balanced over those read replicas.

  3. srishtiv424 commented on Jun 9, 2023

    @srishtiv424

    Hello @singhalkarun which orchestration tool are we using and can you provide some more details regarding this .

    thanks.
    looking forward

  4. singhalkarun commented on Jun 9, 2023

    @singhalkarun
    CollaboratorAuthor

    Hello @singhalkarun which orchestration tool are we using and can you provide some more details regarding this .

    thanks. looking forward

    Hey @srishtiv424 we are open in terms of Orchestration tool, maybe we can start with Docker Swarm and move to Kubernetes in future.

  5. jayanth-kumar-morem commented on Jun 19, 2023

    @jayanth-kumar-morem
    Collaborator

    Hey @singhalkarun , I can take this up. Shall we go ahead using Pgpool-II for configuring load balancing ?

  6. singhalkarun commented on Jun 19, 2023

    @singhalkarun
    CollaboratorAuthor

    Hey @singhalkarun , I can take this up. Shall we go ahead using Pgpool-II for configuring load balancing ?

    Hey @jayanth-kumar-morem let's do a bit of research on other available solutions available as well and create a comparasion with pros and cons of each and then let's decide on which one to use.

    Reference: https://severalnines.com/blog/comparing-load-balancers-postgresql/

  7. jayanth-kumar-morem commented on Jun 19, 2023

    @jayanth-kumar-morem
    Collaborator
  8. c4gt-community-support commented on Sep 13, 2023

    @c4gt-community-support

    Hi!
    Mandatory Details - The following details essential to submit tickets to C4GT Community Program are missing. Please add them!

    • Product Name - Please add a heading called Product Name and mention the name of the product below it.
    • Tech Skills Needed - Please add relevant tech skills
    • Mentors(s) Please tag the relevant mentors on the ticket
    • Complexity - Please mention the complexity only as High/Medium/Low
    • Category - Please add one or more of these options [CI/CD], [Integrations], [Performance Improvement], [Security], [UI/UX/Design], [Bug], [Feature], [Documentation], [Deployment], [Test], [PoC]

    Without these details, the ticket cannot be listed on the C4GT Community Listing.

    Important Details - These following details are helpful for contributors to effectively identify and contribute to tickets.

    • Organization Name
    • Domain - Area of governance
    • Sub-Category - Please mention the sub-category if any for the ticket

    Please update the ticket

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions