- discuss - lists.mariadb.org

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

04 Dec '13

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.

1 0

[Maria-discuss] New Question: CMAKE settings to include TokuDB in 5.5.34
by AskMonty KB 02 Dec '13

02 Dec '13

Hello, A new question has been asked in "TokuDB" by markdiener: -------------------------------- I am trying to build 5.5.34 from source on Linux x64 (Fedora 14). I was looking at the readme files and could not find anything about building 5.5.34 from source and including TokuDB (which has the source code in the /storage/TokuDB/ directory) into the build. I was looking for something like: -DWITH_TOKUDB_STORAGE_ENGINE=ON but did not stumble across anything. Anybody got some ideas? Here is my build script: rm -f CMakeCache.txt make clean cmake \ -DCMAKE_BUILD_TYPE=Release \ -DCMAKE_INSTALL_PREFIX=/mysql \ -DENABLED_PROFILING=OFF \ -DENABLE_DEBUG_SYNC=ON \ -DENABLE_GCOV=OFF \ -DINSTALL_LAYOUT=STANDALONE \ -DMYSQL_DATADIR=/mysql/data \ -DINSTALL_INCLUDEDIR=include/mysql \ -DINSTALL_UNIX_ADDRDIR=/mysql/mysql.sock \ -DUSE_ARIA_FOR_TMP_TABLES=ON \ -DWITHOUT_PBXT_STORAGE_ENGINE=ON \ -DWITHOUT_SERVER=OFF \ -DWITH_ARCHIVE_STORAGE_ENGINE=OFF \ -DWITH_EMBEDDED_SERVER=OFF \ -DWITH_FAST_MUTEXES=OFF \ -DWITH_FEDERATEDX_STORAGE_ENGINE=OFF \ -DWITH_FEEDBACK=OFF \ -DWITH_LIBWRAP=OFF \ -DWITH_PIC=ON \ -DWITH_PARTITION_STORAGE_ENGINE=OFF \ -DWITH_PERFSCHEMA_STORAGE_ENGINE=ON \ -DWITH_SPHINX_STORAGE_ENGINE=OFF \ -DWITH_SSL=OFF \ -DWITH_UNIT_TESTS=OFF \ -DWITH_VALGRIND=OFF \ -DWITH_XTRADB_STORAGE_ENGINE=ON \ -DWITHOUT_OQGRAPH=ON \ -DWITH_ZLIB=bundled make (now compiling your program) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cmake-settings-to-include-tokudb-in-5534/

1 0

[Maria-discuss] Fw: [Website feedback] galera mariadb compiled using msvc
by Yann Nayn 02 Dec '13

02 Dec '13

On Monday, December 2, 2013 11:46 AM, Yann Nayn <yann.nayn(a)yahoo.fr> wrote: >Yes, we're reading mariadb mailing list ... I realized that while reading mailing lists archives . galera is now running using mysqldump as the wsrep sst backup method I didnt dig the details yet and will compile percona xtrabackup next Im tested the deployment with two nodes(...) and still find bootstrapping "tiedeous". I will go with basic sql manipulations in the next coming hours I just tested create database on one node , the database is visible from the other node . I might provide soon msi installation packages to ease testing https://github.com/YannNayn

1 0

[Maria-discuss] Mroonga storage engine is merged into MariaDB 10.0
by kentoku 01 Dec '13

01 Dec '13

Hi! We just pushed Mroonga storage engine into "lp:~mroonga/maria/mroonga". Mroonga is a fulltext/geo search storage engine. Would you please bundle Mroonga into MariaDB? Mroonga's strong points are - High-speed updating with multiple thread searching. (lock-free model) - Support CJK languages. - Support wrapper mode. Wrapper mode works adding fulltext/geo index for other storage engines. Mroonga is tested on the following 64bit OS. Debian GNU/Linux squeeze Debian GNU/Linux wheezy Debian GNU/Linux jessie Debian GNU/Linux sid Ubuntu 10.04 LTS Lucid Lynx Ubuntu 12.04 Precise Pangolin Ubuntu 12.10 Quantal Quetzal Ubuntu 13.04 Raring Ringtail Ubuntu 13.10 Saucy Salamander CentOS 5 CentOS 6 Fedora 19 Mac OS X Windows 7 Mroonga documents (English & Japanease) are available on http://mroonga.org/docs/index.html Test command is the followings. The command calls mysql-test-run.plinternally. > ./storage/mroonga/test/run-sql-test.sh Thanks, Kentoku

6 6

[Maria-discuss] Tr : mariadb galera msvc
by Yann Nayn 30 Nov '13

30 Nov '13

>Le Mercredi 27 novembre 2013 9h33, Colin Charles <byte(a)mariadb.com> a écrit : >does this also include the galera library? or is this just straight mariadb? >Colin Charles, Chief Evangelist >MariaDB | t: +6-012-204-3201 | Skype: colincharles This is not intended to be left undone half the way ... Right now most of galera tests are passing and galera_smm.dll is produced. a more detailed instruction set can be found at: https://github.com/YannNayn/galera-build-msvc/blob/master/build.bat the C89 features have been rewritten Next a pre production deployment is going to be tested Have a Happy ThanksGiving Day when relevant

2 6

[Maria-discuss] New Question: Mariadb refuses to stay confined to install directory
by AskMonty KB 29 Nov '13

29 Nov '13

Hello, A new question has been asked in "Compiling MariaDB From Source" by openiduser33: -------------------------------- I've been struggling with this off and on for weeks. I need a contained MariaDB install running in the home directory. My most recent attempt (and what would be my preferred method) is compiling from source. No matter what I do though MariaDB insists on trying to create /var/run/mysqld/mysqld.sock on every run and fails. I compiled it from source with --prefix pointing to my home directory. I ran mysql with --basedir and --defaults-file. The defaults-file I used contains the location of my mysql.sock file in the home directory but MariaDB will not use it. I even tried recompiling with --exec-prefix as per the MySQL 5.5 documentation but this screws the entire installation up, causing MariaDB to recreate the entire prefix path from root underneath src/efix=/ where I'm storing the source while I install. Here is my configure options: ##./configure --prefix=/home/user/web/servers/mariadb --enable-assembler \ --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \ --with-plugin-maria --with-aria-tmp-tables --without-plugin-innodb_plugin --without-plugin=tokudb \ --with-mysqld-ldflags=-static --with-client-ldflags=-static --with-readline \ --with-ssl --with-plugins=max-no-ndb --with-embedded-server --with-libevent \ --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static \ --with-zlib-dir=bundled --enable-local-infile## And here is what happens when I try to launch MariaDB: ##$ bin/mysqld_safe --basedir=/home/user/web/servers/mariadb --defaults-file=/home/user/web/servers/mariadb/my.cnf 131128 16:20:20 mysqld_safe Logging to '/home/user/web/servers/mariadb/log/error.log'. mkdir: cannot create directory ‘/var/run/mysqld’: Permission denied Fatal error Can't create database directory '/var/run/mysqld/mysqld.sock'## My socket file is specific in the given my.cnf file as /home/user/web/servers/mariadb/run/mysql.sock No matter what I do I can't get MariaDB to behave and run in user land. What am I doing wrong? I've tried the Linux binaries with slightly more success but I still felt like I was fighting the server to get it to read files from the correct location. I'd like to have it compiled from source though and it *should* be easier this way since I can specify a prefix. How can I get MariaDB to follow the set prefix for all files? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-refuses-to-stay-confined-to-install-direct…

1 0

[Maria-discuss] plans for MDL
by MARK CALLAGHAN 28 Nov '13

28 Nov '13

Do you have any plans for MDL in MariaDB 10+ that might do something better for workloads that need to do some DDL concurrent with some long-running SELECT statements? https://www.facebook.com/MySQLatFacebook/posts/10151939557456696 -- Mark Callaghan mdcallag(a)gmail.com

2 1

[Maria-discuss] New Question: Build fails at "Linking CXX executable tdb-recover"
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "Compiling MariaDB From Source" by openiduser33: -------------------------------- I'm trying to compile MariaDB on Ubuntu 13.10. I've followed all the directions here on the KB in regards to compiling. I meet all the package requirements listed. This is the output where make fails: Linking CXX executable tdb-recover cd /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft && /usr/bin/cmake -E cmake_link_script CMakeFiles/tdb-recover.dir/link.txt --verbose=1 /usr/bin/c++ -std=c++11 -Wall -Werror -Wcast-align -Wshadow -Wmissing-format-attribute -Wpointer-arith -Wmissing-declarations -Wno-missing-noreturn -Wextra -Wno-error=strict-overflow -Wpacked -fno-exceptions -fno-rtti -Wno-error=missing-format-attribute -Wmissing-format-attribute -Wlogical-op -Wtrampolines -Wswitch -Winit-self -Wstrict-null-sentinel -Wno-missing-field-initializers -Wall -Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti -fimplicit-templates -flto -fuse-linker-plugin -O2 -g -DNDEBUG -DDBUG_OFF -g -O3 -UNDEBUG -g -fuse-linker-plugin -Wno-error=strict-overflow CMakeFiles/tdb-recover.dir/tdb-recover.cc.o -o tdb-recover -lpthread libft_static.a ../util/libutil_static.a ../../../../zlib/libzlib.a .././xz/lib/liblzma.a ../portability/libtokuportability_static.a -lpthread -ldl -lrt /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft/ft-ops.cc: In function ‘ft_leaf_run_gc’: /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft/ft-ops.cc:2261:26: error: ‘leaf_entry’ may be used uninitialized in this function [-Werror=maybe-uninitialized] if (leaf_entry->type != LE_MVCC) { ^ lto1: all warnings being treated as errors lto-wrapper: /usr/bin/g++-4.8.real returned 1 exit status /usr/bin/ld.bfd.real: lto-wrapper failed collect2: error: ld returned 1 exit status Pastebin for easier reading: http://pastebin.com/wGzHpD2p I'm using the default compile option list posted here: https://mariadb.com/kb/en/generic-build-instructions/ The only thing I've changed is the prefix. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/build-fails-at-linking-cxx-executable-tdb-recover/

1 0

[Maria-discuss] New Question: Link MariaDB Client Library for C with specific external zlib and openssl
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "MariaDB Client Library for C" by trsystran: -------------------------------- Hi, I am trying to link the mariadb client library with zlib and openssl which are neither embedded in mariadb (for zlib), nor the one available on the system: I want to force cmake to use zlib and openssl from a given path. How can I do that? Is there another way than creating my own FindZLIB.cmake and force it via CMAKE_MODULE_PATH ? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/link-mariadb-client-library-for-c-with-specific-ex…

1 0

[Maria-discuss] New Question: SphinxSE gone from MariaDB 10.0.6?
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "Development" by robertmedeksza: -------------------------------- I recently ran apt-get upgrade and this updated my MariaDB 10.0.4 to 10.0.6. After the update the SphinxSE engine is gone and my Sphinx tables no longer function. How can I get SphinxSE back and can this be fixed in 10.0.7? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/sphinxse-gone-from-mariadb-1006/

1 0