[TriLUG] MySQL service

[Cristóbal Palmer]

On Thu, Jun 5, 2008 at 5:53 PM, Paul G. Szabady <paul at thyservice.com> wrote:
>
> Thanks for the advice, but it doesn't help in this case.  We do and will
> continue to use oracle, however, we have a growing number of requests to
> support mysql.  Lots of open source (LAMP) applications are built around
> mysql, not oracle.

Which is one of the reasons we have a lot more MySQL than PostgreSQL
at ibiblio. That doesn't mean we don't have our share of MySQL-related
headaches. This bit us recently, for example:
http://bugs.mysql.com/bug.php?id=4541

Any particular reason you haven't considered PostgreSQL? Just not
familiar with it?

> We currently have five standalone mysql servers for a variety of apps.
> I want to build a solid infrastructure and move these five to it and
> have the ability to support future growth.

We at ibiblio don't do clustering. We do use zmanda for some backups:
http://www.zmanda.com/

We'd be interested to hear back from you about how you end up
structuring your cluster if you do move to it, but honestly ibiblio
can't and won't pay for MySQL Enterprise.

--
Cristóbal M. Palmer
http://tinyurl.com/3apraw "They also abandoned other volumes, later,
while fleeing from the librarians."