- discuss - lists.mariadb.org

[Maria-discuss] New Question: Galera Cluster In MariaDB Tarball 10.1.14
by AskMonty KB 15 Jul '16

15 Jul '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/galera-cluster-in-mariadb-tarball-10114/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am not able to configure mariadb galera cluster using mariadb-enterprise-10.1.14-linux-x86_64.tar.gz file as there are no galera libraries. is it possible to configure galera cluster using this tarball package. please provide a link from where to download galera libraries for tarball packages. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-cluster-in-mariadb-tarball-10114/

1 0

[Maria-discuss] New Question: Moving mariadb to docker installation
by AskMonty KB 12 Jul '16

12 Jul '16

Hello, A new question has been asked in "MariaDB Community" by kitzu. Please answer it at http://mariadb.com/kb/en/moving-mariadb-to-docker-installation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm running debian jessie and I'm currently trying to replace all my server services with docker containers. After some research, i tried this command: docker run --name mariadb -v /var/lib/mysql:/var/lib/mysql -d -p 3306:3306 -d mariadb:latest after stopping the local mariadb service, but this command didn't work. My webapplications didn't have any database access after. How do i currently move all databases? Is there a more secure way? I just want a drop-in replacement. Starting the docker container and using the mariadb server as I used to. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/moving-mariadb-to-docker-installation/

1 0

[Maria-discuss] replicate to multimaster
by Umarzuki Mochlis 12 Jul '16

12 Jul '16

Hi, I have a single Mariadb server 10.1 on Ubuntu 14.04 and 3 Mariadb 10.1 servers on Ubuntu 16.04 with multimaster setup (galera). Is it possible to setup replication from single server to one of multimasters to keep databases and grants updated on multimaster servers? Or should I export databases and grants from single server to any member os multimaster servers? Thanks for any tips/hints.

3 3

[Maria-discuss] Designated donor.
by Thorvald Hallvardsson 08 Jul '16

08 Jul '16

Hi, I want to configure my cluster of 3 nodes let's call them sql1, sql2, sql3 in the way that maxscale will only balance request to sql1 and sql2 but sql3 will be only for backup/donor purposes. My question is... how can I set permanent donor in galera ? Is wsrep_sst_donor the thing ? Thank you. Regards, TH

4 6

[Maria-discuss] Unable to build connector-c
by Muhammad Bashir Al-Noimi 06 Jul '16

06 Jul '16

Hi, I want to use mariadb client for Qt so I tried to build mariadb-connector-c using the following parameters under Linux Mint 17.3 x64 xfce: #!/bin/bash version=2.3.0 pkg=mariadb-connector-c-$version-src.tar.gz url=https://downloads.mariadb.org/f/connector-c-$version/$pkg dir=$(basename $pkg .tar.gz) if [ ! -d $dir ]; then wget -c $url tar -xf $pkg || exit 1 fi pushd $dir sed -i -e"s|ADD_SUBDIRECTORY(unittest/libmariadb)|#ADD_SUBDIRECTORY(unittest/libmariadb)|" CMakeLists.txt sed -i -e"N; s|typedef unsigned short ushort;\n#endif|#endif\ntypedef unsigned short ushort;|" include/my_global.h sed -i -e"N; s|SET_TARGET_PROPERTIES(libmariadb PROPERTIES VERSION.*||" libmariadb/CMakeLists.txt sed -i -e"N; s|SOVERSION \${CPACK_PACKAGE_VERSION_MAJOR})||" libmariadb/CMakeLists.txt # Pig disgusting: the previous multiline thingie should've done it sed -i -e"N; s|\${CPACK_PACKAGE_VERSION_MAJOR}||" libmariadb/CMakeLists.txt # Pig disgusting: what the fuck mkdir build pushd build PKG_CONFIG_PATH=$SR/usr/lib/pkgconfig cmake \ -DCMAKE_BUILD_TYPE=Release \ -DCMAKE_C_FLAGS=--sysroot="$SR" \ -DCMAKE_INSTALL_PREFIX="$SR/usr" \ -DCMAKE_C_COMPILER="$BR"gcc \ -DCMAKE_LINKER="$BR"ld \ -DCMAKE_AR="$BR"ar \ -DCMAKE_NM="$BR"nm \ -DCMAKE_OBJCOPY="$BR"objcopy \ -DCMAKE_OBJDUMP="$BR"objdump \ -DCMAKE_RANLIB="$BR"ranlib \ -DCMAKE_STRIP="$BR"strip \ -DICONV_INCLUDE_DIR="$SR/usr/include" \ -DICONV_LIBRARIES="$SR/usr/lib/libiconv.a" \ -DWITH_EXTERNAL_ZLIB=ON \ -DZLIB_INCLUDE_DIR="$SR/usr/include" \ -DZLIB_LIBRARY="$SR/usr/lib/libz.so" ../ || exit 1 make install || exit 1 popd # ??? pwd cp build/libmariadb/*.{a,so}"$SR/usr/lib/mariadb/" || exit 1 popd But I get this error message: /home/mbnoimi/Snippets/Scripts/Shell/create-mysql-qt-android-plugin/mariadb-connector-c-2.3.0-src/libmariadb/my_context.c: In function 'my_context_init': /home/mbnoimi/Snippets/Scripts/Shell/create-mysql-qt-android-plugin/mariadb-connector-c-2.3.0-src/libmariadb/my_context.c:129:11: error: missing binaryoperator before token"(" #if sizeof(char *) > SIZEOF_INT*2 ^ make[2]: *** [libmariadb/CMakeFiles/mariadb_obj.dir/my_context.c.o] Error 1 make[1]: *** [libmariadb/CMakeFiles/mariadb_obj.dir/all] Error 2 make: *** [all] Error 2 Changes: diff: ./rootfs_files_before.txt: No such file or directory mbnoimi@mbnoimi-laptop ~/Snippets/Scripts/Shell/create-mysql-qt-android-plugin $ How can I fix this issue? NOTE: For full thread about this issue you can use this link <https://forum.qt.io/topic/69038/unable-to-build-mysql-plugin>. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi

1 0

[Maria-discuss] Unable to build connector-c
by Muhammad Bashir Al-Noimi 06 Jul '16

06 Jul '16

1 0

[Maria-discuss] Regarding DR site set-up
by Karthick Subramanian 05 Jul '16

05 Jul '16

Dear Experts, I have a question on Max Scale requirement: In prod - we have two DB server as Primary(Master) and Secondary(Slave). Both being controlled via MaxScale. Do we need to really set it up similar way in DR site also? I meant - Do we need to keep Max Scale set it up in DR as well. Anyway, DR is going to be exceptional scenarios in which entire application servers also work out of DR site and we can still point all the app servers in DR site configured directly to access the Maria DB server at DR instead of Max Scale. Note: We are currently not using MaxScale for any complex needs, we are using MaxScale for normal routing like RW split etc. I know ideal is keep both Prod site and DR site equivalent. But as cost cutting on servers etc, shall we keep DR the way I mentioned. Could you please provide your opinion on this. Regards, Karthick

2 3

[Maria-discuss] MariaDB 10.2.1 Alpha and other releases now available
by Daniel Bartholomew 04 Jul '16

04 Jul '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.1 Alpha. Also now available are the following Stable (GA) releases: MariaDB Connector/C 2.3.0, MariaDB Galera Cluster 5.5.50, and MariaDB Galera Cluster 10.0.26. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.1 Alpha - Release Notes: https://mariadb.com/kb/en/mdb-1021-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1021-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.1 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/C 2.3.0 - Release Notes: https://mariadb.com/kb/en/mcc-230-rn/ - Changelog: https://mariadb.com/kb/en/mcc-230-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.3.0/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-c/ MariaDB Galera Cluster 5.5.50 - Release Notes: https://mariadb.com/kb/en/mgc-5550-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5550-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.50/ About MariaDB Galera Cluster: - https://mariadb.com/kb/en/about-mariadb-galera-cluster/ MariaDB Galera Cluster 10.0.26 - Release Notes: https://mariadb.com/kb/en/mgc-10026-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10026-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.26/ About MariaDB Galera Cluster: - https://mariadb.com/kb/en/about-mariadb-galera-cluster/ - - 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/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Expanding Galera cluster
by Thorvald Hallvardsson 04 Jul '16

04 Jul '16

Hi guys, I need some help as I'm preparing to expand my existing Galera cluster. Generally the purpose of it is I need to replace 3 VMs I have a cluster running on to 2 physical servers I have been given for that purpose. My idea was to join 2 physical cluster to the existing cluster of 3 and then remove all 3 VMs from the cluster leaving 2 physical nodes within. I have a arbitrator box within the cluster as well. The config at the moment contains 2 maxscale proxy nodes on the front balancing the read queries across the entire cluster of 3 and write queries to the elected master. What I want to achieve is as I said above but + I will need another help with maxscale to expand and then shrink the cluster down to 2 nodes afterwards. I have had a situation before when I had to do a simple config change on the Galera cluster and I was trying to mark nodes and put them into maintenance mode to stop traffic coming to them but the commands like set server NODE master didn't actually do anything. I had situations when I had 2 masters in the cluster for a second because then something was happening that my manually selected master was becoming a slave again. I couldn't find anything on the internet what would point me into right direction and explain the whole procedure in details. My cluster is quite busy at the moment even overnight so there is no perfect time to do anything on it. I need to do it the least disruptive way and the most controlled way as well. Hence I'm asking for help and suggestions as I found both Galera and maxscale documentation very very brief not actually providing any decent details or procedures. I found much more help from Percona but descriptions don't match sometimes. Please help. Regards, TH

2 2

[Maria-discuss] New Question: Aggregating data with help tables will raise open table cache - solution?
by AskMonty KB 04 Jul '16

04 Jul '16

Hello, A new question has been asked in "MariaDB Community" by TDS. Please answer it at http://mariadb.com/kb/en/aggregating-data-with-help-tables-will-raise-open-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I need some inspiration :-) Currently we have ~10 tables, each around 3 million rows and about 100 columns in MyISAM format. These table are only for writing data. A cronjob will aggregate data from these tables to time defined tables, e.g. min, hour, day, etc. And here is the problem: With CREATE TABLE and CREATE TEMPORARY TABLE there are difficulties. We create a table, read in data from main table, calculating values and write new data to time table. After that we delete the help table. But the table open cache gets bigger and bigger (>4000 in a day). So how can we avoid this? Switching to InnoDB or use another schema of aggregating values? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/aggregating-data-with-help-tables-will-raise-open-…

1 0