|
Sort Order:
We believe that at least some of our abysmal performance issues may be traced to using HSQLDB in FishEye+Crucible, and would love to be able to move to a more robust database. Also note that we are forced to stop Fisheye/Crucible nightly for backup purposes because of the use of hypersonic. I don't understand why this is so low on the priority list Thank you Peter, glad to see this has been escalated and planned for 1.6.1. Thanks! Sorry to get your hopes up, it was especially annoying me that this had still not been done when I (somewhat prematurely) pushed it to a point release. Reality has unfortunately prevailed and I'm forced to move this out to a major release. Appologies again for the false hope had a pretty significant failure of the HSQL DB (support request CRC-369), and having to use a separate backup procedure for this one app vs the rest of the product suite is kind of painful. Glad to see it coming soon I attach some 'extra motivation to get this done'. A Yourkit profile of our Fisheye/Crucible installation here at Aconex that has a single user request thread after clicking on "Default Projects". Horrific HSQL computation ensures, and pretty much grinds the Fisheye installation to its knees. Please help, asap, we are forced to shutdown and restart often to get this back in working order. Note we have split this JIRA into two Any chance we can throw an Enterprise database in there? DB2? Why not just use hibernate and be done with it. that way pretty much any db is supported. We are BT are a big oracle house, so crucible with all source code being managed and being reviewed for 20,000+ developers doesnt really cut it with hsql. 20,000! It's bad enough with just 15... :-D Thank you! Looking forward to 2.0. Hi I want to know any specified date when we can expect crucible to support external database such as MYSQL, MSSQL Server or Oracle. Crucible only support in-memory database which is big problem with this tool to fit in organization with 500-1000 users. in-memory database uses server machine's RAM memory and also needs processing / computational speed. Multithreading ability of HSSQLDB is still under question. even when only single user uses Crucible and if we want to do review from JIRA, Crucible hangs and abnormally terminates. Thanks in advance for your answers. Hi Rahul, We understand the limitations of our in-memory database and agree that it can hamper scalability. As you pointed out, we have addressed this issue in 2.0, which will offer support for MySQL, PostgreSQL, as well as the built-in HSQLDB. Crucible 2.0 comes with functionality to migrate the entire database from one database to another, through the admin section, at runtime. The release is currently in beta (you can get a taste of the FishEye and Crucible by browsing the public instance at: http://ah-db04.managed.contegix.com/ Our release date is 30th of June, but we will be making a public beta release available for download after the weekend (1st of June). cheers, Please tell me you left UDB/DB2 out of the list of supported databases in error. I do not know many corporations that use mySQL or PostgreSQL in fully production environments... Starting off with just MySQL and PostgreSQL was a deliberate decision, but the work that has gone into decoupling Crucible from hsqldb will make it easier to add support for other databases in the future. To track or vote for Oracle support, see CRUC-1489. Given that the main issue has been performance, it is surprising Oracle wasn't included in the first release. It is also sad that you didn't poll the watchers of this issue, since I'm sure some of us are holding out for Oracle. Coupled with the fact that we don't get the source to roll our own builds, this is really disappointing. I will comment on the DB2 support and vote for it... however: The database is using a Hibernate model is it not? It should be simple to get the SQL statements to be DB2 (do not know enough about Oracle to comment) compatible. This is a great document from IBM that gives you the "101" treatment for mySQL to DB2 migrations. It deals with DB2 Express, so some limitations it mentions in Db2 are not there in the real thing. I have this one bookmarked, but I know there is one for mySQL to 'standard' DB2: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0602tham2/ hi Thanks Hi Rahul, To switch to either MySQL or PostgreSQL, choose the "Database Configuration" option in the admin screen:
I have few questions related to Crucible integration with SVN repository. Qusetion1 - Does Crucible support pre-commit to review the source files? Thanks |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
New Feature
Closed
Blocker
External database
. All the other Atlassian products support an external database. More over, the other Atlassian products clearly state that hypersonic should NOT be used for production use.
. 
An export/import facility of some sort should be made available to migrate data from internal to external storage in order to fully resolve this issue. Otherwise a lot of data will have to be re-entered.