Skip to main content

which is the best database which i could use with gf cluster?

4 replies [Last post]
freeq1986
Offline
Joined: 2008-12-28

Hi again!
I successfully configured loadbalancing for ejb app deployed in cluster (with your support ;)). Since now i have been using 1 mysql server but i want to change that. I want to use some db which supports clustering, i have read that mysql is not the best choice for this purpose. Should I use oracle? Any ideas? Any advices how to start with it?

- michal

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
jwenting
Offline
Joined: 2003-12-02

Oracle is good but fairly heavy (and can be very costly, depending on the options and versions you buy).

It's also the industry standard for relational databases.

But what you should really do is adapt to what your customers are using.
If they have Oracle already up and running, telling them to use (for example) Sybase isn't going to go down well.

freeq1986
Offline
Joined: 2008-12-28

ok what im going to do is try to install mysql on each machine that belongs to cluster. Then configure replication.
some questions:
1. Is it a good idea? ;) Is there any chance it gonna work properly?
2. Configuring it like this brings question: if i change sth on SLAVE is it going to replicate to MASTER?
3. Does the replication work between slaves if master goes down?

wfay
Offline
Joined: 2006-05-05

> 1. Is it a good idea? ;) Is there any chance it gonna
> work properly?

What makes you think the Glassfish forum is the best place to ask specific questions about Mysql replication?? I'd find a Mysql forum or email list online somewhere and post your questions there...

David Van Couvering

That's a short question to a very long discussion. There are many ways
to move up to multiple database servers. One is clustering, but that's
a pretty heavy solution when you want to move from one database server
to say just two. There are lots of solutions out there, some you need
to implement yourself (e.g. sharding or using replication) and there are
a number of vendors out there (Continuent, HiveMind, HSCALE to name a
few) that will help to do this for you.

Oracle Cluster is another way to go, but I don't know if it's the right
solution. First of all, you do have to consider the licensing costs.
Secondly, I would be uncomfortable "getting into bed" with a
proprietary, closed-source solution - even if the licensing fees are OK
now, they could go up, and you will be stuck. There are a number of
current Oracle customers who complain about this bitterly. So I would
do this only as a last resort.

I recommend you do some research on scaling MySQL - there is a lot out
there and a lot (I mean a *lot*, including Digg, Facebook, and other
very large sites) have done this without ever going to Oracle.

David

glassfish@javadesktop.org wrote:
> Hi again!
> I successfully configured loadbalancing for ejb app deployed in cluster (with your support ;)). Since now i have been using 1 mysql server but i want to change that. I want to use some db which supports clustering, i have read that mysql is not the best choice for this purpose. Should I use oracle? Any ideas? Any advices how to start with it?
>
> - michal
> [Message sent by forum member 'freeq1986' (freeq1986)]
>
> http://forums.java.net/jive/thread.jspa?messageID=327083
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net