- discuss - lists.mariadb.org

[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

[Maria-discuss] Dots in filenames of configuration files - !includedir weirdness
by Geoff Montee 24 Oct '14

24 Oct '14

I've noticed some strange behavior that might be a bug in the current implementation of the !includedir directive for my.cnf files. I wanted to get the opinion of the MariaDB community on whether this is working as intended before reporting it. Let's say I have a line like the following in /etc/my.cnf: !includedir /home/mysql/conf MariaDB should load any configuration variables from files with the extension ".cnf" in that directory. The problem I ran into is that MariaDB appears to determine the extension based on the first dot ('.') in the filename. If I have a file with a full path like this: /home/mysql/conf/mariadb10.0-galera.cnf MariaDB appears to think that the extension of the file is 0-galera.cnf, so it won't load it. If the file is renamed to something like this (with no extra dots): /home/mysql/conf/mariadb10-0-galera.cnf MariaDB properly loads the configuration file. Is this a bug that should be reported? System info: OS: RHEL 6 Arch: x86_64 MariaDB build: MariaDB Galera Cluster 10.0.14, built from source Slightly related note: I don't see any documentation on the !includedir directive in the MariaDB knowledgebase. I would expect to see some mention of it here: https://mariadb.com/kb/en/mariadb/documentation/getting-started/configuring… Thanks, Geoff Montee

2 3

[Maria-discuss] New Question: notifier for mariadb
by AskMonty KB 22 Oct '14

22 Oct '14

Hello, A new question has been asked in "Moving from MySQL" by noirefuse: -------------------------------- One thing I miss from MySQL is their windows tray app, MySQL notifier. I am currently using it with MariaDB instead, but would like to see an open source alternative to it. I Haven't been able to find one. Are there any plans to include something like that with the windows install in the future? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/notifier-for-mariadb/

1 0

[Maria-discuss] New Question: sporadic issue with opening connection and Mariadb
by AskMonty KB 22 Oct '14

22 Oct '14

Hello, A new question has been asked in "Moving from MySQL" by helenfeder: -------------------------------- I am using jpa with Spring and Hibernate and testing my application with MariaDB. It is mostly working but then every once in awhile (cannot detect any pattern) I am seeing sporadic Errors like the one below. I am going against a single database machine and we have made sure that there are no firewall preventing access between my application server and the database server. Most of the time the database calls are successful - just periodically they are not. I have been using jmeter to simulate load to help me reproduce the issue. What is causing this problem and how can I correct it? I am using the following properties in my connection (removed our hostname, dbname, port,etc for security reasons): dataSource.url=jdbc:mariadb://<our db hostname: port>/<db-name>?trustServerCertificate=true&useSSL=true&dumpQueriesOnException=true&ssl-cert=/home/hrf/credMgmtDbCerts/client-cert.pem&ssl-key=/home/hrf/credMgmtDbCerts/client-key.pem dataSource.driverClassName=org.mariadb.jdbc.Driver dataSource.dialect=org.hibernate.dialect.MySQL5Dialect dataSource.user=<username> dataSource.password=<password> Here is the relevant part of the stack trace I am seeing --> Caused by: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1397) at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:62) at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:67) at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) ... 39 more Caused by: org.hibernate.exception.JDBCConnectionException: Could not open connection at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:67) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157) at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67) at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160) at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1432) at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:59) ... 41 more Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to <hostname:port>: Unsupported record version Unknown-0.0 at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:136) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.MySQLDataSource.getConnection(MySQLDataSource.java:291) at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:70) at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214) ... 46 more Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect to <hostname:port>: Unsupported record version Unknown-0.0 at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:513) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:673) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:266) at org.mariadb.jdbc.MySQLDataSource.getConnection(MySQLDataSource.java:289) ... 49 more Caused by: javax.net.ssl.SSLException: Unsupported record version Unknown-0.0 at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:524) at sun.security.ssl.InputRecord.read(InputRecord.java:509) at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927) at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1312) at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1339) at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1323) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:444) ... 52 more Your help is greatly appreciated. Thank you. Helen Feder Principal Systems Software Engineer Carnegie Mellon University -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/sporadic-issue-with-opening-connection-and-mariadb/

1 0

[Maria-discuss] New Question: Cluster Overall Memory Requirements (compared to multiple stand-alone nodes)
by AskMonty KB 21 Oct '14

21 Oct '14

Hello, A new question has been asked in "Galera" by getreal: -------------------------------- Maybe I'm just missing it somewhere on the site, but I'm trying to find a way to contrast overall memory requirements for a Galera cluster compared to that of stand-alone mySQL instances. In my profession we build servers that are typically 32GB overall memory running an instance of mySQL within, in which we hand 16GB to innodb_buffer_pool_size (the actually size of the mySQL database files is upwards of four times that). The server does other things by the way (a 6 GB JVM is also loaded). Our buffer pool hit rate is typically a nice high number (over 99%) with that 16GB allocated. So let's take a simple scenario - 6 of my stand-alone servers are going to evolve to MariaDB + Galera cluster. I completely realize we need 3 nodes minimum on the Galera side, and I realize we now are accommodating about 6 x 64GB of former mySQL database files (as long as we presume the database files overall size in mariaDB is about the same as that of mySQL). So I've got 384 GB of database f iles, and let's suppose I want to replace this with a 3 node mariaDB+Galera cluster. I know that 384 GB has to be replicated amongst those three nodes, storage sizing is not so complex, and I know I can probably get enough CPU under these node with 4 vCPUs. But my question is more so around innodb_buffer_pool size for each node. Do I need to run 6 x 16 GB = 96 GB for innodb_buffer_pool_size in each node of that Galera cluster (essentially the same ratio 1:4 as I did in mySQL instances with my stand-alone servers) ? Any help appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cluster-overall-memory-requirements-compared-to-mu…

1 0

[Maria-discuss] New Question: field looks weird using select *
by AskMonty KB 19 Oct '14

19 Oct '14

Hello, A new question has been asked in "MariaDB Documentation" by martyheitzmann: -------------------------------- I just started using mariadb. I created two tables so far : the first one - no issues. But, when I try to select * from the 2nd table, the primary key field looks incomplete: +--------+--------+---------------+----------------+ | teamid | league | teamname1 | teamname2 | +--------+--------+---------------+----------------+ | | A | Anaheim | Angels |ARI | N | Arizona | Diamondbacks | | N | Atlanta | Braves | | A | Baltimore | Orioles | | A | Boston | Red Sox | | A | Chicago | White Sox | N | Chicago | Cubs ... (look past the copy/paste formatting issues please) The teamid column is not printed out for every teamid, and based on the '|' separator, it looks like the field has different lengths, but it's just a char(3) fixed-length. I tried defining the field as nvarchar(3), and char(3), with the same results. I thought it had to do with the file from which the data was imported, but it contains no control characters. It's a ':' separated field that looks like: ANA:A:Anaheim:Angels BAL:A:Baltimore:Orioles BOS:A:Boston:Red Sox CHA:A:Chicago:White Sox ... file imported using : LOAD DATA INFILE '<file>' INTO TABLE Tteams FIELDS TERMINATED BY ':'; thoughts? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/field-looks-weird-using-select/

1 0

[Maria-discuss] New Question: How to use SQL Workbench to connect to MariaDB?
by AskMonty KB 19 Oct '14

19 Oct '14

Hello, A new question has been asked in "Does MariaDB support..." by aaaaaa: -------------------------------- How to use SQL Workbench to connect to MariaDB? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-use-sql-workbench-to-connect-to-mariadb/

1 0

[Maria-discuss] New Question: Historical data, nightly snapshots
by AskMonty KB 17 Oct '14

17 Oct '14

Hello, A new question has been asked in "MariaDB Documentation" by bjquinn: -------------------------------- I have an application where I need to take nightly snapshots of a large InnoDB database (10s of GB) and then have them available to be queried alongside the current data. My underlying filesystem is (or at least can be) ZFS, so actually creating the snapshots is easy enough. But how do I connect to the files contained in the snapshot so that I can query the tables via MariaDB? If it's easier through another storage engine, I could consider that, though I do need row locking in the current data. The historical data would be read only (obviously) and wouldn't need to be changed. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/historical-data-nightly-snapshots/

1 0

[Maria-discuss] New MariaDB 10.1 and MariaDB Galera Cluster releases
by Daniel Bartholomew 17 Oct '14

17 Oct '14

The MariaDB project is pleased to announce the immediate availability of the following new releases: - MariaDB Galera Cluster 5.5.40-stable - MariaDB Galera Cluster 10.0.14-stable - MariaDB 10.1.1-alpha See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.40 - Release Notes: https://mariadb.com/kb/en/mgc-5540-release-notes - Changelog: https://mariadb.com/kb/en/mgc-5540-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.40 MariaDB Galera Cluster 10.0.14 - Release Notes: https://mariadb.com/kb/en/mgc-10014-release-notes - Changelog: https://mariadb.com/kb/en/mgc-10014-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.40 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ MariaDB 10.1.1 - Release Notes: https://mariadb.com/kb/en/mariadb-1011-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1011-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.1 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

Re: [Maria-discuss] .ibd files remaining after DROP TABLE
by Andrew Braithwaite 17 Oct '14

17 Oct '14

Hi, It only seems to happen when replicating DROP TABLE IF NOT EXISTS from a master, not when running it directly on that server. I can replicate this problem every time. Thanks, Andrew On 17 September 2014 15:49, Jan Lindström <jan.lindstrom(a)skysql.com> wrote: > Hi, > > Not at least normally both should be deleted, but maybe not immediately. > Can you provide a example ? > > R: Jan > > On Wed, Sep 17, 2014 at 4:36 PM, Andrew Braithwaite < > andrew.braithwaite(a)graze.com> wrote: > >> Hi, >> >> After dropping tables on my MariaDB 10.0.13 database server, the .frm >> files are removed but the .ibd files remain behind. >> >> Has anyone seen this before? >> >> Thanks.... Andrew >> >> mysqld Ver 10.0.13-MariaDB-1~trusty for debian-linux-gnu on x86_64 ( >> mariadb.org binary distribution) >> >> DISTRIB_ID=Ubuntu >> DISTRIB_RELEASE=14.04 >> DISTRIB_CODENAME=trusty >> DISTRIB_DESCRIPTION="Ubuntu 14.04.1 LTS" >> NAME="Ubuntu" >> VERSION="14.04.1 LTS, Trusty Tahr" >> ID=ubuntu >> ID_LIKE=debian >> PRETTY_NAME="Ubuntu 14.04.1 LTS" >> VERSION_ID="14.04" >> HOME_URL="http://www.ubuntu.com/" >> SUPPORT_URL="http://help.ubuntu.com/" >> BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/" >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > > -- > > Jan Lindström, Principal Engineer > SkySQL - The MariaDB Company > > skype: jan_p_lindstrom > > www.skysql.com > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2F&sa=D&sntz=1&usg=…> > > [image: Twitter] > <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fskysql&sa=D&sntz=1&u…> > [image: Blog] > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2Fblog%2F&sa=D&sntz…> > [image: Facebook] > <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&snt…> > [image: LinkedIn] > <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F12142…> > [image: Google+] <https://plus.google.com/117544963211695643458/posts> >

3 2