Grouper Users - Open Discussion List

[Chris Hyzer <>]

Well, you need something non-myisam.  Grouper is used on mysql more than 
postgres, so that is a plus for mysql, but it supports both, so whatever your 
institution can support better.


Thanks,
Chris

-----Original Message-----
From: Dirk Kastens 
[mailto:]
 
Sent: Tuesday, June 15, 2010 3:01 AM
To: Chris Hyzer
Cc: 

Subject: Re: [grouper-users] RE: Unix GID's in Grouper

Hi,

> Grouper assumes that you use a transactional database.  Are you using mysql 
> with myisam or other nontransactional tables perchance?
>
> http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html
>
> I hope to implement this jira soon (1.6.1?), which will save us all some 
> time by detecting on startup if the DB is transactional.
>
> https://bugs.internet2.edu/jira/browse/GRP-355
>
> Anyways, if this is the case, if you switch to innodb tables or something 
> else that is transactional, it should start working... :)

I'm using MyISAM tables. The problem is, that I'm using our central 
MySQL server which only supports MyISAM. That's what the administrator 
says. So you think it's better to create a standalone database for 
grouper? Do you would prefer postgreSQL over MySQL?

Dirk