External database questions

  • 1
  • Question
  • Updated 5 years ago
  • Answered
We have a locally hosted Hive Manager VM currently using the embedded postgresql server. We're wanting to migrate to using an external database server. Several questions:

1) can we use a non hivemanager image as the basis for our external database? Ideally, we could set up the database ourself on bare metal on our own server hardware (i.e., not an appliance).

2) What is the process for migrating from a locally hosted database to one that is external? From the documentation, it hints that it will migrate existing data automatically, but it never actually comes out and says that.

Thanks in advance!
Photo of Nathan Johnson

Nathan Johnson

  • 2 Posts
  • 0 Reply Likes

Posted 5 years ago

  • 1
Photo of Jade Rampulla

Jade Rampulla

  • 36 Posts
  • 1 Reply Like
I haven't setup an external database, but from my understanding of the documentation and conversations with Aerohive support, the intention of using an external database is to configure a 2nd Hivemanager VM with only database services. This would be done for performance purposes so a single VM isn't doing all the heavy lifting. I'm not aware of a method to use your own DB server - PostgreSQL, MySQL, Oracle, etc.
Photo of Sam

Sam

  • 120 Posts
  • 31 Reply Likes
Nathan,

The only configuration that is supported right now is a 2nd Hivemanager VM.

May we ask why you want an external DB server?
Photo of Nathan Johnson

Nathan Johnson

  • 2 Posts
  • 0 Reply Likes
We are hitting some pretty high i/o waits with the VM that has the embedded database, and typically in our organization we deploy database servers bare-metal anyway. Also, we are currently doing queries against the database until the API is released to extract some reporting data, so if we could have some more control over the database, it would give us more flexibility in what we're able to do. Also It would be nice to have PostgreSQL installed on a beefy machine with fast disk i/o, and also it would be nice to have more control would allow us to handle automated backups, tie into our health monitoring system we use elsewhere in the organization, etc.
Photo of Sam

Sam

  • 120 Posts
  • 31 Reply Likes
Nathan I'll get this entered into our feature request system. (No guarantees) But that way PLM can track it.