April 2014 - discuss - lists.mariadb.org

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 05 Dec '24

05 Dec '24

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.

3 2

[Maria-discuss] EXPLAIN and CONNECT
by Federico Razzoli 04 Jun '14

04 Jun '14

6 17

Re: [Maria-discuss] warning after installing mariadb-galera-server-10.0
by Eric Kom 30 Apr '14

30 Apr '14

On 30 April 2014 21:58:13 SAST, Nirbhay Choubey <nirbhay(a)skysql.com> wrote: >Hi Eric, > >On Wed, Apr 30, 2014 at 10:07 AM, Eric Kom <erickom(a)kom.za.net> wrote: > >> Hi All, >> >> After successfully installed mariadb-galera-server-10.0 on my debian >> wheezy: >> sudo aptitude install rsync galera mariadb-galera-server >> >> I received the above warning: >> 140430 14:29:48 [Warning] Failed to load slave replication state from >> table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB' >> > >mysqld bootstrap command in debian post installation script wrongly >retained 'loose-innodb=OFF' >option, which disabled innodb. The script has been updated. > >https://mariadb.atlassian.net/browse/MDEV-6192 > >Thanks for reporting. Thanks for logged the bug and fixed it. > >-- Nirbhay > > >> >> >> -- >> Kind Regards >> >> Eric Kom >> >> Senior IT Manager - Metropolitan Schools >> _________________________________________ >> / You are scrupulously honest, frank, and \ >> | straightforward. Therefore you have few | >> \ friends. / >> ----------------------------------------- >> \ >> \ >> .--. >> |o_o | >> |:_/ | >> // \ \ >> (| Kom | ) >> /'\_ _/`\ >> \___)=(___/ >> >> 2 Hennie Van Till, White River, 1240 >> Tel: 013 750 2255 | Fax: 013 750 0105 | Cell: 078 879 1334 >> erickom(a)kom.za.net | erickom(a)metropolitancollege.co.za >> www.kom.za.net | www.kom.za.org | www.erickom.co.za >> >> Key fingerprint: 513E E91A C243 3020 8735 09BB 2DBC 5AD7 A9DA 1EF5 >> >> >> _______________________________________________ >> 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 >> -- Sent from my Android device with K-9 Mail. Please excuse my brevity.

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.37 now available
by Daniel Bartholomew 30 Apr '14

30 Apr '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.37 This is a Stable release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.37 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5537-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5537-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.37 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 - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book 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://www.packtpub.com/getting-started-with-mariadb/book - - 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: An Enhanced Drop-in Replacement for MySQL 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] warning after installing mariadb-galera-server-10.0
by Eric Kom 30 Apr '14

30 Apr '14

Hi All, After successfully installed mariadb-galera-server-10.0 on my debian wheezy: sudo aptitude install rsync galera mariadb-galera-server I received the above warning: 140430 14:29:48 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB' -- Kind Regards Eric Kom Senior IT Manager - Metropolitan Schools _________________________________________ / You are scrupulously honest, frank, and \ | straightforward. Therefore you have few | \ friends. / ----------------------------------------- \ \ .--. |o_o | |:_/ | // \ \ (| Kom | ) /'\_ _/`\ \___)=(___/ 2 Hennie Van Till, White River, 1240 Tel: 013 750 2255 | Fax: 013 750 0105 | Cell: 078 879 1334 erickom(a)kom.za.net | erickom(a)metropolitancollege.co.za www.kom.za.net | www.kom.za.org | www.erickom.co.za Key fingerprint: 513E E91A C243 3020 8735 09BB 2DBC 5AD7 A9DA 1EF5

1 0

[Maria-discuss] Name for Native MariaDB Client Library RPM
by Honza Horak 29 Apr '14

29 Apr '14

Hi guys, I'd like to package the native MariaDB client library as an RPM for Fedora. But I got into troubles when discussing the name of the RPM. In Fedora we have some rules about packages names and there are some other facts that need to be taken into account. These are restrictions I face: * not to use underscope unless absolutely necessary * follow upstream's name as much as possible (tarball is called mariadb_client-2.0.0-src.tar.gz) * we already have mariadb-libs and there might be mariadb-client packages in the future, if we start follow upstream naming for subpackages, so we cannot use mariadb-libs or mariadb-client Having these restrictions on my mind and seeing mariadb-native-client as a name for Windows installers, I think this would be also the best name for Fedora. In practice the packages will include these files: mariadb-native-client-2.0.0-1.fc20.x86_64.rpm /usr/lib64/mariadb/libmariadb.so.2 LICENSE, README, ... mariadb-native-client-devel-2.0.0-1.fc20.x86_64.rpm /usr/bin/mariadb_config /usr/include/mariadb/* /usr/lib64/mariadb/libmariadb.so /usr/lib64/mariadb/libmysql.so /usr/lib64/mariadb/libmysqlclient.so /usr/lib64/mariadb/libmysqlclient_r.so By this mail I'd like to check if you, MariaDB upstream, will be OK with that (no response means confirmation). Regards, Honza

1 0

[Maria-discuss] virtual columns and indexes on attributes in JSON objects
by MARK CALLAGHAN 26 Apr '14

26 Apr '14

Does the support for virtual columns allow an index to be created on an attribute in a JSON object stored in a BLOB column? http://falseisnotnull.wordpress.com/2014/04/25/descending-indexes-in-mariadb https://mariadb.com/kb/en/virtual-columns/ -- Mark Callaghan mdcallag(a)gmail.com

4 3

[Maria-discuss] New Question: Loading CSV files
by AskMonty KB 26 Apr '14

26 Apr '14

Hello, A new question has been asked in "CONNECT" by danielkrysiak: -------------------------------- Hi, I have data in CSV files. Partitioned inside a directory, one file per day, alive (constantly written to, insert at the end). I want to load them on-line (not once a day). Normally I would write peace of code, that remembers the last file and place, so it can easily go back and continue. But the Connect engine looks like a great ready solution for this kind of thing. I'm just not sure about: 1. I can't use indexes, because the file is changed all the time. Can I somehow make sure the data will be visible in a "connect table" always in the same order? 2. About "Multiple File Tables". Whats the order of data inside them? 3. What about simple file format change: add column at the end. Will data from older files be visible in "Multiple File Table" as null? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/loading-csv-files/

1 0

[Maria-discuss] New Question: Descending Indexes
by AskMonty KB 25 Apr '14

25 Apr '14

Hello, A new question has been asked in "MariaDB community" by juliobetta: -------------------------------- Does anyone know if MariaDB supports descending indexes? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/descending-indexes/

1 0

[Maria-discuss] New Question: TokuDB engine Installation problem
by AskMonty KB 25 Apr '14

25 Apr '14

Hello, A new question has been asked in "TokuDB" by johnzobolas: -------------------------------- Hi! I downloaded mariadb-10.0.10-linux-x86_64.tar.gz from your website to install and test MariaDB 10.0.10 and specifically the engine TokuDB (and Connect). My questions are: 1)My server's OS is: Ubuntu 12.04.1 LTS (GNU/Linux 3.2.0-29-generic x86_64). Is this supported for TokuDB engine or not? (after i installed mariaDB, there was no plugin for TokuDB (ha_tokudb.so?) in the plugins folder...) 2)Also with connect engine: there was indeed a file called ha_connect.so in the plugins folder and i used: install soname 'ha_connect'; and got: ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql/lib/plugin/ha_connect.so' (errno: 2, libodbc.so.1: cannot open shared object file: No such file or directory). What is wrong here? (With the engines spider and sequence the above command is successfull and they were installed!). Thanks, John. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/tokudb-engine-installation-problem/

1 0