[Building Sakai] MySQL or HSQLDB

Warwick Chapman warwickchapman at gmail.com
Wed Mar 17 23:01:55 PDT 2010


Thanks all.  I will be installing on Debian 5.0.4 and I will be configuring
with InnoDB as is only responsible if one doesn't want irrecoverable tables.

On Wed, Mar 17, 2010 at 11:35 PM, Mark Norton <markjnorton at earthlink.net>wrote:

> If you happen to be installing MySQL on Windows, the install wizard will
> give you the choice of database. Innodb is the right one.  I also have used
> MySQL for years doing Sakai development work.
>
> - Mark Norton
>
> Anthony Whyte wrote:
>
>> I also use MySQL as my development database.  Be sure to choose Innodb as
>> your default database engine since it provides transaction support, foreign
>> key support, row-level locking, etc.  You can specify Innodb as your default
>> engine by creating a /etc/my.cnf file (example below):
>>
>>  ------------------------------------------------------------------------
>>
>>
>>
>> Cheers,
>>
>> Anthony
>>
>>
>>
>> On Mar 17, 2010, at 7:19 PM, Aaron Zeckoski wrote:
>>
>>
>>
>>> HSQLDB does not support transactions or multiple connections. I always
>>> use mysql for development.
>>> -AZ
>>>
>>>
>>> On Wed, Mar 17, 2010 at 5:08 PM, Warwick Chapman
>>> <warwickchapman at gmail.com> wrote:
>>>
>>>
>>>> Hi All
>>>> Following on from my previous mail "Install 2.7", I see there is an
>>>> option
>>>> to use MySQL or other DBMS instead of the default HSQLDB.
>>>> I come from a LAMP(ython) background and am more familiar with MySQL
>>>> than I
>>>> am with HSQLDB.
>>>> Other than familiarity, ss there any reason to use MySQL instead of
>>>> HSQLDB?
>>>> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
>>>> _______________________________________________
>>>> sakai-dev mailing list
>>>> sakai-dev at collab.sakaiproject.org
>>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>>
>>>> TO UNSUBSCRIBE: send email to
>>>> sakai-dev-unsubscribe at collab.sakaiproject.org
>>>> with a subject of "unsubscribe"
>>>>
>>>>
>>>>
>>>
>>> --
>>> Aaron Zeckoski - Software Engineer - http://tinyurl.com/azprofile
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>>
>>>
>>>
>>>
>>>
>>
>>  ------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100318/1e7eb66a/attachment.html 


More information about the sakai-dev mailing list