Skip to content

Add a read replica configuration for the database #8147

Open
@danlipert

Description

@danlipert

User Story

As a Gitcoin site maintainer, I want a read replica configured for the database, so that database queries are faster and we can scale database load horizontally.

Why Is this Needed

Grants round 8 was the most successful grants round by far, and resulted in the highest server loads we've seen. As many of our database queries and server endpoints have complex business logic (which likely can be simplified, but beyond the scope of this ticket) being able to scale the database will help us support higher server loads and keep the site performant.

Description

Type: Feature

Current Behavior

The django codebase only supports one database

Expected Behavior

The django codebase supports one write database, with read replicas

Definition of Done

The additional configuration to support read replicas is added to the django configuration

Data Requirements

Site performance will improve and the upper limit on site activity will be raised

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