[MDEV-14533] Provide information_schema tables using which hardware information can be obtained. Created: 2017-11-29 Updated: 2020-09-23 Resolved: 2018-03-21 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Plugins |
| Fix Version/s: | 10.1.32, 10.2.14, 10.3.6 |
| Type: | Task | Priority: | Critical |
| Reporter: | Johan Wikman | Assignee: | Alexey Botchkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
||||||||||||||||||||||||||||
| Issue Links: |
|
||||||||||||||||||||||||||||
| Sprint: | 10.1.32 | ||||||||||||||||||||||||||||
| Description |
|
MaxScale should be able to react when some node of a cluster hits a disk-full situation. For instance, if the master in a master-slave cluster hits a disk-full situation, MaxScale should promote some existing slave to master and remove the old master from the cluster. That way, a client connected to MaxScale would not necessarily detect anything special at all. In order to do that, MaxScale must be able to detect that a disk-full situation has occurred. It's difficult and unreliable to do that using MariaDB itself, for instance, by trying to create a table and assuming it was a disk-full situation in case the creation fails or the attempt ends with a timeout. Further, that approach would not allow MaxScale to become aware of the situation before the disk actually becomes full. A more reliable way would be to actually monitor the disk-space situation on the node and use that for the decision making, but arranging that is rather complex and fragile. A robust solution would be if there were a pseudo table or pseudo tables in information_schema using which information about the node could be found out. For instance as follows:
With this information available, MaxScale could automatically take corrective action in case the amount of used disk-space grows above, say, 90%. |
| Comments |
| Comment by Johan Wikman [ 2018-02-05 ] |
|
Attached is a proof-of-concept implementation that has been built and tested with MariaDB 10.0.33. |
| Comment by Alexey Botchkov [ 2018-03-21 ] |
|
http://lists.askmonty.org/pipermail/commits/2018-March/012116.html |