Re: multiple mysql servers

2008-07-18 Thread Madan Thapa
Resolved.

multiple mysql servers

2008-07-15 Thread Madan Thapa
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

Re: multiple mysql servers

2008-07-15 Thread Madan Thapa
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 port

Re: monitor multiple mysql servers with no 3306 access

2007-03-14 Thread Nils Meyer
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 polled and polls the MySQL

Re: monitor multiple mysql servers with no 3306 access

2007-03-14 Thread Thiago LPS
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? Thanks in advance, Bing -- MySQL General Mailing List For list archives: http

Re: monitor multiple mysql servers with no 3306 access

2007-03-14 Thread Bing Du
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 polled and polls

monitor multiple mysql servers with no 3306 access

2007-03-13 Thread Bing Du
. 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]

Re: monitor multiple mysql servers with no 3306 access

2007-03-13 Thread Thiago LPS
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

Re: monitor multiple mysql servers with no 3306 access

2007-03-13 Thread Bing Du
for communication 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: http://lists.mysql.com

RE: monitor multiple mysql servers with no 3306 access

2007-03-13 Thread Logan, David (SST - Adelaide)
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 monitoring tools on the Internet. The one I tried today was MONyog

manage multiple mysql servers on different hosts?

2006-03-01 Thread Bing Du
, 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]

RE: manage multiple mysql servers on different hosts?

2006-03-01 Thread jblanchard
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 archives: http

Re: manage multiple mysql servers on different hosts?

2006-03-01 Thread Greg Donald
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 Certification http://destiney.com/ -- MySQL General Mailing

Re: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread SGreen
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 listening on different ports and sockets on same

Re: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread SGreen
: 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: [mysqld1] server-id =1

RE: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread Peter Lovatt
:[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 operating system socket as well as using

RE: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread Sanjeev Sagar
] Sent: 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

Multiple MysQL servers with different IP address on same machine

2004-09-08 Thread Sanjeev Sagar
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

Re: Multiple MysQL servers with different IP address on same machine

2004-09-08 Thread leegold
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

RE: Multiple mysql servers with the same datadir

2004-02-02 Thread ZHANG JIAYING
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

RE: Multiple mysql servers with the same datadir

2004-02-02 Thread Andrew Braithwaite
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 be scalable if your DB

RE: Multiple mysql servers with the same datadir

2004-02-01 Thread Andrew Braithwaite
:[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 there any problems

Multiple mysql servers with the same datadir

2004-01-30 Thread ZHANG JIAYING
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

Multiple MySQL servers on the same machine

2002-10-14 Thread Macarie Neculai
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.

RE: How to run multiple mysql servers

2002-09-02 Thread Tobias Eriksson
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 planning to run two

How to run multiple mysql servers

2002-08-30 Thread Tobias Eriksson
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

RE: How to run multiple mysql servers

2002-08-30 Thread Tobias Eriksson
: +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

Running Multiple MySQL Servers on the Same Machine

2002-05-30 Thread Inbal Ovadia
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

RE: Running Multiple MySQL Servers on the Same Machine

2002-05-30 Thread Simon Green
: 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

Re: Running Multiple MySQL Servers on the Same Machine

2002-05-30 Thread miguel solorzano
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, goto https://order.mysql.com

Multiple MySQL servers same computer

2002-04-24 Thread Luc Foisy
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

Re: Running multiple MySQL servers on one machine

2001-07-19 Thread Jeremy Zawodny
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 seen

Re: Running multiple MySQL servers on one machine

2001-07-19 Thread ryc
). This situation gets even worse if you are depending on a larger key cache for performance. ryan - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: William Chi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 3:59 AM Subject: Re: Running multiple MySQL

Running multiple MySQL servers on one machine

2001-07-15 Thread William Chi
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

multiple mysql servers?

2001-05-29 Thread Rohit Peyyeti
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