November 2016 - discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.1.19 and other releases now available
by Daniel Bartholomew 07 Nov '16

07 Nov '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.19, MariaDB Galera Cluster 10.0.28, and MariaDB Connector/ODBC 2.0.13. These are all stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.19 - Release Notes: https://mariadb.com/kb/en/mdb-10119-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10119-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.19 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Galera Cluster 10.0.28 - Release Notes: https://mariadb.com/kb/en/mgc-10028-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10028-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.28 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/ODBC 2.0.13 - Release Notes: https://mariadb.com/kb/en/mco-2013-rn/ - Changelog: https://mariadb.com/kb/en/mco-2013-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.13 About MariaDB Connector/ODBC: - https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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 or my.ini 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 the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - 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] Community Involvement - GSoC Mentor Summit impressions
by Vicențiu Ciorbaru 07 Nov '16

07 Nov '16

Hi everyone! Since MariaDB has completed another Google Summer of Code program this year, with some great projects as well, the MariaDB Foundation was able to send 2 mentors to the summit in California this year. I was one of the people that had the privilege to go. There were a lot of talks there about community involvement and how to encourage people to contribute. I've picked the ideas that I've found to be most interesting and useful and have blogged [1] about them. I intend to try and apply some of them if possible. Since this is a community matter (albeit more GSoC related), it makes sense to ask for feedback from the community. I think some of the ideas are at least partly implemented but we can always do better. If you're interested, lets have a discussion on this. Vicențiu [1] http://vicentiu.ciorbaru.io/community-involvement-gsoc-mentor-summit-impres…

1 0

[Maria-discuss] GRANT PROXY access denied with proxied User
by Fabian Jucker 04 Nov '16

04 Nov '16

Hi, At our enterprise we have a DBA-User proxied with "GRANT PROXY ON 'dba'@'%' TO ''@'%'" and backed by pam module (roughly according to [1]) to login from our ldap-accounts. When logging in via pam into the DBA-Role I'm unable to grant the proxy privileges to other users. Following [2] (MySQL docs, because the MariaDB docs are lacking any further information about this) I already tried to "GRANT PROXY ON 'dba'@'%' TO ''@'%' WITH GRANT OPTION" and "GRANT PROXY ON ''@'' TO 'dba'@'%' WITH GRANT OPTION" (as [2] is ambiguous about if the "proxied_user" or the "proxy_user" should have the "WITH GRANT OPTION"), but neither the first grant nor the second one showed any effect. When I grant the proxy privilege with grant option to a local user, this user is able to grant the proxy privileges to other users. So my question is, if it's not possible to grant proxy privileges while one's logged in with a proxy user? Thanks in advance, Fabian References: [1]: https://mariadb.com/blog/configuring-pam-authentication-and-user-mapping-ma… [2]: https://dev.mysql.com/doc/refman/5.5/en/proxy-users.html

1 1

[Maria-discuss] MYSQL_OPT_CONNECT_TIMEOUT default?
by Peter Laursen 03 Nov '16

03 Nov '16

MySQL docs page http://dev.mysql.com/doc/refman/5.7/en/mysql-options.html *MYSQL_OPT_CONNECT_TIMEOUT (argument type: unsigned int *)* *The connect timeout in seconds.* However I don't find it documented anywhere what the default (client-initiated) connect_timeout will become if not specified in mysql_options(). Or will the client never initiate a timeout in connection phase in such case? We are usng MariaDB C-conn 2.31 so the question here on this list is specifically for MariaDB connector. I didn't find it documented here either. But both MySql and MariaDB have probably inherited this from the old LGPL 3.x connector so this are probably the same in both. Asked a docs request here as well: http://bugs.mysql.com/bug.php?id=83600 --- Peter

2 3

[Maria-discuss] MariaDB 10.1.18 server audit question?
by Ljr Yang 02 Nov '16

02 Nov '16

HI, all We use MariaDB 10.1.18 and CentOS 6.7, today, try to use server audit log. after execute SET GLOBAL server_audit_events = "query_ddl,query_dml,query_dcl" and SET GLOBAL server_audit_logging = 1 ; find have not filter "select" statement in audit log 20161102 11:08:52,fm-test-118,root,172.28.10.121,908933,2799737,QUERY,test,'select * from anv01 LIMIT 0, 100',0 -- Ljr

2 1

[Maria-discuss] upgrading galera 10.0 -> 10.1 without writes downtime
by Federico Razzoli 02 Nov '16

02 Nov '16

Hello list I have to upgrade a cluster and I hoped I can do it safely without a downtime. In my understanding though it is not possible. In my specific case, the cluster is 10.0 and must be upgraded to 10.1. There is a "master" node. Steps are: 1. I upgrade all "slave" nodes 2. I change the "master" 3. I upgrade the old master The problem is that, between 2 and 3, old master is 10.0, and it replicates from 10.1. This is not supported, based on this page: https://mariadb.com/kb/en/mariadb/upgrading-mariadb-upgrading-from-mariadb-… "to prevent 10.1 propagating to 10.0, which is not supported" So my question is, is there a way to upgrade this cluster without writes downtime? Regards, Federico

1 0

[Maria-discuss] Flashback (MDEV-10459) bikeshedding a name
by Daniel Black 02 Nov '16

02 Nov '16

During the MariaDB Developers Meetup last month we deferred deciding on a name for Flashback - a rewinding of database state using binary logs applied in reverse. It is described in MDEV-10459 (https://jira.mariadb.org/browse/MDEV-10459). If you have an opinion as to what name to choose follow the link below to start the survey. Thank you for your participation! The survey closes at the end of this month. https://www.surveymonkey.com/r/T8JVPR3 Results so far: https://www.surveymonkey.com/results/SM-DPMRQV9N

3 3

[Maria-discuss] Replication compatibility MySQL/MariaDB
by Daniel Black 02 Nov '16

02 Nov '16

Folks, At the MariaDB Developer meetup there was some discussion about the limits of compatibility especially regarding replication. I've started a section on this page: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ If you can identify what can/cannot work in various replication modes between MySQL and MariaDB please document it on this page. If you cannot edit this for some reason reply to the MariaDB Discuss list and eventually the results can be correlated and the page can be updated. As usual other material changes to improving the KB documentation is welcome. Daniel

1 0

[Maria-discuss] node join failure?
by l vic 01 Nov '16

01 Nov '16

I see intermittent failure for some nodes to join cluster (see below): 2016-11-01 17:24:22 140050125105920 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (fdb9a4a3-a056-11e6-a01d-5a15e8d77e80): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable. 2016-11-01 17:24:22 140049819625216 [Note] WSREP: Member 1.0 () requested state transfer from '*any*'. Selected 0.0 ()(SYNCED) as donor. 2016-11-01 17:24:22 140049819625216 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 4) 2016-11-01 17:24:22 140050125105920 [Note] WSREP: Requesting state transfer: success, donor: 0 2016-11-01 17:24:24 140049819625216 [Warning] WSREP: 0.0 (): State transfer to 1.0 () failed: -255 (Unknown error 255) 2016-11-01 17:24:24 140049819625216 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():733: Will never receive state. Need to abort. Any idea what the cause can be and how to deal with it? Thank you,

1 0