Slashdot Mirror

← Back to Stories (view on slashdot.org)

High Availability Solutions for Databases?

Posted by Cliff on from the in-search-of-redundancy dept.

An anonymous reader asks: "What would be the best high availability solution for databases? I don't have enough money to afford Oracle RAC or any architecture that require an expensive SAN. What about open source solutions? MySQL cluster seems to be more master/slave and you can lose data when the master dies. What about this Sequoia project that seems good for PostgreSQL and other databases? Has anyone tried it? What HA solution do you use for your database?"

4 of 83 comments (clear)

  1. Do your own by clockwise_music · · Score: 1, Funny

    Just use .NET's XML serialisation on a DataSet to use an offline file a high availability server which has a RAID-5 array. Ok... so that's not really high availability, simple or really sensible but it would be a bit of fun.

    How about you have a few Access .mdb files (created using Jet, it's free) updated asynchronously using a few COM objects in Transaction Server? Well, it wouldn't work but the idea is pretty cool. Well actually it isn't really but you know.

    Or just write down all of your data, photocopy it and give the copy to your Mum (that's Mom, to all you yanks.. (why are you called "yanks"?)). And let's face it, your Mum, oops sorry Mom, is always itching for your phone call. Maybe you should call her more often?

    It's ok, I think I'm hilarious but know I'm not.

  2. Oh that's easy... by ipoverscsi · · Score: 2, Funny

    It's called a filing cabinet. It's got full text search and an easy to use index. Although it has 99.9999% availability (it's blocked by crap stacked in front of it the other 0.00001%), it's a bit difficult to make backups without access to the office copier, two toner cartriges and 20 boxes of paper.

  3. MOM - Motherly Object Model by ACORN_USER · · Score: 3, Funny

    A typical transaction:
    Phone: Ring Ring
    Son: BEGIN TRANSACTION!
    Mum: Oh, hi dear. How have you been? Did you know that ..
    Son: *cough* Work, remember?
    Mum: Yes, dear.
    Son: WRITE_DOWN into notepad ADDRESSES. fname='John'. sname='Smith'
    Mum: Wait, i have to look up the next identity number thingie. Oooh, that's a big number, I can't even recite it.
    Son: Hush! address='12 Rover Roa..
    Mum: Oh, dear. My pencil broke.
    Son: Ok, Roll back!
    Mum: That's fine for you to say. I don't have any erasers.

  4. Re:MySQL Cluster != master/slave by duffbeer703 · · Score: 2, Funny

    MySQL was prone to massive data loss for years... what's the big deal?

    --
    Conformity is the jailer of freedom and enemy of growth. -JFK