- discuss - lists.mariadb.org

[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

Re: [Maria-discuss] [Maria-docs] New mariadb.org in the works
by Otto Kekäläinen 01 Dec '15

01 Dec '15

(I am replying back to the list as the information might be useful to others too) 2015-12-01 2:54 GMT+02:00 Daniel Bartholomew <dbart(a)mariadb.com>: > On Mon, Nov 30, 2015 at 4:46 PM, Otto Kekäläinen <otto(a)seravo.fi> wrote: >> Work in progress is visible at https://new.mariadb.org/ >> >> Please send us your feedback! > > It's looking great! Awesome work. I really like the new look. > > I noticed a couple typos on one of the pages, whom should I send them to? You can log in as dbart at https://new.mariadb.org/wp-admin/ All the content from the old blog, including user accounts, has been migrated to the new site apart from the very latest blogs and comments. - Otto

1 0

[Maria-discuss] replicate_rewrite_db as a system variable
by Ian Gilfillan 27 Nov '15

27 Nov '15

Is there a reason replicate_rewrite_db is not available as a system variable, while other similar settings, such as replicate_do_db are?

2 1

[Maria-discuss] New Question: Moving from Oracle to MariaDB
by AskMonty KB 27 Nov '15

27 Nov '15

1 0

[Maria-discuss] New Question: How to install MariaDB Galera without internet connection( without YUM)?
by AskMonty KB 25 Nov '15

25 Nov '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by pluto0327. Please answer it at http://mariadb.com/kb/en/how-to-install-mariadb-galera-without-internet-con… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi guys, I want to install a HA ( high availability ) environment without internet, but I am a rookie. Most webs, I can't find relative information how to do this job. First, how to do with step by step instructions, please? Second, is it correct that I must have 4 PCs ( 3 cluster nodes and 1 HA proxy)? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-install-mariadb-galera-without-internet-con…

1 0

[Maria-discuss] MariaDB and Galera Support from Redhat (instead of MariaDB corp)
by Lukas Lehner 25 Nov '15

25 Nov '15

Hi we run DBaaS (Galera Cluster) with growing customer base. We also offer MongoDB, where we have commercial support from MongoDB (we can recommend it). MariaDB is included in RHEL, so Red Hat offers support. We anyway pay for Redhat support. So it means we don't need to buy support from MariaDB? Does Redhat employs MariaDB developers and have DBA/Expert know how? Lukas

2 2

[Maria-discuss] Creating MySQL .MYD, .MYI and .frm tables in Maria
by Carl Whalley 25 Nov '15

25 Nov '15

This is the final stage from my thread regarding a botched F22->23 upgrade which hosed bacula. I have been on to bacula support and they claim not to support Maria. Well, "not support" isn't right, just "not explicitly tested" - I know everything was ok under F22/Maria as I have another server to upgrade which runs fine now with this setup. It seems the MySQL tables were created when bacula was installed several iterations of Fedora ago, and at that time they were of the .MYD, .MYI style. Each time fedora was updated, these were carried forwards - possibly through the swap from when MySQL was native to it becoming Maria, as we see now. That's why all the existing ones are in the form with the extensions I mentioned. So, I'm now in a situation where it seems I have to create one last table ("Snapshot") and am having trouble because it somehow has been created but not in the .MYD, MYI style. The create table command is supplied already for me to enter - how can I remove the phantom one and create it again in the format the rest of the tables are in please?

2 1