It failed so many times. Every time I monitor the production database and slave database at the same time, the monitor server always identified them as the same server, and combine them into just one server, which puzzle me for a long time.
I have tried to use one single agent instances, multiple agent instances, and multiple agent installs. I thought the key problem might lie on the UUID of the server. Because no matter how I change the UUID in the agent configuration files, the UUID value I saw in the monitor page just never changes.
Finally I found an article said that every database stores a UUID value in mysql.inventory to identify it self.
So I checked it, sure enough I found same value in these two database. Sure they are!! I created the slave using the backup of the master server!!
I changed the slave's value, and it works!!
But why this not happened when I monitor another group database, it also includes one master and one slave. It's strange that they have different UUID value in mysql.inventory.
Maybe their version is higher!!
没有评论:
发表评论