- discuss - lists.mariadb.org

[Maria-discuss] New Question: What data type should I use to store XML natively in the database?
by AskMonty KB 06 Aug '15

06 Aug '15

Hello, A new question has been asked in "Data Types" by ksoh15. Please answer it at http://mariadb.com/kb/en/what-data-type-should-i-use-to-store-xml-natively-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I could not find a XML data type. Which data type can I use to store XML natively? I need to be able to parse and run XQuery on XML content. https://mariadb.com/kb/en/mariadb/data-types/ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/what-data-type-should-i-use-to-store-xml-natively-…

1 0

[Maria-discuss] MariaDB 10.0.21 and 5.5.45 now available
by Daniel Bartholomew 06 Aug '15

06 Aug '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.21 and 5.5.45. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.21 - Release Notes: https://mariadb.com/kb/en/mariadb-10021-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10021-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.21 - About MariaDB 10.0: https://mariadb.com/kb/en/what-is-mariadb-100 MariaDB 5.5.45 - Release Notes: https://mariadb.com/kb/en/mariadb-5545-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5545-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.45 - About MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55 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/ 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

[Maria-discuss] Numa linux
by Roberto Spadim 05 Aug '15

05 Aug '15

Hi guys i'm comfiguring linux kernel, there's some valid numa comfig at kernel to check? It's a xeon server with 2 cpu and 10cores each -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

4 3

[Maria-discuss] New Question: How can I Move (migrate) a Replication Server (MariaDB) to a new Hardware and OS.
by AskMonty KB 04 Aug '15

04 Aug '15

Hello, A new question has been asked in "Standard Replication" by wschwauer. Please answer it at http://mariadb.com/kb/en/how-can-i-move-migrate-a-replication-server-mariad… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a server (Master) and 5 clients (slaves). The replication work’s fine. Now I must migrate the Server/Master Database to a new System. How can I move/migrate the old Master DB to the new Hardware? 1: Install MariaDB on new System. 2: Create all Table and so on on ew system. 3: Stop replikation on old Server 4: export all Tabledata from old Server and import to the new server 5: Start Replikation with the new Server IP ??? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-can-i-move-migrate-a-replication-server-mariad…

1 0

[Maria-discuss] MariaDB 10.1.6 beta now available
by Daniel Bartholomew 27 Jul '15

27 Jul '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.6. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.6 - Release Notes: https://mariadb.com/kb/en/mariadb-1016-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1016-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.6 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/ 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

[Maria-discuss] Travis-CI and MariaDB
by Daniel Black 24 Jul '15

24 Jul '15

For those that use or develop open source or commercial projects that use Travis CI MariaDB has been added as a plugin. This installs either 5.5, 10.0 or 10.1 from the latest MariaDB repo against for testing. Documentation isn't up yet however it is planned. ref: https://github.com/travis-ci/travis-build/pull/303 As an example of Syntax (https://github.com/grooverdan/PyMySQL/blob/c05bf7c6d0f3161d91b3e1418ac185b8…) to test against all MariaDB versions as well as the pre-installed MySQL. Quick snippet: matrix: include: - addons: mariadb: 5.5 - addons: mariadb: 10.0 - addons: mariadb: 10.1 So add it to your own project's .travis.yml or send a PR to your favourite github project that can use MariaDB and Travis-ci. As for MariaDB-server in Travis-CI? we'll see if the bug committing fairies decide https://github.com/MariaDB/server/pull/84 is useful. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

2 3

[Maria-discuss] stored procedures external languages
by Federico Razzoli 23 Jul '15

23 Jul '15

Hi all I remember these slides and this worklog about supporting external languages for stored procedures: * http://www.slideshare.net/AntonyTCurtis/external-stored-proceduresformysql2… * http://www.slideshare.net/AntonyTCurtis/a-tour-of-external-language-stored-… * https://dev.mysql.com/worklog/task/?id=820 As far as I can guess from the slides, there has been some active work on this idea, and some working code. I hoped so badly that I could see this in 5.x, and then in10.0, and then in 10.1. Is there any chance to see this feature in a future release, or should I just stop waiting? Please, consider all the benefits that would come from this: using a "real" language, using existing libraries, getting rid of almost all current stored procedures limitations... Regards Federico

4 5

[Maria-discuss] New Question: Installing on Windows 2008
by AskMonty KB 22 Jul '15

22 Jul '15

Hello, A new question has been asked in "MariaDB Community" by meysey. Please answer it at http://mariadb.com/kb/en/installing-on-windows-2008/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are currently MySQL users at the school and I want to migrate us to MariaDB. I tried installing mariadb-5.5.44-winx64.msi and although it installed fine there was no option to migrate the MySQL databases while I installed and there is no migration wizard in the stat menu too. Can anyone help me get up and running. TIA Charlie Markwick -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/installing-on-windows-2008/

1 0

[Maria-discuss] will maria db overcome mysqls feature limitations? (foreign keys+triggers, recursive triggers)
by Ludwig Gramberg 19 Jul '15

19 Jul '15

Hi, I was wondering if mariadb plans to overcome mysqls limitations such as - foreign key operations do not start triggers - triggers can’t be recursive (error 1442) I know that mariadb wants to be compatible with mysql but maybe these features could be optional? The mysql/mariadb comparison shows additional features which wont break compatibility I guess because they don’t exist in mysql (yet?). But besides additional features, is there a chance that mariadb could ever overcome limitations? Is this even a goal of this project? So far I only found postgres to support these features. Background of this question: I am developing an object relational mapper and my goal is to have the database enforce the consistency. So triggers and foreign key constraints working together are vital for this. regards Ludwig

4 5

[Maria-discuss] INSERT IGNORE and triggers
by Federico Razzoli 19 Jul '15

19 Jul '15

Hello. As we all know, IGNORE "catches" some errors and turns them into warnings. But I've noticed that it does not catch the same errors if they were issued by a trigger (using SIGNAL). * Is this by design? * Is this standard SQL behaior? Here is a trigger example to show what I mean: CREATE TRIGGER bi_t BEFORE INSERT ON t FOR EACH ROW BEGIN SIGNAL SQLSTATE '23000' SET MYSQL_ERRNO = 1048; END Regards Federico

2 1