You are viewing fallenpegasus

entries friends calendar user info My Website Previous Previous Next Next
Mark Atwood - Responding to a "My MySQL wishlist".
fallenpegasus
fallenpegasus
Add to Memories
Share
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

Comments
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
profile
Mark Atwood
Name: Mark Atwood
Website: My Website
calendar
Back August 2013
123
45678910
11121314151617
18192021222324
25262728293031
page summary
tags