- discuss - lists.mariadb.org

[Maria-discuss] Galera cluster as slave: Duplicate entry errors
by Otto Berger 08 Sep '14

08 Sep '14

Hi all, i'm new to this list :) My setup: MySQL Server 5.5.37 -> Replication -> Galera 10 Cluster (currently 2 nodes) The old MySQL Master is receiving inserts to a table with a auto_increment field (primary key). The Galera Cluster is configured as classic slave to the master. From time to time i'm getting duplicate entry issues on the galera cluster: 140905 12:06:15 [ERROR] Slave SQL: Error 'Duplicate entry '16383' for key 'PRIMARY'' on query. ... 140905 12:06:15 [Warning] Slave: Duplicate entry '16383' for key 'PRIMARY' Error_code: 1062 I cannot see the problem where there could came from... My thought was if the insert (auto_increment) succeeds on the master then is must also succeed on the galera side... someone with an idea on it? BR Otto

3 3

[Maria-discuss] optimization
by Roberto Spadim 04 Sep '14

04 Sep '14

guys, i have some queries like this: SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;$;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;%;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;%;%294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;$;%294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;%;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;%;%294007/3nfe-1%" LIMIT 1 it's a search about a document number, but the problem is.... the first query at first line (with % at end of the query) return really fast, but executing others queries are very slow, the question is could we optimize this kind of query, since limit=1 row? the explain of this query: idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1PRIMARY mov_documentosrangePRIMARYPRIMARY771Using where; Using index2UNION mov_documentosrangePRIMARYPRIMARY77625612Using where; Using index3UNION mov_documentosrangePRIMARYPRIMARY77625612Using where; Using index4UNION mov_documentosindexPRIMARY771798490Using where; Using index5UNION mov_documentosindexPRIMARY771798490Using where; Using index6UNION mov_documentosindexPRIMARY771798490Using where; Using indexUNION RESULT <union1,2,3,4,5,6>ALL -- Roberto Spadim

3 6

[Maria-discuss] Excluding plugins when building MariaDB 10.1
by Kolbe Kegel 04 Sep '14

04 Sep '14

Hi! I'm trying to build MariaDB 10.1 on OS X. cmake ../server/ -DBUILD_CONFIG=mysql_release -DWITH_SSL=system -DCMAKE_CXX_FLAGS:STRING='-stdlib=libstdc++' -DPLUGIN_TOKUDB=NO -DPLUGIN_OQGRAPH=NO -DWITH_EMBEDDED_SERVER:BOOL=OFF -DWITH_WSREP=OFF The build is failing on tokudb code even though I am trying to avoid building the TokuDB plugin. What gives? Linking CXX shared library libft.dylib Undefined symbols for architecture x86_64: "std::__1::__vector_base_common<true>::__throw_length_error() const", referenced from: toku::dmt<klpair_struct, klpair_struct*, toku::klpair_dmtwriter>::verify() const in bndata.cc.o "std::__1::__vector_base_common<true>::__throw_out_of_range() const", referenced from: toku::dmt<klpair_struct, klpair_struct*, toku::klpair_dmtwriter>::verify() const in bndata.cc.o toku::dmt<klpair_struct, klpair_struct*, toku::klpair_dmtwriter>::verify_internal(toku::dmt_internal::subtree const&, std::__1::vector<bool, std::__1::allocator<bool> >*) const in bndata.cc.o ld: symbol(s) not found for architecture x86_64 clang: error: linker command failed with exit code 1 (use -v to see invocation) make[2]: *** [storage/tokudb/ft-index/ft/libft.dylib] Error 1 make[1]: *** [storage/tokudb/ft-index/ft/CMakeFiles/ft.dir/all] Error 2 make: *** [all] Error 2 Kolbe -- Kolbe Kegel, Principal Support Engineer SkySQL, The MariaDB Company | http://www.skysql.com

3 4

[Maria-discuss] MariaDB Galera Cluster 10.0.13 now available
by Daniel Bartholomew 03 Sep '14

03 Sep '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.13 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.13 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10013-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10013-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.13 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 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 - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - 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/ - http://www.cafepress.com/mariadb 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

Re: [Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 29 Aug '14

29 Aug '14

Hello, Is MariaDB Galera Cluster 10.0.13 on track for release today? https://mariadb.atlassian.net/browse/MDEV/fixforversion/16800/ Thank you, On Mon, Aug 25, 2014 at 1:40 PM, Nirbhay Choubey <nirbhay(a)skysql.com> wrote: > Hi Shannon, > > On Mon, Aug 25, 2014 at 4:26 PM, Cloud Foundry Services < > cf-services-eng(a)pivotal.io> wrote: > >> Hi Nirbhay, >> >> We're looking forward to these fixes: >> >> https://mariadb.atlassian.net/browse/MDEV-5786 - We were previously >> running mysql_upgrade on every node and getting errors due to replication. >> We now disable replication while mysql_upgrade is running but this makes us >> vulnerable to writes while replication is disabled. We could prevent writes >> while replication is disabled, but we expect this fix will allow us to >> revert our automation around disabling replication. >> >> https://mariadb.atlassian.net/browse/MDEV-6492 - Our understanding is >> that until we receive this fix, nodes can receive writes that may not be >> replicated while in donor mode for an rsync SST. We expect this fix to >> prevent writes while in donor mode for rsync SST. >> >> We are also crossing our fingers that 10.0.13 resolves this issue (link >> is to codership forum, just posted the same question to maria-discuss a few >> minutes ago): >> https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI. We >> haven't filed a bug for it yet; were hoping to get a sanity check first. >> > > > Fix for both the above issues have been queued for MariaDB Galera Server > 10.0.13, and should quite likely fix the issues that you are facing. > > Thanks! > > - Nirbhay > > > >> Thank you, >> Shannon >> >> Cloud Foundry Service, Pivotal >> >> On Mon, Aug 25, 2014 at 1:05 PM, Nirbhay Choubey <nirbhay(a)skysql.com> >> wrote: >> >>> Hi, >>> >>> On Mon, Aug 25, 2014 at 3:45 PM, Cloud Foundry Services < >>> cf-services-eng(a)pivotal.io> wrote: >>> >>>> Hello, >>>> >>>> Any word on the release of MariaDB Galera Cluster 10.0.13? >>>> >>> >>> It should be out in a couple of days. >>> >>> >>>> We've been seeing issues with replication that we really hope this >>>> release will fix. >>>> >>> >>> What are the issues like? Could you describe them? Or report a bug? >>> >>> mariadb.org/jira >>> >>> Best, >>> Nirbhay >>> >>> >>>> Thank you, >>>> Shannon >>>> >>>> Cloud Foundry Services, Pivotal >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~maria-discuss >>>> Post to : maria-discuss(a)lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~maria-discuss >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >> >

1 0

Re: [Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Hi Nirbhay, We're looking forward to these fixes: https://mariadb.atlassian.net/browse/MDEV-5786 - We were previously running mysql_upgrade on every node and getting errors due to replication. We now disable replication while mysql_upgrade is running but this makes us vulnerable to writes while replication is disabled. We could prevent writes while replication is disabled, but we expect this fix will allow us to revert our automation around disabling replication. https://mariadb.atlassian.net/browse/MDEV-6492 - Our understanding is that until we receive this fix, nodes can receive writes that may not be replicated while in donor mode for an rsync SST. We expect this fix to prevent writes while in donor mode for rsync SST. We are also crossing our fingers that 10.0.13 resolves this issue (link is to codership forum, just posted the same question to maria-discuss a few minutes ago): https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI. We haven't filed a bug for it yet; were hoping to get a sanity check first. Thank you, Shannon Cloud Foundry Service, Pivotal On Mon, Aug 25, 2014 at 1:05 PM, Nirbhay Choubey <nirbhay(a)skysql.com> wrote: > Hi, > > On Mon, Aug 25, 2014 at 3:45 PM, Cloud Foundry Services < > cf-services-eng(a)pivotal.io> wrote: > >> Hello, >> >> Any word on the release of MariaDB Galera Cluster 10.0.13? >> > > It should be out in a couple of days. > > >> We've been seeing issues with replication that we really hope this >> release will fix. >> > > What are the issues like? Could you describe them? Or report a bug? > > mariadb.org/jira > > Best, > Nirbhay > > >> Thank you, >> Shannon >> >> Cloud Foundry Services, Pivotal >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> >

1 0

[Maria-discuss] Scaling up cluster results in missing rows on some existing nodes
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Apologies for the cross-post; we submitted this question to the Codership forum a week ago and haven't received a response. https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI Hello, Hoping to get some perspective on an issue we saw yesterday. While scaling up from a single node cluster, we inserted into a table on node 0 and selected the row count for that table on all subsequent nodes (scripts below). For each node that was brought online, we observed that connections to node 0 were suspended during SST, and that there was an additional IST. At this point the nodes reported that they were synced. However, sometimes replication did not occur correctly - the additional nodes reported fewer rows than node 0. Each new node was added by itself, and all other nodes restarted during each scale-up. Nodes that became out-of-sync continued to have an incorrect row count even after restart, and sometimes got further out of sync (i.e. the discrepancy between the number of rows in node 0 and the other nodes increased) We were conducting this experiment to see whether* innodb_disallow_writes *was functioning correctly, but aren't sure whether this issue is related. Has anyone seen similar behavior while scaling up? Insert: #!/bin/bash mysql -u$db_user -p$db_password -e"create database if not exists $db_name;" mysql -u$db_user -p$db_password -e"use $db_name; create table if not exists $table_name (val int);" for i in `seq $start_val $end_val`; do echo "inserting $i" mysql -u$db_user -p$db_password -e"use $db_name; insert into $table_name VALUES ($i); select count(*) from $table_name;" sleep 0.1 done Select: #!/bin/bash for i in `seq $start_val $end_val`; do echo "statement $i" mysql -u$db_user -p$db_password -e"use replication_test; select count(*) from vals;" sleep 0.1 done Thank you, Shannon Cloud Foundry Services, Pivotal

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Hello, Any word on the release of MariaDB Galera Cluster 10.0.13? We've been seeing issues with replication that we really hope this release will fix. Thank you, Shannon Cloud Foundry Services, Pivotal

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.39 now available
by Daniel Bartholomew 21 Aug '14

21 Aug '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.39 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.39 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5539-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5539-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.39 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 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 - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - 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/ - http://www.cafepress.com/mariadb 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] doubt about spider and vertical partitioning
by Roberto Spadim 13 Aug '14

13 Aug '14

hi guys, i didn't tested, i was reading mariadb manual, and it tell that VP isn't implemented at mariadb, that's true? what could i do to help with it ? -- Roberto Spadim

1 0