2 Replies Latest reply on Dec 3, 2015 4:45 AM by bhautik

    McAfee ePO DB replication

    bhautik

      Techies,

       

      Please recommend and share your views on the following.

       

      We have requirement to replicate our existing ePO database which is on SQL server to one of our remote location, here we will be providing fresh VM with same SQL version as to primary.

      We need to replicate the DB every night. The purpose of this design to run InfoSec queries for our corporate security team (the same queries can't be run on production as in past we had lots slow response issue with InfoSec queries and script hence this design came in mind)

       

      Now the question is if I install same version of ePO server (different name / IP) on that VM and attached DB will that solve this purpose as I am not sure on that.

      Is there any other method to access the replicated DB through other ePO server? Also this new configuration should not be reflect or support any production client.

       

      Any idea thoughts please share..

        • 1. Re: McAfee ePO DB replication
          tkinkead

          First, if you're running the DB server on VM, why not add some memory and a vCPU or two?  We run a lot of clients through our ePO server (20k+) and we've never had a performance issue running large queries against it.  It'd be a lot cheaper in time, effort, and complexity to just beef up your DB system.

           

          How does your security team do their queries?  Do they create queries and reports in ePO, or do they run queries directly against the database?  If they do it in ePO, can you schedule those reports and queries during off-hours and e-mail the results to the InfoSec team? 

           

          If they run directly against the database, you can automate replicating the database to a remote server and mounting that database, and then your InfoSec team can run queries directly against that DB.  Make sure you test the size of your database, though.  I think mine is approximately 40 GB, and if you're putting that across a WAN every night, that could cause other issues.

          • 2. Re: McAfee ePO DB replication
            bhautik

            Thanks tkinkead.

            The upgrade of existing infra scheduled to next year - not sure when.

            The security Team runs multiple queries from ePO console and from SQL as well. and we have automated so many things in ePO so we have performance issues as well.

             

            So I have doubt that if I setup additional ePO server (will not be register to primary ePO) then is it possible to access that replicated DB so InfoSec team can access and run query on ePO and DB on their schedule ?