- discuss - lists.mariadb.org

[Maria-discuss] 10.1 + Galera
by Tim Callaghan 13 Nov '14

13 Nov '14

3 3

[Maria-discuss] debuginfo packages for MariaDB Galera Cluster 5.5
by Pim Rupert (Lemonbit) 12 Nov '14

12 Nov '14

Where could one find the debuginfo packages for MariaDB Galera Cluster 5.5? I could not find it in the yum channels. - Pim

1 0

[Maria-discuss] New Question: MariaDB configuration file license?
by AskMonty KB 11 Nov '14

11 Nov '14

Hello, A new question has been asked in "MariaDB FAQ" by aled_sage_g. Please answer it at http://mariadb.com/kb/en/mariadb-configuration-file-license/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Are the default MariaDB configuration files licensed under GPL, or is there a more permissive license for it? The context of my question... I am a committer on the apache Brooklyn project [1]. This automates the deployment and runtime management of applications to a range of different clouds. MariaDB can be one of a range of components being deployed and wired together. We have copied the my.cnf configuration file, and templated it so that automated deployment of custom configurations are simpler. However, Apache does not allow inclusion of GPL/LGPL material [2]. We may have to write our own version of the configuration file from scratch, or delete our templated version and resort to `sed` commands to modify the default (yuck!). Aled [1] https://brooklyn.incubator.apache.org/ [2] http://www.apache.org/legal/3party.html -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-configuration-file-license/

1 0

[Maria-discuss] New Question: problem of installing and downloading MariaDB
by AskMonty KB 11 Nov '14

11 Nov '14

Hello, A new question has been asked in "MariaDB community" by wenfangzhang: -------------------------------- hello: i have downloaded mariadb-10.0.14-linux-x86_64.tar.gz , but when i decompress this package , it has errors: this packeage is interrupted . i have triede several times, but it still has this problem. and last , i download the source code of this veision mariadb-10.0.14.tar.gz. After installing this , i try to install tokudb engine by using install soname 'ha_tokudb' , but it also has problems :ERROR 1126 (HY000): Can't open shared library '/usr/local/mariadb/lib/plugin/ha_tokudb.so' (errno: 13, cannot open shared object file: No such file or directory). In fact , i want to install the newest version of MariaDB with tokuDB engine . so what can i do ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-of-installing-and-downloading-mariadb/

1 0

[Maria-discuss] New Question: MariaDB installation
by AskMonty KB 11 Nov '14

11 Nov '14

Hello, A new question has been asked in "Getting Started" by jorgearaya: -------------------------------- How can I install MariaDB on Suse Linux? SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 1 Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-installation/

1 0

[Maria-discuss] New Question: newbie question
by AskMonty KB 07 Nov '14

07 Nov '14

Hello, A new question has been asked in "MariaDB community" by lennartjohansson: -------------------------------- Hi all, I'm a newie to Mariadb but do have a question if a thing we need to do in a project is possible to do at all. We are working with a id-project where Sybase is feeding data into a ldap directory, now we need do to a upgrade witch means that the connector to sybase are lost. To get that to work again we need to have new views build in Sybase and since we dont own the Sybase database that is crazy expenciv. So we thought about using MariaDB as a middleware and store data from Sybase in it and use that instead as data source for our directory. So my question is if it's possible in MariaDB to run a query that reads data from a Sybase DB and store the result? And if so does anybody have any suggestions about best practice how to do that. /Lenanrt -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/newbie-question/

2 1

[Maria-discuss] Maybe a new information schema table for replication?
by Roberto Spadim 06 Nov '14

06 Nov '14

Hi guys, i got one question these days and i don't know how to solve... the question is: "How to see the queries executing by replication thread?" i'm thinking about a information schema plugin to see whats is 'queued' in replication thread, at "master" (write to binlog) and "slave" (executing from binlog) side any idea if this is possible? i didn't checked or read any part of binlog/replication code yet thanks guys! :) -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

1 0

[Maria-discuss] question regarding innodb compression
by Rohan M C 03 Nov '14

03 Nov '14

Hi all, Due to space constraints we are considering the innodb compression option for some of our larger tables. We're not compressing all the tables, but only a select few to begin with. Our current planned process for this is to SET GLOBAL innodb_file_format=Barracuda; create compressed table, transfer data, and switch innodb_file_format back to Antelope. My question is around having this mix of table file formats in the same database. I've tried test queries and they were fine, but is it ok to have a mix of both Antelope and Barracuda file format tables in the db for a production environment? Thanks, Rohan

3 4

[Maria-discuss] MariaDB on Centos 7
by Blake 29 Oct '14

29 Oct '14

Since I had a few issues with it thought I would provide some information for those who are trying to install and help whoever is responsible for the Maria Repository. First, I was successful using the Centos 6 10.1 package via Yum with this repository setting pulled from Mariadb Repository setup. # MariaDB 10.1 CentOS repository list - created 2014-10-29 14:33 UTC # http://mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.1/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 Using "yum clean all" and yum update the following packages installed successfully. Shown in this pastebin http://pastebin.com/SMqECaju I did find though that with 10.0 using both the Centos 6 & 7 packages there is an issue with the language error files between MariaDB-server-10.0.14-1.el7.centos.x86_64 and dependency mariadb-libs-1:5.5.37-1.el7_0.x86_64 http://pastebin.com/CSri8mq0 I hope this information helps someone else and possibly the listing of a 10.1 Centos 7 package in the MariaDB Repository. ~Blake

1 0

[Maria-discuss] Storage engines enabled by default - MySQL 5.6 vs. MariaDB Galera Cluster 10.0
by Geoff Montee 29 Oct '14

29 Oct '14

I've been building MySQL 5.6 from source for a while. I recently started testing MariaDB Galera Cluster 10.0. When I build MariaDB Galera Cluster from source, I originally used the same cmake flags that I used for MySQL 5.6, along with the additional flags specified in Codership's documentation: http://galeracluster.com/documentation-webpages/installmariadbsrc.html My build process basically comes down to this: cmake . -L -DCMAKE_INSTALL_PREFIX=$MYQL_PREFIX -DMYSQL_DATADIR=$MYSQL_DATA -DWITH_SSL=yes -DWITH_READLINE=ON -DWITH_PIC=ON -DWITH_UNIT_TESTS=0 -DWITH_WSREP=ON -DWITH_INNODB_DISALLOW_WRITES=1 make make install With MariaDB Galera Cluster 10.0.14, the server that gets built does not have the Archive and Blackhole storage engines enabled by default. I do see that "ha_archive.so" and "ha_blackhole.so" were built and placed in plugin_dir, so I could probably enable them manually with INSTALL PLUGIN. This surprised me, because these engines are enabled by default in MySQL 5.6, and I see no mention of this difference here: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/#incompati… Of course, if I add "-DWITH_ARCHIVE_STORAGE_ENGINE=ON -DWITH_BLACKHOLE_STORAGE_ENGINE=ON" to my cmake arguments, then these engines are enabled in the MariaDB server that gets built. Is this difference intentional? If so, you may want to add a note to the documentation referenced above. If it's an unintentional discrepancy, I can submit a bug report on JIRA. Thanks, Geoff

2 2