Bug #29198 mysqlmanager problems with replication

Submitted: 19 Jun 2007 7:21 Modified: 4 Dec 2007 21:45
Reporter: JinRong Ye Email Updates:
Status: Unsupported Impact on me:
None 
Category:Instance Manager Severity:S3 (Non-critical)
Version:5.1.19 OS:FreeBSD (, Linux)
Assigned to: Alexander Nozdrin CPU Architecture:Any

[19 Jun 2007 7:21] JinRong Ye
Description:
I setup mysqlmanager to manage mysql,i stop a instance and then change some of the replication,such as server-id/slave_net_timeout and so on,then start the instance,but these options don't take affected.

How to repeat:
terminal 1:
(root:localhost:)(none)> show global variables like 'slave_net_timeout';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| slave_net_timeout | 3600  |
+-------------------+-------+

(root:localhost:)(none)> show global variables like 'server_id';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| server_id     | 1      |
+---------------+--------+

terminal 2:
(yejr:localhost:)(none)> stop instance mysqld1;
Query OK, 0 rows affected (1.20 sec)

(yejr:localhost:)(none)> set mysqld1.slave_net_timeout=10;
Query OK, 0 rows affected (0.00 sec)

(yejr:localhost:)(none)> set mysqld1.server-id=1;
Query OK, 0 rows affected (0.00 sec)

(yejr:localhost:)(none)> start instance mysqld13306;
Query OK, 0 rows affected (0.00 sec)
Instance started

cat my.cnf
[mysqld1]
......
replicate-same-server-id=0
slave_net_timeout=10
......

back to terminal 1:
(root:localhost:)(none)> show global variables like 'slave_net_timeout';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| slave_net_timeout | 3600  |
+-------------------+-------+

(root:localhost:)(none)> show global variables like 'server_id';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| server_id     | 1      |
+---------------+--------+

there is no difference with the first result.
[19 Jun 2007 7:57] Sveta Smirnova
Thank you for the report.

Verified as described. All options are not getting updated.

Workaround: restart mysqlmanager.
[4 Dec 2007 21:45] Konstantin Osipov
The instance manager is deprecated in 5.1 and discontinued in 6.0

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.