CORR-E database arch

[andaks]

Hi to all. Wonder to know more about databases used in CORR.

1. What mysql database for?

     a) What kind of data stores there?

     b) How often do they change?

2. What postgres database for?

     a) What kind of data stores there?

     b) How often do they change?

3. Inno DB

I need complete information about these things. Or if smbd knows where to get this info.

Any help would be appreciated

[marioc]

Hi, did you ever got an answer ?

Thks

[bondarets]

Have you tried this:

?

[EricLamer]

Hi,

  I know that the mysql database is where the events, active list etc are stored, this is the main database, updated many many many times every seconds. I didnt find any indexes in the mysql database so I assume they are using special indexes.  I think postgres are the same as on the logger, its for internal logs.

  I was able to tweak mysql and access it remotely with a mysql database browser.