Log in

entries friends calendar profile My Website Previous Previous Next Next
Responding to a "My MySQL wishlist". - Mark Atwood
Responding to a "My MySQL wishlist".
I just saw 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.

Tags: ,
Current Location: Home, Capitol Hill, Seattle WA

2 comments or Leave a comment
krow From: krow Date: November 15th, 2007 04:28 pm (UTC) (Link)
I have no idea when I will get back to that, aka the zeroconf work. Depends a lot on available time... I do believe it currently works without issue though.
awfief From: awfief Date: November 15th, 2007 06:28 pm (UTC) (Link)
your SNMP agentx plugin makes me quiver.
2 comments or Leave a comment