December 2015 - discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.1.8 Stable (GA) now available
by Daniel Bartholomew 10 Dec '15

10 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.8. This is the first Stable (GA) release in the MariaDB 10.1 series. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.8 - Release Notes: https://mariadb.com/kb/en/mariadb-1018-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1018-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.8 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 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/en/donate/ We hope you enjoy MariaDB! -- MariaDB 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

6 9

[Maria-discuss] SST xtrabackup-v2 and 10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0')
by Engelmann Florian 08 Dec '15

08 Dec '15

Dear list, this is my 1st time testing Galera Cluster with MariaDB 10.1. With version 10.1.9 I get the following error using xtrabackup-v2 for SST: Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026872588032 [Note] WSREP: Member 1.0 () requested state transfer from '*any*'. Selected 0.0 ()(SYNCED) as donor. Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026872588032 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0) Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140027564807936 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026000176896 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0'' Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140027564807936 [Note] WSREP: sst_donor_thread signaled with 0 Dec 7 18:32:22 wsc-db01a-test mysqld: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20151207 18:32:22.249) Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Streaming with xbstream Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Using socat as streamer Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Using /tmp/tmp.l5q4N6ELOD as innobackupex temporary directory Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Streaming GTID file before SST Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Evaluating xbstream -c ${INFO_FILE} | socat -u stdio TCP:10.1.234.223:4444; RC=( ${PIPESTATUS[@]} ) Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Sleeping before data transfer for SST Dec 7 18:32:23 wsc-db01a-test mysqld: 2015-12-07 18:32:23 140026880980736 [Note] WSREP: (6b6485fa, 'tcp://0.0.0.0:4567') turning message relay requesting off Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Streaming the backup to joiner at 10.1.234.223 4444 Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Evaluating innobackupex --no-version-check $tmpopts $INNOEXTRA --galera-info --stream=$sfmt $itmpdir 2> >(logger -p daemon.err -t -innobackupex-backup) | socat -u stdio TCP:10.1.234.223:4444; RC=( ${PIPESTATUS[@]} ) Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: This software is published under Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Get the latest version of Percona XtraBackup, documentation, and help resources: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: http://www.percona.com/xb/ubuntu Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: 151207 18:32:32 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock' as 'sstuser' (using password: NO). Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: 151207 18:32:32 innobackupex: Connected to MySQL server Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: innobackupex: Error: Unsupported server version: '10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0'). Please report a bug at https://bugs.launchpad.net/percona-xtrabackup Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: innobackupex finished with error: 1. Check /var/lib/mysql//innobackup.backup.log Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Cleanup after exit with status:22 Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Cleaning up temporary directories Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Failed to read from: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0' Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0': 22 (Invalid argument) Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Command did not run: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0' Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026872588032 [Warning] WSREP: 0.0 (): State transfer to 1.0 () failed: -22 (Invalid argument) Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026872588032 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0) Dec 7 18:32:33 wsc-db01a-test mysqld: 2015-12-07 18:32:33 140026872588032 [Note] WSREP: Member 0.0 () synced with group. Dec 7 18:32:33 wsc-db01a-test mysqld: 2015-12-07 18:32:33 140026872588032 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) My 90-galera.cnf looks like: [mysqld] query_cache_size = 0 binlog_format = ROW default_storage_engine = InnoDB innodb_autoinc_lock_mode = 2 innodb_doublewrite = 1 server_id = 100 innodb_flush_log_at_trx_commit = 0 wsrep_on = ON wsrep_provider_options = "gcache.size=512M;pc.recovery=TRUE" wsrep_cluster_address = "gcomm://10.1.234.222,10.1.234.223,10.1.234.224,10.1.234.225" wsrep_cluster_name = dba wsrep_sst_method = "xtrabackup-v2" #wsrep_sst_method = "rsync" wsrep_sst_auth = "sstuser:xxxxxxxxxxxxxxxxxxxxxxx" wsrep_provider = "/usr/lib/galera/libgalera_smm.so" wsrep_slave_threads = 4 wsrep_node_address = 10.1.234.221 wsrep_node_incoming_address = 10.0.234.221 With wsrep_sst_method = "rsync" SST works fine. Did I miss something? All the best, Florian

2 2

[Maria-discuss] New Question: Mysql database concept's information.
by AskMonty KB 08 Dec '15

08 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/mysql-database-concepts-information/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I am studying about the MariaDB and MySql database and need few necessary details about it. I could not find the details while searching in google. I want to know what tools have been used while developing MySql database? Like the editor window output window tools, Parser, etc. Hope to get answer soon. Thanks and regards. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysql-database-concepts-information/

1 0

[Maria-discuss] New Question: How to store the string in %s
by AskMonty KB 07 Dec '15

07 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/how-to-store-the-string-in-s/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I am studying source code of MySQL.I noted that in error messages they are using %s,%d here %s is used to store the database name,table name which is chose by user,and %d for error number. I want to know how they store the string in %s.can you help me for that. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-store-the-string-in-s/

1 0

[Maria-discuss] New Question: How to create the line numbers in MySQL query window
by AskMonty KB 07 Dec '15

07 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/how-to-create-the-line-numbers-in-mysql-query-wind… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to create a query window as MySQL query window.for that I am using visual studios .can you say how can they create the line numbers. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-create-the-line-numbers-in-mysql-query-wind…

1 0

[Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster
by Bertrand Caplet 05 Dec '15

05 Dec '15

Hi all, I'm using MariaDB Cluster with 3 servers and I often have split brain because of network. When a network split brain happen, only one node is disconnected. What is for you the best choice for SST or maybe IST method for this configuration ? (N.B.: I already tried rsync method but i'm not really satisfied with it). I have another question, I tried xtrabackup-v2 but it seems this method can't be use for bootstrapping while database is on. Does xtrabackup method can do this ? Regards, -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

3 4

[Maria-discuss] New Question: filter QLA
by AskMonty KB 03 Dec '15

03 Dec '15

Hello, A new question has been asked in "MaxScale Filters" by chris_jack_g. Please answer it at http://mariadb.com/kb/en/filter-qla/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to show in the query log the user in which the session originated? Here is my filter config, pretty straight forward: [qla] type=filter module=qlafilter options=/tmp/QueryLog -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/filter-qla/

1 0

[Maria-discuss] New Question: (Another) Install problem on Mac OSX 10.10.2
by AskMonty KB 03 Dec '15

03 Dec '15

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by 7stud. Please answer it at http://mariadb.com/kb/en/another-install-problem-on-mac-osx-10102/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- In am using the Generic Build instructions: https://mariadb.com/kb/en/mariadb/generic-build-instructions/ And here were my results trying to install: **MariaDB 10.1.8**\\ on **Mac OSX 10.10.2 **\\ with **Xcode 6.3.2**\\ {{{ $ cmake --version cmake version 3.4.0-rc3 CMake suite maintained and supported by Kitware (kitware.com/cmake) $ cmake . -DBUILD_CONFIG=mysql_release $ make --version GNU Make 3.81 Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 $ make ... ... ~/Downloads/mariadb-10.1.9$ make ... ... ... Scanning dependencies of target install_tdb_h [ 71%] Generating db.h [ 71%] Built target install_tdb_h Scanning dependencies of target util_static [ 71%] Building CXX object storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/context.cc.o In file included from /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/util/context.cc:94: In file included from /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/util/context.h:96: /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/buildheader/db.h:323:1: error: empty struct has size 0 in C, size 1 in C++ [-Werror,-Wextern-c-compat] struct __toku_db_lsn { ^ 1 error generated. make[2]: *** [storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/context.cc.o] Error 1 make[1]: *** [storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/all] Error 2 make: *** [all] Error 2 ~/Downloads/mariadb-10.1.9$ }}} -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/another-install-problem-on-mac-osx-10102/

1 0

[Maria-discuss] Voting for some MariaDB Server related submissions for Percona Live
by Colin Charles 03 Dec '15

03 Dec '15

Hi all, It turns out that what is considered to be the largest conference for those interested in the MySQL world, nowadays called the Percona Live Data Performance Conference, is requiring the community to vote on submissions that they would like to hear. Only after voting, will those with a certain threshold (not published) be sent to the next level for the program committee to vote on. Its clear that you *do not* have to be attending the event, but you do need to register to vote. I’m sure all of us would appreciate your votes. The people below offering talks are Sergei Golubchik, Sergei Petrunia, Michael “Monty” Widenius, Gerry Narvaja, Serge Frezefond, Anders Karlsson, and me, Colin Charles. Thanking you all in advance! cheers, -colin Using and Managing MariaDB https://www.percona.com/live/data-performance-conference-2016/sessions/comp… MariaDB 10.1 - What's New? (*** includes Monty himself! ***) https://www.percona.com/live/data-performance-conference-2016/sessions/mari… Databases in the Hosted Cloud https://www.percona.com/live/data-performance-conference-2016/sessions/data… Best Practices for MySQL High Availability https://www.percona.com/live/data-performance-conference-2016/sessions/best… Choosing a MySQL HA solution today https://www.percona.com/live/data-performance-conference-2016/sessions/choo… MariaDB/MySQL security essentials https://www.percona.com/live/data-performance-conference-2016/sessions/mari… The MySQL Server Ecosystem in 2016 https://www.percona.com/live/data-performance-conference-2016/sessions/mysq… MariaDB Connectors: Fast and Smart with the new protocol optimizations https://www.percona.com/live/data-performance-conference-2016/sessions/mari… MariaDB 10.1 Security: Validation, Authentication, Encryption https://www.percona.com/live/data-performance-conference-2016/sessions/mari… Window functions in MariaDB https://www.percona.com/live/data-performance-conference-2016/sessions/wind… Exploring MariaDB Query Optimizer with ANALYZE for statements https://www.percona.com/live/data-performance-conference-2016/sessions/expl… Window functions in MariaDB https://www.percona.com/live/data-performance-conference-2016/sessions/wind… Exploring MariaDB Query Optimizer with ANALYZE for statements https://www.percona.com/live/data-performance-conference-2016/sessions/expl… The MariaDB CONNECT Storage Engine to simplify heterogeneous data access https://www.percona.com/live/data-performance-conference-2016/sessions/mari… Low Impact Monitoring https://www.percona.com/live/data-performance-conference-2016/sessions/low-… MariaDB on Power8: https://www.percona.com/live/data-performance-conference-2016/sessions/ibm-… The good and bad on datatypes in different database systems: https://www.percona.com/live/data-performance-conference-2016/sessions/migr… Character sets and Collations explained: https://www.percona.com/live/data-performance-conference-2016/sessions/char… -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

1 0

[Maria-discuss] New Question: Stored Procedures & Functions on nodes in a Galera Cluster
by AskMonty KB 03 Dec '15

03 Dec '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by tim_peart_g. Please answer it at http://mariadb.com/kb/en/stored-procedures-functions-on-nodes-in-a-galera-c… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am at the planning stage of a new Galera/MariaDB cluster. I can find very little info on how Stored Procedures and Functions are handled across the cluster. Am I safe to assume that a Stored Procedure or Function which is defined on one cluster node is not automatically propagated to any of the other nodes in the cluster? If so, then what are the Best Practices regarding update of Stored Procedures and Functions across the Cluster? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/stored-procedures-functions-on-nodes-in-a-galera-c…

1 0