Re: multiple mysql service on the same server

2008-08-24 Thread Ananda Kumar
Hi All, I did using single my.cnf file, by specifying different server groups, which allows for specifying different socket, pid and data directory structure. It can be managed by using mysqld_multi. regards anandkl On 8/22/08, Jim Lyons [EMAIL PROTECTED] wrote: You really need different

Re: multiple mysql service on the same server

2008-08-24 Thread Ananda Kumar
Hi Jim, If i need to use different my.cnf file, they should be in different directory right. regards anandkl On 8/24/08, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, I did using single my.cnf file, by specifying different server groups, which allows for specifying different socket, pid and

Re: multiple mysql service on the same server

2008-08-24 Thread chaim . rieger
Right Keep them in the datadir to make things easier for you Sent via BlackBerry from T-Mobile -Original Message- From: Ananda Kumar [EMAIL PROTECTED] Date: Sun, 24 Aug 2008 23:47:24 To: Jim Lyons[EMAIL PROTECTED] Cc: mysqlmysql@lists.mysql.com Subject: Re: multiple mysql service

multiple mysql service on the same server

2008-08-22 Thread Ananda Kumar
Hi All, I am asking a very simple question. I need to install two mysql service (instances) on the same server. I know we can do that using different port, but should i use two different my.cnf files, and also, what is the procedure to stop one mysql service and keep other one running. regards

Re: multiple mysql service on the same server

2008-08-22 Thread Jim Lyons
You really need different config files if you're going to log anything or if you need different server ids. You should also use different sockets. You can stop a specific server by specifying the host on the mysqladmin shutdown command. I did it by keeping everything different, including the