Audit and Repository Database Requirements

[tgetty]

I am creating an environment that has 2 clustered Integration Servers. Each IS will perform core and audit logging to a database and the repository server will also write to a database. Can the core, audit and repository information be on the same db instance or should the repository have its own db instance?

Also, if I were to run 2 Integration Servers on the same machine, would I need to have a db instance for core and audit logging for each IS or could they share one instance?

Thanks
Troy

[Uday_Dhanista]

Can the core, audit and repository information be on the same db instance or should the repository have its own db instance?

>> I dont see a reason why repo tables and core audit tables cannot be on the same database instance.
fyi - I have seen the file based repo server to have a better performance than the RDBMS based repo server.

would I need to have a db instance for core and audit logging for each IS or could they share one instance

>> We are able to point three IS servers (clustered) to the same instance of the audit database without any errors. I am not sure if this answers your question.

[jbraunstein]

1--They can be on the same database and schema as well, but probably should not for manageability and potentially I/O performance

2-- All your IS should point to 1 centralized AuditLog Db.