- discuss - lists.mariadb.org

[Maria-discuss] New Question: Historical data, nightly snapshots
by AskMonty KB 17 Oct '14

17 Oct '14

Hello, A new question has been asked in "MariaDB Documentation" by bjquinn: -------------------------------- I have an application where I need to take nightly snapshots of a large InnoDB database (10s of GB) and then have them available to be queried alongside the current data. My underlying filesystem is (or at least can be) ZFS, so actually creating the snapshots is easy enough. But how do I connect to the files contained in the snapshot so that I can query the tables via MariaDB? If it's easier through another storage engine, I could consider that, though I do need row locking in the current data. The historical data would be read only (obviously) and wouldn't need to be changed. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/historical-data-nightly-snapshots/

1 0

[Maria-discuss] New MariaDB 10.1 and MariaDB Galera Cluster releases
by Daniel Bartholomew 17 Oct '14

17 Oct '14

The MariaDB project is pleased to announce the immediate availability of the following new releases: - MariaDB Galera Cluster 5.5.40-stable - MariaDB Galera Cluster 10.0.14-stable - MariaDB 10.1.1-alpha See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.40 - Release Notes: https://mariadb.com/kb/en/mgc-5540-release-notes - Changelog: https://mariadb.com/kb/en/mgc-5540-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.40 MariaDB Galera Cluster 10.0.14 - Release Notes: https://mariadb.com/kb/en/mgc-10014-release-notes - Changelog: https://mariadb.com/kb/en/mgc-10014-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.40 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ MariaDB 10.1.1 - Release Notes: https://mariadb.com/kb/en/mariadb-1011-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1011-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.1 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/ - 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] .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

[Maria-discuss] Aborted connection (Unknown error)
by Florent Bautista 15 Oct '14

15 Oct '14

Hi all, I'm getting annoying errors when I want to switch clients from MySQL to MariaDB. I use Debian Wheezy, and MariaDB 10.0 repositories, then I install mariadb-common & libmariadbclient. Then I restart services using MySQL Client Library and I have a lot of warnings like these on my MariaDB Server (with Galera or not) : [Warning] Aborted connection 136305 to db: 'db' user: 'user' host: 'xx.xx.xx.xx' (Unknown error) I do not have more information in logs. This is not a network problem, because it occurs with 127.0.0.1 too. What do I miss ? Thank you a lot. Florent

2 2

[Maria-discuss] MariaDB 5.5.40 now available
by Daniel Bartholomew 09 Oct '14

09 Oct '14

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