November 2016 - discuss - lists.mariadb.org

[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