Monitoring and Management of Percona XtraDB - Revision history

Admin: /* Troubleshooting */

2018-10-26T17:04:32Z

Troubleshooting

2018-10-26T17:03:33Z

Troubleshooting

2018-10-26T17:02:38Z

Troubleshooting

2018-10-26T17:02:00Z

Data collection

2018-08-30T13:32:39Z

Conclusion

2018-05-10T04:34:21Z

2018-05-10T04:32:59Z

Data collection

2018-05-10T04:31:51Z

Start the percona/pmm-server container

2018-05-10T04:29:04Z

Data collection

2018-05-10T04:16:53Z

Data collection

@@ Line 140: / Line 140: @@
 Case: we have 3 nodes in our cluster in this tutorial (db1, db2 and db3) we stop mysql first on db1, db2 nd db3 . The node that will have it's safe_to_bootstrap: 1 will be db3 so we will have to run /etc/init.d/mysql bootstrap-pxc on db3 first and start mysql on db1 and db2 with sudo systemctl start mysql
   # GALERA saved state
   version: 2.1

@@ Line 139: / Line 139: @@
 If you have n node in your cluster and you shutdown all n nodes by stopping first mysql (sudo systemctl stop mysql)  and powering them off (sudo poweroff). When You you bring back all the nodes and try to start mysql, )sudo systemctl start mysql) mysql woundn't start.  You need to bootstrap first the last node you stop mysql on. That will be the node that has safe_to_bootstrap: 1 in /var/lib/grastate.dat.
 Case: we have 3 nodes in our cluster in this tutorial (db1, db2 and db3) we stop mysql first on db1, db2 nd db3 . The node that will have it's safe_to_bootstrap: 1 will be db3 so we will have to run /etc/init.d/mysql bootstrap-pxc on db3 first and start mysql on db1 and db2 with sudo systemctl start mysql
 ==Conclusion==
 We have installed Percona Monitoring and Management server on  docker and configured all 3 nodes in the cluster to connect to it. We also set what we needed to monitor from the cluster.

@@ Line 138: / Line 138: @@
 If you have n node in your cluster and you shutdown all n nodes by stopping first mysql (sudo systemctl stop mysql)  and powering them off (sudo poweroff). When You you bring back all the nodes and try to start mysql, )sudo systemctl start mysql) mysql woundn't start.  You need to bootstrap first the last node you stop mysql on. That will be the node that has safe_to_bootstrap: 1 in /var/lib/grastate.dat.
-Case: we have 3 nodes in our cluster in this tutorial (db1, db2 and db3) we stop mysql first on db1, db2 nd db3 . The node that will have it's safe_to_bootstrap: 1 will be db3 so we will have to run /etc/init.d/mysql bootstrap-pxc on db3 first and start mysql on db1 and db2 with sudo systemctl start mysq
+Case: we have 3 nodes in our cluster in this tutorial (db1, db2 and db3) we stop mysql first on db1, db2 nd db3 . The node that will have it's safe_to_bootstrap: 1 will be db3 so we will have to run /etc/init.d/mysql bootstrap-pxc on db3 first and start mysql on db1 and db2 with sudo systemctl start mysql
 ==Conclusion==
 We have installed Percona Monitoring and Management server on  docker and configured all 3 nodes in the cluster to connect to it. We also set what we needed to monitor from the cluster.

@@ Line 134: / Line 134: @@
 [[File:Pmm-srv-db5.JPG|400px|]]
 ==Conclusion==
 We have installed Percona Monitoring and Management server on  docker and configured all 3 nodes in the cluster to connect to it. We also set what we needed to monitor from the cluster.

← Older revision		Revision as of 13:32, 30 August 2018
Line 136:		Line 136:

	==Conclusion==		==Conclusion==
		+
		+	We have installed Percona Monitoring and Management server on docker and configured all 3 nodes in the cluster to connect to it. We also set what we needed to monitor from the cluster.

@@ Line 123: / Line 123: @@
   [mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN root:***@unix(/var/run/mysqld/mysqld.sock)
-[[File:Pmm-srv-db2.JPG|400|]]
+[[File:Pmm-srv-db2.JPG|400px|]]
-[[File:Pmm-srv-db3.JPG|400|]]
+[[File:Pmm-srv-db3.JPG|400px|]]
 After installing pmm client and enabling data collection on all 3 nodes we can now see all 3 node in the pmm server dashboard
-[[File:Pmm-srv-db4.JPG|400|]]
+[[File:Pmm-srv-db4.JPG|400px|]]
 Query Analytics

@@ Line 79: / Line 79: @@
 Open a browser and type in your IP address to access the pmm-server dashboard
-[[File:Pmm-srv-dashboard.JPG|400|]]
+[[File:Pmm-srv-dashboard.JPG|400px|]]
 ==Install Pmm-client on each node==

← Older revision		Revision as of 04:16, 10 May 2018
Line 128:		Line 128:

	After installing pmm client and enabling data collection on all 3 nodes we can now see all 3 node in the pmm server dashboard		After installing pmm client and enabling data collection on all 3 nodes we can now see all 3 node in the pmm server dashboard
		+
		+	[[File:Pmm-srv-db4.JPG\|400\|]]