September 2014 - discuss - lists.mariadb.org

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 26 Apr '25

26 Apr '25

Binaries have been uploaded for both x86 and amd64 platforms. due to github file size limitations , the directories have been uploaded unarchived. for Win33 binaries , please checkout https://github.com/YannNayn/galera-mariadb-win32.git and for Win64(amd64) binaries (being uploaded/pushed): https://github.com/YannNayn/galera-mariadb-win64.git they are not recommended for a production environment. in the my.cnf file: _________ wsrep_provider=galera_smm.dll wsrep_sst_method=msqldump # percona xtrabackup will be tested soon _________ libevent and openssl(the provided binaries use respectively 2.1.3-alpha and 1.1.0-dev versions ) will be added next on github some limitations are stated on openssl website copied here for convenience: ____________ from http://www.openssl.org/ ____________ This software package uses strong cryptography, so even if it is created, maintained and distributed from liberal countries in Europe (where it is legal to do this), it falls under certain export/import and/or use restrictions in some other parts of the world. PLEASE REMEMBER THAT EXPORT/IMPORT AND/OR USE OF STRONG CRYPTOGRAPHY SOFTWARE, PROVIDING CRYPTOGRAPHY HOOKS OR EVEN JUST COMMUNICATING TECHNICAL DETAILS ABOUT CRYPTOGRAPHY SOFTWARE IS ILLEGAL IN SOME PARTS OF THE WORLD. SO, WHEN YOU IMPORT THIS PACKAGE TO YOUR COUNTRY, RE-DISTRIBUTE IT FROM THERE OR EVEN JUST EMAIL TECHNICAL SUGGESTIONS OR EVEN SOURCE PATCHES TO THE AUTHOR OR OTHER PEOPLE YOU ARE STRONGLY ADVISED TO PAY CLOSE ATTENTION TO ANY EXPORT/IMPORT AND/OR USE LAWS WHICH APPLY TO YOU. THE AUTHORS OF OPENSSL ARE NOT LIABLE FOR ANY VIOLATIONS YOU MAKE HERE. SO BE CAREFUL, IT IS YOUR RESPONSIBILITY. ________________________________________________ msvc 1600 redistributables SP1 need to be installed/available on the target machine: vcredist_x86.exe : http://www.microsoft.com/en-us/download/details.aspx?id=8328 vcredist_x64.exe : http://www.microsoft.com/en-us/download/details.aspx?id=13523 MSys binaries are provided and msqld.bat should then be used instead of mysqld.exe (e.g. mysld.bat --console --wsrep_cluster_address=gcomm:// ) in order to have a working sh shell(cygwin has been proved to do it as well) Please note that oqgraph is disabled (boost trunk is used , that is 1.55) Comments and suggestions are welcome.

4 3

Re: [Maria-discuss] .ibd files remaining after DROP TABLE
by Andrew Braithwaite 17 Oct '14

17 Oct '14

Hi, It only seems to happen when replicating DROP TABLE IF NOT EXISTS from a master, not when running it directly on that server. I can replicate this problem every time. Thanks, Andrew On 17 September 2014 15:49, Jan Lindström <jan.lindstrom(a)skysql.com> wrote: > Hi, > > Not at least normally both should be deleted, but maybe not immediately. > Can you provide a example ? > > R: Jan > > On Wed, Sep 17, 2014 at 4:36 PM, Andrew Braithwaite < > andrew.braithwaite(a)graze.com> wrote: > >> Hi, >> >> After dropping tables on my MariaDB 10.0.13 database server, the .frm >> files are removed but the .ibd files remain behind. >> >> Has anyone seen this before? >> >> Thanks.... Andrew >> >> mysqld Ver 10.0.13-MariaDB-1~trusty for debian-linux-gnu on x86_64 ( >> mariadb.org binary distribution) >> >> DISTRIB_ID=Ubuntu >> DISTRIB_RELEASE=14.04 >> DISTRIB_CODENAME=trusty >> DISTRIB_DESCRIPTION="Ubuntu 14.04.1 LTS" >> NAME="Ubuntu" >> VERSION="14.04.1 LTS, Trusty Tahr" >> ID=ubuntu >> ID_LIKE=debian >> PRETTY_NAME="Ubuntu 14.04.1 LTS" >> VERSION_ID="14.04" >> HOME_URL="http://www.ubuntu.com/" >> SUPPORT_URL="http://help.ubuntu.com/" >> BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/" >> >> _______________________________________________ >> 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 >> >> > > > -- > > -- > > Jan Lindström, Principal Engineer > SkySQL - The MariaDB Company > > skype: jan_p_lindstrom > > www.skysql.com > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2F&sa=D&sntz=1&usg=…> > > [image: Twitter] > <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fskysql&sa=D&sntz=1&u…> > [image: Blog] > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2Fblog%2F&sa=D&sntz…> > [image: Facebook] > <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&snt…> > [image: LinkedIn] > <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F12142…> > [image: Google+] <https://plus.google.com/117544963211695643458/posts> >

3 2

Re: [Maria-discuss] MariaDB,TokuDB and FusionIO
by Christophe Le Roux 02 Oct '14

02 Oct '14

Hi Jan, Thank you for your answer. I am writing to the TokuDB community. I hope for good news ☺ Cordialement, [Claranet]<http://www.claranet.fr/> [Linkedin]<http://www.linkedin.com/company/claranet> [Twitter]<https://twitter.com/#!/Claranet_FR> [Youtube]<http://www.youtube.com/user/ClaranetFR> [Gartner MQ]<http://www.claranet.fr/propos-de/gartner.html> De : Jan Lindström [mailto:jan.lindstrom@mariadb.com] Envoyé : mardi 30 septembre 2014 10:38 À : Christophe Le Roux; Maria Discuss Objet : Re: [Maria-discuss] MariaDB,TokuDB and FusionIO Hi, On Tue, Sep 30, 2014 at 11:27 AM, Christophe Le Roux <christophe.le.roux(a)fr.clara.net<mailto:christophe.le.roux@fr.clara.net>> wrote: About NVM compression, is it a hardware compression doing by the FusionIO controller or is it a software compression doing by the CPU of the server ? Compression is done by CPU in the MariaDB server (InnoDB/XtraDB storage engine). About Atomic Write, I understand there is missing code to have this feature to the TokuDB engine. Should I ask to the Mariadb dev team or the Tokutek dev team (or SanDisk/FusionIO dev team ?) to add it (maybe it’s technically no doable ?)? I would start from Tokutek dev team, I do not know fully how database tables are stored on Tokutek, but I do not see immediately a reason why atomic writes would not be possible. Do you think this can boost performances for huge TokuDB tables ? Atomic will boost performance but only if database is stored on device that supports atomic writes. R: Jan

4 5

[Maria-discuss] Possible? upgrading gallera cluster without service interruption
by Benoit Panizzon 30 Sep '14

30 Sep '14

Hello We would like to upgrade from 5.5.33a+maria-1~saucy to 5.5.39+maria-1~saucy on a running cluster without service interruption. So we took down one node, upgraded and restarted that instance... It fails to connect to the next gcomm server. MariaDB fails to start. We tested network connectivity, there is no issue we could detect. We downgraded back to 5.5.33a+maria-1~saucy and the connectivity issue disappeared. So my question here is: Is it possible to upgrade the cluster without interruption, or do we have to shut the whole cluster down, upgrade every node and then restart everything? Kind regards Benoit Panizzon -- I m p r o W a r e A G - ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 07 CH-4133 Pratteln Fax +41 61 826 93 02 Schweiz Web http://www.imp.ch ______________________________________________________

2 1

[Maria-discuss] New Question: Error linking with client API on Linux
by AskMonty KB 30 Sep '14

30 Sep '14

Hello, A new question has been asked in "MariaDB community" by sruliganor: -------------------------------- Hi, I have a Windows C program that works with the MariaDB client API 1.0. I'm porting it to Linux RH. I downloaded the Linux client API 1.0 and built the program with it. The link fails with this errors: undefined reference to `simple_command' undefined reference to `net_safe_read' Please help. Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-linking-with-client-api-on-linux/

1 0

Re: [Maria-discuss] MariaDB,TokuDB and FusionIO
by Dhananjoy Das 30 Sep '14

30 Sep '14

Hi Christophe, This is Dhananjoy Das (Joy) from SanDisk (formally Fusion-io inc.,) contributor to the NVM Compression. In regards to your query on access to NVMFS, yes currently its supported on Atomics Series of ioMemory cards(PX/SX), I would suggest its best to get in touch with the SanDisk Sales team (formally Fusion-io inc.,) and request for the LA NVMFS 1.0 (Limited Edition). Additionally, NVM Compression (changes are part of InnoDB/XtraDB) is independent of the TokuDB DB-engine. Hope that help, feel free to reach out. Thanks, Dhananjoy Das (Joy) mailto:Dhananjoy.Das@SanDisk.com Sr. Architect, SanDisk Corporation From: Christophe Le Roux <christophe.le.roux(a)fr.clara.net<mailto:christophe.le.roux@fr.clara.net>> Subject: [Maria-discuss] MariaDB,TokuDB and FusionIO Date: 26 September 2014 19:05:49 GMT+8 To: "maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>" <maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>> Hello, After reading the previous discussion about Fusion IO with Torben Mathiasen contribution, I have some questions. I understand that the nvmfs is developed by FusionIO and is closed source. Can we have this module (I think it's a kernel module , right ?) if we buy a new FusionIO card (Only with Atomic Series?)? Is this module ok with "old" FusionIO card (iodrive2) ? About AtomicWrites and the NVM compression, can these features be added to the TukuDB engine ? Can the TokuDB compression and the NVM compression be working together or if we enable one, we need to disable the other ? Cordialement, http://www.claranet.fr<http://www.claranet.fr/> [cid:C1D6FBD4-E7DA-4EF6-A28E-00B0FF3DA706]<http://www.claranet.fr/> [cid:7968F977-345B-49BE-B90E-B0E5C25851A5]<http://www.linkedin.com/company/claranet> [cid:3F049FCF-C7CF-42AA-B1BF-9AABDFA7AF7A]<https://twitter.com/#!/Claranet_FR> [cid:88A700FC-5D51-471E-8AF6-E8F2220BA02D]<http://www.youtube.com/user/ClaranetFR> [cid:4F716A83-5DA5-4C6B-AF45-AED5D649A6B9]<http://www.claranet.fr/propos-de/gartner.html> This e-mail (and any attachments) is confidential and may be privileged. Any unauthorized use, copying, disclosure or dissemination of this communication is prohibited. If you are not the intended recipient, please notify the sender immediately and delete all copies of the message and its attachments.

2 1

[Maria-discuss] MariaDB Cluster wont start
by Carlos Raúl Laguna 29 Sep '14

29 Sep '14

I have a 3node galera-mariadb10 cluster working without issues until today in ubuntu 14.04, all node stop, all i can grasp from mysqld is this: [Warning] option 'table_cache': unsigned value 2097152 adjusted to 524288 [Note] WSREP: Read nil XID from storage engines, skipping position init [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' [Note] WSREP: wsrep_load(): Galera 25.3.5-wheezy(rXXXX) by Codership Oy < info(a)codership.com> loaded successfully. [Note] WSREP: CRC-32C: using hardware acceleration. [Note] WSREP: Found saved state: 193c65da-169f-11e4-a58c-ba3055701076:-1 [Note] WSREP: Passing config to GCS: base_host = 172.17.1.2; base_port = 4567; cert.log_conflicts = no; debug = no; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 1; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; protonet. Note] WSREP: Service thread queue flushed. [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 [Note] WSREP: wsrep_sst_grab() [Note] WSREP: Start replication [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 [Note] WSREP: protonet asio version 0 [Note] WSREP: Using CRC-32C (optimized) for message checksums. [Note] WSREP: backend: asio [Note] WSREP: GMCast version 0 [Note] WSREP: (d35fbdc5-47fa-11e4-88ce-ebeacde19e39, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 140929 13:05:34 [Note] WSREP: (d35fbdc5-47fa-11e4-88ce-ebeacde19e39, 'tcp:// 0.0.0.0:4567') multicast: , ttl: 1 [Note] WSREP: EVS version 0 [Note] WSREP: PC version 0 [Note] WSREP: gcomm: connecting to group 'baruwa_cluster', peer 'baruwadb1:,baruwadb2:,baruwadb3:' [Warning] WSREP: (d35fbdc5-47fa-11e4-88ce-ebeacde19e39, 'tcp://0.0.0.0:4567') address 'tcp://172.17.1.2:4567' points to own listening address, blacklisting [Warning] WSREP: no nodes coming from prim view, prim not possible [Note] WSREP: view(view_id(NON_PRIM,d35fbdc5-47fa-11e4-88ce-ebeacde19e39,1) memb { d35fbdc5-47fa-11e4-88ce-ebeacde19e39,0 } joined { } left { } partitioned { }) [Note] WSREP: gcomm: connected 7 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) [Note] WSREP: Opened channel 'baruwa_cluster' [Note] WSREP: Waiting for SST to complete. [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 [Note] WSREP: Received NON-PRIMARY. [Note] WSREP: New cluster view: global state: :-1, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version -1 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.5018S), skipping check my.cnf: #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_address="gcomm://baruwadb1,baruwadb2,baruwadb3?pc.wait_prim=no" wsrep_sst_method=rsync wsrep_cluster_name="baruwa_cluster" Any help will be appreciated. Thanks and regards

2 6

[Maria-discuss] MariaDB 10.0.14 now available
by Daniel Bartholomew 26 Sep '14

26 Sep '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.14 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.14 - Release Notes: https://mariadb.com/kb/en/mariadb-10014-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10014-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.14 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ 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

2 1

[Maria-discuss] MariaDB,TokuDB and FusionIO
by Christophe Le Roux 26 Sep '14

26 Sep '14

Hello, After reading the previous discussion about Fusion IO with Torben Mathiasen contribution, I have some questions. I understand that the nvmfs is developed by FusionIO and is closed source. Can we have this module (I think it's a kernel module , right ?) if we buy a new FusionIO card (Only with Atomic Series?)? Is this module ok with "old" FusionIO card (iodrive2) ? About AtomicWrites and the NVM compression, can these features be added to the TukuDB engine ? Can the TokuDB compression and the NVM compression be working together or if we enable one, we need to disable the other ? Cordialement, http://www.claranet.fr<http://www.claranet.fr/> [Claranet]<http://www.claranet.fr/> [Linkedin]<http://www.linkedin.com/company/claranet> [Twitter]<https://twitter.com/#!/Claranet_FR> [Youtube]<http://www.youtube.com/user/ClaranetFR> [Gartner MQ]<http://www.claranet.fr/propos-de/gartner.html>

1 0

[Maria-discuss] where's mroonga?
by Federico Razzoli 26 Sep '14

26 Sep '14

Hi Is Mroonga included in any MariaDB packet? If not: 1 is it in the source, and 2 any hints for compiling it? Regards Federico

2 1