User privileges in Mysql replication

sem007 · 09-27-2010, 08:59 AM

Dear Friends,

Might this is silly question but I am not much familiar to database.

I am doing master slave Mysql replication for load balancing.

On master server different database has different user privileges. I create backup using mysqldump command and restore on slave server instead of using load data from master; command.
When i replicate database from master to slave will i require to set user privileges same as master ?

One more question: How to lock all database in mysql?
Regards,

hairysocks · 09-27-2010, 09:03 AM

No. You can different permissions on master and slave. I have my master user set with update, insert, delete, select, but the slave has only select.

sem007 · 09-27-2010, 09:10 AM

Quote:

Originally Posted by hairysocks

No. You can different permissions on master and slave. I have my master user set with update, insert, delete, select, but the slave has only select.

thanks for replay.

You mean to say i don't want to configure privileges on slave.

One more question:

if i run below command it will lock only one db tables. right?

Code:

mysql> use db_name;
mysql> FLUSH TABLES WITH READ LOCK;

How can i lock all database/tables in mysql?

Regards,