We don't support MySQL Cluster at this time, as
it's currently limited in many
ways. (Everything must fit in memory, can't have certain field types, etc.)
What mediawiki code would need to be rewritten and has anyone tried to
do a cluster with the non-supported stuff as a regular InnoDB? Is it
just the blob stuff that's a problem? I was also just kind of curious
of what the game plan was on the horizon, if you were holding out
until MySQL added support in a later version or if other things were
eclipsing database stuff at the moment. What is the general consensus
on Oracle?
Thanks,
Chris
On 3/15/06, Brion Vibber <brion(a)pobox.com> wrote:
> chris muse wrote:
> > We have been looking into possibly setting up a MySQL cluster to avoid some
> > of the complexities of a master-slave environment. Does the mediawiki code
> > support MySQL clustering?
>
We don't support MySQL Cluster at this time, as
it's currently limited in many
ways. (Everything must fit in memory, can't have certain field types, etc.)
>
> > Also, how does wikipedia currently handle automatic
> > failover of a master-slave transition and then also later the slave-master
> > transition when the master comes back online?
>
> We currently handle failover manually by switching things around from the
> primary master to a standby. The previous master then gets cleaned up, put back
> into service as a slave, and is available as a standby for the next exciting
> failure.
>
> > what kind of monitoring do you to make sure everything is
> > in good health?
>
> Not enough; servmon is currently broken and offline.
>
> -- brion vibber (brion @
pobox.com)
>
>
>
> _______________________________________________
> Wikitech-l mailing list
> Wikitech-l(a)wikimedia.org
>
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
>
>
>