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

Sun Jan 1 05:13:24 PST 2012

We moved to 5.1.44 with innodb plugin for the last week of exams, after performance issues earlier in the week.
I just moved to 5.1.60 with innodb plugin.

This is on Solaris 10. We have a Linux test system with newer hardware (and 10 Gbps iSCSI-based storage), which I intend to move to in Spring break. It's currently being used as our QA/test database. I think I'm going to move it to MariaDB/XtraDB. If that works, it will go into production at Rutgers at Spring break.

On Dec 21, 2011, at 12:04:36 AM, Earle Nietzel wrote:

> It would be nice if anyone that has used MariaDB could chime in.
> 
> I've heard a lot of not so good things about what Oracle has done to MySQL.
> 
> Also the original creator of MySQL has said that MariaDB is hands down faster MySQL, and that most of all the knowledgeable MySQL devs now work on MariaDB. He has also mentioned that they have to fix like 40% of the patches they get from Oracle because they don't know the inner workings of MySQL.
> 
> MariaDB is supposed to be a drop in replacement for MySQL 100% compatible.
> 
> Just would like to here from someone who has used it and what their experiences are?
> 
> Earle
> 
> On Tue, Dec 20, 2011 at 9:19 AM, Mike Jennings <mike_jennings at unc.edu> wrote:
> Steve,
> 
> That is what I thought, from other discussions on the list, ect.
> 
> Mike
> 
> On 12/19/2011 10:45 PM, Steve Swinsburg wrote:
> > 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
> >
> 
> --
> ==============================================================================
> 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
> _______________________________________________
> 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/20120101/1053e101/attachment.html 