October 2013 - discuss - lists.mariadb.org

[Maria-discuss] New Question: Using Connect with MySQL 5.5
by AskMonty KB 23 Oct '13

23 Oct '13

Hello, A new question has been asked in "Connect" by shlomisut: -------------------------------- Hi We're currently testing usage of MySQL Federated engine, used for read-only cached tables. The Connect engine looks like a very interesting option as it will allow us to use the index/condition push down, thus reducing the amount of network & total query time. Do you have any experience with using Connect as a MySQL engine? migrating to MariaDB is not possible at current time frames, though it is on our roadmap Thanks! Shlomi -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/using-connect-with-mysql-55/

1 0

[Maria-discuss] Binlog replication protocol in MySql 5.0.95, 5.1 and 5.5
by Vesa-Matti J Kari 21 Oct '13

21 Oct '13

Hello, We have a MySQL Version 5.0.95 setup that consists of 1 master server and 3 replication slave servers. Now we want to upgrade these servers to MySQL 5.5 via intermediate step MySQL 5.1. Can we upgrade one MySQL server at a time or do we have to take all servers down and upgrade all at once? In other words, is the binlog replication protocol compatible between all MySQL 5.0.95, 5.1 ja 5.5? Many thanks for the information. Regards, vmk -- ************************************************************************ Tietotekniikkakeskus / Helsingin yliopisto IT department / University of Helsinki ************************************************************************

1 0

[Maria-discuss] New Question: new stable release for MariaDB Client Library for "C"
by AskMonty KB 18 Oct '13

18 Oct '13

Hello, A new question has been asked in "MariaDB Client Library for C" by gghervase: -------------------------------- Hello, Can you please tell me if a new stable release for the mariadb native client will be done anytime soon? There are several bug fixes on trunk and I wonder when will they be released. For example, I can't ssl authenticate to the maridb 5.5.33 with the currently released client (Bad Handshake - response error 1043 from the server), but it works with your lastest code from trunk. Thank you very much. Best regards, Gabriel Ghervase -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/new-stable-release-for-mariadb-client-library-for-…

1 0

[Maria-discuss] New Question: Galera Cluster starting backup can't find innobackupex in the path
by AskMonty KB 16 Oct '13

16 Oct '13

Hello, A new question has been asked in "Galera" by tubaguy50035: -------------------------------- I am trying to get a Galera cluster running. I have the first node up and ready for connections. My second node, however, when trying to run wsrep_sst_xtrabackup gets the error "Can't find innobackupex in the path". As soon as I start the mysql service on the second node, I briefly see it as an incoming address on the first node, but then it goes away. Not sure what would be necessary to help me with this, so here's my whole wsrep specific section of my my.cnf: <<code>> binlog_format=ROW default_storage_engine=innodb innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 innodb_doublewrite=1 wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_provider_options="gcache.size=256M; gcache.page_size=128M" wsrep_cluster_address=gcomm://firstnode wsrep_cluster_name="Cluster" wsrep_node_address="thisnode" wsrep_node_name="thisnode" wsrep_sst_method=xtrabackup wsrep_sst_auth="root:password" wsrep_node_incoming_address=this node's IP wsrep_sst_receive_address=this node's IP wsrep_slave_threads=16 <</code>> -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-cluster-starting-backup-cant-find-innobacku…

1 0

[Maria-discuss] ECDHE ciphers PHP->MariaDB
by Reindl Harald 15 Oct '13

15 Oct '13

Hi is it PHP'sd mysqli/mysqlnd or MySQL/MariaDB which is resposible that no ECDHE-ciphers are used? below ends in TLSv1 with DHE-RSA-AES128-SHA * MariaDB as well as PHP/Apache compiled with a ECDHE supporting OpenSSL, proven by https://www.ssllabs.com/ssltest/ as well as Postfix/Dovecot logs compiled against the same openssl-build * Fedora 19 with https://bugzilla.redhat.com/show_bug.cgi?id=319901#c108 home-made build $this->conn->ssl_set($this->ssl_key, $this->ssl_crt, $this->ssl_ca, NULL, 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:AES128-SHA');

1 0

[Maria-discuss] Issues using the connect engine with ODBC on Linux
by eric hernandez 15 Oct '13

15 Oct '13

Hi, I am trying to use the "Connect" engine to read data from Microsoft SQL Server 2008 R2 from a linux based MariaDB instance. I am getting the following error. create table tablea ( -> id bigint(20) NOT NULL, ) -> engine=connect table_type=ODBC -> block_size=10 -> tabname='tablea' -> Connection='DSN=MSSQLTestServer' ERROR 1105 (HY000): Unsupported table type ODBC I have the underlying linux box talking fine to the "MSSQLTestServer" via odbc through the iSQL command. You can see here where i connect via isql from the command line with no issue isql -v MSSQLTestServer sa $sanitized +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ So odbc is installed and working properly on the linux box. Do you have any advice on how to get past this error? Thanks, -Eric

3 2

[Maria-discuss] New Question: I want to install mariadb5.5.33(with tokudb plugin) without 'apt-get install'
by AskMonty KB 12 Oct '13

12 Oct '13

Hello, A new question has been asked in "MariaDB FAQ" by frances714: -------------------------------- I want to install mariadb5.5.33(with tokudb plugin) without 'apt-get install' on debain 6 squeeze(i686), but there is only mariadb5.5.30(with tokudb plugin) for x86_64 on tokudb.org. So is there any method to install the mariadb(with tokudb plugin) on my computer? Thank you so much! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-want-to-install-mariadb5533with-tokudb-plugin-wi…

1 0

[Maria-discuss] DELETE Operations in MariaDB 5.5.30 do not reduce size of table files
by Steve Afrin 09 Oct '13

09 Oct '13

To anyone who knows how the MyISAM engine works (or maybe this is independent of the DB engine), here’s my scenario: * I have a table with 180,000 rows * I delete 170,000 rows with a DELETE and subsequent COMMIT statement * The MYI table file is still the same size it was before the 170k rows were deleted I saw there’s an administrative PURGE command, but it looks like that is just for purging data from binary logs, if you’ve even turned on the option for keeping binary logs. In MariaDB 5.5.30 or later, how do I run a purge operation to compress the deleted rows of data out of my physical table files and cause the reindexing to happen for the data that is still in my tables? Thanks, Steve

2 1

[Maria-discuss] New Question: regarding seconds behind master variable in 10.0.4
by AskMonty KB 09 Oct '13

09 Oct '13

Hello, A new question has been asked in "MariaDB Documentation" by jaihind213: -------------------------------- hi we setup maria 10.0.4 for multisource replication. it was replicating from a percona 5.5 master. When we started replication, maria was a day behind its master. its working fine but we noticed this phenomenon: when we execute 'show all slaves status' consecutively the 'seconds_behind_master' flips from 0 to XXX and XXX to 0. XXX keeps decreasing though, which is good as its getting closer to the state of its master. But wanted to know why the 'seconds_behind_master' comes down to 0 then again sets to a positive number. Note: XXX is some positive number. Thanking you. vishnu rao -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/regarding-seconds-behind-master-variable-in-1004/

1 0

[Maria-discuss] Left Join Bug?
by Jamie Jackson 07 Oct '13

07 Oct '13

Hi Folks, I'm seeing a difference in a query result between MariaDB 5.5.32 and MySQL 5.1.69. I've distilled things down as far as I can get them, while still being able to reproduce the issue. Anything else I do to get the sample to make it smaller or more focused seems to make the issue disappear. The data: https://www.dropbox.com/s/m02sqjl2y2cq4ky/sampledump1.zip The query, and the results (and explains) in both MySQL and MariaDB: https://gist.github.com/jamiejackson/6829118 What's going on here? Is there an oustanding bug for this? Should I file a bug? Thanks, Jamie

2 2