On Jan 4, 2005, at 6:32 PM, Aristedes Maniatis wrote:
Are you talking about real clustering, or the master/slave type
support in mySQL?
Clustering is where the MySQL database appears as a single database but
is really setup to be multiple machines responding as one.
What I mean is, do you end up with only one master which has to
receive all the writes and others which are read only?
I think you're referring to "replication" here.
Replication basically "slaves" multiple mysql servers off one main.
You can read from any of the master or slaves, you can only write to
the master. This works well if you have a high ratio of reads to
writes.
Replication requires a lot of work on the WO side as WebObjects has no
clue about how to put writes to one address and reads to another. You
would have to do something that would segregate the write functionality
into one application and the read into another.
We looked at both. There are problems with both. They are different
and it really depends on what you're doing as to which is worse. In
our case, the issues with clustering where to unstable and problematic
for our particular needs.
Was your investigation of clustering for the purpose of improved
reliability or increasing performance?
Both. In particular we need high-availability and anticipate
high-traffic for our product.
BTW, one thing that is also significant is that you can go a LONG ways
along the performance curve by simply buying top of the line hardware
and investing in a single machine with a lot of power. With RAID and a
lot of redundancy in network/memory hardware, you can easily surpass a
bottom of the line clustering setup.
And, on the other end, you can invest in Oracle and one of their
clustered solutions and that will work quite well with WebObjects (or
as well as any other SQL database will).
Cheers
Ari Maniatis
On 05/01/2005, at 9:49 AM, Erik Walter wrote:
We approached MySQL and spent some time interacting with their
technical people. In the end we found there were too many problems
with the current version of MySQL clustering (4.1) to use it with
Java applications and especially WebObjects.
-------------------------->
ish group pty ltd
http://www.ish.com.au
7 Darghan St Glebe 2037 Australia
phone +61 2 9660 1400 fax +61 2 9660 7400
PGP fingerprint 08 57 20 4B 80 69 59 E2 A9 BF 2D 48 C2 20 0C C8
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
