Enterprise Monitor: “Add Bulk MySQL Instances” 50 in 1-click.

http://ift.tt/1EPAOyS

Carrying on with my MySQL 5.7 Labs Multi Source Replication scenario, I wanted to evaluate performance impact via MySQL Enterprise Monitor. Whilst I opened my environment, I remember that I had generated lots of different skeleton scripts that allowed me to deploy the 50 servers quickly, and I didn’t want to add each of my targets 1 by 1 in MEM. So, I used one of the many features available, “Add Bulk MySQL Instances”. So, I’ve got 50 (3001-3050) masters but only 1 slave (3100). By default, MEM monitors it’s own repository, i.e. the 1/1 server being monitored in the All group. I want to add my slave in first, because that’s how I’m organizing things, and I’ll take the opportunity to create the monitoring group I want to keep them all in. Click on “Add MySQL Instance” and after entering the server details for 3100, I go to Group Settings, and add a special group for all my servers: Adding a New Group As no group existed before, I write the name I want to call the new group, and the comment “new group” appears, i.e. confirming that it’s a new group. In fact, in the greyed out part, you can see that there are 45 of the 50 unmonitored. I’ve got 5 to start yet, but almost there. Now to add them in in Bulk mode. I’ve got a few I haven’t started, and MEM tells me that there are 44 instances up and running and eager to be monitored: 44 of the 50 new instances are unmonitored. Click on the Add Bulk MySQL Instances button. The following window appears: One window, 50 servers added. So with some copy & pasting, I’ve got all 50 servers added into the Connection Endpoint window, made sure each port is ok and entered the root user & passwd which is the same for all servers here. I also chose to not create the general & limited users, but could have done so to ease monitoring all with the root user. And that’s it. All servers that are up and running are added. As I haven’t started them all, I will see those 6 as Bad Configurations, i.e. unreachable because it’s hard to connect if it’s just not there… Now I’m going to go away and look at the performance graphs for the different load tests.

from Planet MySQL http://ift.tt/1du18ol