Can I use a cluster of online Drizzle servers, as a backup for a local Drizzle server?

Asked by Stuart on 2009-04-25

I want to be able to install a Drizzle database on a customers LAN, and have a cluster of Drizzle databases online that backs everything up in realtime. If the local Drizzle server fails, the data will still be accessible from the online databases.

When the local server is replaced, it automatically pulls all the data off the online servers.

Will Drizzle be suitable for this?

Question information

Language:
English Edit question
Status:
Answered
For:
Drizzle Edit question
Assignee:
No assignee Edit question
Last query:
2009-04-26
Last reply:
2010-04-11
Brian Aker (brianaker) said : #1

Hi!

I believe you are asking if you can use Drizzle on a Lan where the drive can be remounted on another host in the case of a failure?

While this can be done, we don't recommend Drizzle right now for production usage.

Stuart (stuart-stu) said : #2

Its more a question about how replication works. I want to write an application that uses a database that is accessible from any Internet connection. If the user so wishes, they can install a local database server on their LAN, for faster access times, and availability when the Internet is down. If the local database fails, the data is still available from the servers online.

Is it likely Drizzle can be made to work in this way in the future?

Brian Aker (brianaker) said : #3

Hi!

I don't see any reason why you couldn't do this. The transport for
replication won't be completed until August though.

Cheers,
 -Brian

On Apr 26, 2009, at 2:38 AM, Stuart wrote:

> Question #68732 on Drizzle changed:
> https://answers.launchpad.net/drizzle/+question/68732
>
> Status: Answered => Open
>
> Stuart is still having a problem:
> Its more a question about how replication works. I want to write an
> application that uses a database that is accessible from any Internet
> connection. If the user so wishes, they can install a local database
> server on their LAN, for faster access times, and availability when
> the
> Internet is down. If the local database fails, the data is still
> available from the servers online.
>
> Is it likely Drizzle can be made to work in this way in the future?
>
> --
> You received this question notification because you are a member of
> Drizzle-developers, which is an answer contact for Drizzle.

Vahaber (alphagoblin4) said : #4

reload your system
its help me

Can you help with this problem?

Provide an answer of your own, or ask Stuart for more information if necessary.

To post a message you must log in.