- discuss - lists.mariadb.org

[Maria-discuss] New Question: Schema Missing after upgrading from MySQL 5.5.8 to MariaDB 5.5.31
by AskMonty KB 05 Jun '13

05 Jun '13

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by reustmd: -------------------------------- My OS is Windows 7 64-bit. I used the MariaDB msi installer. I uninstalled MySQL and installed MariaDB. I then launched sqlyog and it only found the standard mysql schemas (e.g., information_schema, mysql, performance_schema). My application schema appears to be missing. I also tried running "mysql_upgrade --verbose" and that didn't seem to help. Should I have to do something else? Thanks! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/schema-missing-after-upgrading-from-mysql-558-to-…

1 0

Re: [Maria-discuss] Clear-text plugin
by Peter Laursen 04 Jun '13

04 Jun '13

We have the same problem. We cannot test either. But we have a few user reports. We will discuss what we can do. Is there any parameter or compile-time option we should be aware of? Any specific documentation somewhere? Anything? -- Peter On Tue, Jun 4, 2013 at 2:19 PM, Sergei Golubchik <serg(a)mariadb.org> wrote: > Hi, Peter! > > On Jun 04, Peter Laursen wrote: > > For clarity: a 'dummy' parameter doing nothing does not solve our > > problem. We actually want to build clients that can (also) connect to > > Oracle MySQL Enterprise servers configured to make use of Oracle's PAM > > implementation. > > We build and distribute a cleartext plugin. And it can be used if the > server requests. In a sense, in MariaDB a cleartext plugin is always > enabled. So a dummy option is needed only to restore the binary protocol > compatibility. That's my understanding, at least, but I don't have > Oracle's PAM plugin, so I cannot test it. > > But if you have verified that your client with our C connector can not > connect to Oracle MySQL Enterprise server with the Oracle's PAM > implementation - please submit a bug report, and we will fix it. > > Regards, > Sergei > >

1 0

Re: [Maria-discuss] Clear-text plugin
by Peter Laursen 04 Jun '13

04 Jun '13

For clarity: a 'dummy' parameter doing nothing does not solve our problem. We actually want to build clients that can (also) connect to Oracle MySQL Enterprise servers configured to make use of Oracle's PAM implementation. -- Peter On Tue, Jun 4, 2013 at 11:05 AM, Peter Laursen <peter_laursen(a)webyog.com>wrote: > yes .. in the Connector/C. We use C/C++ for both SQLyog and MONyog. > > -- Peter > > > On Tue, Jun 4, 2013 at 10:17 AM, Sergei Golubchik <serg(a)mariadb.org>wrote: > >> Hi, Peter! >> >> On Jun 04, Peter Laursen wrote: >> > This is a continuation of >> > https://mariadb.atlassian.net/browse/CONC-25. We requested support for >> > the clear-text plugin (or a workaround of any kind) that would allow a >> > client compiled with the MariaDB connector to use PAM authentication >> > with MySQL Enterprise servers from Oracle. >> >> Another related issue is https://mariadb.atlassian.net/browse/MDEV-4574 >> which should be fixed in 5.5.32, next 5.5 release. >> >> But you, probably, want it in Connector/C, don't you? >> >> Regards, >> Sergei >> >> >

1 0

[Maria-discuss] Clear-text plugin
by Peter Laursen 04 Jun '13

04 Jun '13

This is a continuation of https://mariadb.atlassian.net/browse/CONC-25. We requested support for the clear-text plugin (or a workaround of any kind) that would allow a client compiled with the MariaDB connector to use PAM authentication with MySQL Enterprise servers from Oracle. I will not dispute Sergei's opinions about Oracle's implementation. But I believe it misses the point. The question is if the MariaDB connector should be a replacement for the C-IPA from Oracle. And the question is nothing else than that. Not the quality of solutions bundled with Enterprise servers from Oracle. I would like to hear opinions not only from 'core developers' like Sergei, but also from wider circles in MariaDB organization (management, marketing) as well as the user community. For us the problem is like this: We introduced support for the clear-text plugin in SQLyog 11.1. In 11.12 beta2 we replaced Oracles connector with MariaDB (and had to removed it again). We had a few crashes and memory leaks with mariaDB Connector but that is getting in control now (ther were bugs in both the API and in oru code). We probably could patch the MariaDB code without much problems to support the full-text plugin - but we don't have a MySQL Enterprise server to test with and we cannot release without proper testing. We have already started getting complaints from users/customers about that what we introduced in 11.1 has been removed in current development tree. It seems that we have quite a lot of customers using Oracle's Enterprise servers wiht Oracle's PAM authentication. A solution/workaround would very much be appreciated. Regards Peter Laursen Webyog

1 0

[Maria-discuss] New Question: Netbeans 7.3 + Hibernate + MariaDB Java Client + MySQL database
by AskMonty KB 30 May '13

30 May '13

Hello, A new question has been asked in "MariaDB Java Client" by mr_lou_d: -------------------------------- Although I can access the database through Netbeans using this driver and MySQL database, I am having difficulty getting Hibernate to work with the driver. Hibernate.cfg file has these entries: <property name="hibernate.connection.driver_class">org.mariadb.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306 /myspecial?zeroDateTimeBehavior=convertToNull [MariaDB - root on myspecial]</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> Note that the Hibernate plugin can't seem to find (doesn't have) any valid dialects for the mariadb driver. Therefore I edited the above xml to force MySQLDialect. This allowed me to get a little further, but when I try to create new "Hibernate mapping files and pojos from database", I fill in the dialog - but no files are generated. When I follow the same steps with the MySQL Java "Connector", including the same hibernate.reveng, it generates the pojos, and all works fine. Thanks for taking a look at this... Any ideas? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/netbeans-73-hibernate-mariadb-java-client-mysql-d…

1 0

Re: [Maria-discuss] [DBD-mysql] mysql_server_prepare causes segmentation fault on execute (#44)
by Patrick Galbraith 28 May '13

28 May '13

Hi Jan, I suspect it's a server issue vs. client, since as you say mysql crashes. No client should be able to do that :) The real test, is to write a program in C against libmysql that uses the server-side prepared statement API and see if you can reproduce it there. Monty and his team definitely would want to know about the crash. Any chance you could run that with mysql running debug and capture a trace? I would want to get that to Monty and team ASAP. Regards, Patrick On May 25, 2013, at 6:02 AM, Jan Pingel <notifications(a)github.com> wrote: > I've been debugging an issue with prepared queries crashing on the 2nd execute() on my FreeBSD box with the following: > > perl-5.16.2_1 > p5-DBD-mysql-4.021 > p5-DBI-1.625 > mariadb-server-5.5.30 > After connect if I set $DB->{'mysql_server_prepare'} = 1 the first execute() works but on the 2nd one the connection is lost as mariadb/mysql crashes. If I set $DB->{'mysql_server_prepare'} = 0 after connect it works as expected. > > The prepared query is: > > our $shop::test_query = $DB->prepare("SELECT id, merchant_id, name, price, image FROM lbn_shop_products WHERE category_id = ? ORDER BY purchase_count DESC, ctime DESC LIMIT ?, ?"); > Executing the queries: > > #>print $shop::test_query->execute(11, 0, 15) > 3 > $VAR1 = 1; > > #>print $shop::test_query->execute(11, 0, 15) > Database Error: > Lost connection to MySQL server during query > File Line Subroutine > ...k/shared/lib/exceptions.pm 93 (eval) oyster::console::__ANON__ > ...ork/shared/lib/database.pm 17 exceptions::throw > ...ared/lib/oyster/console.pm 73 (eval) database::handle_error > ...ared/lib/oyster/console.pm 31 oyster::_console_execute > ...k/shared/lib/exceptions.pm 178 (eval) oyster::console::__ANON__ > ...ared/lib/oyster/console.pm 64 exceptions::try > script/console.pl 38 oyster::console::start > > ! HASH(0x7fdcf8abd5b8) > The mysql/mariadb log isn't very useful: > > 130525 08:45:41 mysqld_safe mysqld restarted > I believe this is the same issue mentioned on both of these: > http://bugs.mysql.com/bug.php?id=27421 > https://rt.cpan.org/Public/Bug/Display.html?id=83497 > > Is there any additional information that would be useful such as setting the trace level and reporting the output? > > — > Reply to this email directly or view it on GitHub. >

1 0

[Maria-discuss] Aria table with auto increment PK - no concurrent inserts?
by Dmitry Insta 27 May '13

27 May '13

Hello, Aria FAQ says: "Multiple concurrent inserters into the same table." However, if I create a table with autoincrement PK, ENGINE=Aria ROW_FORMAT=PAGE (tried also TRANSACTIONAL=1) then there is no concurrency - only 1 thread is working, others are stuck in "Waiting for table level lock". I couldn't find the exact description of Aria engine behaviour in docs/faq/discussions - is it the way it's supposed to be? Thank you!

1 0

[Maria-discuss] New Question: database password?
by AskMonty KB 27 May '13

27 May '13

Hello, A new question has been asked in "Getting Started" by TommiG: -------------------------------- Dear colleagues, is there a way to have user restrictions embedded into the database? I learned user accounts and passwords are stored as part of the DBMS, but not as part of the DB. Therefore someone could copy the physical DB-files to an memorystick, move it to another machine and with a fresh installation of MariaDB he can read and modify all data. We create a desktop application and would like to distribute a database with private information to the end users. Is there a way we can hide this information and restrict its access only by using our client application but not by any other client? Sure we could encrypt our secret data, but than the DBMS could not create inizes, constrains, etc. Thank you in advance. Best regards, Thomas Env: WinXP, Win7, Win8 -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/database-password/

1 0

[Maria-discuss] New Question: my.cnf
by AskMonty KB 25 May '13

25 May '13

Hello, A new question has been asked in "Getting Started" by mici: -------------------------------- Hallo people, Today I install mariaDB 5.5.31 from binary source in Linux, Installation was success but after that I could not find my.cnf file. I need to edit cnf.file because I have to change the port number. can you tell where is my my.cnf file ? thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mycnf/

1 0

[Maria-discuss] New Question: my.cnf
by AskMonty KB 25 May '13

25 May '13

Hello, A new question has been asked in "Getting Started" by mici: -------------------------------- Hallo people, Today I install mariaDB 5.5.31 from binary source in Linux, Installation was success but after that I could not find my.cnf file. I need to edit cnf.file because I have to change the port number. can you tell where is my my.cnf file ? thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/getting-started-mycnf/

1 0

[Maria-discuss] Flush logs does not recreate slowlog.
by Rafał Radecki 24 May '13

24 May '13

Hi All. I use: MariaDB-server-5.5.30-1.x86_64 on CentOS release 6.4 (Final) 2.6.32-358.el6.x86_64 "flush logs" or "flush slow logs" does not recreate the file. In https://dev.mysql.com/doc/refman/5.5/en/flush.html there is "With no log_type option, FLUSH LOGS closes and reopens all log files." and "With a log_type option, only the specified log type is flushed." but neither command recreates the log file. I rotate slowlog through crontab: mv /var/log/mysqld-slow.log /var/log/mysqld-slow.log.old ; mysqladmin flush-logs Is it a bug or should it be so for some reason? Best regards, Rafal.

2 2

[Maria-discuss] MariaDB 5.5.31 now available
by Daniel Bartholomew 23 May '13

23 May '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.31. This is a bug-fix release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.31 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5531-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5531-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.31 Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - 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 (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - The MariaDB project tries to support as many different Operating Systems and Linux Distributions as we can. However, when a distribution or OS stops receiving security and other updates it becomes difficult to freely provide packages for that platform. In such cases, our policy is to deprecate that platform and stop providing binary packages for it. Accordingly, this will be the final release of MariaDB 10.0 for the following distributions: - Ubuntu 8.04 LTS "Hardy" - Ubuntu 11.10 "Oneiric" If your chosen Linux Distribution or Operating System is deprecated, packages or support are not completely unavailable. Companies such as SkySQL and others provide support for all versions of MariaDB back to even very old MySQL versions. This includes packaged binaries. Contact them for more details. More information on the deprecation policy can be found at: - https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - 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] 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 02 May '13

02 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

[Maria-discuss] New server, switch to MariaDB, different versions
by Tanstaafl 27 Apr '13

27 Apr '13

Hello, My current (8 yr old bare metal) server is currently running mysql 5.1.62, with just a couple of very small databases: postfixadmin and roundcube I am setting up a shiny new virtualized (ESXi host) server, that now has MariaDB 5.5.30 on it... My question is, can I do a dump from my old server running mysql 5.1.62, then restore that dump to my new server running MariaDB 5.5.30, run mysql_upgrade, and have any kind of reasonable expectation of it working? I'd rather not update the current (production) server to MariaDB (I'm gunshy when it comes to major changes on a production system). If not, then my other option would be to downgrade MariaDB on the new server to 5.1.66... but again, I'd rather not do that if it isn't necessary. Thanks - I'm really looking forward to saying goodbye to mysql (for political reasons, the software itself has served me well these 8 years, it's just too bad that they got bought by Oracle)... Charles

3 3

[Maria-discuss] Buildbot for Ubuntu Raring 13.04
by Colin Charles 25 Apr '13

25 Apr '13

Hi! Today Ubuntu released Raring 13.04 and we probably need to setup some VMs for that 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 0

[Maria-discuss] MariaDB 10.0.2-alpha now available
by Daniel Bartholomew 24 Apr '13

24 Apr '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.2. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else. This is the third 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. See the release notes and changelog for details on what is new in this release. Do not use alpha releases on production systems. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.2 Alpha - Release Notes: http://kb.askmonty.org/en/mariadb-1002-release-notes - Changelog: http://kb.askmonty.org/en/mariadb-1002-changelog - Downloads: http://downloads.mariadb.org/mariadb/10.0.2 Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ - - 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 (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - The MariaDB project tries to support as many different Operating Systems and Linux Distributions as we can. However, when a distribution or OS stops receiving security and other updates it becomes difficult to freely provide packages for that platform. In such cases, our policy is to deprecate that platform and stop providing binary packages for it. Accordingly, this will be the final release of MariaDB 10.0 for the following distributions: - Ubuntu 8.04 LTS "Hardy" - Ubuntu 11.10 "Oneiric" If your chosen Linux Distribution or Operating System is deprecated, packages or support are not completely unavailable. Companies such as SkySQL, Monty Program, and others provide support for all versions of MariaDB back to even very old MySQL versions. This includes packaged binaries. Contact them for more details. More information on the deprecation policy can be found at: https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - 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 Monty Program - http://montyprogram.com

1 0

[Maria-discuss] TokuDB + MariaDB: libjemalloc is important
by Colin Charles 23 Apr '13

23 Apr '13

Hi! Continuing on the interest in libjemalloc, and how we have a thread started on in, especially since Percona is building their server going forward using it (see: https://lists.launchpad.net/maria-discuss/msg00788.html) we've also had requests from Team Tokutek, that TokuDB also requires us building with jemalloc for a good experience. I'm adding Tim Callaghan to the discussion, as TokuDB has been building & releasing with it for over a year The other Callaghan who's on this list, Mark, has also made posts about jemalloc: https://www.facebook.com/MySQLatFacebook/posts/486784224710172 & https://www.facebook.com/notes/mysql-at-facebook/using-jemalloc-to-fix-a-pe… Shall we think about using a different malloc implementation? LD_PRELOAD may be the only option we have to change... (oh and test, benchmark, etc.) 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 0

[Maria-discuss] Fedora test day for replacing MySQL with MariaDB
by Colin Charles 18 Apr '13

18 Apr '13

Hi all, By now you must know of the movement to replace MySQL with MariaDB in Fedora-land (http://fedoraproject.org/wiki/Features/ReplaceMySQLwithMariaDB) One important thing is to ensure that MariaDB is a drop-in replacement. Fedora is a fast-moving high quality Linux distribution, so their focus aims are to ensure that MariaDB and MySQL are compatible, data can be migrated easily and there are minimal/no upgrade issues (and if so, they need to be documented) This is why on 30 April 2013, there is a Fedora test day dedicated to this very important task: http://fedoraproject.org/wiki/Test_Day:2013-04-30_MariaDB I plan to be on IRC for as long as humanly possible on #fedora-test-day (freenode) and will be watching the process closely. If you would like to participate, this is naturally welcome to help new MariaDB users 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/

1 0

[Maria-discuss] jemalloc used in Percona Server 5.5.30
by Colin Charles 13 Apr '13

13 Apr '13

Hi! Steve Meyers, a MariaDB user, is quite excited to see that libjemalloc is used for Percona Server 5.5.30 (http://www.stevemeyers.net/2013/04/percona-server-to-ship-with-jemalloc.html) He's wondering if we'll adopt this A note from the latest release notes: "Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost." Blogpost: http://www.mysqlperformanceblog.com/2012/07/05/impact-of-memory-allocators-… 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 0

[Maria-discuss] We're accepted into Google Summer of Code 2013
by Colin Charles 10 Apr '13

10 Apr '13

Subject says it all We need people to sign up as mentors (http://www.google-melange.com/gsoc/homepage/google/gsoc2013) against the MariaDB project Students start opening up soon If you know of projects a student can complete in 3 months over a summer, this is the ideal place to list the task: https://kb.askmonty.org/en/google-summer-of-code-2013/ This is the first time MariaDB is going to participate. Some of you have done this in the past against MySQL or Drizzle. Big win for MariaDB this year! 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/

2 1

[Maria-discuss] Google Summer of Code 2013 ideas page
by Colin Charles 09 Apr '13

09 Apr '13

Hi all, Team MariaDB wants to participate in Google Summer of Code 2013. We definitely want to ensure that students have lots to do within those three summer months plus continue being MariaDB developers Please contribute to the ideas page: https://kb.askmonty.org/en/google-summer-of-code-2013/ Thanks -- 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 0

[Maria-discuss] KB Question: Creating forms
by Daniel Bartholomew 08 Apr '13

08 Apr '13

The following question has been posted in the AskMonty Knowledgebase: https://kb.askmonty.org/en/creating-forms/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Creating forms I am new to MariaDB and MySQL. I am experienced with MS Access. I have an extensive Access DB that I want to convert to MariaDB. I have read MariaDB Crash Course. My question is what front-end do I use to create forms and reports? Is the best approach, use PHP or Python and create a web based application? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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 Monty Program - http://montyprogram.com

1 0

[Maria-discuss] KB Question: Client library compatibility
by Daniel Bartholomew 04 Apr '13

04 Apr '13

The following question has been posted to the AskMonty Knowledgebase: https://kb.askmonty.org/en/client-library-compatibility/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Hi, Two questions : You mention that the MariaDB client library is compatible with MySQL 5.5. What about its actual MariaDB-versionned compatibility ? I also noted that the client library code is in active and constant development. Is it aimed at evolving at the same time as MariaDB, or will we have, as it's the case for MySQL, a client library for each new MariaDB release ? Thanks in advance, Bruno - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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 Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Single-threaded performance & optimizer overhead
by Colin Charles 03 Apr '13

03 Apr '13

Hi! Mark Callaghan asks this on Facebook: While testing single-threaded performance to compare MySQL 5.1 with 5.6 I think there is much more overhead in the optimizer in 5.6. Do you have benchmark results for a single-threaded workload with fast queries (like SELECT one row by PK from a cached table)? I am curious whether new versions of MariaDB have a similar increase in optimizer overhead. http://bugs.mysql.com/bug.php?id=68825 He also wrote a blog post: http://mysqlha.blogspot.com/2013/04/mysql-56-single-thread-update-only.html Might make a great post at our blog 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/

3 2

Re: [Maria-discuss] [Dbmail] MariaDB and dbmail
by Reindl Harald 03 Apr '13

03 Apr '13

Am 03.04.2013 11:09, schrieb Sergej Pupykin: > At Tue, 02 Apr 2013 19:47:15 +0400, > Sergej Pupykin <ml(a)sergej.pp.ru> wrote: >> Not sure if it caused by migration to mariadb, but problem appeared >> near same time. > > Downgrading back from mariadb 5.5.30 to mysql 5.5.30 solves the > problem. It looks like mariadb has ordering problems or it is not > drop-in replacement of mysql i am CC'ing this to the MariaDB list.......... but "however when I run it from command line it works well" speaks against it - this is highly interesting since more and more distributions are switching to MariaDB including Fedora and i am at preparing the switch too with no problems until now _____________________________ zamri <myzamri(a)gmail.com> wrote: > MariaDB is fully compatible with MySQL. Migration is done. So far so good. Phewww!... > > Now I need to do some research on tuning mariadb if needed. I found that after migration following SQL returns wrong sorted data: SELECT l.part_key, l.part_depth, l.part_order, l.is_header, DATE_FORMAT(ph.internal_date,GET_FORMAT(DATETIME,'ISO')), data FROM dbmail_mimeparts p JOIN dbmail_partlists l ON p.id = l.part_id JOIN dbmail_physmessage ph ON ph.id = l.physmessage_id WHERE l.physmessage_id = <ID> ORDER BY l.part_key,l.part_order ASC; however when I run it from command line it works well. Probably it does not fail always because of not all emails damaged. Not sure if it caused by migration to mariadb, but problem appeared near same time.

3 3

Re: [Maria-discuss] [Dbmail] MariaDB and dbmail
by Sergej Pupykin 03 Apr '13

03 Apr '13

At Wed, 03 Apr 2013 14:35:59 +0400, Sergej Pupykin <ml(a)sergej.pp.ru> wrote: > > Yes, but > > $ systemctl stop postfix dbmail-imapd dbmail-timsieved dbmail-pop3d mysqld > $ pacman -S mysql-clients mysql libmysqlclient > $ systemctl start mysqld postfix dbmail-imapd dbmail-timsieved dbmail-pop3d > $ mysql_upgrade --force > > solves the problem. > > I tested it using telnet to imap port. > ? LOGIN ... > ? SELECT ... > ? FETCH <ID> body[] > and check order of mime parts. > > Also dbmail/libzdb code looks clean. It just get sql query results and > put them to IMAP client... Link to thread start: http://www.mail-archive.com/dbmail%40dbmail.org/msg18179.html

1 0

[Maria-discuss] [Certification] Oracle MySQL exams horribly outdated. Are there MariaDB exams in planning?
by Lukas Lehner 26 Mar '13

26 Mar '13

Oracle MySQL exams are horribly outdated. Are there MariaDB exams in planning?

2 1

[Maria-discuss] WL#4925 and multi-source replication
by Greg 15 Mar '13

15 Mar '13

Hi, I'm testing multi-source replication with 6 sources, it works great ! Now I'm at the "HA" state, testing a master multi-source with DRBD. To do a safe switch between masters, I have to enable sync_binlog=1 and then the master delay grow... I see that WL#4925 suggest a solution that could work : is that job in progress in MariaDB 10 trunk ? And if not, how to ask to include it ? Thanks! -- Greg

4 12

[Maria-discuss] MariaDB 5.5.30 now available
by Daniel Bartholomew 12 Mar '13

12 Mar '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.30. This is a bug-fix release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.30 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5530-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5530-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.30 Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: https://downloads.mariadb.org/mariadb/repositories/ - - 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 (my.ini on Windows) file! See http://kb.askmonty.org/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 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 Monty Program - http://montyprogram.com

1 0

[Maria-discuss] unexpected index growth
by Said Ramirez 11 Mar '13

11 Mar '13

We have noticed a very strange index growth with one of our tables. The data in the table is currently ~ 42GB and has been growing at a rate of about 1 GB per day for the week. Inserts/Updates on the tables are done with statements like: insert into foo ( ...) on duplicate key update ... We have a job which updates about 1/3 of the table 12 times a day. We running Mariadb version 5.5.27-MariaDB-log We noticed that the index sizes have been growing quite a bit: ** 7 days ago *** > select table_name,index_name,index_total_pages, (index_total_pages * 16*1024)/(1024*1024*1024) index_size_gb from INNODB_INDEX_STATS where table_name='foo'; +--------------------+----------------------+-------------------+---------------+ | table_name | index_name | index_total_pages | index_size_gb | +--------------------+----------------------+-------------------+---------------+ | foo | PRIMARY | 1192456 | 18.1954 | | foo | idx_active_deleted | 5647809 | 86.1787 | | foo | idx_last_update_plus | 5329538 | 81.3223 | | foo | active | 8586719 | 131.0229 | +--------------------+----------------------+-------------------+---------------+ 4 rows in set (0.00 sec) > optimize table db.foo; +---------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +---------+----------+----------+-------------------------------------------------------------------+ | db.foo | optimize | note | Table does not support optimize, doing recreate + analyze instead | | db.foo | optimize | status | OK | +---------------------------------+----------+----------+-------------------------------------------------------------------+ 2 rows in set (4 hours 1 min 24.73 sec) > select table_name,index_name,index_total_pages, (index_total_pages * 16*1024)/(1024*1024*1024) index_size_gb from INNODB_INDEX_STATS where table_name='foo'; +--------------------+----------------------+-------------------+---------------+ | table_name | index_name | index_total_pages | index_size_gb | +--------------------+----------------------+-------------------+---------------+ | foo | PRIMARY | 639296 | 9.7549 | | foo | idx_active_deleted | 403520 | 6.1572 | | foo | idx_last_update_plus | 531392 | 8.1084 | | foo | active | 517312 | 7.8936 | +--------------------+----------------------+-------------------+---------------+ 4 rows in set (0.00 sec) ** Today ** > select table_name,index_name,index_total_pages, (index_total_pages * 16*1024)/(1024*1024*1024) index_size_gb from INNODB_INDEX_STATS where table_name='foo'; +--------------------+----------------------+-------------------+---------------+ | table_name | index_name | index_total_pages | index_size_gb | +--------------------+----------------------+-------------------+---------------+ | foo | PRIMARY | 1013436 | 15.4638 | | foo | idx_active_deleted | 2478512 | 37.8191 | | foo | idx_last_update_plus | 2459700 | 37.5320 | | foo | active | 3888175 | 59.3288 | +--------------------+----------------------+-------------------+---------------+ 4 rows in set (0.10 sec) One of the even stranger things is that the slaves of this table do not experience such a noticeable index size growth: [slave] >select table_name,index_name,index_total_pages, (index_total_pages * 16*1024)/(1024*1024*1024) index_size_gb from INNODB_INDEX_STATS where table_name='foo'; +--------------------+----------------------+-------------------+---------------+ | table_name | index_name | index_total_pages | index_size_gb | +--------------------+----------------------+-------------------+---------------+ | foo | PRIMARY | 1010492 | 15.4189 | | foo | idx_active_deleted | 454510 | 6.9353 | | foo | idx_last_update_plus | 543085 | 8.2868 | | foo | active | 583468 | 8.9030 | +--------------------+----------------------+-------------------+---------------+ 4 rows in set (0.01 sec) Our suspicion is that it has to do with how transactions are executing on the master since on the slaves the insert/updates would be executed in a single thread. However we can't tell why this is happening. Is this a known bug we are hitting ? As anyone else seen this behavior and come up with a solution other than having to run optimize table ? Thanks, -Said

2 4

[Maria-discuss] MariaDB Galera Cluster 5.5.29 Stable (GA) Released
by Daniel Bartholomew 05 Mar '13

05 Mar '13

After some final testing and polishing, the MariaDB project and Codership are pleased to announce the release of MariaDB Galera Cluster 5.5.29. This is a Stable (GA) release. - - MariaDB Galera Cluster 5.5.29 Links - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-galera-5529-release-notes Changelog: http://kb.askmonty.org/en/mariadb-galera-5529-changelog Downloads: http://downloads.mariadb.org/mariadb-galera/5.5.29 APT & YUM Repository Configuration Tool: http://downloads.mariadb.org/mariadb-galera/repositories Overview of MariaDB Galera Cluster 5.5: http://kb.askmonty.org/en/what-is-mariadb-galera-cluster More information: http://kb.askmonty.org/en/galera http://codership.com - - About MariaDB Galera Cluster - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster is made for today's cloud based environments. It is fully read-write scalable, comes with synchronous replication, allows multi-master topologies, and guarantees no lag or lost transactions. Some of its features & benefits are listed below. Features * Synchronous replication * Active-active multi-master topology * Read and write to any cluster node * Automatic membership control, with failed nodes dropped from the cluster * Automatic node joining * True row-level parallel replication * Direct client connections, native MariaDB/MySQL look & feel Benefits The above features yield several benefits for a database clustering solution, including: * No slave lag * No lost transactions * Both read and write scalability * Smaller client latencies Technology MariaDB Galera Cluster uses the Galera Library for the replication implementation. http://codership.com/products/galera_replication To interface with Galera replication, we have enhanced MariaDB to support the replication API definition in the Write Set REPlication (https://launchpad.net/wsrep) project. The implementation of the replication API in MariaDB happens in the open source MySQL-wsrep project. http://www.codership.com/products/mysql-write-set-replication-project - - Operations Support - - - - - - - - - - - - - - - - - - - - - - - - Once you run MariaDB Galera Cluster in production you want to make sure there is a helping hand available whenever needed. We're happy to inform you that our partner, SkySQL, offers 24-hour support for MariaDB Galera Cluster, see http://www.skysql.com/enterprise/galera-cluster for more information. - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous usage information. This information is used by the developers to track trends in usage to better guide development efforts. If you would like to help make MariaDB Galera Cluster better, please add "feedback=ON" to your my.cnf file! See http://kb.askmonty.org/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 We hope you enjoy MariaDB Galera Cluster! - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - http://mariadb.org We're also on: Google+: http://google.com/+mariadb Facebook: http://fb.com/MariaDB.dbms Twitter: http://twitter.com/mariadb Follow, friend, and add us to your circles to keep up to date with MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL

1 0

[Maria-discuss] KB Question: FreeBSD 9.1, Mariadb55, and strfill()
by Daniel Bartholomew 04 Mar '13

04 Mar '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/freebsd-91-mariadb55-and-strfill/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - FreeBSD 9.1, Mariadb55, and strfill() Please give me a hint. Under FreeBSD my application cannot find strfill(). It can be found in libmysqlclient.a and libmysqlclient_r.a but NOT in the shared library libmysqlclient.so. Oddly, strcend() can be found in all of those libraries but I cannot find a difference in CMake between the two. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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 Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Using 10.0s multi-source replication for database consolidation
by Markus "Shorty" Uckelmann 22 Feb '13

22 Feb '13

Hi all, I want to consolidate the databases on several servers onto a single server. And all this without or only minimal downtime. After reading an article[1] from the Percona folks I was thinking of using the multi-source replication feature of 10.0. But there are a few things I'm not sure about. Maybe someone can help me out. What MySQL/MariaDB versions are needed before and behind the MariaDB 10 server? My plan/idea/dream was the following: 1. Stop the server on a slave and start it with skip-slave and skip-networking. Write down replication data. 2. Dump the databases I want to move with "mysqldump <db-name>" 3. Load the dump into MariaDB 10.0 and configure replication. This is done for all the databases I want to put onto a single server. The rest should be business as usual. BTW: We use similar grants on all servers. So the MariaDB 10.0 will be setup with the same statements and I don't have to care about the "mysql"-database. Does this sound realistic? Or have I missed something? [1] http://www.mysqlperformanceblog.com/2012/12/18/migrating-several-single-sta… Thanks a lot, Shorty

2 4

[Maria-discuss] KB Question: Low level access 8Bit MCU
by Daniel Bartholomew 19 Feb '13

19 Feb '13

The following question has been posted in the Knowledgebase: https://kb.askmonty.org/en/low-level-access-8bit-mcu/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Low level access 8Bit MCU are there any possibilities for a low level access via TCP/IP or UDP with an 8Bit MCU, for the basic functions, read record, edit record, add record. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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 Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Configuration tool
by Joerg Stephan 19 Feb '13

19 Feb '13

Hi there, if you follow the instructions regarding Ubuntu 12.04 LTS, the instructions will nit lead to an succesfull installation. apt-get will run into an unresolved dependency state, doing it with aptitude you can resolve the dependency in an second step. Maybe the issue should be fixed, or the docu should be updated. Regards Jörg

2 1

[Maria-discuss] KB Question: What Join?
by Daniel Bartholomew 18 Feb '13

18 Feb '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/what-join/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - I have a table called called ContenidosDeModelos with fields +------------+-------------+------+-----+ | Field | Type | Null | Key | +------------+-------------+------+-----+ | CdMID | int(5) | NO | PRI | | ModeloID | int(5) | NO | MUL | | ArticuloID | int(5) | NO | MUL | | Cantidad | float(10,3) | NO | | +------------+-------------+------+-----+ which in turn is related on the field ArticuloID to a table called CatArticulos with fields +-----------------------+-------------------------------------- | Field | Type +------------------------+------------------------------------- | ArticuloID | int(5) | ArticuloCodigo | char(7) | ArticuloNombre | varchar(45) | ArticuloDesc | varchar(75) | ArticuloDeshabilitado | char(1) | ArticuloUnidad | enum('pz','mts','kg','ton','m3','lts') +-----------------------+-------------------------------------- I want a listing of ALL of table CatArticulos (1300+ records) with the value of the field Cantidad from the table ContenidosDeModelos for a specified ModeloID (3 - 10 records) when there is a common ArticuloID otherwise Cantidad should be NULL when there is no corresponding ArticuloID in ContenidosDeModelos. I have written at least 100 different joins that don't work. Can someone give me a clue? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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 Monty Program - http://montyprogram.com

2 1

[Maria-discuss] CentOS 6 RPMS - do give them a test
by Colin Charles 18 Feb '13

18 Feb '13

Hi! If you're using CentOS, do consider checking out the testing packages available: http://lists.centos.org/pipermail/centos-devel/2013-February/009029.html Quick start: drop http://dev.centos.org/centos/6/mariadb/mariadb.repo into /etc/yum.repos.d/ and yum list mariadb\* Please let us know how it goes and report bugs to http://bugs.centos.org/ 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 0

[Maria-discuss] testing Galera
by Jan Kirchhoff 12 Feb '13

12 Feb '13

Hi, I'd like to evaluate mariadb-galera on some test databases. Our load is at least 90% writes coming from a datastream and I would try to set up a real-world situation and test with real data. Most of the work load is "insert ... on duplicate key update" mass-inserts (actually updates) of about 4MB/10000 rows each. 99% of these run onto 3-4 tables (each around 10GB/7 million rows of size). Total database size is around 800 GB. We have a traditional statement-based master-slave replication, but all these mass-inserts run over a proxy with SET SQL_LOG_BIN=0 in parallel on all systems - no way to process this amount of data single-threaded on the slaves. I was hoping galera would make this easier and make our proxies obsolete. I have some servers I could use for galera as a first step. I wanted to do this for 4 months now but never got into it, I read your request to test the RC and think I should start now hoping to be able to give some valuable feedback: After reading through the documentation and some blogs I have some doubts, but my idea was to do the following: I'd clone the database of an existing slave to a new machine with mariadb-galera (name the host "testgalera1" and rsync the database or use mysqldump). I'd then set up this one as a "normal" statement based slave connected to one of our masters? Afterwards, the next host "testgalera2" would have to be added to the galera-cluster? And after that, I'd set up one of our older database servers and add that to the cluster, too. My idea was to take an older, slower system to see how much this slowes the cluster down and get an idea how much headroom I'd have when I leave those old machines out (the old machines have only 64GB of RAM and slower CPUs). I'd then modify my proxy for all the incoming inserts and add a writer-thread to one of the hosts in the cluster, that data should be replicated by galera to all other galera hosts. All other data should be coming in via the "traditional" replication thread of testgalera1. This should give me a 95-99% real world write situation on the cluster. Adding a host to a running cluster would mean cloning the whole database (of course), but this also means the host I copy from would have to block write access to its tables and buffer all modifications in memory (at least that's how I read the documentation) during the copy process. Looking at the database size and amount of inserts, I am afraid adding a host to the cluster without taking everything down would be impossible - or even if it works fine now it could cause trouble once the database gets just a little bit larger or my load increases a bit. before I start with this - is galera an insane idea regarding my load? Or is it worth a try? Jan some numbers of some of the old databases: innodb_buffer_pool_size between 60-120 GB depending on server memory configuration. db5: Uptime: 8052248 Threads: 44 Questions: 1413881794 Slow queries: 160049 Opens: 683779 Flush tables: 2 Open tables: 1024 Queries per second avg: 175.588 db6: Uptime: 8070552 Threads: 6 Questions: 873413218 Slow queries: 3208 Opens: 336584 Flush tables: 1 Open tables: 578 Queries per second avg: 108.222 db7: Uptime: 4175032 Threads: 28 Questions: 639627677 Slow queries: 139337 Opens: 522673 Flush tables: 1 Open tables: 2016 Queries per second avg: 153.203 db7# mysql -e 'show global status like "%com\_%" ' |grep -v '\s0$' Variable_name Value Com_admin_commands 289127 Com_alter_table 6269 Com_analyze 725 Com_begin 3712141 Com_change_db 80112 Com_commit 3999309 Com_create_db 1 Com_create_table 253849 Com_create_trigger 10 Com_create_view 68 Com_delete 12365037 Com_delete_multi 7 Com_drop_table 310771 Com_drop_trigger 10 Com_drop_view 65 Com_empty_query 509 Com_flush 48 Com_grant 36 Com_insert 314280963 Com_insert_select 613565 Com_kill 214 Com_lock_tables 85 Com_optimize 1 Com_purge 2320 Com_rename_table 11 Com_repair 1 Com_replace 14240825 Com_replace_select 29920 Com_revoke 8 Com_rollback 13 Com_select 178540996 Com_set_option 6886915 Com_show_binlogs 69960 Com_show_charsets 1542 Com_show_collations 1544 Com_show_create_db 28 Com_show_create_func 195 Com_show_create_table 53282 Com_show_create_trigger 1 Com_show_databases 43584 Com_show_events 3 Com_show_fields 131874 Com_show_function_status 45 Com_show_grants 335 Com_show_keys 2582 Com_show_master_status 142 Com_show_plugins 7224 Com_show_procedure_status 45 Com_show_processlist 116918 Com_show_slave_status 83193 Com_show_status 155732 Com_show_storage_engines 25 Com_show_table_status 7439 Com_show_tables 1973739 Com_show_triggers 538 Com_show_variables 85034 Com_show_warnings 766 Com_stmt_close 363 Com_stmt_execute 363 Com_stmt_prepare 363 Com_truncate 452 Com_unlock_tables 79 Com_update 34496744 Com_update_multi 408212

5 10

[Maria-discuss] Problem in replication with NOW('2012-03-07 17:32:03')
by Jan Kirchhoff 12 Feb '13

12 Feb '13

Hi, I set up 2 hosts as a galera cluster, one of them is a slave of my main database. The galera hosts are 5.5.28a-MariaDB-a1~precise-log, all other databases are 5.2.12-MariaDB-mariadb115~squeeze-log. The 5.5 slave stops with 1064 errors. I figured this is because of updates using NOW() on timestamp columns, I think they come from a phpmyadmin frontend. In the error log the queries look like this: UPDATE ..., some_timestamp_field = NOW('2012-03-07 17:32:03') WHERE ...primary keys... when I manually execute the query and just remove the NOW so it is a simple update some_timestamp_field = '2012-03-07 17:32:03' and then execute set global sql_slave_skip_counter=1;slave start; everything is fine again. All 5.2 hosts replicate just fine. is this a bug in 5.5? Thanks Jan

2 4

[Maria-discuss] service on port 4567 is not starting
by Kőszegi Dániel 12 Feb '13

12 Feb '13

Hi All, I would appreciate a little help. I have done everything how it is in the installation steps, but the galera service on the port 4567 is not starting. No errors in mysql or syslog :( Tried on debian and centos as well. Right now server version: 5.5.28a-MariaDB-a1~squeeze-log mariadb.org binary distribution, wsrep_23.7rc1.rXXXX but I have tried with relevant mysql binaries as well. Do you have any idea why is it not starting the cluster service? wsrep.conf on node1: root@mariaclu01:/etc/mysql# cat /etc/mysql/conf.d/wsrep.cnf [wsrep] wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_address="gcomm://" wsrep_sst_auth=sst:sstpass123 wsrep.conf on node2: root@mariaclu02:~# cat /etc/mysql/conf.d/wsrep.cnf [wsrep] wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_address="gcomm://192.168.1.30:4567" wsrep_sst_auth=sst:sstpass123 MariaDB [(none)]> show status like 'wsrep%'; +--------------------------+----------------------+ | Variable_name | Value | +--------------------------+----------------------+ | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 0 | | wsrep_cluster_state_uuid | | | wsrep_cluster_status | Disconnected | | wsrep_connected | OFF | | wsrep_local_index | 18446744073709551615 | | wsrep_provider_name | | | wsrep_provider_vendor | | | wsrep_provider_version | | | wsrep_ready | ON | +--------------------------+----------------------+ root@mariaclu01:/etc/mysql# netstat -tulpn | grep -e 4567 -e 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3387/mysqld Thank you in advance! Cheers, Daniel dudu(a)ihd.hu

2 2

[Maria-discuss] MariaDB 10.0.1-alpha now available
by Daniel Bartholomew 06 Feb '13

06 Feb '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.1. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else. This is the second 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. See the release notes and changelog for details on what is new in this release. Do not use alpha releases on production systems. - - MariaDB 10.0 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-1001-release-notes Changelog: http://kb.askmonty.org/en/mariadb-1001-changelog Downloads: http://downloads.mariadb.org/mariadb/10.0.1 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 - - New Packages - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.1 includes packages for Fedora 18 "Spherical Cow" and Ubuntu 12.10 "Quantal Quetzal". Visit the Repository Configurator to generate the necessary commands to easily install MariaDB on these and several other distributions. https://downloads.mariadb.org/mariadb/repositories/ - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - Along with the news of new package builds is the news that some old distributions have been deprecated. The MariaDB project tries to support as many different operating systems and Linux distributions as possible. However, when a distribution or OS stops receiving upstream security and other updates it becomes difficult to provide packages for that platform. In such cases, our policy is to deprecate that platform and stop building binary packages for it in our build system. As of 1 Feb 2013, we stopped building and testing packages for the following: - Fedora 16 "Verne" - Debian 5 "Lenny" - Ubuntu 10.10 "Maverick" - Ubuntu 11.04 "Natty" Even after your chosen Linux distribution is deprecated, packages and support are still available. Companies such as SkySQL and Monty Program (among others) provide paid support for all versions of MariaDB and back to even very old MySQL versions. This includes packaged binaries. More information on our deprecation policy can be found at: https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - 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 (my.ini on Windows) file! See http://kb.askmonty.org/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 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