Code Review / music / mdbc.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: bde93d7) | patch
Database issues with mdbc docker env 65/75065/2
authorRob Daugherty <rd472p@att.com>
Fri, 21 Dec 2018 15:39:47 +0000 (10:39 -0500)
committerBrendan Tschaen <ctschaen@att.com>
Wed, 2 Jan 2019 19:02:52 +0000 (19:02 +0000)
commitec36f7c8662d3a90e78d6c59d8d45e11dbce16ab
tree85352f3a584749932c28ab018c73a31124de42a1tree | snapshot
parentbde93d748fd26d3f0447a434b92009aa9f24ba7ecommit | diff
Database issues with mdbc docker env

Two problems:

The docker-compose scripts are pulling in an older version
of mariadb that doesn't have the JSON functions we need.
We can use 10.3.11, which is the latest stable release.

The DB user needs to have the SUPER privilege so that mdbc
can add database triggers.

Change-Id: Ic9b2daeb0196a2134f9260b39a41a4a10be01a06
Issue-ID: MUSIC-266
Signed-off-by: Rob Daugherty <rd472p@att.com>
mdbc-packages/mdbc-docker/compose/one-site/docker-compose.yml diff | blob | history
mdbc-packages/mdbc-docker/compose/one-site/volumes/mariadb/docker-entrypoint-initdb.d/01-create-test-database.sh diff | blob | history
mdbc-packages/mdbc-docker/compose/two-sites/docker-compose.yml diff | blob | history
mdbc-packages/mdbc-docker/compose/two-sites/volumes/mariadb/docker-entrypoint-initdb.d/01-create-test-database.sh 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.