Cortex Agent and PostgreSQL Server

[kenlacrosse]

Has anyone installed a Cortex Agent on a high performance database server such as PostgreSQL?  We are reaching the point in our rollout where we will need to decide if this is something that we can do without negatively impacting the performance of our OLTP system during normal operations.  We are looking to find out what lessons other users of Cortex XDR can teach us without having to go through the same pain ourselves.  🙂

[bbarmanroy]

Hi @kenlacrosse this is a very subjective question and the answer to it is 'it depends'. Customers have deployed across different database standalone or cluster deployments with little to no issues. Given that each environment is unique, I recommend you to go ahead and deploy Cortex XDR in UAT and consider perform profiling as an added measure (e.g. disk I/O).  Once your team is satisfied with the performance, you can deploy it to Production environments.

[eluis · Accepted solution]

Hi @kenlacrosse ,

Apart from what @bbarmanroy mentioned which is a must to do in this cases.

I would also have a clear picture of your resources on that DB server before you deploy XDR. If in the production server you are almost up to the limit of resources, please just bear in mind that even XDR is designed to not to have much impact on your resources, it still some resources to work, and the more activity you have in your server, the more resources XDR might need to check and inspect all transactions, processes executing in the server ... 

Ive seen customers running already at 98% on their servers far way too much processes running so if XDR needs a bit of memory and a bit of CPU to check the behaviour of every process, the amount of resources increase and so the server can be overloaded. 

Keep an eye to have your UAT server as similar as the production server as possible. 

Hope this helps, 

Luis 

[Rodgerbarbara]

Cortex is the most sophisticated product in the market for highly automated migrations of Oracle databases to native PostgreSQL. In fact, migrating the business logic and combining this with all its dependencies between the Data and Code Objects makes Cortex unique. On average, Cortex is able to automatically migrate at least 80% of all the Oracle Code Objects to native PostgreSQL. Because we believe in database freedom, we always migrate Oracle databases to native PostgreSQL to avoid any vendor lock-in and to deliver maximum freedom of deployment on-premise and/or in the Cloud. facetime app