topic Re: Alfresco with Oracle/TDE enabled in Alfresco Forum

Alfresco with Oracle/TDE enabled

bigs4321 — Thu, 30 May 2019 20:57:53 GMT

Hi,I am planning on turning on TDE (Transparent Data Encryption) in Oracle. Has anyone already implemented this with Alfresco and have any issues/performance issues arisen?Thanks,Colin.

Re: Alfresco with Oracle/TDE enabled

angelborroy — Fri, 31 May 2019 09:33:09 GMT

According to this benchmark, TDE has impact in performance for any use case:

Oracle Transparent Data Encryption (TDE) performance benchmark test

When using Alfresco, the main part of the database load is focused in ALF_NODE and ALF_NODE_PROPERTIES. In fact, I guess you want to use TDE for ALF_NODE_PROPERTIES, where metadata is stored. Anyway, I don't see any problem for TDE derivated from this fact.

I didn't tested this configuration, but IMO it should work fine with Alfresco.

Re: Alfresco with Oracle/TDE enabled

bigs4321 — Fri, 31 May 2019 18:08:51 GMT

Thanks for the response. I had read that link and forwarded onto my peers. They were just curious if there was anyone in the Alfresco community who has implemented TDE and what their experience was.

My understanding is what you said, this should be transparent to Alfresco and the overhead, if any will be on the encrypting/decrytping, etc.

Thanks again!