Hi,
no problem, I appended it as a text file.
I use H2 as basis for my research
(http://www.informatik.uni-jena.de/~m4goan/).
We develope a multi tenant dbms and in this context we extend H2 by
- transaction latency monitoring
- resource usage monitoring at table level and schema level
- live migration between H2 instances
- asynchronous replication
- support for managing service level agreements (latency/throughput)
- a H2 proxy (extension of TCP proxy) for sharding / load balancing
adaptable online
Kind regards, Andreas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
SET LOCK_MODE 0;
CREATE SCHEMA IF NOT EXISTS MONITOR_SCHEMA2 AUTHORIZATION SA;
CREATE CACHED TABLE MONITOR_SCHEMA2.SLA(
SLA_NAME VARCHAR(100) NOT NULL,
METRIC VARCHAR(20) NOT NULL,
SCOPE VARCHAR(20) NOT NULL,
RATE_VALUE DECIMAL(4, 4),
ALL_SCHEMATA BOOLEAN NOT NULL,
ALL_TRANSACTIONS BOOLEAN NOT NULL,
CREATOR VARCHAR(100) NOT NULL,
CREATE_DATETIME DATETIME NOT NULL,
CATALOG VARCHAR(100) NOT NULL
);
ALTER TABLE MONITOR_SCHEMA2.SLA ADD CONSTRAINT MONITOR_SCHEMA2.CONSTRAINT_1
PRIMARY KEY(SLA_NAME);
CREATE CACHED TABLE MONITOR_SCHEMA2.MAP_SLA_TRANS(
TA_TYPE_ID BIGINT NOT NULL,
SLA_NAME VARCHAR(100) NOT NULL,
CREATOR VARCHAR(100) NOT NULL,
CREATE_DATETIME DATETIME NOT NULL,
CATALOG VARCHAR(100) NOT NULL
);
ALTER TABLE MONITOR_SCHEMA2.MAP_SLA_TRANS ADD CONSTRAINT
MONITOR_SCHEMA2.CONSTRAINT_DE9 PRIMARY KEY(TA_TYPE_ID, SLA_NAME);
INSERT INTO MONITOR_SCHEMA2.MAP_SLA_TRANS (TA_TYPE_ID, SLA_NAME, CREATOR,
CREATE_DATETIME, CATALOG)
VALUES (
SELECT 1 as TA_TYPE_ID,SLA_NAME,'TEST' as CREATOR, CURRENT_TIMESTAMP() AS
CREATE_DATETIME,'TPCC30' AS CATALOG
FROM MONITOR_SCHEMA2.SLA
WHERE ALL_TRANSACTIONS = 'TRUE' AND SLA_NAME != 'TENANT1_ONLYTWOTAS');
