February 2017 - discuss - lists.mariadb.org

[Maria-discuss] ROLE and DEFAULT DATABASE
by Karthick Subramanian 09 Feb '17

09 Feb '17

Hi, Can anyone assist me on this below: I have a database called appdb. I need to grant access to this db to different users say: api_user, app_user, portal_user. So I created a ROLE as APP_ROLE and GRANT as below: GRANT SELECT, INSERT, UPDATE, DELETE ON APPDB.* TO APP_ROLE; Later I assign the Role to user: GRANT APP_ROLE TO API_USER@'%' IDENTIFIED BY 'YOU'; SET DEFAULT ROLE APP_ROLE TO API_USER@'%'; But the problem now is: Application team want to choose the database when they establish connection. But they couldn't use APPDB. So they couldn't see any db objects listed in APPDB. Is there a way we can assign a default database also for user.

3 2

[Maria-discuss] default_tmp_storage_engine=NULL
by Ian Gilfillan 09 Feb '17

09 Feb '17

What is the purpose/effect of having MariaDB's default_tmp_storage_engine setting default to NULL instead of the default used in MySQL, Innodb? I can't see any obvious differences in behaviour.

3 3

Re: [Maria-discuss] R: default_tmp_storage_engine=NULL
by Federico Razzoli 09 Feb '17

09 Feb '17

Well, I can't think many cases where InnoDB is not the default engine. But, if it is not, why should you use it for temporary tables? If you mainly use TokuDB, maybe don't want to mix the engines. If you use MyISAM, maybe you don't want transactional temporary tables. I still think that MEMORY makes sense in all cases :) Federico -------------------------------------------- Gio 9/2/17, Ian Gilfillan <ian(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] R: default_tmp_storage_engine=NULL A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Giovedì 9 febbraio 2017, 10:32 > I beleive that there is a difference if default_storage_engine != innodb, because in that case, default_tmp_storage_engine will not be InnoDB. Yes, that's the case. So why is this desirable in MariaDB as opposed to MySQL's implementation? _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

1 0

[Maria-discuss] R: default_tmp_storage_engine=NULL
by Federico Razzoli 09 Feb '17

09 Feb '17

Hi Ian I beleive that there is a difference if default_storage_engine != innodb, because in that case, default_tmp_storage_engine will not be InnoDB. It is much less clear to me why default_tmp_storage_engine doesn't default to MEMORY in both MariaDB and MySQL :) Federico -------------------------------------------- Gio 9/2/17, Ian Gilfillan <ian(a)mariadb.org> ha scritto: Oggetto: [Maria-discuss] default_tmp_storage_engine=NULL A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Giovedì 9 febbraio 2017, 09:23 What is the purpose/effect of having MariaDB's default_tmp_storage_engine setting default to NULL instead of the default used in MySQL, Innodb? I can't see any obvious differences in behaviour. _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

2 1

[Maria-discuss] 2017 MariaDB Developers Conference
by Ian Gilfillan 07 Feb '17

07 Feb '17

The 2017 MariaDB Developers Conference is taking place in New York City from 9-10 April. It's free to attend for everyone interested and you are welcome to sign up on the Meetup Group, as well to propose a topic, or vote for an existing topic. Details at https://mariadb.org/2017-developers-meetup-new-york/ M|17, the MariaDB User's Conference, is taking place directly afterwards, so if you're in the area, why not attend both :) https://m17.mariadb.com/

1 1

[Maria-discuss] CentOS7 Cassandra
by Ian Gilfillan 01 Feb '17

01 Feb '17

Can someone clarify the status of Cassandra in CentOS7? It appears to have been available in 6, but not in 7.

5 5