I just did this last week on a 5.0.18 machine. It's supported by the
mysqlmanager out of the box. Here are a copy of my notes, and worked
well on a Suse machine. The locations of your files may not be the
same.
# stop the server, if running
/etc/init.d/mysql stop
# edit /etc/my.cnf to set up
Thanks Rich.
On Mon, 2006-04-17 at 08:28 -0500, Duzenbury, Rich wrote:
I just did this last week on a 5.0.18 machine. It's supported by the
mysqlmanager out of the box. Here are a copy of my notes, and worked
well on a Suse machine. The locations of your files may not be the
same.
#
: ~ How to install 3 instances of mysql~
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
To: [EMAIL PROTECTED]
From: Mohammed Abdul Azeem [EMAIL PROTECTED]
Subject: Re: ~ How to install 3 instances of mysql~
Hello Keith,
Thank you very much for your guidence.
This is my
- Adelaide)
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: RE: ~ How to install 3 instances of mysql~
Hi Logan,
Thanks for the links. But how am i suppose to allocate my physical
memory for the 3 mysql instances. Pls guide me on the innodb memory
settings. My total RAM memory is 1 GB.
Thanks
Hi Mohammed - yes it is possible to install multiple
instances of mysqld on one machine.
Under SuSE Linux 9.2 I have had 3 instances of mysqld
running.
I would suggest the following.
Use the generic static pre-compiled distibution.
Linux (non RPM package) downloads (platform notes)
Linux
Create 3 my.cnf files with different ports and sockets:
[mysqld]
port = 3306
socket=/var/lib/mysql/mysql1.sock
.
Launch server with:
bin/safe_mysqld --defaults-file=/usr/local/mysql/bin/my1.cnf
client:
/usr/local/mysql/bin/mysql -S /var/lib/mysql/mysql1.sock
stop:
mysqladmin -S
Hello Keith,
Thank you very much for your guidence.
This is my existing my.cnf file
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
To: [EMAIL PROTECTED]
From: Mohammed Abdul Azeem [EMAIL PROTECTED]
Subject: Re: ~ How to install 3 instances of mysql~
Hello Keith,
Thank you very much for your guidence.
This is my existing my.cnf file
[mysqld]
port
3 instances of mysql~
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
To: [EMAIL PROTECTED]
From: Mohammed Abdul Azeem [EMAIL PROTECTED]
Subject: Re: ~ How to install 3 instances of mysql~
Hello Keith,
Thank you very much for your guidence.
This is my existing my.cnf file