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

Add storage for additional information about instance added by user on console. #1257

Open
1 of 5 tasks
fabian4 opened this issue Sep 20, 2023 · 2 comments · May be fixed by #1262
Open
1 of 5 tasks

Add storage for additional information about instance added by user on console. #1257

fabian4 opened this issue Sep 20, 2023 · 2 comments · May be fixed by #1262
Labels
enhancement New feature or request

Comments

@fabian4
Copy link
Contributor

fabian4 commented Sep 20, 2023

What is the feature you want to add?

  • add storage for additional information about instance added by user on console.

Why do you want to add this feature?

How to implement this feature?

@fabian4 fabian4 added the enhancement New feature or request label Sep 20, 2023
@fabian4
Copy link
Contributor Author

fabian4 commented Sep 20, 2023

database struct design (mysql) for additional instance info.

new table instance_console

-- --------------------------------------------------------
--
-- Table structure `instance_console`
--
CREATE TABLE `instance_console`
(
    `id`                  VARCHAR(128)                  NOT NULL COMMENT 'Unique ID',
    `isolate`             TINYINT(4)                    DEFAULT NULL COMMENT 'Example isolation status flag, 0 is not isolated, 1 is isolated',
    `weight`              SMALLINT(6)                   DEFAULT NULL COMMENT 'The weight of the instance is mainly used for LoadBalance, default is 100',
    `metadata`            LONGTEXT COLLATE utf8_bin     DEFAULT NULL COMMENT 'Instance metadata',
    `flag`                TINYINT(4)                    NOT NULL DEFAULT '0' COMMENT 'Logic delete flag, 0 means visible, 1 means that it has been logically deleted',
    `ctime`               TIMESTAMP                     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Create time',
    `mtime`               TIMESTAMP                     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last updated time',
    PRIMARY KEY (`id`),
    KEY `mtime` (`mtime`)
) ENGINE = InnoDB;

@fabian4 fabian4 linked a pull request Sep 26, 2023 that will close this issue
11 tasks
@fabian4
Copy link
Contributor Author

fabian4 commented Oct 11, 2023

  1. add new table to store additional instance info.
  2. cache the data changed by user in web console separately.
  3. combine the data when needed from service.
  4. split it to cache when user added or updated additional instance info in web console.

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant