Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2009
    Posts
    4

    Question 2 Syncronized databases

    Hello,

    I didn't find any post here about it, cause I don't have the right definition.

    My question:
    I need to set 2 mechienes which both have databses from some kind.
    I also need to sychronize between these database servers (not with a script)
    with some build-in mechanism they have.

    My goal is to have a backup-server. which means, that if server_1 is down, server_2 will continue to work from the same point, and i will able to access it instead of server_1, and when server_1 comes up, they will syncronize automatically. Also they need to stay syncronized (in their data state) all the time.

    Any ideas? how it is called? does Mysql supports it?
    Is there any database which supports it?

    Thanks,

  2. #2
    Join Date
    Nov 2009
    Posts
    4
    Ok, MySQL Cluster is what I was looking for.

    Hope also helped other

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Nearly every database server offers some feature like what you've described.
    Microsoft also offers clustering, mirroring, and merge replication. Oracle offers RAC. DB2 offers clustering. Sybase offers several solutions, based on which database engine you're using.

    My experiences with MySQL clustering haven't been very good. I'd suggest that you at least review your other options before you make a commitment.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Nov 2009
    Posts
    4
    Ok, thanks for you reply!

    It will be kind if you can maybe answer my second question:
    What about working offline,

    If I would like to work offline with some SQL server, and when i get online, my application will execute all INSERT Queries.

    Do you know about any API that do that? virtual server on the client that can do that? or any buffer that can help?

    Thanks in advance!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •