December 2014 - discuss - lists.mariadb.org

[Maria-discuss] MariaDB OpenSuSE repo does not resolve all conflicts if KDE programs are installed.
by Peter Laursen 17 Dec '14

17 Dec '14

I have written about this in another thread. But let us take it from scratch. The other thread is messy. The problem is KDE and certain KDE programs. Quite a lot of those have an option to store data in MySQL (embedded or not) and they install dependent libraries in order to do so. Do this to reproduce and understand the problem: 1) Install OpenSUSE with a GUI. I used xfce desktop, but it should be the same with any destop not based on KDE (with KDE and KDE-derivates, it could be more complicated) 2) During install also install the "LAMP Server". Probably just installing MariaDB 10.10.14 from SuSE's repos later will also do. 3) Now install Amarok (for instance). Inspect dependencies being installed - including two MySQL-related libraries. I used the GUI for install but probably zypper has a --verbose option listing dependencies. See dependencies.jpg. 4) Register MariaDB's repo for SuSE '. See repos.jpg 5) Open "Software management" and search for MariaDB . See packages.jpg 6) MariaDB's RPMs do not resolve dependencies on libraries installed with Amarok (see conflict.jpg). 7) But you can do manually - if using the GUI at least (as in conflicts_resolved.jpg). Now everything installs and works fine after install. If you don't do it right first time (later is too late!) you will encounter issues. For instance I was only able to use command line clients as root. This is reproducible exactly the same way with OpenSuSE 12.3 GA as well as the 'bleeding edge' "OpenSuSE factory". Should not those dependencies be resolved automatically? -- Peter -- Webyog

1 0

[Maria-discuss] New Question: 10.0.15 missing from this list
by AskMonty KB 17 Dec '14

17 Dec '14

Hello, A new question has been asked in "MariaDB Galera 10.0 Release Notes" by daniel-black. Please answer it at http://mariadb.com/kb/en/10015-missing-from-this-list/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Can't see 10.0.15 on this page despite it existing -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/10015-missing-from-this-list/

1 0

[Maria-discuss] Getting Started with MariaDB, free today
by Daniel Bartholomew 16 Dec '14

16 Dec '14

FYI, the electronic version of my book, Getting Started with MariaDB, is FREE today (16 Dec) as part of Packt's "Christmas Countdown" promotion. DRM free as well, in pdf, mobi, and epub formats. :-) https://www.packtpub.com/packt/offers/christmas-countdown Happy holidays everyone! -- Daniel Bartholomew, MariaDB Release Manager MariaDB | http://mariadb.com

1 0

[Maria-discuss] Doubt about 'atomic' insert
by Roberto Spadim 15 Dec '14

15 Dec '14

Hi guys i'm with a doubt about the "standard" (sql standand?) error reporting , about INSERT SELECT... should this insert select return duplicate key? INSERT INTO errorsX (id) SELECT MAX(id)+1 FROM errorsX; considering: ---- CREATE TABLE errorsX( id INT NOT NULL DEFAULT 0, PRIMARY KEY (id) ) ; ---- -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

4 14

[Maria-discuss] the future of --skip-innodb
by Federico Razzoli 14 Dec '14

14 Dec '14

Hi. In MySQL 5.7 documentation: https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html I read: "As of MySQL 5.7.5, the InnoDB storage engine can no longer be disabled, and the --innodb=OFF and --skip-innodb options are deprecated and have no effect. Their use results in a warning. These options will be removed in a future MySQL release." Will MariaDB remove --skip-innodb? If so, when? Regards Federico

3 2

[Maria-discuss] mariadb 10 build/link ignores specified linker path to specified lib (pcre). correct method?
by grantksupport＠operamail.com 13 Dec '14

13 Dec '14

building mariadb 10.0.15 on linux/64 i have a non-system instance of (lib)pcre, installed in /usr/local/test/pcre, that i need to build/link against reading Link MariaDB Client Library for C with specific external zlib and openssl https://mariadb.com/kb/en/mariadb/client-libraries/client-library-for-c/lin… i've built with cmake .. \ ... -DCMAKE_C_FLAGS="... -I/usr/local/test/pcre/includes" \ -DCMAKE_CXX_FLAGS="... -I/usr/local/test/pcre/includes" \ -DCMAKE_SHARED_LINKER_FLAGS="... -L/usr/local/test/pcre/lib64 -lpcre" \ ... and cmake .. \ ... -DCMAKE_C_FLAGS="... -I/usr/local/test/pcre/includes" \ -DCMAKE_CXX_FLAGS="... -I/usr/local/test/pcre/includes" \ -DCMAKE_SHARED_LINKER_FLAGS="... -L/usr/local/test/pcre/lib64 -Wl,-rpath,/usr/local/test/pcre/lib64 -lpcre " \ ... but id both cases, the resultant binary still links against system pcre libs ldd sql/mysqld | egrep -i "pcre" libpcre.so.1 => /usr/lib64/libpcre.so.1 (0x00007f6165a5e000) what's the correct method for linking against a specified, non-system path'd lib? specifically, here, libpcre?

3 8

[Maria-discuss] New Question: TokuDB
by AskMonty KB 13 Dec '14

13 Dec '14

Hello, A new question has been asked in "Development" by timosaarinen. Please answer it at http://mariadb.com/kb/en/tokudb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We noticed, that MariaDB includes TokuDB engine too nowadays. We have read, that it should be more high-performance than the default one. We are curious to know, what's the reason, it's not the default engine in MariaDB. Is it ready for production use? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/tokudb/

3 2

[Maria-discuss] New Question: MaxScale Customisation - Filter, Routing of Clients, "Sticky" Statements
by AskMonty KB 11 Dec '14

11 Dec '14

Hello, A new question has been asked in "MariaDB community" by moshpit. Please answer it at http://mariadb.com/kb/en/maxscale-customisation-filter-routing-of-clients-s… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hey guys, I am with a company that provides services and develops software for shipping companies. We usually deploy our web applications on our own infrastructure. I've been dealing with MariaDB and MaxScale for 2 weeks now and I'd say I do have a pretty good overview of whats going on. I already set up a demo environment with 1 master, 3 slaves, 1 client and 1 MaxScale proxy. Since we want to use MariaDB and MaxScale in production environments when it gets out of the Beta state, I am trying to test this technology for some requirements we have. This one might be rather tricky than trivial, though I wanted to discuss this here because I am having struggle setting it up the way I want. If you need more information on the requirements itself let me know so I can figure out if I can provide you with a more detailed description. Requirement: Our web applications excessively use temporary tables. This means, a lot of tables are generated on-the-fly and used within a session. They are deleted by cronjobs after a specified period of time (or after the current http session was closed/invalidated/timed out). The web applications then use these temporary tables to join them with persistent tables on the databases to generate reports. Usually, the table names of temporary tables are named somewhat similar to __tmp_<number>__ . The last part of those table names are equal to a part of the URL of the web application within the “session_id=” variable. For example: + URL: https://url.to.web.app./session_id=123 + temporary table name: __tmp_123 So, depending on the variable “session_id=” in the URL of the application the names of the temporary tables gets generated dynamically from within the application. To reduce network overhead, throughput decrease and other performance parameters, we do not want those tables to be replicated to the slaves. But we do not as well want to have all the read/write load for those temporary tables on one single master machine. So, this is when a multi-master setup comes on the plan. And with it the question on filters and how to manage and distribute the load on the available master servers. Suggestion: Supposing we have 4 master servers (master_00, master_01, master_02 and master_03). Supposing they are set up in a multi-master replication setup. Supposing we use MaxScale as the respective proxy for routing the requests. When a client sends one of those MySQL statements that create or read from a temporary table, we could use the RegEx filter to route the client to specific master machines (not slaves, since write statements are redirected to master servers in any case). Excluding the temporary tables from replication in the server configuration might be mandatory here. Questionnaire: Since the names of those temporary tables are unique throughout their lifecycle (meaning the name could be used again in another session after the table currently holding the name is being deleted), it might come in handy to do an operation such as: Table name: __tmp_<number>__ Operation: <number> MOD x (x being the number of master servers in the cluster) For example: <number> = 6091073567508922368; Number of master servers: 8  Resolves in 6091073567508922368 MOD 4 = 0, so the request gets routed to master_00 (assuming we start counting on 0 for the number of master servers) Regarding the (RegEx) filter, these questions come to mind: + Is it possible to do mathematic operations such as Modulo within the filter definition? + Is it possible to retrieve the number of current master servers being a member of the cluster from within the filter definition? + Is it possible to dynamically build the filter definitions with a script and inject them into a running MaxScale implementation or does MaxScale need to be restarted after changing the configuration? + What happens when one of the masters dies? + Is it possible to have join statements spread over multiple servers? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maxscale-customisation-filter-routing-of-clients-s…

1 0

[Maria-discuss] What happened to 10.1 downloads
by Peter Laursen 10 Dec '14

10 Dec '14

Not listed here: https://downloads.mariadb.org/ -- Peter -- Webyog

2 2

[Maria-discuss] MariaDB 10.0.15 now available
by Daniel Bartholomew 10 Dec '14

10 Dec '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.15 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.15 - Release Notes: https://mariadb.com/kb/en/mariadb-10015-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10015-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.15 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ 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

7 29