August 2016 - discuss - lists.mariadb.org

[Maria-discuss] New Question: ST_AsGeoJSON
by AskMonty KB 12 Aug '16

12 Aug '16

Hello, A new question has been asked in "Geographic Functions" by dbauszus. Please answer it at http://mariadb.com/kb/en/st_asgeojson/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Are there plans to implement ST_AsGeoJSON in MariaDB? This is by far the most widely use format to present data in web mapping applications. It will be a large overhead if we need to format records in the client prior to rendering the data on a web map. Best, Dennis -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/st_asgeojson/

1 0

[Maria-discuss] New Question: Percona XtraBackup Trigger Restore
by AskMonty KB 11 Aug '16

11 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/percona-xtrabackup-trigger-restore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i restore the triggers using percona xtrabackup?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/percona-xtrabackup-trigger-restore/

1 0

[Maria-discuss] New Question: where can i download connector c which build with glibc2.11
by AskMonty KB 11 Aug '16

11 Aug '16

Hello, A new question has been asked in "MariaDB Connector/C" by shuianle. Please answer it at http://mariadb.com/kb/en/where-can-i-download-connector-c-which-build-with-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- i download mariadb-connector-c-2.3.0-linux-x86_64.tar.gz, it need glibc2.14, but my os is suse11 sp1 with glibc2.11, so it not work. Our customer user mysql now， and we have program use mysql connector c。 In the further，our customer will use mariadb。 The os is suse11 sp1，glib version is 2.11。So the download of mariadb connector can't work. Where can I download ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/where-can-i-download-connector-c-which-build-with-…

1 0

[Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?
by jocelyn fournier 10 Aug '16

10 Aug '16

Hi, After upgrading from TokuDB Enterprise with MariaDB 5.5 to MariaDB 10.1.14, I tried to enable the parallel replication (parallel_mode=optimistic, slave_parallel_threads=4) on a GTID enabled RFR slave, but it leads to random failures. (both master & slave are running 10.1.14) E.g : Could not execute Update_rows_v1 event on table sc_2.sc_param_index; Can't find record in 'sc_param_index', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.008418, end_log_pos 217608066 If I issue a start slave (with sql_slave_skip_counter=0) : Could not execute Update_rows_v1 event on table sc_2.sc_log_cron; Can't find record in 'sc_log_cron', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.008418, end_log_pos 218275984 If I put back slave_parallel_threads to 0, the slave keeps replicating happily without any issue. Is this a known limitation with TokuDB ? Tokudb configuration : tokudb_rpl_lookup_rows=0 tokudb_rpl_unique_checks=0 tokudb_pk_insert_mode=2 tokudb_directio = 1 Thanks and regards, Jocelyn Fournier

3 18

[Maria-discuss] MariaDB 5.5.51, Connector/J 1.5.0, & Connector/C 2.3.1 now available
by Daniel Bartholomew 10 Aug '16

10 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.51 Stable (GA), MariaDB Connector/J 1.5.0 Release Candidate (RC), and MariaDB Connector/C 2.3.1 Stable (GA). See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.51 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mdb-5551-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5551-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.51 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 Connector/J 1.5.0 RC - Release Notes: https://mariadb.com/kb/en/mcj-150-rn/ - Changelog: https://mariadb.com/kb/en/mcj-150-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.0/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/C 2.3.1 - Release Notes: https://mariadb.com/kb/en/mcc-231-rn/ - Changelog: https://mariadb.com/kb/en/mcc-231-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.3.1/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-c/ - - 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/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] New Question: Percona XtraBackup restore
by AskMonty KB 09 Aug '16

09 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/percona-xtrabackup-restore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i restore a single database from a full backup or from a single database backup?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/percona-xtrabackup-restore/

1 0

[Maria-discuss] Help on ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
by Karthick Subramanian 07 Aug '16

07 Aug '16

Dear Experts, I almost tried all sort of combinations that I think of very difficult to crack, but repeatedly failed to satisfy MariaDB not throw this error. Can anyone guide me on what is the specific needs for successful password. Warning message: +---------+------+----------------------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------------------+ | Warning | 1819 | cracklib: error loading dictionary | | Error | 1819 | Your password does not satisfy the current policy requirements | +---------+------+----------------------------------------------------------------+ Regards, Karth

2 2

[Maria-discuss] Discrepancy with innodb table statistics
by Mark Wadham 05 Aug '16

05 Aug '16

Can anyone explain this? http://pastebin.com/Zctaj8BE TL;DR index sizes seem to differ drastically in size depending on how you request them. Thanks, Mark

1 1

[Maria-discuss] New Question: 2 node replication failover/recovery
by AskMonty KB 03 Aug '16

03 Aug '16

Hello, A new question has been asked in "MariaDB Community" by greg_brownell_g. Please answer it at http://mariadb.com/kb/en/2-node-replication-failoverrecovery/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to automate the following: 1. 2 node system set up as master-master replication 2. node 1, master 1 fails. 3. node 2 master 2 is now the active instance. Up to here, all works well. Replication is fast enough. We detect failure and code now uses master 2 on node 2. The problem is sync'ing master 1 when the node 1 restarts, perhaps 5 minutes later. Requirement is: 1. node 2 master 2 continues to run without interruption 2. node 1 master 1 must sync as quickly as possible with node 2 master 2 3. this must be done without human intervention (using scripts, programs, whatever) Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/2-node-replication-failoverrecovery/

1 0

[Maria-discuss] New Question: MariaDB Backup using Percona XtraBackup
by AskMonty KB 03 Aug '16

03 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-faq-mariadb-backup-using-percona-xtrabacku… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Percona suggests to use the xtrabackup script for taking backup but it does not have anything to take compressed backup.The compact backup reduces the size of 48gb database to 47gb which is of no use. How to acheive compressed backup using percona xtrabackup utility?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-backup-using-percona-xtrabacku…

1 0