| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connection slave; |
| 4 |
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_host'; |
| 5 |
VARIABLE_NAME VARIABLE_VALUE |
| 6 |
REPORT_HOST 127.0.0.1 |
| 7 |
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_port'; |
| 8 |
VARIABLE_NAME VARIABLE_VALUE |
| 9 |
REPORT_PORT 9308 |
| 10 |
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_user'; |
| 11 |
VARIABLE_NAME VARIABLE_VALUE |
| 12 |
REPORT_USER my_user |
| 13 |
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_password'; |
| 14 |
VARIABLE_NAME VARIABLE_VALUE |
| 15 |
REPORT_PASSWORD my_password |
| 16 |
show global variables like 'report_host'; |
| 17 |
Variable_name report_host |
| 18 |
Value 127.0.0.1 |
| 19 |
show global variables like 'report_port'; |
| 20 |
Variable_name report_port |
| 21 |
Value 9308 |
| 22 |
show global variables like 'report_user'; |
| 23 |
Variable_name report_user |
| 24 |
Value my_user |
| 25 |
show global variables like 'report_password'; |
| 26 |
Variable_name report_password |
| 27 |
Value my_password |
| 28 |
set @@global.report_host='my.new.address.net'; |
| 29 |
ERROR HY000: Variable 'report_host' is a read only variable |
| 30 |
end of tests |
| 31 |
include/rpl_end.inc |