Resolved.
On Tue, Jul 15, 2008 at 7:05 PM, Madan Thapa <[EMAIL PROTECTED]>
wrote:
> Hello,
>
> I already have mysql 4 installed on datadir /var/lib/mysql and basedir
> /var/lib on RHEL5 running on port 3306. I want to run another instance in
> /home/mysql5 with datadir = /home/mysql5 and basedir=/home on p
: Thu 9/9/2004 9:51 AM
To: [EMAIL PROTECTED]; Sanjeev Sagar
Cc: [EMAIL PROTECTED]; Sanjeev Sagar
Subject: RE: Multiple MysQL servers with different IP address on same machine
Hi
We have a machine with 2 IP addresses and mysql 3.23 on one and 4.10 on the
other. Both using port 3306
One instance
mailto:[EMAIL PROTECTED]
> Sent: 09 September 2004 14:53
> To: Sanjeev Sagar
> Cc: [EMAIL PROTECTED]; Sanjeev Sagar
> Subject: Re: Multiple MysQL servers with different IP address on same
> machine
>
>
> I need to add to my previous post -- You asked about using the SAME
> o
I need to add to my previous post -- You asked about using the SAME
operating system socket as well as using separate addresses with the same
port number (different IP sockets)
My answer to that is NOT ON YOUR LIFE. Think of the chaos. If one client
tried to connect to an OS socket that 3 diffe
An "IP socket" is the unique combination of an IP address and a port
number. I don't see why you couldn't run those separate instances of your
db servers on the same port but each with their own addresses as they
would each have their own unique "IP socket". I don't think you would
create any c
The example below renames a col. But can I rename a col. w/out giving
all that type spec. at the end of the statement below. I just want to
rename everything else stays the same. Thanks.
mysql> ALTER TABLE search CHANGE Description PageDescription
VARCHAR(255) NOT NULL;
--
MySQL General Mailing
be scalable if your DB system is cpu or ram bound. If
it's diskbound then you won't achieve scalability this way.
Cheers,
Andrew
-Original Message-
From: ZHANG JIAYING [mailto:[EMAIL PROTECTED]
Sent: Monday 02 February 2004 20:35
To: [EMAIL PROTECTED]
Subject: RE: Multipl
Hi, Andrew. Thank you very much for your explanation. And yes, I actually wanted to
mean BDB, instead of DBD.
I just checked BDB document. It seems they maintain their own locks. So my two cases
will lead to data corruption. I wonder if there are any database management systems
implementing lo
Hi,
I think you're getting mixed up between DBD (data base driver) and BDB
(BerkeleyDB) but I reckon you mean BDB...
I'm not sure if the locking of the page (i.e. the whole table file) is done
at the filesystem level or is managed internally by each mysqld instance.
If it is managed by each mysql
10 matches
Mail list logo
