• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: OT: database clusering & failover
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: OT: database clusering & failover


  • Subject: Re: OT: database clusering & failover
  • From: Kieran Kelleher <email@hidden>
  • Date: Thu, 2 Nov 2006 14:26:02 -0500

Josh,

I have not used MySQL cluster, but it is explained well in the online docs. It requires at least a half-dozen computers or more to offer the redundancy that motivates its use. The advantage of a cluster is that a node in the cluster in the server can fail and at worst a couple of transactions get rolled back, but otherwise the cluster keep running with no downtime, major data loss and no subsequent data recovery downtime.

Standard replication requires 2 computers at least, provides data loss protection and is very very easy to set it up.

Here is updated replication setup instructions from my upgrade to 4.1 yesterday. Much easier now with version 4.1.
http://homepage.mac.com/kelleherk/iblog/C711669388/E20061027215152/ index.html


Anyway HTH,

-Kieran
________________________________________________________________
Blog: http://webobjects.webhop.org/
Dev Config = OS X 10.4.8 MBPro-Intel / Java 1.4.2_09 / WO 5.3.1 & P. Wonder / XCode v2.2.1 / MySQL 4.1.21-std / Connector-J 3.0.17
Deploy Config = WO on OS X 10.3.9 Server G4-PPC / Java 1.4.2_09 / WO 5.2.3 / Connector-J 3.0.17 / MySQL 4.1.21 on OS X 10.4.8





On Nov 1, 2006, at 1:15 AM, Joshua Paul wrote:

What solutions have people here used to deal with database or hardware failures? Has anyone tried or deployed using MySQL Cluster? If so, what pitfalls/hurdles did you encounter?

--
josh
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com


This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Prev by Date: Re: refreshing refetched objs
  • Next by Date: Re: OT: database clusering & failover
  • Previous by thread: Re: OT: database clusering & failover
  • Next by thread: creating WORequest multipart form content?
  • Index(es):
    • Date
    • Thread