[Building Sakai] MySQL or HSQLDB

Mark Norton markjnorton at earthlink.net
Wed Mar 17 14:35:10 PDT 2010


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"



More information about the sakai-dev mailing list