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.
>
>
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 t
- 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 in
] [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 15 April 2006 10:45 PM
> To: mysql@lists.mysql.com
> Subject: Re: ~ How to install 3 instances of mysql~
>
> On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
>
> > To: [EMAIL PROTECTED]
> > From: Mohammed Abdul Azeem <[
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.
>
>
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 exi
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
t
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 /var/li
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 (x8
