[Maria-developers] users table
hi guys, what's the better way to have a shared mysql schema? i'm talking about creating a user in one database and this user be created in many databases (in the same server) i'm trying with symbolic links in data directory, but sure i have some problems that i need same server version (ok no problem) and flush tables in all servers after add an user i don't know if i could do a two replications since it's like a master-master storage when one database add a user all databases need that information any idea? -- Roberto Spadim
Am 19.06.2013 00:03, schrieb Roberto Spadim:
hi guys, what's the better way to have a shared mysql schema? i'm talking about creating a user in one database and this user be created in many databases (in the same server) i'm trying with symbolic links in data directory, but sure i have some problems that i need same server version (ok no problem) and flush tables in all servers after add an user
this is russian roulette if you need the same users use a dedicated dtabase with it's own connection from all applications or implement logic in the software to connect to all databases for the insert this is nothing which should be done with hacks
maybe ldap or other feature could help me? thinking about a new auth_plugin for example, there's something that is near to what i need? like setup mysql database in all servers setup auth plugin in all servers pointing to some 'master database with users', any grant or auth will be done there and my current server will say ok you are in, (what i'm saying now is near mysql tables replication + some plugin) thinking again... could replication be used in mysql tables? allowing a automatic flush privileges when something change? 2013/6/18 Reindl Harald <h.reindl@thelounge.net>
hi guys, what's the better way to have a shared mysql schema? i'm talking about creating a user in one database and this user be created in many databases (in the same server) i'm trying with symbolic links in data directory, but sure i have some
Am 19.06.2013 00:03, schrieb Roberto Spadim: problems that i need same server version (ok
no problem) and flush tables in all servers after add an user
this is russian roulette
if you need the same users use a dedicated dtabase with it's own connection from all applications or implement logic in the software to connect to all databases for the insert
this is nothing which should be done with hacks
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial
Hi Roberto. 1) By default, replication applies to mysql.* tables also. GRANTS aredocumented to be immediately be applied without FLUSH PRIVILEGES. 2) Most people just have one or two mysql instances perserver machine for production work. 3) If you would like more detailed answers in the future, please saywhy you're doing something, and try more formal English. Youroriginal email was not exactly clear to me. Also, this is thewrong list for end-user questions like grants and basic replication. Thanks, James. --- On Tue, 6/18/13, Roberto Spadim <roberto@spadim.com.br> wrote: From: Roberto Spadim <roberto@spadim.com.br> Subject: Re: [Maria-developers] users table To: "Reindl Harald" <h.reindl@thelounge.net> Cc: "maria-developers@lists.launchpad.net" <maria-developers@lists.launchpad.net> Date: Tuesday, June 18, 2013, 4:46 PM maybe ldap or other feature could help me? thinking about a new auth_plugin for example, there's something that is near to what i need? likesetup mysql database in all servers setup auth plugin in all servers pointing to some 'master database with users', any grant or auth will be done there and my current server will say ok you are in, (what i'm saying now is near mysql tables replication + some plugin) thinking again... could replication be used in mysql tables? allowing a automatic flush privileges when something change? 2013/6/18 Reindl Harald <h.reindl@thelounge.net> Am 19.06.2013 00:03, schrieb Roberto Spadim:
hi guys, what's the better way to have a shared mysql schema?
i'm talking about creating a user in one database and this user be created in many databases (in the same server)
i'm trying with symbolic links in data directory, but sure i have some problems that i need same server version (ok
no problem) and flush tables in all servers after add an user
this is russian roulette if you need the same users use a dedicated dtabase with it's own connection from all applications or implement logic in the software to connect to all databases for the insert this is nothing which should be done with hacks _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp -- Roberto Spadim SPAEmpresarial -----Inline Attachment Follows----- _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
You may try with mysql-proxy which to handle the creation of users to all of your servers. Marian On 06/19/2013 02:46 AM, Roberto Spadim wrote:
maybe ldap or other feature could help me? thinking about a new auth_plugin for example, there's something that is near to what i need? like setup mysql database in all servers setup auth plugin in all servers pointing to some 'master database with users', any grant or auth will be done there and my current server will say ok you are in, (what i'm saying now is near mysql tables replication + some plugin) thinking again... could replication be used in mysql tables? allowing a automatic flush privileges when something change?
2013/6/18 Reindl Harald <h.reindl@thelounge.net <mailto:h.reindl@thelounge.net>>
Am 19.06.2013 00:03, schrieb Roberto Spadim: > hi guys, what's the better way to have a shared mysql schema? > i'm talking about creating a user in one database and this user be created in many databases (in the same server) > i'm trying with symbolic links in data directory, but sure i have some problems that i need same server version (ok > no problem) and flush tables in all servers after add an user
this is russian roulette
if you need the same users use a dedicated dtabase with it's own connection from all applications or implement logic in the software to connect to all databases for the insert
this is nothing which should be done with hacks
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net <mailto:maria-developers@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
participants (4)
-
James Briggs -
Marian Marinov -
Reindl Harald -
Roberto Spadim