Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Re: Twin interfaces, and one and a half databases to a project

by JPaul (Hermit)
on Aug 15, 2002 at 04:56 UTC ( [id://190301]=note: print w/replies, xml ) Need Help??


in reply to Re: Twin interfaces, and one and a half databases to a project
in thread Twin interfaces, and one and a half databases to a project

Greetings;

Basic information that, on reflection, would have been useful:
The machine is a Linux machine running Apache w/MySQL... The usual poor mans super-server.

As is my understanding, replication very specifically only works in one direction, master -> slave, and there's a very good reason for this. I'm hoping to perhaps argue him away from this model.
And, (unfortunately|fortunately), this man also happens to be very famaliar with databases, of many different brands.

His notion is for, I suppose, some form of physical security on data - credit card numbers may be stored in the database and he doesn't want the second, "Customer management", server to be able to ever know this information exists...
While I appreciate his paranoia in protecting his customers, the server that he has for his current inelegant management system runs SSH, qmail and Apache... Not what I would usually consider high-risk software packages. With this very limited opportunities for black-hat access, I see the data as being somewhat secure.

But of course, maybe thats why he worked at the PKI company and I never will?

JP,
-- Alexander Widdlemouse undid his bellybutton and his bum dropped off --

Replies are listed 'Best First'.
Re: Re: Re: Twin interfaces, and one and a half databases to a project
by dws (Chancellor) on Aug 15, 2002 at 05:59 UTC
    the server that he has for his current inelegant management system runs SSH, qmail and Apache... Not what I would usually consider high-risk software packages.

    I lost a home linux box to an SSH exploit, and I thought I had it pretty well nailed down, with a firewall that only let SSH and HTTP traffic in.

    My earlier advice stands. If you have senstive data, keep it on a separate box.

Re: Twin interfaces, and one and a half databases to a project
by Abigail-II (Bishop) on Aug 15, 2002 at 10:16 UTC
    Replication can be done both ways, regardless of what Sybase or Oracle or whoever are saying. But it isn't easy, you won't find off-the-shelf solutions, and you might not get support from your vendor.

    But I've implemented two way replication between 4 (!) Sybase servers, purely on a database level (no non-database programs were written except to present status information).

    Don't think it was simple though. In total, it took about 18 months of work. It's hard to get everything right!

    Abigail

      That sounds pretty impressive. And you did it purely in transac-sql? No external scripts? Wow.

      Yves / DeMerphq
      ---
      Software Engineering is Programming when you can't. -- E. W. Dijkstra (RIP)

        No changes allowed in the existing binaries/libraries was actually a design requirement. Although we did use the fact the application was already required to lock trades (done with a stored procedure) before able to modify them (you don't want two traders modifying the same trade at the same time - yes, it was a financial application).

        Abigail

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://190301]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (4)
As of 2024-03-29 11:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found