Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Colocation] Make colocated tables default for SQL databases #5239

Closed
rkarthik007 opened this issue Jul 28, 2020 · 1 comment
Closed

[Colocation] Make colocated tables default for SQL databases #5239

rkarthik007 opened this issue Jul 28, 2020 · 1 comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list.
Projects
YSQL Colocation

Comments

@rkarthik007
Copy link
Collaborator

rkarthik007 commented Jul 28, 2020 •
edited by jira bot
Loading

Jira Link: [DB-414](https://yugabyte.atlassian.net/browse/DB-414)
SQL databases often have many tables, most of these are often very small. It would be good to start with colocated tables by default, and proceed to splitting only those tables that are observed to be growing fast. Below is a list of tasks in order to accomplish this.

Status Feature GitHub Issue YugabyteDB Version
✅ Design doc for colocated tables
✅ Support ALTER TABLE for colocated tables #4293 v2.2
⬜️ Optimize joins in colocated tables #4515 v2.2, v2.3
⬜️ Support TABLEGROUP syntax for colocated tables in YSQL v2.3
⬜️ Online index rebuild for colocated tables v2.3
⬜️ Support multiple colocation groups in one database #4525 v2.3
⬜️ Support backup and restore for colocated tables #4517 v2.3
⬜️ xCluster replication support in colocated tables #4516 v2.3
⬜️ Manually pull out fast growing tables from colocation group #4396 Consider for v2.3
⬜️ Route query to colocated tablet leader’s YSQL server #4514
⬜️ Automatically pull out fast growing tables from colocation group #4396

Analytics
@rkarthik007 rkarthik007 added kind/enhancement This is an enhancement of an existing feature area/ysql Yugabyte SQL (YSQL) roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list. labels Jul 28, 2020
@rkarthik007 rkarthik007 added this to To Do in YCQL via automation Jul 28, 2020
@ddorian ddorian mentioned this issue Jan 13, 2021
Open
@ddorian ddorian mentioned this issue Jan 26, 2021
Closed
@frozenspider frozenspider added this to To do in Colocation via automation May 18, 2022
@frozenspider frozenspider added this to Backlog in YSQL via automation May 18, 2022
@frozenspider frozenspider removed this from To Do in YCQL May 18, 2022
@frozenspider frozenspider changed the title Make colocated tables default for SQL databases [Colocation] Make colocated tables default for SQL databases May 18, 2022
@yugabyte-ci yugabyte-ci added the priority/medium Medium priority issue label May 18, 2022
@frozenspider
Copy link
Contributor

This is now outdated, tracking issue moved to #11665

YSQL automation moved this from Backlog to Done May 18, 2022
Colocation automation moved this from To do to Done May 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list.
Projects
Colocation
Done
YQL-beta
Status: Done
YSQL
  
Done
Milestone
No milestone
Development

No branches or pull requests
4 participants
@frozenspider @rkarthik007 @ndeodhar @yugabyte-ci