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.

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

[Colocation] Tables should be able to opt out of colocation #3102

Closed
ndeodhar opened this issue Dec 6, 2019 · 0 comments
Closed

[Colocation] Tables should be able to opt out of colocation #3102

ndeodhar opened this issue Dec 6, 2019 · 0 comments
Assignees
Labels
area/ysql Yugabyte SQL (YSQL)
Milestone

Comments

@ndeodhar
Copy link
Contributor

ndeodhar commented Dec 6, 2019

In a colocated DB, provide an option to CREATE TABLE so that large tables can opt out of using colocated tablet and create its own set of tablets instead.

@ndeodhar ndeodhar added the area/ysql Yugabyte SQL (YSQL) label Dec 6, 2019
@ndeodhar ndeodhar added this to the v2.1 milestone Dec 6, 2019
Zhongweizhao pushed a commit that referenced this issue Dec 21, 2019
Summary:
Expand grammar for create colocated db/table
```
CREATE DATABASE ... WITH colocated = true | false
CREATE TABLE ... WITH (colocated = true | false)
```

Creating a colocated database will create a dummy table and a tablet. Every table in the database will share this tablet. Creating a table in a colocated database will make this table colocated by default. User can specify colocated = false to opt out using the colocated tablet

Next step is drop flow and truncate flow.

Test Plan:
`ybd --java-test org.yb.pgsql.TestPgRegressFeature`
`ybd --cxx-test pgwrapper_pg_libpq-test --gtest_filter PgLibPqTest.TabletColocation`
`ybd --cxx-test create-table-itest --gtest_filter CreateTableITest.TabletColocationRemoteBootstrapTest`

Reviewers: neha, mihnea, hector, jason

Reviewed By: hector, jason

Subscribers: bogdan

Differential Revision: https://phabricator.dev.yugabyte.com/D7608
@ndeodhar ndeodhar closed this as completed Jan 7, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL)
Projects
None yet
Development

No branches or pull requests

2 participants