user for DDL

1
2
3
4
5
6
7
8
9
10
11
12
13

-- Create the user
create user UMDB_DEV identified by "UMDB_DEV_2014"
  default tablespace DATSPACE
  temporary tablespace TEMP;
-- Grant/Revoke role privileges
grant connect to UMDB_DEV;
grant resource to UMDB_DEV;
-- Grant/Revoke system privileges
grant create any sequence to UMDB_DEV;
grant create any table to UMDB_DEV;
grant create any view to UMDB_DEV;
-- Grant/Revoke tablespace privileges
grant unlimited tablespace to UMDB_DEV;

user for DML

1
2
3
4
5
6
7
8
9
10

-- Create the user
create user umdb_dev_dml identified by "umdb_dev_dml_2014"
  default tablespace DATSPACE
  temporary tablespace TEMP;
-- Grant/Revoke role privileges
grant connect to umdb_dev_dml;
-- Grant/Revoke system privileges
grant create any synonym to umdb_dev_dml;
-- Grant/Revoke tablespace privileges
grant unlimited tablespace to umdb_dev_dml;

##启动oracle数据库

Kafka is a distributed streaming platform.

Zookeeper is a centralized service for maintaining configuration information, naming, providing distributed synchronization, and providing group services. All of these kinds of services are used in some form or another by distributed applications. Each time they are implemented there is a lot of work that goes into fixing the bugs and race conditions that are inevitable. Because of the difficulty of implementing these kinds of services, applications initially usually skimp on them, which make them brittle in the presence of change and difficult to manage. Even when done correctly, different implementations of these services lead to management complexity when the applications are deployed.

Vitess

OneProxy

Oceanus

MySQL Proxy

Heisenberg

Cobar is a proxy for sharding databases and tables