Code Review / music / mdbc.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: 92a8013) | patch
Move trigger creation to startup 02/88302/2
authorTschaen, Brendan <ctschaen@att.com>
Wed, 22 May 2019 19:29:16 +0000 (15:29 -0400)
committerTschaen, Brendan <ctschaen@att.com>
Wed, 22 May 2019 21:54:42 +0000 (17:54 -0400)
commit97fe11b3e90ead341cecae5365340962c3896dea
tree66007ba353f7d1bc716580a9983bb22a0a176a8etree | snapshot
parent92a80130ba924dc7b101b978bdad1d0fba14b141commit | diff
Move trigger creation to startup

Change-Id: I0f06d0d704914299ff8dd6dbda2517fd7518507a
Issue-ID: MUSIC-396
Signed-off-by: Tschaen, Brendan <ctschaen@att.com>
mdbc-server/src/main/java/org/onap/music/mdbc/MdbcConnection.java diff | blob | history
mdbc-server/src/main/java/org/onap/music/mdbc/MdbcPreparedStatement.java diff | blob | history
mdbc-server/src/main/java/org/onap/music/mdbc/MdbcStatement.java diff | blob | history
mdbc-server/src/main/java/org/onap/music/mdbc/StateManager.java diff | blob | history
mdbc-server/src/main/java/org/onap/music/mdbc/mixins/DBInterface.java diff | blob | history
mdbc-server/src/main/java/org/onap/music/mdbc/mixins/MySQLMixin.java diff | blob | history
The most crucial recipe is a multi-site database cache (mdbc) that enable ONAP components that maintain state in a SQL database to avail the benefits of MUSIC without compromising their need to use transactional SQL DBs. These ONAP components can rely on existing db clustering techniques like MariaDB for transactionality and complex querying within a site. mdbc will intercept each of these read/write calls to the db cluster and mirror this state to other geo-distributed sites through MUSIC either synchronously or asynchronously (configurable at a table-level). For example, components like the ONAP Service Orchestrator that use MariaDB to maintain state can directly use this recipe with no change to their SQL code.