• Home
• io.shulie
• druid
• 1.2.5.6
• source code
• basic.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

support.monitor.mysql.basic.sql Maven / Gradle / Ivy

create table druid_domain (
	id bigint(20) AUTO_INCREMENT NOT NULL,
	domain varchar(45) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE INDEX (domain)
);

insert into druid_domain (domain) values ('default');

create table druid_app (
	id bigint(20) AUTO_INCREMENT NOT NULL,
	domain varchar(45) NOT NULL,
	app varchar(45) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE (domain, app)		  
);

insert into druid_app (domain, app) values ('default', 'default');

create table druid_cluster (
	id bigint(20) AUTO_INCREMENT NOT NULL,
	domain varchar(45) NOT NULL,
	app varchar(45) NOT NULL,
	cluster varchar(45) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE (domain, app, cluster)		  
);

insert into druid_cluster (domain, app, cluster) values ('default', 'default', 'default');

create table druid_inst (
	id bigint(20) AUTO_INCREMENT NOT NULL,
	app varchar(45) NOT NULL,
	domain varchar(45) NOT NULL,
	cluster varchar(45) NOT NULL,
	host varchar(128) NOT NULL,
	ip varchar(32) NOT NULL,
	lastActiveTime datetime NOT NULL,
	lastPID bigint(20) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE (domain, app, cluster, host)		  
);