It depends how public your database is. If you ever need to shut off one client then you might use separate users. Otherwise it's just annoying complexity, use a single user.

Remember to use a different 'server-id' for each client!

Ben

Krishna Chandra Prajapati wrote:
Hi,

I am setting up a replication with 1 master and multiple slave. My question
is can i use the same user (from master) for setting up replication on
multiple slaves. Is there any advantage for replication by creating
different user for different slave.

Thanks & Regards,

--
Ben Clewett
Road Tech Computer Systems Ltd
http://www.tachomaster.co.uk
http://www.roadrunner.uk.com
01923 460000
Shenley Hall
Rectory Lane
Shenley
Hertfordshire WD7 9AN


*************************************************************************
This e-mail is confidential and may be legally privileged. It is intended
solely for the use of the individual(s) to whom it is addressed. Any
content in this message is not necessarily a view or statement from Road
Tech Computer Systems Limited but is that of the individual sender. If
you are not the intended recipient, be advised that you have received
this e-mail in error and that any use, dissemination, forwarding,
printing, or copying of this e-mail is strictly prohibited. We use
reasonable endeavours to virus scan all e-mails leaving the company but
no warranty is given that this e-mail and any attachments are virus free.
You should undertake your own virus checking. The right to monitor e-mail
communications through our networks is reserved by us

 Road Tech Computer Systems Ltd. Shenley Hall, Rectory Lane, Shenley,
 Radlett, Hertfordshire, WD7 9AN. - VAT Registration No GB 449 3582 17
Registered in England No: 02017435, Registered Address: Charter Court, Midland Road, Hemel Hempstead, Hertfordshire, HP2 5GE. *************************************************************************

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to