Najdorf HA Appliance and DB Setup

[bfilion05]

Hi All,

I am in the process of upgrading our current environment from Ivanchuk-2 to Najdorf 1.3 and am just doing a fresh install with new VMs. I am following the High Availability guide at https://www.manageiq.org/docs/reference/latest/high_availability_guide/index.html and now have 4 virtual machines (VMWare Vcenter) deployed with the ova on the download page. 2 are for the datatabase and 2 are for the appliances. I've gotten the appliances joined to the region (at least I believe I do), in the UI I am seeing 3 appliances/servers with 1 of those being the primary database. My question is, should I be seeing the database node listed in the default zone we have? Or should I be switching off some of the server roles that are currently assigned to the database node? I've attached a couple of screenshots for reference of what I am seeing. I am somewhat guessing that the database node should only have the database operations role selected? And maybe also need to de-select the database operations role from my 2 appliance nodes?

[jrafanie]

@bfilion05 servers you're seeing in the UI represent appliances that have started evmserverd against the currently configured database. If you started the evmserverd on the primary database node, then, that's why it's there. If you intend to have the primary and standby database nodes be standalone and not run the application, you probably intended to configure the database as a dedicated database server, see: https://github.com/ManageIQ/manageiq-appliance_console/blob/c62dfe86b7c8ea404f0ae09b7748c3c9af102499/lib/manageiq/appliance_console/internal_database_configuration.rb#L52

I think you can change this after to the fact by disabling the systemctl disable evmserverd and manually setting the shared buffers for a dedicated datbase, see: https://github.com/ManageIQ/manageiq-appliance_console/blob/c62dfe86b7c8ea404f0ae09b7748c3c9af102499/lib/manageiq/appliance_console/internal_database_configuration.rb#L168-L169

If you do want a dedicated postgresql database, you can then remove the "Server" entry in the UI that represents the database node.