Re: Mysql over NFS

2001-02-06 Thread Nathan Cook
TIA! .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems & Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ] - Original Message - From: "Peter Skipworth" <[EMAIL PROTECTED]> To: "Nathan Cook" <[EMAIL PROTECTED]> Cc: <[

Mysql over NFS

2001-02-06 Thread Nathan Cook
or machine fails the other daemon can access the independent RAID. Is this possible and will two mysql daemons play nicely with each other when accessing data on a drive shared between the two computers? Essentially, can two mysql daemons play nicely with mysql data over a RAID or NFS? TIA, Nathan

Re: Load Balancing.

2001-02-01 Thread Nathan Cook
down then machine B will take all requests and then re-sync when machine A comes back online. It seems like this is impossible without some sort of two way replication available. Any input is welcome. Thank You! .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems & Network Administr

Load Balancing.

2001-01-30 Thread Nathan Cook
It seems like I have seen somewhere that load balancing and fail-over-services are available for MySQL, to share the load and mirror the data between two machines. Is this possible and if so where can I read more about it? Thank You, .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems & Net

Select not working selectively

2001-01-24 Thread Nathan Cook
LIMIT 0,10 I get the error: The table 'SQL4a5b_0' is full, Does this error mean a temporary table is full? What can I do to get this query to work. Thank You P.S. > The query works on an similar table with 10 fields 10,000 records. .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Syst

Re: mySQL vs Oracle

2001-01-22 Thread Nathan Cook
My bad... They aren't scheduled to come out until 3.24. Sorry. .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems & Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ] - Original Message - From: "tc lewis" <[EMAIL PROTECTED]>

Re: mySQL vs Oracle

2001-01-22 Thread Nathan Cook
Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems & Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ] - Original Message - From: "Scott Gerhardt" <[EMAIL PROTECTED]>