Hi!
You could write an "Identity" plugin. Just have it store its
information somewhere and let the user push generic key/pair into it.
The values would be exposed as variables and you could just add in a
custom I_S schema.
I've done this with just a normal table in the past, but it could be
made all fancy and stuff :)
Cheers,
-Brian
On Sep 22, 2009, at 11:21 AM, Ronald Bradford wrote:
Hi Guys,
I'd like to see a better means to identify a Drizzle/MySQL instance
when connected to it.
My situation is a client with many (100s) of production databases,
some with multiple instances, and you can never tell when connected
to the instance, any specifics of it's purpose for example.
Oracle has the concept of ORACLE_SID http://www.orafaq.com/wiki/ORACLE_SID
Ideally I'd like to see the capacity for multiple global variables
that are user definable, and that way it's possible to give greater
flexibility to implementer. The issue obviously is in managing the
namespace.
Alternatively more complex solutions could be a custom I_S table of
name/value pairs, but ideally I'd like to see something that can
integrate easily into existing syntax and procedures.
Thoughts, anybody. I'd appreciate some input before making a
feature request.
Ronald
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
