Re: High Availability.. (SQL server)

2000-10-07 Thread Robert Davies

Yes, we've faced this problem and are planning a solution.
We've not coded anything yet, but have plans for a couple of months.  Maybe
it could be an Open Source project if there's nothing pre-existing.  I'd
want the daemon interfaces to be DB independant.

Basic idea is to seperate the Queries from the Updates.
Queries use local mysql DB, tracking is done asynchronously through a perl
daemon, that queues, then sends the writes in batches, to reduce number of
transactions.

The Master DB is not truly redundant, but would have hot spare, the fault
tolerance comes in from the buffering introduced by the daemons, and
queueing system.

Rob

- Original Message -
From: "Christian Hammers" [EMAIL PROTECTED]
To: "Jason Hammerschmidt" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, October 06, 2000 10:24 PM
Subject: Re: High Availability.. (SQL server)


 Hello

 Has anyone ever tried to make a webserver host with a mysql database
 (used for a session database that gets updated on every click) redundant
 by adding an exactly same computer and do DNS-load balancing?

 If there were no SQL database this would be no problem, two web-servers
 that access a shared NFS Raid for data. But you can't have two MySQL
 daemons access the same files and if you have only one SQL server for
 both web servers there is no redundancy. On the other side if you have
 two seperate mysql servers there is no synchronising between them, I
 know about that update-log method but when serving a couple of clients
 per second I doubt that the two servers syncronise fast enough to allow
 using a session-db (imaging first request on A, then second request on B
 but B's mysql server hasn't updated the mysql db and so the session
 information are lost).

 Any ideas?

 bye,

  -christian-



--  
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: nat

2000-10-07 Thread J-Mag Guthrie

On Fri, 6 Oct 2000, Kevin wrote:

 
   I was wondering if anyone can tell me sort of problems I would have
   if I assigned internal ips to our customers and used ipmasq.
   Basically I don't want to do this, but I need some sort of firepower
   to persuade my boss that he doesn't want it either.  Any
   info/link/short coming of age stories would be greatly appreciated.

ICQ absolutely hates it.  This was all I needed to convince one client.

-- 
J-Mag Guthrie/"\  "Even Microsoft's product managers privately 
Brokersys\ /   concede that this new version, with its 
281-580-3358 (voice)  Xwarm-and-fuzzy nickname of Windows Me, 
281-586-0628 (fax)   / \   is not for everyone." -- Dwight Silverman


--  
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: nat

2000-10-07 Thread Dariush Pietrzak



 Even for the "standard" protocols it fails if you need to connect to a
 port not handled by the module. Example: the ip_masq_irc watches only
fails? since when? it works perfectly.

 something, not everything (here: DCC) will work.
dah??
DCC works like a charm, where did you get an idea it doesen't work?
of course from behind firewall acitivating side bust be outside 
( if you're behind NAT you can accept dcc chat/send/whatever
but can't successfully initiate one without a little of magic, 
but that's obvious, that's the way single ip - network mapping works )



--  
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Hello.

2000-10-07 Thread Joshua Abbott



Hello,
Could someone please indulge me and give me 5 
reasons why they would like to go into computers for a job (or why they 
did)?

Thanks
Joshua
[EMAIL PROTECTED]



Re: Hello.

2000-10-07 Thread Dariush Pietrzak


 Could someone please indulge me and give me 5 reasons why they would like
 to go into computers for a job (or why they did)?

hmm, maybe this will help:
1) people are evil
2) personal preferences ( physics, then maths, then discovered
programming)
3) people are evil
4) computer jobs give you money, other money-making jobs include working
with people, require you to lie to them and do bad things to them (lawyer,
politicians etc )
5) people are evil, computer jobs usually keep you away from the poeple

hmm, maybe you've guessed that, but I'm socially impaired ( e.g. I don't
need to get drunk or high to have fun )
if you need those reasons that you should probably go into after some
normal job. And I was told to find something I like, not something OTHER
people want me to do or have reasons for me to do. Common man, it's YOUR
life.

Hmm, Is this a trick question?




--  
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Hello.

2000-10-07 Thread Chris Jenks

five reasons, I'll come as close as I can.

1) I know now that I am not good enough at guitar to keep me fed.
2) Up until not to long ago, you couldn't get paid to rock climb.
3) My times were not good enough at swimming to send me to the olympics.
4) I prefer a non dangerous night job.
5) I like to read, not talk.

Chris

At 01:34 PM 10/7/00 -0500, Joshua Abbott wrote:
   Hello, Could someone please indulge me and give me 5  reasons why they
would like to go into computers for a job (or why they  did)?   Thanks
Joshua [EMAIL PROTECTED]   


--  
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




removing blocked route

2000-10-07 Thread Jeremy C. Reed

I used route reject to block an IP. To get access back to the blocked IP,
I had to add a gateway for the host. Does anyone know how I can get rid of
the blocked entry?

This is what I did first:

  /sbin/route add -host aa.bb.cc.200 reject # IP changed!

What do I do to undo this?

I worked around it by doing:

  route add -host aa.bb.cc.200 gw my.regular.gateway.here eth0

I can now get to aa.bb.cc.200, but route is like:

Destination Gateway Genmask Flags Metric RefUse Iface
aa.bb.cc.200my.regular.gate 255.255.255.255 UGH   0  00 eth0
aa.bb.cc.200-   255.255.255.255 !H0  -0 -

How do get rid of this ! (reject route) entry?

(I tried route del, route add ... reinstate.)

Thanks,

  Jeremy C. Reed
  http://www.reedmedia.net/
  http://bsd.reedmedia.net/


--  
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Hello.

2000-10-07 Thread Trent

To Joshua,

My top reasons are

a.) to write good code 
b.) to express myself in my code  
c.) to read and write in an logical fashion
d.) to help others do the same
e.) to make 

And for what study is this for?

Thanks,
Trent
[EMAIL PROTECTED]

If the future didn't exist, somebody would have invented it.


 Joshua Abbott wrote:
 
 Hello,
 Could someone please indulge me and give me 5 reasons why they would
 like to go into computers for a job (or why they did)?
 
 Thanks
 Joshua
 [EMAIL PROTECTED]



--  
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]