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
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 port 3307. I
installed as follows, but when I try to start mysql5, it fails to sta
; server. 'Localhost' is used for communication between web applications
>> and database server. In this case, how should I monitor our multiple
>> mysql servers remotely? Would anybody advise?
>
> Well you will then need an approach where the servers report to the
>
7;skip-networking' configured. So mysql don't accept requests
>> coming from outside via network. Each mysql server also runs as web
>> server. 'Localhost' is used for communication between web applications
>> and database server. In this cas
communication between web applications
and database server. In this case, how should I monitor our multiple
mysql servers remotely? Would anybody advise?
Well you will then need an approach where the servers report to the
monitoring server, or where some service running on your MySQL servers
gets p
ailto:[EMAIL PROTECTED]
Sent: Wednesday, 14 March 2007 6:31 AM
To: mysql@lists.mysql.com
Subject: Re: monitor multiple mysql servers with no 3306 access
> On 3/13/07, Bing Du <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>>
>> Seems like there are quite many MySQL monitor
s
>> coming from outside via network. Each mysql server also runs as web
>> server. 'Localhost' is used for communication between web applications
>> and database server. In this case, how should I monitor our multiple
>> mysql servers remotely? Would anybody advise?
&g
ication between web applications
and database server. In this case, how should I monitor our multiple
mysql servers remotely? Would anybody advise?
Thanks in advance,
Bing
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
tions
and database server. In this case, how should I monitor our multiple
mysql servers remotely? Would anybody advise?
Thanks in advance,
Bing
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ariables' returns, plus what databases exist on each server, are there
> any tools that can do that? Can phpMyAdmin manage multiple mysql
> servers?
Additional MySQL servers can be defined in phpMyAdmin's config.inc.php file.
--
Greg Donald
Zend Certified Engineer
MySQL Core Certific
there
any tools that can do that? Can phpMyAdmin manage multiple mysql
servers?
[/snip]
I have used phpMyAdmin to manage up to 20 MySQL servers and hundreds of
millions of records. It is easy to install and configure. It is robust
and scalable.
--
MySQL General Mailing List
For list
rver, are there
any tools that can do that? Can phpMyAdmin manage multiple mysql
servers?
Thanks in advance for any ideas,
Bing
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: 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
te on 09/08/2004
05:04:38 PM:
>
> Hello All,
>
> MySQL : Standar Binary 4.0.20
> O/S : Red Hat Linux release 9 (Shrike)
> Linux 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686
> i386 GNU/Linux
>
> I already have setup of Three Multiple MySQL servers lis
Pine
"Sanjeev Sagar" <[EMAIL PROTECTED]> wrote on 09/08/2004
05:04:38 PM:
>
> Hello All,
>
> MySQL : Standar Binary 4.0.20
> O/S : Red Hat Linux release 9 (Shrike)
> Linux 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686
> i386 GNU/Linux
>
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
Hello All,
MySQL : Standar Binary 4.0.20
O/S : Red Hat Linux release 9 (Shrike)
Linux 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686 i386 GNU/Linux
I already have setup of Three Multiple MySQL servers listening on different ports and
sockets on same machine
Option File
end and
> to provide data consistency needed by database, so that we can
> increase the number of database servers easily.
If you plan to use a single disk array back-end and multiple mysql servers
connecting to it via NFS and gradually increase the numbers of DB servers,
then this will only
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
om: ZHANG JIAYING [mailto:[EMAIL PROTECTED]
Sent: Friday 30 January 2004 20:06
To: [EMAIL PROTECTED]
Subject: Multiple mysql servers with the same datadir
Hi, all. I notice this is not recommended in the manual. But I wonder if
not considering performance, when using dbd as the table type, are th
Hi, all. I notice this is not recommended in the manual. But I wonder if not
considering performance, when using dbd as the table type, are there any problems in
these two cases?
1) running multiple mysqld processes on the same machine with the same datadir.
2) running multiple mysqld on differe
Hi!
I want to run 2 versions of MySQL on the same Linux machine. I already
have 3.23.41 installed and I want to install 4.0.3 to test it. I tried to
install MySQL 4.0.4 but cannot install because of failed dependencies.
Thanks for any help,
Macarie Neculai.
gata 6
254 38 Helsingborg, Sweden
Direct: +46 42 389918
Phone: +46 42 389900
e-mail: [EMAIL PROTECTED]
-Original Message-
From: Okan CIMEN [mailto:[EMAIL PROTECTED]]
Sent: 01 September 2002 11:40
To: Tobias Eriksson
Subject: Re: How to run multiple mysql servers
Hi Tobias,
I am plann
: +46 42 389918
Phone: +46 42 389900
e-mail: [EMAIL PROTECTED]
-Original Message-
From: Tobias Eriksson
Sent: 30 August 2002 14:41
To: [EMAIL PROTECTED]
Subject: How to run multiple mysql servers
I would like to run >2 mysqld-nt at the same time. This is because we
are shipping mysql w
I would like to run >2 mysqld-nt at the same time. This is because we
are shipping mysql with our product and then we would like to have the
database installed within our product. And also run separate from any
other MySQL database that might be installed on the system.
When I try to run the comma
At 14:28 30/5/2002 +0200, Inbal Ovadia wrote:
Hi,
>Hi all,
>I want to run multiple mySQL servers on my machine.
>Can i do this on windows 2000
This will possible with the next release of 4.0.2
>or just on Unix?
Regards,
Miguel
--
For technical support contracts
: Inbal Ovadia [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2002 13:29
To: [EMAIL PROTECTED]
Subject: Running Multiple MySQL Servers on the Same Machine
Hi all,
I want to run multiple mySQL servers on my machine.
Can i do this on windows 2000 or just on Unix?
because the manual talk about Unix.
How can i do
Hi all,
I want to run multiple mySQL servers on my machine.
Can i do this on windows 2000 or just on Unix?
because the manual talk about Unix.
How can i do this on windows?
thanks
-
Before posting, please check:
http
Is there any way to be a slave to multiple masters from a single instance of
a mysql server?
If not, I suppose we can run multiple instances of mysql server, each with
its own data directory and reading its own my.cnf file ( which I dont think
would be too hard to do on a linux pc BUT)
How
3:59 AM
Subject: Re: Running multiple MySQL servers on one machine
> On Mon, Jul 16, 2001 at 12:40:24PM +1000, William Chi wrote:
> > Hi,
> >
> > I was wondering if anyone has any opinions on the advantages and
> > disadvantages of running multiple servers on one mach
On Mon, Jul 16, 2001 at 12:40:24PM +1000, William Chi wrote:
> Hi,
>
> I was wondering if anyone has any opinions on the advantages and
> disadvantages of running multiple servers on one machine. Each
> server would be used to access different databases.
Off the top of my head, since I haven't
Hi,
I was wondering if anyone has any opinions on the advantages and
disadvantages of running multiple servers on one machine.
Each server would be used to access different databases.
Note also that these databases will both be replicated and there shall be
multiple machines. Possibly some machi
Hello All:
Did anybody setup multiple mysql servers on single machine? Do
I have to use mysqld_multi? I tried using this but gives me
this error:
ABORT: Bad GNR: mysql2 See mysqld_multi --help
This is how I ran mysqld_multi:
mysqld_multi --config-file=/etc/my.cnf start mysqld2
Here are the
35 matches
Mail list logo
