[Building Sakai] Rutgers is now using innodb-plugin in production

[Steve Swinsburg]

Ah, that's why it is working (existing db). If you startup on a new database you will get failures when hibernate tries to create tables due to keywords and choosing the wrong column types et al.

cheers,
Steve



On 20/12/2011, at 1:50 PM, Mike Jennings wrote:

> We are using the
> 
> hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
> 
> BTW, this database was running on 5.1.x and imported to 5.5.x
> 
> Mike
> 
> On 12/19/2011 8:14 PM, Steve Swinsburg wrote:
>> Hi Mike,
>> 
>> What is your hibernate dialect?
>> 
>> cheers,
>> Steve
>> 
>> 
>> 
>> On 20/12/2011, at 11:41 AM, Jennings, Michael wrote:
>> 
>>> At UNC we are using MySql 5.5 Enterprises edition with Sakai 2.7.0
>>> without any issues so far.
>>> 
>>> We are also in the process of upgrading to 2.8.1 and things look good
>>> so far
>>> 
>>> Mike
>>> 
>>> Mike
>>> 
>>> 
>>> 
>>> -------- Original message --------
>>> Subject: Re: [Building Sakai] Rutgers is now using innodb-plugin in
>>> production
>>> From: Steve Swinsburg <steve.swinsburg at gmail.com
>>> <mailto:steve.swinsburg at gmail.com>>
>>> To: Hedrick Charles <hedrick at rutgers.edu <mailto:hedrick at rutgers.edu>>
>>> CC: "sakai-dev at collab.sakaiproject.org
>>> <mailto:sakai-dev at collab.sakaiproject.org> Developers"
>>> <sakai-dev at collab.sakaiproject.org
>>> <mailto:sakai-dev at collab.sakaiproject.org>>
>>> 
>>> 
>>> Any version pre 2.9 doesn't work too well but post 2.9 may be ok. YMMV
>>> though and it hasn't been QA'd or endorsed, only 5.1.
>>> 
>>> cheers,
>>> Steve
>>> 
>>> 
>>> 
>>> On 20/12/2011, at 11:14 AM, Hedrick Charles wrote:
>>> 
>>> > No. My understanding was that Sakai wasn't supported for 5.5.
>>> >
>>> > On Dec 19, 2011, at 6:46:05 PM, Robert Cohen wrote:
>>> >
>>> >>
>>> >> Did you evaluate mysql 5.5?
>>> >> From what I've read its supposed to have performance improvements
>>> over 5.1
>>> >> even with the innodb plugin.
>>> >>
>>> >>
>>> >>
>>> >> On 20/12/11 5:54 AM, "Charles Hedrick" <hedrick at rutgers.edu
>>> <mailto:hedrick at rutgers.edu>> wrote:
>>> >>
>>> >>> We've had two episodes of the database server going to 100%.
>>> Because some
>>> >>> of my tests have shown that innodb-plugin works better under some kinds
>>> >>> of load, we're moving to it. We also had a DNS problem that might have
>>> >>> contributed to this. It's been fixed, so if our problems don't come
>>> back
>>> >>> we may not be sure what caused it.
>>> >>>
>>> >>> We're using old versions of mysql 5.1, simply because we haven't wanted
>>> >>> to upgrade in the middle of the year, 5.1.44 with innodb plugin 1.0.6.
>>> >>> We'll probably be moving from our Solaris-based server to a server on
>>> >>> Linux running the newest 5.1, in late January. It's the final part
>>> of our
>>> >>> new Xenserver / iSCSI virtual architecture. After looking at
>>> various test
>>> >>> results I've decided to run the new system with hypertheading on.
>>> Innodb
>>> >>> plugin should deal with the multicore scaling problems sufficiently for
>>> >>> that to make sense.
>>> >>>
>>> >>> _______________________________________________
>>> >>> sakai-dev mailing list
>>> >>> sakai-dev at collab.sakaiproject.org
>>> <mailto: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
>>> <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of
>>> >>> "unsubscribe"
>>> >>
>>> >>
>>> >
>>> > _______________________________________________
>>> > sakai-dev mailing list
>>> > sakai-dev at collab.sakaiproject.org
>>> <mailto: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
>>> <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject
>>> of "unsubscribe"
>>> 
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> <mailto: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
>>> <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject
>>> of "unsubscribe"
>> 
> 
> -- 
> ==============================================================================
> Mike Jennings
> Teaching and Learning Developer
> University of North Carolina at Chapel Hill
> 
> Office: (919) 843-5013
> Cell: (919) 698-3746
> E-mail: mike_jennings at unc.edu