Open Source Network Monitoring and Systems Management - Anyone swap out MYSQL for a different...

Up to Discussions in zenoss-users

This Question is Possibly Answered

1 "correct" answer available (4 pts) 5 "helpful" answers available (2 pts)

3,227 Views 3 Replies Last post: Feb 8, 2010 5:11 PM by ZenKeck

ZenKeck

12 posts since
Jan 4, 2010

Currently Being Moderated

Feb 8, 2010 4:28 PM

Anyone swap out MYSQL for a different database?

We are thinking of using Oracle instead of MySql. If you have experience swapping these out, do you mind sharing that info with me?

It looks like you can use dbaccess base, DbConnectionPool.createConnection but I'm not sure where the user name, password etc is getting set.

In MySqlEventManager, there is this line

   backend = "mysql" ,  I'm assuming we could change that to Oracle?


Does Zope use property files or configuration files to set which DB is used and what the user name/passwords are?

file:///C:/Documents%20and%20Settings/skeck/My%20Documents/zenoss%20docs/api/Products.ZenEvents.DbConnectionPool.DbConnectionPool-class.html

Matt Ray

1,991 posts since
Apr 5, 2008

Currently Being Moderated

1. Feb 8, 2010 4:53 PM

in response to: ZenKeck

Re: Anyone swap out MYSQL for a different database?

As I confirmed via email, that's definitely the right area to get started on a DB port. Most of the work would be in the Products/ZenEvents directory. The queries are mostly in there and there are several MySQL-specific conversions of formats and query syntax that you'd need to fix. There have been questions about porting to PostgreSQL before, if anyone's interested there would probably be overlapping work.