USE cmon;
INSERT IGNORE INTO cmon_cluster_counters(id, var, enabled)  VALUES (1,'ABORTS','1'),(2,'COMBINED','1'),(3,'COMMITS','1'),(4,'OPERATIONS','1'),(5,'RANGE_SCANS','1'),(6,'READS_ALL','1'),(7,'SIMPLE_READS','1'),(8,'TABLE_SCANS','1'),(9,'TRANSACTIONS','1'),(10,'WRITES','1');

DELETE FROM cmon_mysql_counters;
DELETE FROM cmon_mysql_graphs;
DELETE FROM cluster_event_types;
INSERT IGNORE INTO `cluster_event_types` VALUES ('ArbitResult'),('ArbitState'),('CM_REGCONF'),('CM_REGREF'),('CommunicationClosed'),('CommunicationOpened'),('Connected'),('ConnectedApiVersion'),('CopyDict'),('CopyFragDone'),('CopyFragsCompleted'),('CopyFragsStared'),('Disconnected'),('FIND_NEIGHBOURS'),('GCP_TakeoverCompleted'),('GCP_TakeoverStarted'),('LCP_TakeoverCompleted'),('LCP_TakeoverStarted'),('LocalCheckpointCompleted'),('LocalCheckpointStarted'),('NodeFailCompleted'),('NODE_FAILREP'),('StartCompleted'),('StartPhaseCompleted'),('StartREDOLog'),('StopCompleted'),('StopStarted');
INSERT IGNORE INTO `cluster_severity_types` VALUES ('ALERT'),('CRITICAL'),('DEBUG'),('ERROR'),('INFO'),('WARNING');

INSERT IGNORE INTO `cmon_mysql_graphs` VALUES (1,'ABORTED_CLIENTS'),(2,'ABORTED_CONNECTS'),(3,'COMBINED'),(4,'CONNECTIONS'),(7,'CREATED_TMP_DISK_TABLES'),(8,'CREATED_TMP_TABLES'),(5,'THREADS_CONNECTED'),(6,'THREADS_RUNNING'); 
INSERT IGNORE INTO `cmon_cluster_graphs` VALUES (1,'COMBINED'),(5,'COMMITS'),(2,'OPERATIONS'),(4,'RANGE_SCANS'),(6,'READS_ALL'),(8,'SIMPLE_READS'),(3,'TRANSACTIONS'),(7,'WRITES');


delete from mysql_states;

INSERT IGNORE INTO mysql_states(id,name,description) VALUES(0, 'MYSQL_OK', 'OK');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(1, 'MYSQL_DISCONNECTED', 'MySQL Server is disconnected');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(2, 'MYSQL_REPL_LAG', 'Replication is lagging behind');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(3, 'MYSQL_REPL_FAILED', 'Replication is stopped');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(4, 'MYSQL_REPL_ACTION_NEEDED', 'Rebuild slave is needed');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(5, 'MYSQL_REPL_REBUILD_NEEDED', 'Rebuild slave is needed');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(6, 'MYSQL_REPL_REBUILDING', 'Rebuilding slave');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(7, 'MYSQL_REPL_REBUILD_FAILED', 'Rebuild slave failed - try again');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(8, 'MYSQL_REPL_FASTFORWARD', 'Skipping ahead to a good position - data will be lost');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(9, 'MYSQL_REPL_USER_STOPPED', 'User initiated stop of slave');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(10, 'MYSQL_REPL_RESUME_SLAVE', 'Slave can be resumed now');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(11, 'MYSQL_GALERA_FAILED', 'Galera failed on node');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(12, 'MYSQL_GALERA_NODE_RECOVERY', 'Galera node recovery needed');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(13, 'MYSQL_GALERA_CLUSTER_RECOVERY', 'Galera cluster recovery needed');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(14, 'MYSQL_GALERA_READ_ONLY', 'Read-only');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(15, 'MYSQL_GALERA_NODE_RECOVERING', 'Galera node recovery in progress');
INSERT IGNORE INTO mysql_states(id,name,description) VALUES(16, 'MYSQL_GALERA_CLUSTER_RECOVERING', 'Galera cluster recovery in progress');