Responding to a "My MySQL wishlist".
Posted on 2007.11.15 at 06:09Current Location: Home, Capitol Hill, Seattle WA
I just saw ![[info]](http://l-stat.livejournal.com/img/userinfo.gif)
dveeden's post in PlanetMySQL.
He writes:
krow has written a plugin that announces a MySQL server via Apple's BonJour zeroconf protocol. Extending it to announce databases in the server might be doable …
Also, I'm (slowly) working on a SNMP AgentX plugin for MySQL server. With that, one can autodiscover MySQL servers and databases via Nagios, OpenView, etc.
That's a great idea! I'm adding it right now to the desired feature set for my AgentX project, and I'm going to bendkrow's ear about it.
dveeden's post in PlanetMySQL.He writes:
3. Database locator. So you've got hundreds of servers … and a multitude of databases. How to connect to the right server to reach the database you needed? Something like oracle TNS would be helpful here. What about implementing TNS for MySQL or just using DNS? How do you solve this?
krow has written a plugin that announces a MySQL server via Apple's BonJour zeroconf protocol. Extending it to announce databases in the server might be doable …Also, I'm (slowly) working on a SNMP AgentX plugin for MySQL server. With that, one can autodiscover MySQL servers and databases via Nagios, OpenView, etc.
4. Saving extra metadata about the database. A common way to store stuff like customerid, data classification, service classification (development, production, etc) would be helpful. Many people are already storing this info but there is no way MySQL Administrator, phpMyAdmin or other tools can use it.
That's a great idea! I'm adding it right now to the desired feature set for my AgentX project, and I'm going to bend
krow's ear about it.