Meet SPQR 1.3.0 #569
                  
                    
                      Denchick
                    
                  
                
                  announced in
                Announcements
              
            Replies: 0 comments
  
    Sign up for free
    to join this conversation on GitHub.
    Already have an account?
    Sign in to comment
  
        
    
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
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 DISTRIBUTIONcommand. The next step is to specify a list of tables and columns viaATTACH RELATIONcommand. At the end specify a list of ranges: which values to route to which shard viaCREATE KEY RANGEcommand. You can see an example at Syntax.md.SHARDING RULEsyntax 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.
All reactions