Re: Reg- CCDB and UAADB model

Gowrisankar M

Thanks Filip for the information for UAA DB. Any idea on Cloud controller
DB (postgresSQL) design ? documetation ?

On Thu, Jul 20, 2017 at 9:26 PM, Filip Hanik <fhanik(a)> wrote:

UAA DB is nothing special. We like to keep it simple.
We don't use foreign keys to simplify migration scripts.
We support four different database types, HSQLDB, MySQL(MariaDB),
PostgreSQL and SQL Server.

We made a choice to store some data in JSON format in text or clob
columns. We do this for data we don't want to query and index.

The UAADB is really a very small database, there isn't much to it. The one
thing we are considering reworking is data that is frequently deleted based
on time expiration. MySQL performance is really bad for large transactional
deletes and it can cause hiccups and consume both locks and CPU.

We use Flyway for database migrations between versions.


On Thu, Jul 20, 2017 at 8:49 AM, Gowrisankar M <gowrisankarbeece(a)
Hi Colleages,

I am trying to understand CCDB/UAADB design . Can somebody share some
link for the db design of uaa/cc

BRs, Gowrisankar

Join { to automatically receive all group messages.