Mark Atwood (fallenpegasus) wrote,
Mark Atwood
fallenpegasus

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: geek, mysql
Subscribe

  • Razors

    I'm getting ads for I think five different "all metal" "get the best shave of your life" "throw away the plastic" razor startups. They all seem to be…

  • Doing what needs to be done

    On May 1st, one of my co-residents found one of the feral rabbits that live in the area cuddled up against a corner of the house. It was seriously…

  • The CTO of Visa, after listening to me present

    Some years ago, I was asked to travel to the corporate meeting center to present at a presentation-fest to the CxO staff of Visa. Yes, the one with…

  • Post a new comment

    Error

    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 2 comments