Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: Database Redundancy

    My company has valuable data being constantly logged to a database 24/7. Actually, the data logs to two separate database systems in case one goes down for whatever reason such as power failure, routine maintenance, glitch, whatever. These two systems are housed at different physical locations.

    We are planning to set up a third database system which polls the other two every minute. It compiles and mantains a deduped, clean, and complete collection of data from the other two database systems. If one of the first two systems goes down or misses a row, the third will automatically get the data from the other system. If this deduped database system goes down, we can rebuild the data from the other two.

    Does this seem like the right route to take or is there a simpler or safer route available?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Talking about safer is to pay the bill (add $50 administrative fee + 15% of outstanding balance per day past due). It's also simpler to present your data the way it should be presented, - SPAM targets, many of which are email addresses of many participants of this forum that would appreciate this SPAM to stop. Anybody else sees any value in this kind of data?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Huh? SPAM? Administrative fees? What???
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    rdjabarov seems to go ballistic every time RogerWilco posts... I'd write that one off as a lover's quarrel myself.

    -PatP

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Well, that's a relief. I thought it was just me...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Hmmm, interesting observations

    I don't go ballistic, I just hate when people like Kurt display that level of immaturity by trying to avoid to pay for the services that were provided.

    I went out of my way, thinking that if someone needs help I will go an extra mile just because I am that kind of person.

    His case was not disasterous, he is a smart guy, a very good programmer, but definitely lacks maturity and ethics when it comes to business.

    He continues showing up here and hopes for a free help while capitalizing on strategy that I presented to him, for which he should pay, right? Or am I the only one thinking that our services (if asked for) are not free? After all, that WAS the initial agreement...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    So you had a business agreement with him? What's the SPAM stuff all about?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by rdjabarov
    I don't go ballistic, I just hate when people like Kurt display that level of immaturity by trying to avoid to pay for the services that were provided.
    I'd say that was open to debate.
    Quote Originally Posted by rdjabarov
    He continues showing up here and hopes for a free help while capitalizing on strategy that I presented to him, for which he should pay, right? Or am I the only one thinking that our services (if asked for) are not free? After all, that WAS the initial agreement...
    That might well be another story. I don't have any clue about what private agreements might exist between you two, so I can't comment on them. All I know is that everytime RogerWilco posts, it appears to me that you promptly go off the deep end.

    I simply don't respond to RogerWilco's posts anymore. I don't need the aggrivation.

    -PatP

  9. #9
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Quote Originally Posted by blindman
    So you had a business agreement with him? What's the SPAM stuff all about?
    That's what his "company" does, - SPAM. His "valueable" data is millions and millions of people's personal info, including emails and addresses, that they are getting from somewhere. As I said, he is a very good programmer, writes his own parsing and processing engines (C++), and manages to get by with more-or-less decent T-SQL stuff. When he asked for help I spent most of the weekend visiting his site and presenting to him some conceptual changes in his infrastructure that will facilitate more efficient processing of this huge bulk of data. Before and shortly after my visit I received about a dozen of emails from him discussing all that, and after the visit received a "thank you" note from him and his boss, saying that "the payment will be made promptly."

    Well, my question to him is "WHERE THE HECK IS IT?"

    And Pat, if you can't comment (as you wrote yourself), - then DON'T I definitely didn't ask for your opinion.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  10. #10
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by rdjabarov
    And Pat, if you can't comment (as you wrote yourself), - then DON'T I definitely didn't ask for your opinion.
    I don't believe that I commented on your private arrangements, only on my perception of your public (on this forum) behavior.

    -PatP

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I am afraid I didn't ask for your perception either. Making the first post for the guy's question and asking him to pay his bill is not indicative of "public behavior" you're incinuating.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    rdjabarov, i can understand how you feel, i've been stiffed before too

    however, this site is not the place for you to raise the issue

    anybody else besides me feel that it would be a good idea to purge the whole thread?

    somebody, please, click on that little exclamation mark, and it's gone...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    OK, I am all for it, just don't be so eager to answer his questions. He can actually fake his way through whatever problems he has on his own
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  14. #14
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Ok, you can call him spammer scum, but DUDE! YOU HELPED HIM!

    I can see why you want to get paid. Full-body disinfection can't be cheap. Then there is the truckload of margaritas required to get the bad taste out of your mouth, not to mention paying a monastery full of monks to pray your soul out of purgatory. Cost of business, sure, but it all has to add up...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  15. #15
    Join Date
    Oct 2003
    Posts
    268
    Robert!! You have my email and cell phone number and until now you never mentioned payment problems or any dissatisfaction in dealing with me. You really should have mentioned this to me in private rather than like this on a public forum.

    I emailed our accountant to arrange payment for 8 hours worth of work (this was all several months ago); if that didn't happen I assure you it was a purely unintentional mistake and it will be corrected PROMPTLY!

    I'm going to continue this discussion with you in private as it's really inappropriate here.

    I'd like to stress that I really do appreciate the help that I get here. This forum is designed on a free basis but honestly much of the help that I get here is very valuable and would be worth paying for. If I owned the business I would give bounties on every useful answer I got but it's hard to sell those kinds of idead to my boss.

    It's not that I'm not willing to pay for help; I work in a technical architect/team lead role. Getting management approval for funds for outside help is difficult even though I am a strong proponent of doing so.

    Quote Originally Posted by rdjabarov
    Hmmm, interesting observations

    I don't go ballistic, I just hate when people like Kurt display that level of immaturity by trying to avoid to pay for the services that were provided.

    I went out of my way, thinking that if someone needs help I will go an extra mile just because I am that kind of person.

    His case was not disasterous, he is a smart guy, a very good programmer, but definitely lacks maturity and ethics when it comes to business.

    He continues showing up here and hopes for a free help while capitalizing on strategy that I presented to him, for which he should pay, right? Or am I the only one thinking that our services (if asked for) are not free? After all, that WAS the initial agreement...

Posting Permissions

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