In a transaction, for example,
SELECT count(*) as count FROM `order` WHERE user_id = 25286 LOCK IN SHARE MODE;
INSERT INTO `order` (`id`, `user_id`, `product_id`) VALUES (NULL, '25286', '36296');
we perform the SELECT LOCK IN SHARE MODE; the SELECT query will be executed on the slave database and lock a row.
Does the SELECT LOCK IN SHARE MODE also create a row locking on the master database so that the INSERT query will not run on a master database?