hypermike
Contributor
Contributor

Is there a way to upgrade a hyperic server and point to an external DB

Jump to solution
Im currently running the postgreSQL 8.1 on a linux unbuntu system . I was asked to upgrade to the latest version of the hyperic server, BUT use a external MYsql database .

Is there a way to UPGRADE so I dont lose all my configuration alerts etc BUT use a EXTERNAL mysql DB. ????
0 Kudos
1 Solution

Accepted Solutions
ama_hyperic
Hot Shot
Hot Shot
The built in Database is PostGres.

View solution in original post

0 Kudos
7 Replies
ama_hyperic
Hot Shot
Hot Shot
there is no migration script from PostGres -> MySQL.
hypermike
Contributor
Contributor
Thanks I thought so . So I will lose everything.
0 Kudos
mattm_hyperic
Contributor
Contributor
How about built-in database migrate to using MySQL?
ama_hyperic
Hot Shot
Hot Shot
The built in Database is PostGres.
0 Kudos
mattm_hyperic
Contributor
Contributor
so is there an upgrade path from built-in DB to MySQL?
0 Kudos
JohnMarkOrg
Hot Shot
Hot Shot
There is no current upgrade path for this. However, there are migration tools that may or may not help you (we cannot vouch for them):

http://www.lightbox.ca/pg2mysql.php


Some people have also apparently found help with Apatar: http://solutions.mysql.com/solutions/item.php?id=441


YMMV. Let us know if they work. If the question becomes "what do I recommend" then that changes things significantly - I wouldn't recommend migrating to another DB architecture unless you really know what you're doing. Migrating to an outside postgres instance, however, should be rather trivial.

-John Mark
0 Kudos
hypermike
Contributor
Contributor
thanks
0 Kudos