- discuss - lists.mariadb.org

[Maria-discuss] Maria DB 10.0 Roles Usage
by Adam Scott 13 Nov '13

13 Nov '13

Roles are supported according to ( https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/) So the following commands worked: create role read_only;grant select on example.* to read_only;grant usage on example.* to read_only; grant select on example.* to app_report@'localhost';When i logged in as app_report, show databases did not show the example database. And selects against tables in the example database did not work. What am I missing? Thanks, Adam C. Scott

4 4

[Maria-discuss] MySQL Workbench 6 & MariaDB
by Colin Charles 12 Nov '13

12 Nov '13

Hi! I now notice that MySQL Workbench connecting to MariaDB 10.0.5 will tell you that the server version 10 is not supported. Is this a bug worthy of reporting to Oracle upstream at bugs.mysql.com or do we just list it as an incompatibility here: https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/ Would be interested in hearing your thoughts on this matter cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

2 2

[Maria-discuss] Is OQGRAPH back in 10.0.5?
by Colin Charles 11 Nov '13

11 Nov '13

Hi! I noticed that ha_oqgraph.so exists in /usr/lib64/mysql/plugin on the 10.0.5 packages. So I just installed it, and it shows up in SHOW ENGINES output. I tried creating a table, and it worked (confirmed via output in SHOW TABLE STATUS) So, is this something we are planning on shipping in 10.0? This is version 2 of the plugin and it is now marked to be Beta quality (from INFORMATION_SCHEMA.PLUGINS) If we are shipping this in 10.0, we really need to improve the documentation around it in the Knowledgebase cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] New Question: mariadb RAM usage
by AskMonty KB 08 Nov '13

08 Nov '13

Hello, A new question has been asked in "MariaDB Performance & Advanced Configurations" by ferreirah: -------------------------------- When you bundle your app with mysql or mariadb, you don't want mysql or mariadb to devour all your RAM, especially if the database is installed on a desktop operating system. I haven't recently tried out mysql or mariadb, but I was wondering about the minimum memory required on windows. I sent a question to mysql and they told me it only requires 1 MB RAM minimum. At that stage they still supported windows 2000 and windows xp, which isn't supported any more. I remember installing mysql on windows xp and you could configure it through a wizard. You could either set it to dedicated server, shared server or developer install. I suppose developer install will use the least amount of RAM. How much RAM would mariadb use with a developer install if you had to install it on windows vista/7/8/8.1? Does it matter which engine you are using? XtraDB? Thanks H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-ram-usage/

1 0

[Maria-discuss] New Question: licencing of mariadb and mysql dot net connector
by AskMonty KB 08 Nov '13

08 Nov '13

Hello, A new question has been asked in "Client libraries" by ferreirah: -------------------------------- Hi I agree with one of the previous posts that licencing is such a tricky aspect of IT. I read in previous posts that when using mariadb with the odbc framework that you can distribute both the odbc connector and mariadb with your closed source commercial application. It said in the post if you use a framework to access the database then both the connector and mariadb are free for commercial use. What about dot net? Dot net is a framework through which you can access mariadb? Does this mean that both the dot net connector as well as mariadb are free for closed source commercial use? I suppose the downside is that you can't use any mariadb specific features if you are using the mysql connector? Thanks H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/licencing-of-mariadb-and-mysql-dot-net-connector/

1 0

[Maria-discuss] MariaDB 10.0.5 Beta Now Available
by Daniel Bartholomew 07 Nov '13

07 Nov '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.5. This is a Beta release. It includes new features and bug fixes. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.5 Beta Blog Post - https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/ MariaDB 10.0.5 Beta - Release Notes: https://mariadb.com/kb/en/mariadb-1005-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1005-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.5 About MariaDB 10.0: https://mariadb.com/kb/en/what-is-mariadb-100 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Downloads page should be updated soon.
by Peter Laursen 06 Nov '13

06 Nov '13

(to whom it concerns) *B*log post at https://mariadb.com/blog/mariadb-100-beta-launched-important-milestoneurges to download 10.05 but downlods page https://downloads.mariadb.org/ give access to 10.0.4 only. Thanks! (I could not comment in the blog as it requires authentication from services where I don't have an account. Why is Google/gmail not an option here BTW?) -- Peter -- Webyog

2 1

[Maria-discuss] New Question: Client for Mysql - zeroDateTimeBehavior=convertToNull key
by AskMonty KB 05 Nov '13

05 Nov '13

Hello, A new question has been asked in "MariaDB Java Client" by netanel: -------------------------------- Hi, Does it possible to use the "zeroDateTimeBehavior=convertToNull" to the jdbc url connection string like in the original mysql driver? Is there a workaround? Netanel -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/client-for-mysql-zerodatetimebehaviorconverttonull…

1 0

[Maria-discuss] New Question: XtraDB and Workbench CE compatibility?
by AskMonty KB 04 Nov '13

04 Nov '13

Hello, A new question has been asked in "XtraDB and InnoDB" by ferreirah: -------------------------------- Hi I read here that there are some issues with Aria and Workbench? Are there any issues with XtraDB and Workbench CE? People have mentioned HeidiSQL but can it do diagrams of your table structure? Will HeidiSQL work with XtraDB? Any other free for commercial use, alternatives? Thanks H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/xtradb-and-workbench-ce-compatibility/

1 0

[Maria-discuss] New Question: XtraDB and ODBC compatibility?
by AskMonty KB 04 Nov '13

04 Nov '13

Hello, A new question has been asked in "XtraDB and InnoDB" by ferreirah: -------------------------------- Hi How compatible is XtraDB with the myodbc driver? Any issues that you know about? Thanks H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/xtradb-and-odbc-compatibility/

1 0