1 Reply Latest reply: Oct 6, 2014 12:35 PM by John Daigle RSS

    If RH Server's database goes down, does RH Server go down also?

    kdeuler Community Member
    kdeuler Oct 6, 2014 11:51 AM

      Hi experts. I've a couple RH Server questions:

       

      1. Supposing RH Server's database fails, or at least it's connection to the database fails. What would be the consequences. That is, would RH Server crash and not serve up anything. Or, would it simply be that reports are no longer accessible, etc.
      2. Has anyone used RH Server (installed on a Win 7 system) connected to a SQL Server Express instance (installed on another Win 7 system to spread CPU load).

       

      My IT Manager is very leery of the free database option (for performance/reliability reasons), but there's no way we're going to spend almost 20K$ on SQL Server or Oracle DB. So, I'd like to allay his concerns about the SQL Service Express option.

       

      Thanks in advance.

       

      -Kurt

      • 19 Views
      • Tags:
        • 1. Re: If RH Server's database goes down, does RH Server go down also?
          John Daigle CommunityMVP
          John Daigle Oct 6, 2014 12:35 PM (in response to kdeuler)
          1. Rh Server *is* a database-driven application and as such it requires a database be up and working for both serving content as well as reporting.
          2. Your IT person raises good points. I have used the "SQL Express" version without issues. As your IT person already knows, there are certain Microsoft connection and size limitations on its use. Otherwise it would be better than Access and assuming it fits the other DB/OS combination requirements I noted in the links above.
          3. Unless something has changed, the open-source Apache Tomcat Server itself does not support "Load Balancing" and so I don't think you can "spread the CPU load". Although I am not that network savvy, so a call to Adobe support (asking to be escalated for Rh Server-specific assistance) to verify this would be a good idea. That said, I know organizations that have set up "fault tolerance" configurations to their satisfaction (but can't be more specific than that.)


          Thanks

          John Daigle

          Adobe Certified RoboHelp and Captivate Instructor

          Evergreen, Colorado

          303-670-8955

          www.showmethedemo.com