https://github.com/pg-sharding/spqr/discussions/569

Skip to content
Toggle navigation
 
Sign in

  * Product
      +  
        Actions
        Automate any workflow
      +  
        Packages
        Host and manage packages
      +  
        Security
        Find and fix vulnerabilities
      +  
        Codespaces
        Instant dev environments
      +  
        Copilot
        Write better code with AI
      +  
        Code review
        Manage code changes
      +  
        Issues
        Plan and track work
      +  
        Discussions
        Collaborate outside of code
    Explore
      + All features
      + Documentation
      + GitHub Skills
      + Blog
  * Solutions
    For
      + Enterprise
      + Teams
      + Startups
      + Education
    By Solution
      + CI/CD & Automation
      + DevOps
      + DevSecOps
    Resources
      + Learning Pathways
      + White papers, Ebooks, Webinars
      + Customer Stories
      + Partners
  * Open Source
      +  
        GitHub Sponsors
        Fund open source developers
      +  
        The ReadME Project
        GitHub community articles
    Repositories
      + Topics
      + Trending
      + Collections
  * Pricing

Search or jump to...

Search code, repositories, users, issues, pull requests...

Search
[                    ]
Clear

Search syntax tips

Provide feedback

We read every piece of feedback, and take your input very seriously.

[                    ] [ ] Include my email address so I can be
contacted
Cancel Submit feedback

Saved searches

Use saved searches to filter your results more quickly

Name [                    ] 
Query [                    ]

To see all available qualifiers, see our documentation.

Cancel Create saved search
Sign in
Sign up
You signed in with another tab or window. Reload to refresh your
session. You signed out in another tab or window. Reload to refresh
your session. You switched accounts on another tab or window. Reload
to refresh your session. Dismiss alert
{{ message }}
pg-sharding / spqr Public

  * Notifications
  * Fork 29
  * Star 489

  * Code
  * Issues 5
  * Pull requests 10
  * Discussions
  * Actions
  * Projects 0
  * Security
  * Insights

Additional navigation options

  * Code
  * Issues
  * Pull requests
  * Discussions
  * Actions
  * Projects
  * Security
  * Insights

Meet SPQR 1.3.0 #569

Denchick announced in Announcements
Meet SPQR 1.3.0 #569
@Denchick Denchick
Mar 25, 2024 * 0 comments
Return to top
Discussion options

  * 

{{title}}

Something went wrong.
Quote reply
edited

  * 

{{editor}}'s edit

{{actor}} deleted this content .

{{editor}}'s edit

Something went wrong.

[314]
Denchick
Mar 25, 2024
Maintainer

-

It's been a long time since the last SPQR release, and a lot of work
has been done. Here's a brief review of what we've been working on.

SPQR 2.0 news #431
In this release, we add new syntax to handle sharding configuration.
To make all things work, you should create a distribution via CREATE
DISTRIBUTION command. The next step is to specify a list of tables
and columns via ATTACH RELATION command. At the end specify a list of
ranges: which values to route to which shard via CREATE KEY RANGE
command. You can see an example at Syntax.md. SHARDING RULE syntax is
deprecated now.

Extended Protocol improvements
We continue to work on the extended protocol support in SPQR. A lot
of work has already been done, and in most cases, the router works
correctly.

Shards [re]balancing news
The essential part of our solution is smart shard rebalancing. We
made the first version of this component (again). Data migration
between shards aims to balance the workload across shards
proportionally. The main idea is to minimize any locking impact
during these migrations, which is accomplished by reducing the size
of the data ranges being transferred.

We still have a lot of room for improvement. The full list of changes
can be found in the release notes. Stay tuned!

Beta Was this translation helpful? Give feedback.

5 You must be logged in to vote
 10  9  7
All reactions

  *  10
  *  9
  *  7

Replies: 0 comments

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

Announcements
Labels
None yet
1 participant
@Denchick
Heading
Bold
Italic
Quote
Code
Link
---------------------------------------------------------------------
Numbered list
Unordered list
Task list
---------------------------------------------------------------------
Attach files
Mention
Reference
Menu

  * Heading
  * Bold
  * Italic
  * Quote
  * Code
  * Link
  * 
  * Numbered list
  * Unordered list
  * Task list
  * 
  * Attach files
  * Mention
  * Reference

Select a reply

Create a new saved reply
 1 reacted with thumbs up emoji  1 reacted with thumbs down emoji 
1 reacted with laugh emoji  1 reacted with hooray emoji  1 reacted
with confused emoji [?] 1 reacted with heart emoji  1 reacted with
rocket emoji  1 reacted with eyes emoji

Footer

 (c) 2024 GitHub, Inc.

Footer navigation

  * Terms
  * Privacy
  * Security
  * Status
  * Docs
  * Contact
  * Manage cookies
  * Do not share my personal information

You can't perform that action at this time.