www-builds mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aristedes Maniatis <...@maniatis.org>
Subject more databases
Date Thu, 14 Jan 2010 10:35:38 GMT
Thanks to Tim, we now have SQL Server on the new Windows box which is great for testing. The
next step for proper automated testing of Cayenne (and some other database centric projects
who have also expressed interest), is to be able to test on these common dbs:

* mysql
* postgres
* oracle 10 (I'm pretty sure the free dev license is quite sufficient)
* sqlite

Maybe more later, but those would be a great start. Now infrastructure have a new database
server on the way sometime soon which will host the big databases behind Jira, Confluence,
etc. However I'm wondering whether it would be more suitable to host these databases on one
of the Hudson test machines.

I had previously attempted to do that within the Cayenne Solaris zone, but it was just too
hard to install software within the locked down zone. Something that would be trivial in Ubuntu
or FreeBSD.

I don't think I have access rights to allow me to install an rpm, so a Hudson admin would
have to do it. Would this be an appropriate use of these resources? Could we proceed to set
this up?  If so, I'll go create Jira tasks.

As for system resources:

* disk size: tiny (possibly measured in kilobytes for the data)
* databases: one per database engine for the Cayenne project (possible a couple more say if
we want myisam and innodb as two separate tests)
* CPU: tiny load once per test run, not more than once an hour
* memory: they will all sit there using up RAM just idling, but they could all be tuned for
a low RAM usage configuration since performance is not being measured as part of the testing.


Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A

View raw message