Welcome Guest! Log in


The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Solved Location of the log database

06 Jul 2016 18:13 - 07 Jul 2016 09:55 #1 by Josserand BRINON
Location of the log database was created by Josserand BRINON

We are installing a new runtime and we have noticed that there are several possible locations for the log database:
1- we can keep the initial configuration > internal DB on H2
2- we can use a "known" database > MS SQL Server in our case

If I'm right, the 2nd solution is safer for production environment, and generally recommended for any environment.

In that case, my question is :
Excepted the potential network issues, are there any inconvenients to locate the log database on a remote server?
I mean: runtime on server1 <--> log database on server2

Actualy, we want to avoid multiply Stambia log databases and, ideally, keep only one database per environment.
runtimeA-environment1 --> log database on serverA-environment1 (local)
runtimeA-environment2 --> log database on serverA-environment2 (local)
runtimeB-environment1 --> log database on serverA-environment1 (remote)
runtimeB-environment2 --> log database on serverA-environment2 (remote)

Please, let me know if I'm not clear.

Last edit: 07 Jul 2016 09:55 by Josserand BRINON. Reason: Precisions
07 Jul 2016 09:56 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Location of the log database

There is no other inconvenient than the potential network issues (stability and performance). Simply make sure your network architecture is adapted and monitored.

PS: also think about setting up purges - see www.stambia.org/doc/106-runtime/log/63-p...the-runtime-database
07 Jul 2016 10:03 #3 by Josserand BRINON
Replied by Josserand BRINON on topic Location of the log database
Ok, thank you Thomas :)