- discuss - lists.mariadb.org

[Maria-discuss] Update mariadb-galera-server in Debian repository to 5.5.30
by Patric Falinder 17 May '13

17 May '13

Hi, I was just going to try MariaDB Galera on a couple of Debian 7.0 servers and noticed that the package mariadb-galera-server is not updated to version 5.5.30, it's still 5.5.29 which makes it impossible to install through the repository as it depends on libssl0.9.8 and Debian 7.0 is using libssl1.0.0. When looking at this bugreport https://mariadb.atlassian.net/browse/MDEV-4229 and if I understand it right, it's fixed in version 5.5.30, "Fix Version/s: 5.5.30-galera". Or have I misinterpreted that? Was mariadb-galera-server just missed when the updates where made? Can someone clarify that it's fixed in version 5.5.30 and if the repository is going to be updated? Thanks for your time, -Patric -

2 2

[Maria-discuss] mariadb update through yum repo when new version is available?
by Rafał Radecki 16 May '13

16 May '13

Hi All. I use http://yum.mariadb.org/5.5.30/centos6-amd64/ . Current version is 5.5.30. I would like to use the same version on all my mariadb machines so that (for example) the file format of storage engines would be the same (I make frequently rsyncs between servers). Lets assume that a new version 5.5.31 would be available in repo and then an update would be made. Are updates from 5.5.X to 5.5.Y always safe (small changes) or there can be problems/I should always read release info? Best regards, Rafal.

2 1

[Maria-discuss] int(x) does nothing
by Richard Couture 15 May '13

15 May '13

We discovered that declaring an int(x) of x characters does not seem to impose any restrictions what-so-ever on the size of data that can be stored in that int. Storing an int of greater dimension than that which was declared does NOT even generate a warning. Can someone please tell us why we are allowed to make such declarations and what are there purposes? Thanks Richard -- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc(a)linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.

4 3

[Maria-discuss] Spider 3.0 is merged against MariaDB 10.0
by Colin Charles 12 May '13

12 May '13

Hi! Kentoku Shiba has merged the latest Spider 3.0 against MariaDB 10.0: https://code.launchpad.net/~kentokushiba/maria/10.0-spider-3.0 I would like to propose this for merging There is also a complete test suite now, and Kentoku has written some instructions: == testing Spider I pushed Spider into "lp:~kentokushiba/maria/10.0-spider-3.0". It's tested on "CentOS 6.3 x86_64" and "Windows 7 professional 32bit". Test command is the followings. > cd mysql-test > ./mysql-test-run.pl --mysqld=--innodb --suite=spider The following test command can't done yet, because it needs some change for MariaDB. > ./mysql-test-run.pl --mysqld=--innodb --suite=spider/bg Spider's background/parallel search feature works allocate and free result-set from data node on different thread, but MariaDB 10.0's "per thread memory usage" feature can't understand it. > ./mysql-test-run.pl --mysqld=--innodb --suite=spider/handler Table partition feature need to support "handler" command. I have a patch file. In addition, it is awesome to note that Kentoku & his team behind the development of Groonga storage engine have also won an award (Japan OSS Incentive Award): http://ossforum.jp/en/node/1277 Thanks cheers, -colin -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

4 9

[Maria-discuss] KB Question: lgpl .net connector
by Daniel Bartholomew 09 May '13

09 May '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/lgpl-net-connector/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - lgpl .net connector Will there be an lgpl .net connector released in the future? I understand that most mysql downloads are for windows machines which would indicate a large market for mariadb. An lgpl .net connector would be a big incentive for a lot of people to move on MariaDB i think. My company currently use SQL Server but are looking at other options. An lgpl licence for mariadb would be the difference between us moving to mariadb rather than mysql or the liberally licenced postgresql. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart 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 Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] KB Question: Online non-locking statistics update?
by Daniel Bartholomew 09 May '13

09 May '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/analyze-table/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Is there anyway to do an online non-locking statistics update? Our db can't tolerate more than 3 secs locking on same table. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart 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 Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Running LinkBench against MariaDB
by Colin Charles 09 May '13

09 May '13

Hi XL, Today, Facebook made LinkBench public (see: https://www.facebook.com/notes/facebook-engineering/linkbench-a-database-be…) It might be useful for us to run LinkBench benchmarks against MariaDB to see how we stack up on this workload The source is here: https://github.com/facebook/linkbench Hoping to see benchmark results for this soon cheers, -colin -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

1 1

[Maria-discuss] KB Question: Strange ssl messages in error log
by Daniel Bartholomew 03 May '13

03 May '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/strange-ssl-messages-in-error-log/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Strange ssl messages in error log Hello, I'm getting these odd messages appearing in my error log since enabling SSL for replication in MariaDB Galera Cluster using the 5.5.29 release with 3 nodes using WAN clustering on AWS, 2 nodes are in us-east, 1 node in us-west-1. The host defined in the log (10.112.50.145) isn't even one of the local ips of the hosts in the cluster or my severalnines cluster control ip. It keeps incrementing 2 ports and retrying every 5-6 seconds. It's showing the same thing on two nodes in us-east, but nothing in the error log on the us-west-1 node. Apr 26 21:51:45 ip-x-x-x-x mysqld: 130426 21:51:45 [ERROR] WSREP: handshake with remote endpoint ssl:10.112.50.145:6347 failed: 1: 'End of file.' ( ) Apr 26 21:51:51 ip-x-x-x-x mysqld: 130426 21:51:51 [ERROR] WSREP: handshake with remote endpoint ssl:10.112.50.145:6349 failed: 1: 'End of file.' ( ) Everything else is working fine. Apr 26 17:57:17 ip-x-x-x-x mysqld: 130426 17:57:17 [Note] WSREP: SSL handshake successful, remote endpoint ssl:node3-public-ip:49900 local endpoint ssl:node2-local-ip:4567 cipher: AES128-SHA compression: zlib compression Apr 26 17:57:17 ip-x-x-x-x mysqld: 130426 17:57:17 [Note] WSREP: (bbbd2230-ae9a-11e2-0800-e4917d5483c5, 'ssl:0.0.0.0:4567') turning message relay requesting off Apr 26 17:57:18 ip-x-x-x-x mysqld: 130426 17:57:18 [Note] WSREP: SSL handshake successful, remote endpoint ssl:node1-local-ip:4567 local endpoint ssl:node2-localip:46046 cipher: AES128-SHA compression: zlib compression It seems that everything is replicating to all 3 nodes, however, my log is just getting filled with an useless error message. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart 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 Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB Java Client 1.1.2 Released
by Daniel Bartholomew 03 May '13

03 May '13

The MariaDB project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.2. This is a Stable (GA) release. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Java Client 1.1.2 - Release Notes: https://kb.askmonty.org/en/mariadb-java-client-112-release-notes/ - Changelog: https://kb.askmonty.org/en/mariadb-java-client-112-changelog/ - Downloads: https://downloads.mariadb.org/client-java/1.1.2/ Overview of the MariaDB Java Client: https://kb.askmonty.org/en/about-the-mariadb-java-client/ - - 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 MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/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 Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] aria checksum
by Scott Feldstein 30 Apr '13

30 Apr '13

Hi, I have data which I want to store in the aria storage engine, the data is inserted then never updated or deleted, although the table could be truncated. This data could potentially be replicated in production. The data is inserted in parallel and once the table reaches a certain capacity data is no long inserted into it. My question is, would I want to turn on the checksum for this data? And, if yes, should I use table checksum or page checksum? What are the advantages / disadvantages of this? I tried searching docs and couldn't find a breakdown so if someone could answer this or point me to a doc or discussion that would be great. Right now I am using DYNAMIC row format since I want the smallest footprint possible. thanks, Scott

2 1