- discuss - lists.mariadb.org

[Maria-discuss] MariaDB and TLB misses / Large Pages
by J. Cassidy 21 Oct '16

21 Oct '16

Hello all, is there a reliable cookbook / checklist to implement Large Tables on a SuSE SLES 12 SP1 Linux distribution? I find there there is a lot of old/inaccurate/dodgy information on my search machine travels. The test setup is as follows- Everything enabled for Large Pages as per various online Fora. 128GB RAM 72GB InnoDB buffer size, eight instances. MariaDB is DB is defined in a 52GB RAM disk. (This is a test to tie down TLB and Lx cache misses and high CPU next activity) Any pointers/hints most welcome. Regards, JC John Cassidy Obere Bühlstrasse 21 8700 Küsnacht (ZH) Switzerland / Suisse / Schweiz Mobile: +49 152 58961601 (Germany) Mobile: +352 621 577 149 (Luxembourg) Mobile: +41 78 769 17 97 (CH) Landline: +41 44 509 1957 Mobile email: mobile(a)jdcassidy.eu http://www.jdcassidy.eu "Aut viam inveniam aut faciam" - Hannibal.

3 2

[Maria-discuss] MariaDB Knowledge base - 500 error
by Karthick Subramanian 21 Oct '16

21 Oct '16

Did anyone facing this 500 error while accessing the Maria DB Knowledge Base. Thank you. Don't know to whom we need to report this, so sending to this mail ID. Sorry if it cause any inconvenient for others. When we click the Support in MariaDb website, getting below error: Database Error: *There seems to be a problem connecting to the database server specified in your configuration file. Please contact your local system administrator for further assistance. *

4 3

[Maria-discuss] wsrep problem with dns names
by l vic 20 Oct '16

20 Oct '16

I am trying to use dns hostnames vs. ip addresses in mariadb container configuration: --wsrep-cluster-address=gcomm://node1.cluster1.mesos,node2.cluster1.mesos.. --wsrep_node_address=node1.cluster1.mesos --wsrep-new-cluster .. but i see galera error: WSREP: Failed to resolve tcp://node1.cluster1.mesos The address "node1.cluster1.mesos" i can ping 64 bytes from node-x (10.10.30.1): icmp_seq=1 ttl=64 time=0.023 ms Would it be possible to configure Galera to use dns names? Thanks, -V

3 3

[Maria-discuss] eviction in information_schema?
by l vic 19 Oct '16

19 Oct '16

How can i detect eviction of node from the cluster from "information_schema" other than decreasing of WSREP_CLUSTER_SIZE? Thanks,

3 3

Re: [Maria-discuss] MariaDB Server 10.3 notes
by Federico Razzoli 17 Oct '16

17 Oct '16

You made a question and also provided the answer. If you really need to run a storage engine optimized for a specific use case on an operating system that is not good for MySQL, use Docker :) Federico -------------------------------------------- Lun 17/10/16, Richard Bensley <richardbensley(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes A: "Rich Prohaska" <prohaska7(a)gmail.com> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Lunedì 17 ottobre 2016, 17:10 With hyper-v becoming free, the arrival of the Linux subsystem, and docker for windows 10; there isn't much of an excuse to proclaim you are unable to use the Linux binaries. The Redis and Postgres devs are already rejoicing. -----Segue allegato----- _______________________________________________ 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

1 0

[Maria-discuss] MariaDB 5.5.53 and Connector/J 1.5.4 now available
by Daniel Bartholomew 17 Oct '16

17 Oct '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.53 and MariaDB Connector/J 1.5.4. Both are Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.53 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mdb-5553-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5553-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.53 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.4 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mcj-154-rn/ - Changelog: https://mariadb.com/kb/en/mcj-154-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.4/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - 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] MariaDB Server 10.3 notes
by Colin Charles 17 Oct '16

17 Oct '16

Hi, Sorry this is a little later than expected (who couldn’t resist walking around Amsterdam on that late beautiful Saturday afternoon?)! This session was led by Rasmus whom while employed by MariaDB Corporation, was also the MariaDB Foundation Board member leading it. This was the last session on the formal schedule before lunch (more was added to it as well later on) I notice he’s also blogged [part 1](https://mariadb.org/thoughts-mariadb-server-10-3-mariadb-developers-meet…, and maybe these notes help for part 2 (or maybe they don’t). Scroll down for what is still coming in MariaDB Server 10.2 of course (post-GA even)! # MariaDB Server 10.3 * MDEV-10177 * MDEV-371 * MDEV-7773 - create aggregate functions in SQL * User defined types (pluggable data type API) * CJK language support - MDEV-10267, MDEV-10268 * SPIDER storage engine - MDEV-7698 * Further MyRocks development (10.2 will have it as experimental; MariaDB Corporation is looking to hire a dedicated engineer to work on MyRocks) * InnoDB: InnoDB native partitioning - so MySQL 8 InnoDB? But Monty says there's next to no changes in InnoDB 8... Instant add column. New InnoDB deadlock detection (8.0). New INFORMATION_SCHEMA table (8.0). Dedicated tablespace for temporary tables (in 5.7 and merged, check). Lock wait policy (contribution) * Pluggable parser - MDEV-10142, PL/SQL parser, Oracle syntax support, INTERSECT, EXCLUDE * Sequences (like PostgreSQL implementation) * more for window functions (user defined window functions, MDEV-10855) * more for CTEs (CTE sharing isn't in now, and MySQL 8 has it, so needs to be done; Writable CTEs) * replace yaSSL with GnuTLS (SChannel in Windows) * "always encrypt" on the client side - Booking says there is no particular interest in this at the moment. * socket authentication * X Protocol/Document store - only if people have time or money will it be done * Peter asks if there is any plans to support other languages like V8? Supporting legacy database like Oracle PL/SQL is nice, but what about JavaScript and stuff? Eric mentions his old work on Perl and Java external language stored procedures. Peter says, if JSON and JavaScript are your lingua franca, PL/SQL isn't so interesting - but there was no interest in this amongst the folk. * No slave left behind patch - MDEV-8112 (Booking wants a bit more than the current patch, some extensions) - maybe in 10.2 * Compressed binary log (from Tencent) * For ALTER TABLE show the corresponding CREATE TABLE statement as a comment in the binary log. This is an annotation. * Counters for unsafe statements in replication (maybe in 10.2) * Extended table map in RBR is missing * Galera 4, encryption of gcache * Fix the XA transaction bug ( MySQL has fixed it already ) - MDEV-7974 * Indexes on expressions (this is part of virtual columns, will it not go into 10.2? Check with Serg) * Flashback DDL MDEV-10571 (flashback DML will come in 10.2). It only works with row based replication. Talk about what to name it. There's already a MySQL time machine on github. Many like the name Rewind (but not Monty). Let's do a poll on the mailing list * Additional GIS functions to stay compatible. Also it would be good to have a standalone GIS library (Georg suggests; wlad isn't too happy with the suggestion). Georg suggests that calculations should use the reference systems (Unflatten the world - MariaDB Server GIS the world looks flat) * Optimizer trace - MDEV-6111 * Query rewriting - MDEV-5561 * Replace libmysqlclient with Connector/C - MDEV-9055 - embedded/replication/ storage engine (connect, spider, federatedX) - work continues from 10.2 * Invisible indexes from MySQL 8 - this is something Eric wants to see * With MyRocks coming, should we drop TokuDB (and maybe even deprecate in 10.2?) - bugs that MariaDB Corporation reports to Percona don't seem to get fixed. Peter says that bugs are fixed for customers... and there is ongoing development to make it better * ORDER BY LIMIT optimizer bugs (MDEV-8306) # Still in MariaDB Server 10.2 * Flashback DML - MDEV-10570 * Time delayed replication - MDEV-7145 * MyRocks (10.2.4 - maturity experimental) * GeoJSON (in 10.2 after beta) and ST_Geohash * sha256_password plugin (after GA) - MDEV-9804 - Serg will do it in a MySQL compatible way * sys schema (after GA) * Server system default values MDEV-7635 * MySQL deprecated `DES_ENCRYPT`, `DES_DECRYPT` - Monty says he knows a high level customer using it, a bank. * Column compression from Tencent? -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

19 54

[Maria-discuss] New MariaDB 10.1.18 Galera setup question
by Alex Evonosky 17 Oct '16

17 Oct '16

Hello team- Quick question- I recently just installed mariaDB 10.1.18 (via apt-get) and all went well, no issues.. Here is my galera.cnf file: cat galera.cnf [mysqld] binlog_format = ROW default_storage_engine = InnoDB innodb_autoinc_lock_mode = 2 innodb_locks_unsafe_for_binlog = 1 wsrep_on = ON wsrep_causal_reads = ON wsrep_cluster_address = gcomm://10.10.10.104,10.10.13.2 wsrep_cluster_name = soho_cluster wsrep_node_address = 10.10.10.104 wsrep_provider = /usr/lib/galera/libgalera_smm.so wsrep_provider_options = "gcache.size=512M" wsrep_slave_threads = 4 # Should be equal to the number of cpu-cores. wsrep_sst_auth = "sstuser:r3pl1c@t3" #wsrep_sst_method = xtrabackup-v2 wsrep_sst_method = rsync I started the server as: galera_new_cluster and see no errors. Syslog reports mariaDB has started. However, I never see any messages with WSREP. the database stat shows: mysql -u root -p -e "show status like 'wsrep%'" Enter password: +--------------------------+----------------------+ | Variable_name | Value | +--------------------------+----------------------+ | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 0 | | wsrep_cluster_state_uuid | | | wsrep_cluster_status | Disconnected | | wsrep_connected | OFF | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 4294967295 | | wsrep_provider_name | | | wsrep_provider_vendor | | | wsrep_provider_version | | | wsrep_ready | OFF | | wsrep_thread_count | 0 | +--------------------------+----------------------+ The wsrep always shows OFF. I have removed and purged any and all mysql, mysql-server etc three times and get the same result. Is there something I am missing? Thank you!

2 2

[Maria-discuss] Best way to scale writes
by Jon Foster 17 Oct '16

17 Oct '16

I have a DB scenario that is very write intensive. Essentially its a large scale hit counter of sorts. Currently we're running on a single 12core server with 6 SSDs in a RAID6 array. But we're looking for a way to scale out write volume by adding more servers, hopefully as conveniently as I might add Apache servers to a website. We see two servers laboring so we add a third to the mix and so on. I'm still looking at the various technologies available to me and was wondering if someone out there had some suggestions on this front. Although Galera Cluster says it scales for write loads too it also says that all servers write the same data and make sure its committed by the time the transaction is completed. So it seems like write performance would never scale because all servers are doing the same write. Maybe I'm missing something. Anyhow some pointers would be appreciated. TIA - Jon -- Sent from my Debian Linux workstation -- http://www.debian.org/intro/about Jon Foster JF Possibilities, Inc. jon(a)jfpossibilities.com 541-410-2760 Making computers work for you!

4 6

[Maria-discuss] Virtual CHECK constraint using Virtual columns
by Peter Laursen 16 Oct '16

16 Oct '16

As described in this Blog http://mablomy.blogspot.dk/2016/04/check-constraint-for-mysql-not-null-on.h…. A very nice hack/trick IMO. However it is not working with MariaDB as VC's cannot be declared NOT NULL. What prevents that? -- Peter -- Webyog

3 7

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns
by Federico Razzoli 16 Oct '16

16 Oct '16

As Sergei said, MariaDB 10.2 has CHECKs. In old versions, honestly I don't like your solution. Take a look at what locks will be set: https://www.percona.com/blog/2006/12/12/innodb-locking-and-foreign-keys/ You can use trigger instead. When you only want to execute a check like this, triggers are not slow. Just SIGNAL an error is the value of i_must_be_between_7_and_12 is not valid. Federico -------------------------------------------- Dom 16/10/16, Pantelis Theodosiou <ypercube(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Domenica 16 ottobre 2016, 16:45 Would this be good to be added in the documentation of VIRTUAL columns? Or as a separate page, as a way to enforce/emulate arbitrary CHECK constraints? It can be slightly simplified (IF is not needed) and the BOOLEAN could be BIT (not sure if that adds any complication): CREATE TABLE truth (t BIT PRIMARY KEY) ; INSERT INTO truth (t) VALUES (TRUE) ; -- and remove all write permissions to the table CREATE TABLE checker ( i float, i_must_be_between_7_and_12 BIT AS (i BETWEEN 7 AND 12) -- whatever CHECK constraint we want here PERSISTENT, CONSTRAINT check_i_must_be_between_7_and_ 12 FOREIGN KEY (i_must_be_between_7_and_12) REFERENCES truth (t) ); On Wed, Apr 6, 2016 at 6:46 PM, Pantelis Theodosiou <ypercube(a)gmail.com> wrote: On Mon, Apr 4, 2016 at 2:10 PM, Peter Laursen <peter_laursen(a)webyog.com> wrote: As described in this Blog http://mablomy.blogspot. dk/2016/04/check-constraint- for-mysql-not-null-on.html. A very nice hack/trick IMO. However it is not working with MariaDB as VC's cannot be declared NOT NULL. What prevents that? (Peter, sorry fro the previous private reply, not sure how I got the reply buttons wrong.) I can't answer that, but there's another workaround for (some) CHECK constraints, described here: http://dba.stackexchange.com/ questions/9662/check- constraint-does-not-work/ 22019#22019 Unfortunately, it works only for smallish (int or date) ranges. We can't use for floats or decimals (as it would require a very big reference table). But it could be combined with the hack you link, using something like: CREATE TABLE truth (t BOOLEAN PRIMARY KEY) ; INSERT INTO truth (t) VALUES (TRUE) ; -- and remove all write permissions to the table CREATE TABLE checker ( i int, i_must_be_between_7_and_12 BOOLEAN AS (IF(i BETWEEN 7 AND 12, TRUE, FALSE)) PERSISTENT, CONSTRAINT check_i_must_be_between_7_and_ 12 FOREIGN KEY (i_must_be_between_7_and_12) REFERENCES truth (t) ); Haven't tested it but should work for more complex constraints as well. Pantelis -----Segue allegato----- _______________________________________________ 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

1 0

Re: [Maria-discuss] MariaDB Server 10.3 notes
by Federico Razzoli 16 Oct '16

16 Oct '16

But those people can't use Galera, pt, Xtrabackup... If we care about Windows, that software should be ported first, because it's general purpose. Federico -------------------------------------------- Dom 16/10/16, Tim Callaghan <tmcallaghan(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes A: "Reindl Harald" <h.reindl(a)thelounge.net> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Domenica 16 ottobre 2016, 14:45 I was just adding context. I agree that Windows is very uninteresting in a production context, but not having a version of TokuDB for Windows certainly excluded people (academic and professional) from trying it out on their laptops. On Sat, Oct 15, 2016 at 1:10 PM, Reindl Harald <h.reindl(a)thelounge.net> wrote: Am 15.10.2016 um 17:22 schrieb Tim Callaghan: Every time the topic of getting TokuDB to run on Windows the developers could not have run out of the room any faster. :) frankly what is the purpose of running MySQL/MariaDB on Windows? who does that in production? for development? seriously? develop a application on Windows which finally runs on a different OS? not in 2016 when anybody sane in his mind would setup a virtual machine so that his testing servers are really reflecting the later production environment (for the poor guys which are running Windows on their bare metal development machine) ______________________________ _________________ Mailing list: https://launchpad.net/~maria-d iscuss Post to : maria-discuss(a)lists.launchpad. net Unsubscribe : https://launchpad.net/~maria-d iscuss More help : https://help.launchpad.net/Lis tHelp -----Segue allegato----- _______________________________________________ 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

1 0

Re: [Maria-discuss] MariaDB Server 10.3 notes
by Federico Razzoli 15 Oct '16

15 Oct '16

A lot of things don't run on Windows: Galera, Percona Toolkit, Xtrabackup... Is this really a problem for MySQL users? Federico -------------------------------------------- Sab 15/10/16, Reindl Harald <h.reindl(a)thelounge.net> ha scritto: Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes A: maria-discuss(a)lists.launchpad.net Data: Sabato 15 ottobre 2016, 19:10 Am 15.10.2016 um 17:22 schrieb Tim Callaghan: > Every time the topic of getting TokuDB to run on Windows the developers > could not have run out of the room any faster. :) frankly what is the purpose of running MySQL/MariaDB on Windows? who does that in production? for development? seriously? develop a application on Windows which finally runs on a different OS? not in 2016 when anybody sane in his mind would setup a virtual machine so that his testing servers are really reflecting the later production environment (for the poor guys which are running Windows on their bare metal development machine) _______________________________________________ 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

2 1

[Maria-discuss] Reg replication and commit
by Karthick Subramanian 14 Oct '16

14 Oct '16

Hi All, I have the below topology: Master -> Slave (using GTID replication) Master -> Maxscale (Binlog Router) Maxscale -> DR Site (via binlog router) my.cnf is same across all sites: lower-case-table-names=1 autocommit=0 #replication variables log-bin=binlog binlog-format=ROW replicate_annotate_row_events=OFF binlog_annotate_row_events=OFF I have created a table and I could see on slave DB as well as at DR Site DB. When I INSERT records, this is not shown up in Slave DB as well DR Site DB. I have checked replication status and both are sync with master server binlog pos. But the rows reflected in slave and DR site DB only when we COMMIT on both Slave as well DR site DB. Below when I try at Slave DB: MariaDB [dr_repl]> select * from test_dr_repl; Empty set (0.00 sec) MariaDB [dr_repl]> commit; Query OK, 0 rows affected (0.00 sec) MariaDB [dr_repl]> select * from test_dr_repl; +----+------+ | id | val | +----+------+ | 1 | 1 | | 2 | 2 | | 3 | 3 | +----+------+ 3 rows in set (0.00 sec) I am wondering whether I did any weird mistake. Could anyone please help me to understand and a solution for this. Regards, Karthick

3 3

Re: [Maria-discuss] MariaDB Server 10.3 notes
by Federico Razzoli 14 Oct '16

14 Oct '16

Hi all, So basically everyone would love, love, love to have external languages for stored procedures, but no one is working on it... so bad. Please consider something: 1- Some features could be implemented as stored procedures, it's much easier. This has been done in the past (Flexviews, Securich...) but SQL is too limited. 2- I am sure that a lot of people would implement procedures libraries if they could use something like JavaScript or PHP. If we could use Python, stuff like NumPy and SciPy could be used. 3- SQL limitations could be lifted (namespaces for global objects, arrays, argv, cursors based on a prepared statement...) but will you ever do it? Probably not. But if we have external languages, who cares about procedural SQL limitations. I believe that next releases features are selected based on their cost (not only that of course). But please consider points 2 and 3, and try to estimate the cost of features that the community can develop for you, plus the cost of features that won't be really needed anymore if external languages are available (arrays in SQL). Cheers Federico -------------------------------------------- Mer 12/10/16, Sergei Golubchik <serg(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes A: "Justin Swanhart" <greenlion(a)gmail.com> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 12 ottobre 2016, 14:15 Hi, Justin! Very good questions, thanks! Some answers below: On Oct 12, Justin Swanhart wrote: > > > * InnoDB: InnoDB native partitioning - so MySQL 8 InnoDB? But Monty > > says there's next to no changes in InnoDB 8... Instant add column. > > New InnoDB deadlock detection (8.0). New INFORMATION_SCHEMA table > > (8.0). Dedicated tablespace for temporary tables (in 5.7 and merged, > > check). Lock wait policy (contribution) > > Monty is *notorious* for low balling estimates. His famous phrase is "it > is trivial". Everybody knows that if Monty says it is trivial, you can add > 10x the work to get it done, or more. Yes, I tend to agree with that. But Monty estimates are not that far off when applied to *Monty*. They're often too low when applied to others. https://www.google.de/search?q=10x+developer > includes transportable tablespaces for partitioned tables, and will likely > support native partitioning by the time 8 rolls. Native partitioning also > entails implementing the changes to the SE. See: > http://mysqlserverteam.com/innodb-native-partitioning-early-access/ InnoDB native partitioning is in 5.7.6: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html Is it better than upper-layer partitioning? Why? > > * more for window functions (user defined window functions, MDEV-10855) > What other databases have user definable window functions? Will the syntax > be similar? I can't really think of a reason to need custom window > functions personally, as the existing set is very comprehensive. What kind > of custom window function do you think people would need to write? In most > implementations any aggregate functions can be used in a window frame > context, thus any aggregate SQL functions should satisfy requirements for > user defined window funcs. Yes, that was a confusing description. What it really means - we will have aggregate SQL functions (MDEV-7773) and preferrably, it should be possible to make them window-aware. Using an aggregate function as a window function, means applying it to every possible position of a sliding frame, and it has O(N*n) complexity (where N is total number of rows, n is the number of rows in the frame). If the aggregate function can remove rows from a group, it will only be O(N). > > * socket authentication > Can you explain this. Is there an MDEV? That's using unix_socket authentication by default for the root user. It improves security and maintainability, but is not really new - Debian is already doing that for months. This change could be confusing and break exising user scripts, so it needs to be done with care. > > * X Protocol/Document store - only if people have time or money will > > it be done > If you want people to pay for it, perhaps you should implement it in > MaxScale instead of the server :) Interesting idea :) But the MariaDB Meetup is a community event organized by the MariaDB Foundation. This particular session was about MariaDB Server planning. MariaDB Foundation has nothing to do with MaxScale, so we could not have planned anything for it. > >* Peter asks if there is any plans to support other languages like V8? > PLEASE PLEASE PLEASE PLEASE IMPLEMENT WL-820. External stored procs and > table functions. Been sitting there for the taking for a long time. > Antony has tried to get you to get it into the server, but alas, it has > never happened, and though there continues to be wide requests for this > feature from the community, they fall on deaf ears. Frankly speaking, I'd love it. But this feature never got enough priority, not in MySQL times nor in MariaDB. Unfortunately. Perhaps we'll be able to sneak it into 10.3, but no promises here. > > * Compressed binary log (from Tencent) > Compressing the binary log saves on space on the master, but it makes > seeking into binary logs much more difficult, and searching backwards > through them becomes much more difficult (which has implications for query > 'rewind') Tencent compresses individual events (think Compressed_query_log_event type). So seeking works as before, events are not decompressed on reading, they are sent compressed to slaves, etc. But the compression ratio is worse, of course. > > * Fix the XA transaction bug ( MySQL has fixed it already ) - MDEV-7974 > Please actually complete XA support, don't just half fix it like Oracle > did. Add full support for XA SUSPEND and XA RESUME and allow more than one > thread to participate in a distributed transaction in the server. Right. Still, MDEV-7974 is an important step, we cannot have proper XA without it. XA SUSPEND and XA RESUME should be the next one, I agree. > > * Indexes on expressions (this is part of virtual columns, will it not > > go into 10.2? Check with Serg) > Indexes on expressions requires parser support. > create index expr_idx on some_table(a + b); > select * from some_table where a+b > 30 and a+b <= 50 -- (uses range over > expr_idx) Right, but the parser support is the least of my worries. I don't want to low ball estmates :) but the *parser* can be fixed in a few hours. The most tricky part will be to fix the optimizer. > > * Flashback DDL MDEV-10571 (flashback DML will come in 10.2). It only > > works with row based replication. Talk about what to name it. There's > > already a MySQL time machine on github. Many like the name Rewind (but > > not Monty). Let's do a poll on the mailing list > Okay, Flashback query is VERY complicated. A flashback query is a > materialized view. There are two ways generally to achieve flashback: > a) materialize the query as is, and instead of rolling the query forward > incrementally, you roll it backwards. Flexviews achieves this by computing > the query as it is now, then computing the delta from a prior point in time > until the transaction in which that computation happened. Then the delta is > played back against the query, but the MONUS of each operation is applied > which changes insertions to deletions and vice versa. This still presents > a problem for OUTER JOIN. No documented asynchronous refresh algorithms > exist for outer join that I'm aware of, that would work with the concept of > reading row history from serialized changes. Flexviews uses the "rolling > join propagation" algorithm, which only works with inner joins. Interesting... I'll continue reading on that, thanks. But see below > b) provide a point-in-time snapshot of every table used in the query at the > desired point in time, and run the query over those tables (this is a > synchronous mechanism which supports OUTER JOIN). The problem here is how > to provide such a table. The most straight-forward way is to copy the > table, and then do the backwards replay for each (ideally in parallel) but > this is obviously undesirable if the query is "select * from some_big_table > join another_big_table on (...)" because you have to fully copy each table > before you can undo changes. Otherwise you need to have the SE display old > versions, just like it does for MVCC, but it has to display versions from > binary logs, not undo logs, and this requires a lot of SE and engine > changes! This is about correct. There are different applications for "flashback" with different use cases and different implementation trade-offs. One is, for example, to see historical sales numbers, for different months or years. That is, basically, for some kind of data analytics. Lots of SELECT queries, ad-hoc queries, at different historical time points. Another one is "damn, I've made a typo in a WHERE clause and updated too much". In this case one doesn't need joins or materialized views, one needs to see the data before the erroneous statement. This is not used often. For the second use case one can afford to copy tables and backward-replay the binary log. For the first use case one would need a completely different approach, I agree. May be something like what Flexviews does. > If you are going to have generic flashback, you might as well commit to > incrementally refreshable materialized views. Right, when we'll have materialized views, than we could think about incrementally updating them using rolling join propagation. > > * Additional GIS functions to stay compatible. Also it would be good > > to have a standalone GIS library (Georg suggests; wlad isn't too happy > > with the suggestion). Georg suggests that calculations should use the > > reference systems (Unflatten the world - MariaDB Server GIS the world > > looks flat) > > GIS functions should use gdal, just like postgresql does. Then you can > also add support for rasters. Here is an example of the awesomeness of > postgresql and postgis. It uses SQL aggregate functions, table functions, > CTE, GIS raster functions, sequences, etc: > https://github.com/greenlion/osmvox/blob/master/postgresql/combined_schema.… May be. On the other hand, we're more precise that postgis, because our implementation uses fixed-point math, not doubles. And let's not forget that MySQL uses Boost::Geometry. > > * Query rewriting - MDEV-5561 > I would like you to provide a SQL->DOM function call instead of just > providing a DOM to plugins. This function could be exposed as a regular > item function as well so that anything in the server can parse SQL. I > suggest you implement my SQL "shim" interface and just provide some way to > get a easy to iterate over parsed data structure from the SQL, such as a > nested JSON array of objects. A nested array is generated by > PHP-SQL-Parser and would provide a good template for such a JSON object. > https://github.com/greenlion/PHP-SQL-Parser We actually have an MDEV for that :) > > * With MyRocks coming, should we drop TokuDB (and maybe even deprecate > > in 10.2?) - bugs that MariaDB Corporation reports to Percona don't > > seem to get fixed. Peter says that bugs are fixed for customers... and > > there is ongoing development to make it better > It is certainly disheartening that Percona isn't responsive to MariaDB > bugs, but I'm sure you understand that it is hard for a competitor to fix > bugs for another competitor. MariaDB maintains a forked version of > TokuDB. It isn't fair to expect the upstream vendor to fix bugs that your > customers are paying you to support, does it? Perhaps you should pay a > percentage of your support fees for TokuDB issues to Percona, or come to > some other support agreement. Perhaps YOU should make the bug fixes and > submit them to Percona. And we do, look for bug reports I've reported on TokuDB to Percona - with patches :) But, really, Percona *is* fixing TokuDB bugs, it's just that they did a bit of refactoring after getting TokuDB and it took time for it to stabilize. And MariaDB Server has a vanilla TokuDB with almost no changes, we have no plans to fork it. > > * ORDER BY LIMIT optimizer bugs (MDEV-8306) > Oh god, this is a downward spiral every time somebody touches it. > Fixing it correctly requires rewriting the parser, something that > Oracle is undertaking. This didn't have much to do with the parser, and we've refactored that part of the parser in 10.2, so now this has nothing to do with the parser, it's purely the optimizer issue. > What about other new MySQL 8 features? Are you getting rid of the .FRM > nightmare? Are you going to support SET PERSIST? etc? FRM was made purely optional in 10.0 - every storage engine decides for itself whether it uses FRMs or not. May be InnoDB will use FRMs in 10.3, may be it will not. MyISAM most probably will continue use them. SET PERSIST - and this is my personal opinion - this needs to be thought over *very* carefully. There have been quite a few security vulnerabilities with my.cnf stored in the datadir, and that's why since 2005 the server no longer reads my.cnf in the datadir. But mysql_safe still does - and there have been new security vulnerabilities *last month*, caused by my.cnf in the datadir. And finally both MySQL (in 5.7?) and MariaDB (in 10.2) stopped reading my.cnf in the datadir for real. So, having my security(a)mariadb.org hat on, I look at SET PERSIST with a lot of suspicion, because it's nothing else than another attempt of storing server configuration information in the datadir and have it writable by the server itself. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org _______________________________________________ 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

6 11

Re: [Maria-discuss] MariaDB Server 10.3 notes
by Justin Swanhart 12 Oct '16

12 Oct '16

Hi Sergei! I moved this back to the mailing list, because of your .FRM explanation, and also because I'd like to explain rasters. A GIS raster is an array of data represented as a raster image. Rasters have "layers" and each layer can have a different measurement in it. It is most commonly used for height maps. The pgsql schema that I sent you is for a personal project of mine that uses Voxel.js (http://voxeljs.com/) to turn real world height maps from the space shuttle (SRTM v3 data) into interpolated 1 meter resolution voxel (minecraft-like, as 1 block = 1 sq meter) landscapes. I intersect the raster data with the GIS data from OSM (open street map) so that I can render buildings, roads, forest areas, rivers, etc, somewhat correctly (overpasses, underhangs, and missing building heights cause significant problems.). The ST_PixelsAsCentroids or ST_PixelsAsPoints can be used to get the specific value for a band in the raster, such as the height in a specific 30sq meter area (for the 1 arcsecond resolution of the SRTM data). I could never do such a thing in MySQL, and that makes me sad :( On Wed, Oct 12, 2016 at 9:34 AM, Sergei Golubchik <serg(a)mariadb.org> wrote: > Hi, Justin! > > On Oct 12, Justin Swanhart wrote: > > > > Regarding SET PERSIST, yes, it has dangers. One of them would be to > > set the buffer pool too large, so I filed a MySQL FR to set the BP to > > the default size if the malloc fails. It can be increased dynamically > > later. But there are many changes that could cause problems. This > > feature has to be managed carefully. Then again, Oracle RDBMS has had > > pfile configuration for well over a decade, and it is functionally > > equivalent to a binary my.cnf in the data dir. > > Right. Personally I fully expect that we will need to suport SET PERSIST > eventually. It's just so convenient. I only said it needs some very > careful thinking - and I was responsible for security(a)mysql.com for ten > years and now for security(a)mariadb.org for six, so I am a bit paranoid > about this :) > > > re: GIS, well, gdal and proj are used by almost every application > > that deals with GIS. What does the extra accuracy get you? Anyway, > > rasters really aren't useful without table functions, as you can't get > > the data from each point without them. > > I don't really know what rasters are. > > And I do not actually *use* GIS, so may be extra accuracy is not useful. > I'd think it might be particularly important for functions like > ST_TOUCHES(). > > I really want MariaDB to have table functions - perhaps we will have > them in 10.3. > > > Some more questions: > > Even though .FRM are optional, that still doesn't necessarily make DDL > > changes atomic, does it? > > If the engine declares FRM optional, then the whole DDL is happening > inside the engine, and it's up to the engine to make it atomic. I > expect that when we'll make FRMs optional for InnoDB, InnoDB DDLs > will be atomic. > > Regards, > Sergei > Chief Architect MariaDB > and security(a)mariadb.org >

1 0

[Maria-discuss] (/usr/include/mysql and libmysqlclient) vs (/usr/include/mariadb libmariadbclient and libmariadb)
by james harvey 11 Oct '16

11 Oct '16

First, let me clarify everything here is MariaDB - nothing actually involving the MySQL code. In Arch Linux, I'm running a MariaDB server and client. I installed the mariadb package, built from the source at: http://ftp.heanet.ie/mirrors/mariadb/mariadb-10.1.18/source/mariadb-10.1.18… This provides: - /usr/include/mysql/* (141 .h files) - /usr/lib/libmysqlclient.so - /usr/lib/libmysqld.so (I see this is for embedding a MariaDB server in an application which I don't need, so I'll ignore that for the rest of my message.) I have C++ applications that will access MariaDB, and I thought I also needed mariadb-connector-c, so I built tag v2.3.1 at https://github.com/MariaDB/mariadb-connector-c This provides: - /usr/include/mariadb/* (40 .h files) - /usr/lib/mariadb/libmariadbclient.a - /usr/lib/mariadb/libmariadb.so Q1 - What's the purpose and difference between libmysqlclient, libmariadbclient, and libmariadb? (Ignoring difference shared vs static library.) Q2 - /usr/include/mysql/mysql.h (from http://ftp.heanet.ie/mirrors/mariadb/mariadb-10.1.18/source/mariadb-10.1.18…) and /usr/include/mariadb/mysql.h (from tag v2.3.1 at from https://github.com/MariaDB/mariadb-connector-c) Are quite similar and have a lot of identical code, but are also way different. I ran into that /usr/include/mysql/mysql.h defines: const char * STDCALL mysql_error(MYSQL * myql); But /usr/include/mariadb/mysql.h defines: char * STDCALL mysql_error(MYSQL *mysql); (Note the missing const on the return value.) I got very confused at this point why the same function is declared in each, why they're different, which I should be using, etc.

2 1

[Maria-discuss] Notes from the session MariaDB Foundation priorities
by Colin Charles 08 Oct '16

08 Oct '16

Hi! These notes were from the last session on Friday, 7 October, at the MariaDB Server Developers meeting in Amsterdam at the Booking.com office, headed by Eric Herman, Board Member of the MariaDB Foundation # MariaDB Foundation priorities ## Goal: foster collaboration 1. Product should be called MariaDB Server (MariaDB is the company, since MariaDB Corporation owns the trademark) * needs some copyediting on the MariaDB Foundation website that needs editing 2. the MariaDB Foundation board majority shouldn't be from MariaDB Corporation. Expect that to be fixed within a week, at least 50:50 -- Monty. Is there a community board member? Monty says Serg, but JF/Eric says this is a conflict of interest. Is there a path for community governance? Serg represents the developers. Board selects its own members, says Otto, and there can be a maximum of 10 board members. Now they will think about a community member. 3. The documentation is on mariadb.com (the The MariaDB Knowledge Base: https://mariadb.com/kb/en/) Monty says the documentation is going to stay on mariadb.com. It is a barrier to contribution, according to Eric. Serg says MariaDB Foundation finds this a priority and is working on it. 4. Twitter/FB accounts are owned by MariaDB Corporation - so there will be a new one created for the MariaDB Foundation / MariaDB Server. The Corporation is going to keep @mariadb 5. Jira says it's licensed to MariaDB Corporation. ## Goal: Priorities for code 1. Steward patches through the integration process 2. Personal engagement when it comes to you asking about patches, features, etc. in Jira or list 3. One MariaDB Server release a year, and Serg stewards that 4. The MariaDB Foundation does not do any paid for work! 5. Security, porting, and packaging is a priority of the MariaDB Foundation (e.g. getting the MariaDB Server to work with clang is important) ## Booking's goal: easy to upgrade/cross-grade between distributions of MySQL/MariaDB Server * Eric says that interoperability is a big deal for Booking * Monty says, all members in the MariaDB Foundation have different priorities, but if it's important for Booking, the MariaDB Foundation will focus on it. Maximum increased MariaDB Server usage - this means the mission statement suggests that there must be interoperability. * JF says, Jira is not supported on MariaDB Server (certified with MySQL 5.6). Increasing adoption will happen if more applications can run with MariaDB Server. * Monty says, MySQL 5.6, should be comparable to MariaDB Server 10.1. And for 10.2 it should be compatible with MySQL 5.7. ## Transparency * Transparency during the development process and technical decision making - Vicentiu thinks we can do better, because a lot of decisions are happening on private channels * The Oracle compat work, it is a project from MariaDB Corporation, and it will be donated to the MariaDB Foundation * Vicentiu says that most of the talk about bugs happen on the MariaDB Corporation Slack channel. Serg says that no one would read them anyway. Monty agrees that having all discussions on server engineering should be on public IRC/lists. Increases transparency but maybe doesn't lower the barrier to participate, says Otto. * (Contributor who’s name I didn’t catch) PostgreSQL does all their discussions on public mailing lists and it really helps. -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

2 1

[Maria-discuss] sharding with mariadb?
by l vic 07 Oct '16

07 Oct '16

I wonder how to use sharding with symmetric replication... Does that mean I have to partition every database instance? Does it work with third-party tools, like Vitess (http://vitess.io/)? Thanks

4 7

[Maria-discuss] Expected release of 10.0.28
by Rhys.Campbell＠swisscom.com 07 Oct '16

07 Oct '16

Hi All, Do we have any estimation of the release of 10.0.28? Regards, Rhys

3 2

[Maria-discuss] thank you -> myrocks in mariadb
by MARK CALLAGHAN 06 Oct '16

06 Oct '16

MyRocks is coming to MariaDB. I think this is great news for MyRocks and the MariaDB community. Thank you. https://jira.mariadb.org/browse/MDEV-9658 -- Mark Callaghan mdcallag(a)gmail.com

1 0

[Maria-discuss] possible full-stack idea
by Mark Edwards 04 Oct '16

04 Oct '16

hello - i just joined this list and i apologize in advance if this is not the proper way to ask this question. recently i have had success combining deepstream and sequelize against a JSON column to allow for CRUD functionality in a browser with surprisingly very little code. my hope is to include something like vue, matreshka or even express to have full-stack functionality. before proceeding any further, i thought i should solicit a few opinions on this. currently i have a crude working prototype on github. please let me know any thoughts, concerns or questions before i proceed. Thank you, Mark Edwards

1 0

[Maria-discuss] MariaDB 10.1.18 now available
by Daniel Bartholomew 30 Sep '16

30 Sep '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.18. This is a stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.18 - Release Notes: https://mariadb.com/kb/en/mdb-10118-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10118-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.18 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/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] Reg Maria DB + .Net Combination
by Karthick Subramanian 30 Sep '16

30 Sep '16

All, Can anyone share your experience or reference on below: 1. Production system with Maria DB and .Net environment 2. Transaction throughput, performance issues 3. Any challenges in terms of connectors etc. Thank you. Regards, Karthick

1 0

[Maria-discuss] Regarding ROLE
by Karthick Subramanian 29 Sep '16

29 Sep '16

All, When I GRANT ROLE to a USER, its throwing error: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements +---------+------+----------------------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------------------+ | Warning | 1819 | cracklib: it is WAY too short | | Error | 1819 | Your password does not satisfy the current policy requirements | | Error | 1961 | Cannot grant role 'developer' to: 'apiuser'@'some ip'. | +---------+------+----------------------------------------------------------------+ Can anyone guide me on how to tackle this? Thank you. Regards, Karthick

1 1

[Maria-discuss] MariaDB 10.2.2 Beta now available
by Daniel Bartholomew 27 Sep '16

27 Sep '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.2 Beta. This is the first beta release in the MariaDB 10.2 series. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.2 Beta - Release Notes: https://mariadb.com/kb/en/mdb-1022-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1022-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.2 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ 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/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] (no subject)
by l vic 24 Sep '16

24 Sep '16

Is there is a good way to remove a node from a galera cluster besides just killing it? / Are there are any implications of killing a node? Thanks,

2 1

[Maria-discuss] Long semaphore waits killing server
by Jon Foster 22 Sep '16

22 Sep '16

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.52 and Connector/ODBC 2.0.12 now available
by Daniel Bartholomew 21 Sep '16

21 Sep '16

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.52 and MariaDB Connector/ODBC 2.0.12. Both are Stable (GA) releases. See the Release Notes and Changelog for details. IMPORTANT: There was a security fix included in the 5.5.51 release of MariaDB. If you are running MariaDB or MariaDB Galera Cluster 5.5.50 or lower, please upgrade to at least 5.5.51 right away. See the MariaDB 5.5.51 release notes and the following blog post for more details. - https://mariadb.org/mariadb-server-versions-remote-root-code-execution-vuln… - https://mariadb.com/kb/en/mariadb-5551-release-notes/ - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.52 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mgc-5552-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5552-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.52 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/ODBC 2.0.12 - Release Notes: https://mariadb.com/kb/en/mco-2012-rn/ - Changelog: https://mariadb.com/kb/en/mco-2012-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.12/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - 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] backup front end?
by l vic 19 Sep '16

19 Sep '16

Is there any open source front end tool for Xtrabackup? Thanks, -V

4 5

[Maria-discuss] MariaDB 5.5.52 now available
by Daniel Bartholomew 13 Sep '16

13 Sep '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.52 Stable (GA). See the Release Notes and Changelog for details. IMPORTANT: There was a security fix included in the 5.5.51 release of MariaDB. If you are running MariaDB 5.5.50 or lower, please upgrade to at least MariaDB 5.5.51 right away. See the MariaDB 5.5.51 release notes and the following blog post for more details. - https://mariadb.org/mariadb-server-versions-remote-root-code-execution-vuln… - https://mariadb.com/kb/en/mariadb-5551-release-notes/ - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.52 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mdb-5552-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5552-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.52 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] Critical Update for CVE-2016-6662
by Alex 13 Sep '16

13 Sep '16

Hello, In regards to this zero day remote exploit , it seems MariaDB is also affected. Percona seems to have released new versions out to fix this. Any news from MariaDB side ? http://legalhackers.com/advisories/MySQL-Exploit-Remote-Root-Code-Execution… Regards, Alexandru

5 16

[Maria-discuss] MariaDB Developers Meetup
by Ian Gilfillan 12 Sep '16

12 Sep '16

The MariaDB Developers Meetup in Amsterdam is less than a month away now (October 6-8), and we're starting to set the schedule. If you want to suggest a topic to be covered, please add it now at https://docs.google.com/spreadsheets/d/1D7yS8wgCQVXNSEzuIjtAOGfyVwJStUoEb23… - you can also vote for those sessions you'd most be interested in. Full details of the meetup are at https://mariadb.org/2016-mariadb-developers-meetup/ - remember to sign up on the Meetup group as well to let us know you'll be coming.

1 0

[Maria-discuss] Database Platform Migration
by Suresh Rajagopal 11 Sep '16

11 Sep '16

Hi, How to migrate mysql 5.0 database from darwin to Linux? Database size is close to 1 TB Thanks Suresh Rajagopal

1 0

[Maria-discuss] Spider Nodes
by Suresh Rajagopal 10 Sep '16

10 Sep '16

Hi, What is best place to keep spider nodes ? Dedicated Physical Servers or Virtual Machines or Backend Nodes Backend nodes are physical servers with SSD. ThanksSuresh Rajagopal

1 0

[Maria-discuss] Reg Audit Trail Implementation
by Karthick Subramanian 08 Sep '16

08 Sep '16

All, Before I reinvent a wheel again, thought of checking with you experts whether any recommendation or suggestion for implementing audit trail feature for your database. I am looking for any open source product/tool for this purpose. I thought of exploring audit plugin, but I am not sure whether we can enable audit trail for the data changes in a tables. For example: *ORDER table:* ORDER_ID PRODUCT_ID QTY ORDER_DATE SHIP_DATE DELIVERY_DATE DELIVERY_ADDRESS Any changes on the above table's data (rows), we need to capture the audit trail like TABLE_NAME,COLUMN_NAME,OLD_VALUE,NEW_VALUE,CHANGE_DATE,CHANGE_BY,HOST,APP,MODULE etc. Thank you, Karthick

2 1

[Maria-discuss] handling of mixed case roles
by Robin Peiremans 05 Sep '16

05 Sep '16

Hi I've created a role with both upper and lowercase name, resulting in some weird behavior (output and test case below). The first thing I noticed is that you can create roles with the same name but different case (test_role and test_ROLE in below example), but you can't grant both to the same user as that results in an error 1961 when granting the second role. Imo this indicates that not all the roles code is case-sensitive. The second weird thing is that when you get the error 1961 in above scenario, the first role (that was granted successfully) is gone from the show grants output. It is not revoked (the user can still use it), it just isn't shown anymore until I flush privileges. Can this be considered a bug, or am I missing something here? MariaDB version: 10.1.13-MariaDB OS: Red Hat 7.2 Kind regards Robin Output and test case: MariaDB [mysql]> create role test_ROLE; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> create role test_role; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> grant select on mysql.* to test_role; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> select user, host from user where is_role='y' and user like 'test%'; +-----------+------+ | user | host | +-----------+------+ | test_ROLE | | | test_role | | +-----------+------+ 2 rows in set (0.00 sec) MariaDB [mysql]> grant test_role to testuser; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> show grants for testuser; +------------------------------------------------------------------------+ | Grants for testuser@% | +------------------------------------------------------------------------+ | GRANT test_role TO 'testuser'@'%' | | GRANT USAGE ON *.* TO 'testuser'@'%' IDENTIFIED VIA pam USING 'mariadb' | +------------------------------------------------------------------------+ 2 rows in set (0.00 sec) MariaDB [mysql]> grant test_ROLE to testuser; ERROR 1961 (HY000): Cannot grant role 'test_ROLE' to: 'testuser'. MariaDB [mysql]> show grants for testuser; +------------------------------------------------------------------------+ | Grants for testuser@% | +------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'testuser'@'%' IDENTIFIED VIA pam USING 'mariadb' | +------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [mysql]> select * from roles_mapping where user='testuser'; +-----------+---------+-----------+--------------+ | Host | User | Role | Admin_option | +-----------+---------+-----------+--------------+ | % | testuser | test_role | N | +-----------+---------+-----------+--------------+ 3 rows in set (0.00 sec) MariaDB [mysql]> flush privileges; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> show grants for testuser; +------------------------------------------------------------------------+ | Grants for testuser@% | +------------------------------------------------------------------------+ | GRANT test_role TO 'testuser'@'%' | | GRANT USAGE ON *.* TO 'testuser'@'%' IDENTIFIED VIA pam USING 'mariadb' | +------------------------------------------------------------------------+ 2 rows in set (0.00 sec) This e-mail and any attached files are confidential and may be legally privileged. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify KBC immediately and then delete this e-mail. KBC does not accept liability for the correct and complete transmission of the information, nor for any delay or interruption of the transmission, nor for damages arising from the use of or reliance on the information. All e-mail messages addressed to, received or sent by KBC or KBC employees are deemed to be professional in nature. Accordingly, the sender or recipient of these messages agrees that they may be read by other KBC employees than the official recipient or sender in order to ensure the continuity of work-related activities and allow supervision thereof.

2 2

[Maria-discuss] R: handling of mixed case roles
by Federico Razzoli 05 Sep '16

05 Sep '16

Users are case-sensitive, so I expect the same from roles. If something doesn't work with mixed-case roles, it is probably a bug. Federico -------------------------------------------- Lun 5/9/16, Robin Peiremans <robin.peiremans(a)kbc.be> ha scritto: Oggetto: [Maria-discuss] handling of mixed case roles A: "maria-discuss(a)lists.launchpad.net" <maria-discuss(a)lists.launchpad.net> Data: Lunedì 5 settembre 2016, 10:27 Hi I've created a role with both upper and lowercase name, resulting in some weird behavior (output and test case below). The first thing I noticed is that you can create roles with the same name but different case (test_role and test_ROLE in below example), but you can't grant both to the same user as that results in an error 1961 when granting the second role. Imo this indicates that not all the roles code is case-sensitive. The second weird thing is that when you get the error 1961 in above scenario, the first role (that was granted successfully) is gone from the show grants output. It is not revoked (the user can still use it), it just isn't shown anymore until I flush privileges. Can this be considered a bug, or am I missing something here? MariaDB version: 10.1.13-MariaDB OS: Red Hat 7.2 Kind regards Robin Output and test case: MariaDB [mysql]> create role test_ROLE; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> create role test_role; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> grant select on mysql.* to test_role; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> select user, host from user where is_role='y' and user like 'test%'; +-----------+------+ | user | host | +-----------+------+ | test_ROLE | | | test_role | | +-----------+------+ 2 rows in set (0.00 sec) MariaDB [mysql]> grant test_role to testuser; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> show grants for testuser; +------------------------------------------------------------------------+ | Grants for testuser@% | +------------------------------------------------------------------------+ | GRANT test_role TO 'testuser'@'%' | | GRANT USAGE ON *.* TO 'testuser'@'%' IDENTIFIED VIA pam USING 'mariadb' | +------------------------------------------------------------------------+ 2 rows in set (0.00 sec) MariaDB [mysql]> grant test_ROLE to testuser; ERROR 1961 (HY000): Cannot grant role 'test_ROLE' to: 'testuser'. MariaDB [mysql]> show grants for testuser; +------------------------------------------------------------------------+ | Grants for testuser@% | +------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'testuser'@'%' IDENTIFIED VIA pam USING 'mariadb' | +------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [mysql]> select * from roles_mapping where user='testuser'; +-----------+---------+-----------+--------------+ | Host | User | Role | Admin_option | +-----------+---------+-----------+--------------+ | % | testuser | test_role | N | +-----------+---------+-----------+--------------+ 3 rows in set (0.00 sec) MariaDB [mysql]> flush privileges; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> show grants for testuser; +------------------------------------------------------------------------+ | Grants for testuser@% | +------------------------------------------------------------------------+ | GRANT test_role TO 'testuser'@'%' | | GRANT USAGE ON *.* TO 'testuser'@'%' IDENTIFIED VIA pam USING 'mariadb' | +------------------------------------------------------------------------+ 2 rows in set (0.00 sec) Disclaimer -----Segue allegato----- _______________________________________________ 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

1 0

[Maria-discuss] mysqld syslog flood Bad file descriptor
by Raffael Sahli 05 Sep '16

05 Sep '16

Hi Over the weekend I had a problem with one mysqld instance. This single instance flooded our entire syslog infrastructure with ~190mio log entries within 6 hours. The messages was: "140289656219584 [ERROR] Error in accept: Bad file descriptor" mysqld: /usr/sbin/mysqld Ver 10.1.16-MariaDB-1~trusty for debian-linux-gnu on x86_64 (mariadb.org binary distribution) I will configure rsyslog to throttle such entries, but anyways, is this a known problem? Cheers -- Raffael Sahli public(a)raffaelsahli.com

1 0

[Maria-discuss] 回复：Re:__转发：failed_to_connect_mariadb_at_addition_node_in_MariaDB_galera_cluster
by 西门吹牛 03 Sep '16

03 Sep '16

Hi, Thanks for the reponse. No, I started mysqld on the second node via comamd "mysqld --defaults-extra-file=mdb.my.cnf --debug". The problem is permanent. No abnormal output seen from the console. I feel mariadb may stuck somewher. from the trace log(attached mdb.mysqld.trace). it looks stuck at wsrep_replication_process. It may wait for some message from primary node. but I have no ieda what it waits for. -------------------------------- ----- 原始邮件 ----- 发件人：Nirbhay Choubey <nirbhay(a)mariadb.com> 收件人：zh1029(a)sina.com 抄送人：maria-discuss <maria-discuss(a)lists.launchpad.net>, "yan-jack.chen" <yan-jack.chen(a)nokia.com> 主题：Re:_[Maria-discuss]_转发：failed_to_connect_mariadb_at_addition_node_in_MariaDB_galera_cluster 日期：2016年09月02日 23点26分 Hi, On Thu, Sep 1, 2016 at 11:08 PM, 西门吹牛 <zh1029(a)sina.com> wrote: Hi, I deployed two MariaDB galera version in two nodes to build cluster. But I can’t connect MariaDB in second node as seems the port is not created by MariaDB because looks like it is stuck somehow. Version: mysqld 10.1.17-MariaDB-debug VS galera-3-25.3.17 I started MariaDB in first node. Seems fine. Port 3307 was created and I can login Mariadb by mysql. You shouldn't use --wsrep-new-cluster to start the 2nd node (in case you are).Regarding the hang:Does it happen all the time? Repeatable?Is that all you see in the error log? Nothing after the partial last line?Will it be possible to attach mysqld to some debugger to check where exactly does it hang? Best,Nirbhay [root@MMN-0(RCP-69) /root/test] # /home/_rcpadmin/bin/mariadb/bin/mysqld --defaults-extra-file=./mmn.my.cnf --wsrep-new-cluster --debug 2016-09-01 16:41:37 140716544316288 [Note] /home/_rcpadmin/bin/mariadb/bin/mysqld (mysqld 10.1.17-MariaDB-debug) starting as process 15248 ... 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Setting wsrep_ready to 0 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Read nil XID from storage engines, skipping position init 2016-09-01 16:41:38 140716544316288 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so' 2016-09-01 16:41:38 140716544316288 [Note] WSREP: wsrep_load(): Galera 3.17(r0) by Codership Oy <info(a)codership.com> loaded successfully. 2016-09-01 16:41:38 140716544316288 [Note] WSREP: CRC-32C: using hardware acceleration. 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Found saved state: 900987cc-7003-11e6-b25f-de0a52317f1d:0 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Passing config to GCS: base_dir = /mariadb/; base_host = MMN-0; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /mariadb/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mariadb//galera.cache; gcache.page_size = 300M; gcache.size = 300M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc 2016-09-01 16:41:38 140716029634304 [Note] WSREP: Service thread queue flushed. 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1 2016-09-01 16:41:38 140716544316288 [Note] WSREP: wsrep_sst_grab() 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Start replication 2016-09-01 16:41:38 140716544316288 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Setting initial position to 900987cc-7003-11e6-b25f-de0a52317f1d:0 2016-09-01 16:41:38 140716544316288 [Note] WSREP: protonet asio version 0 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Using CRC-32C for message checksums. 2016-09-01 16:41:38 140716544316288 [Note] WSREP: backend: asio 2016-09-01 16:41:38 140716544316288 [Note] WSREP: gcomm thread scheduling priority set to other:0 2016-09-01 16:41:38 140716544316288 [Warning] WSREP: access file(/mariadb//gvwstate.dat) failed(No such file or directory) 2016-09-01 16:41:38 140716544316288 [Note] WSREP: restore pc from disk failed 2016-09-01 16:41:38 140716544316288 [Note] WSREP: GMCast version 0 2016-09-01 16:41:38 140716544316288 [Note] WSREP: (e5a32d3c, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2016-09-01 16:41:38 140716544316288 [Note] WSREP: (e5a32d3c, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2016-09-01 16:41:38 140716544316288 [Note] WSREP: EVS version 0 2016-09-01 16:41:38 140716544316288 [Note] WSREP: gcomm: bootstrapping new group 'example_cluster' 2016-09-01 16:41:38 140716544316288 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Node e5a32d3c state prim 2016-09-01 16:41:38 140716544316288 [Note] WSREP: view(view_id(PRIM,e5a32d3c,1) memb { e5a32d3c,0 } joined { } left { } partitioned { }) 2016-09-01 16:41:38 140716544316288 [Note] WSREP: save pc into disk 2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr without UUID: tcp://169.254.0.4:4567 2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr proto entry 0x5652b0352ef0 2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr without UUID: tcp://169.254.0.5:4567 2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr proto entry 0x5652b035b720 2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr without UUID: tcp://169.254.0.6:4567 2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr proto entry 0x5652b0363ea0 2016-09-01 16:41:38 140716544316288 [Note] WSREP: gcomm: connected 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Opened channel 'example_cluster' 2016-09-01 16:41:38 140715987670784 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2016-09-01 16:41:38 140716544316288 [Note] WSREP: Waiting for SST to complete. 2016-09-01 16:41:38 140715987670784 [Note] WSREP: STATE_EXCHANGE: sent state UUID: e5a3bc45-701f-11e6-ba1c-471590fea490 2016-09-01 16:41:38 140715987670784 [Note] WSREP: STATE EXCHANGE: sent state msg: e5a3bc45-701f-11e6-ba1c-471590fea490 2016-09-01 16:41:38 140715987670784 [Note] WSREP: STATE EXCHANGE: got state msg: e5a3bc45-701f-11e6-ba1c-471590fea490 from 0 (MMN-0) 2016-09-01 16:41:38 140715987670784 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 0, last_appl. = -1, protocols = 0/7/3 (gcs/repl/appl), group UUID = 900987cc-7003-11e6-b25f-de0a52317f1d 2016-09-01 16:41:38 140715987670784 [Note] WSREP: Flow-control interval: [16, 16] 2016-09-01 16:41:38 140715987670784 [Note] WSREP: Restored state OPEN -> JOINED (0) 2016-09-01 16:41:38 140715987670784 [Note] WSREP: Member 0.0 (MMN-0) synced with group. 2016-09-01 16:41:38 140716542806784 [Note] WSREP: New cluster view: global state: 900987cc-7003-11e6-b25f-de0a52317f1d:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 2016-09-01 16:41:38 140715987670784 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2016-09-01 16:41:38 140716544316288 [Note] WSREP: SST complete, seqno: 0 2016-09-01 16:41:38 140716544316288 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-09-01 16:41:38 140716544316288 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2016-09-01 16:41:38 140716544316288 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2016-09-01 16:41:38 140716544316288 [Note] InnoDB: The InnoDB memory heap is disabled 2016-09-01 16:41:38 140716 _______________________________________________ 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

2 1

[Maria-discuss] TLS SNI support
by Felipe Gasper 03 Sep '16

03 Sep '16

Hi all, Has support for TLS SNI ever been discussed for MariaDB? This would allow hosting of multiple SSL certificates from the same server. It’s a boon in shared hosting environments. From the client’s end, at least, it would be trivial to implement. Doing it on the server would be trickier, but still pretty doable, I’d think? -Felipe Gasper

3 5

[Maria-discuss] 转发：failed to connect mariadb at addition node in MariaDB galera cluster
by 西门吹牛 02 Sep '16

02 Sep '16

SGksDQogIEkgZGVwbG95ZWQgdHdvIE1hcmlhREIgZ2FsZXJhIHZlcnNpb24gaW4gdHdvIG5vZGVzIHRvIGJ1aWxkIGNsdXN0ZXIuIEJ1dCBJIGNhbuKAmXQgY29ubmVjdCBNYXJpYURCIGluIHNlY29uZCBub2RlIGFzIHNlZW1zIHRoZSBwb3J0IGlzIG5vdCBjcmVhdGVkIGJ5IE1hcmlhREIgYmVjYXVzZSBsb29rcyBsaWtlIGl0IGlzIHN0dWNrIHNvbWVob3cuDQogIFZlcnNpb246IG15c3FsZCAxMC4xLjE3LU1hcmlhREItZGVidWcgVlMgZ2FsZXJhLTMtMjUuMy4xNw0KIA0KSSBzdGFydGVkIE1hcmlhREIgaW4gZmlyc3Qgbm9kZS4gU2VlbXMgZmluZS4gUG9ydCAzMzA3IHdhcyBjcmVhdGVkIGFuZCBJIGNhbiBsb2dpbiBNYXJpYWRiIGJ5IG15c3FsLg0KDQoNCiANCg0KDQpbcm9vdEBNTU4tMChSQ1AtNjkpIC9yb290L3Rlc3RdDQoNCiMgL2hvbWUvX3JjcGFkbWluL2Jpbi9tYXJpYWRiL2Jpbi9teXNxbGQgLS1kZWZhdWx0cy1leHRyYS1maWxlPS4vbW1uLm15LmNuZiAtLXdzcmVwLW5ldy1jbHVzdGVyIC0tZGVidWcNCg0KMjAxNi0wOS0wMSAxNjo0MTozNyAxNDA3MTY1NDQzMTYyODggW05vdGVdIC9ob21lL19yY3BhZG1pbi9iaW4vbWFyaWFkYi9iaW4vbXlzcWxkIChteXNxbGQgMTAuMS4xNy1NYXJpYURCLWRlYnVnKSBzdGFydGluZyBhcyBwcm9jZXNzIDE1MjQ4IC4uLg0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IFNldHRpbmcgd3NyZXBfcmVhZHkgdG8gMA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IFJlYWQgbmlsIFhJRCBmcm9tIHN0b3JhZ2UgZW5naW5lcywgc2tpcHBpbmcgcG9zaXRpb24gaW5pdA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IHdzcmVwX2xvYWQoKTogbG9hZGluZyBwcm92aWRlciBsaWJyYXJ5ICcvdXNyL2xpYjY0L2xpYmdhbGVyYV9zbW0uc28nDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogd3NyZXBfbG9hZCgpOiBHYWxlcmEgMy4xNyhyMCkgYnkgQ29kZXJzaGlwIE95IDxpbmZvQGNvZGVyc2hpcC5jb20+IGxvYWRlZCBzdWNjZXNzZnVsbHkuDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogQ1JDLTMyQzogdXNpbmcgaGFyZHdhcmUgYWNjZWxlcmF0aW9uLg0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IEZvdW5kIHNhdmVkIHN0YXRlOiA5MDA5ODdjYy03MDAzLTExZTYtYjI1Zi1kZTBhNTIzMTdmMWQ6MA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IFBhc3NpbmcgY29uZmlnIHRvIEdDUzogYmFzZV9kaXIgPSAvbWFyaWFkYi87IGJhc2VfaG9zdCA9IE1NTi0wOyBiYXNlX3BvcnQgPSA0NTY3OyBjZXJ0LmxvZ19jb25mbGljdHMgPSBubzsgZGVidWcgPSBubzsgZXZzLmF1dG9fZXZpY3QgPSAwOyBldnMuZGVsYXlfbWFyZ2luID0gUFQxUzsgZXZzLmRlbGF5ZWRfa2VlcF9wZXJpb2QNCj0gUFQzMFM7IGV2cy5pbmFjdGl2ZV9jaGVja19wZXJpb2QgPSBQVDAuNVM7IGV2cy5pbmFjdGl2ZV90aW1lb3V0ID0gUFQxNVM7IGV2cy5qb2luX3JldHJhbnNfcGVyaW9kID0gUFQxUzsgZXZzLm1heF9pbnN0YWxsX3RpbWVvdXRzID0gMzsgZXZzLnNlbmRfd2luZG93ID0gNDsgZXZzLnN0YXRzX3JlcG9ydF9wZXJpb2QgPSBQVDFNOyBldnMuc3VzcGVjdF90aW1lb3V0ID0gUFQ1UzsgZXZzLnVzZXJfc2VuZF93aW5kb3cgPSAyOyBldnMudmlld19mb3JnZXRfdGltZW91dA0KPSBQVDI0SDsgZ2NhY2hlLmRpciA9IC9tYXJpYWRiLzsgZ2NhY2hlLmtlZXBfcGFnZXNfc2l6ZSA9IDA7IGdjYWNoZS5tZW1fc2l6ZSA9IDA7IGdjYWNoZS5uYW1lID0gL21hcmlhZGIvL2dhbGVyYS5jYWNoZTsgZ2NhY2hlLnBhZ2Vfc2l6ZSA9IDMwME07IGdjYWNoZS5zaXplID0gMzAwTTsgZ2NvbW0udGhyZWFkX3ByaW8gPSA7IGdjcy5mY19kZWJ1ZyA9IDA7IGdjcy5mY19mYWN0b3IgPSAxLjA7IGdjcy5mY19saW1pdCA9IDE2OyBnY3MuZmNfbWFzdGVyX3NsYXZlDQo9IG5vOyBnY3MubWF4X3BhY2tldF9zaXplID0gNjQ1MDA7IGdjcy5tYXhfdGhyb3R0bGUgPSAwLjI1OyBnY3MucmVjdl9xX2hhcmRfbGltaXQgPSA5MjIzMzcyMDM2ODU0Nzc1ODA3OyBnY3MucmVjdl9xX3NvZnRfbGltaXQgPSAwLjI1OyBnY3Muc3luY19kb25vciA9IG5vOyBnbWNhc3Quc2VnbWVudCA9IDA7IGdtY2FzdC52ZXJzaW9uID0gMDsgcGMuYW5ub3VuY2VfdGltZW91dCA9IFBUM1M7IHBjLmNoZWNrc3VtID0gZmFsc2U7IHBjLmlnbm9yZV9xdW9ydW0NCj0gZmFsc2U7IHBjLmlnbm9yZV9zYiA9IGZhbHNlOyBwYw0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjAyOTYzNDMwNCBbTm90ZV0gV1NSRVA6IFNlcnZpY2UgdGhyZWFkIHF1ZXVlIGZsdXNoZWQuDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogQXNzaWduIGluaXRpYWwgcG9zaXRpb24gZm9yIGNlcnRpZmljYXRpb246IDAsIHByb3RvY29sIHZlcnNpb246IC0xDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogd3NyZXBfc3N0X2dyYWIoKQ0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IFN0YXJ0IHJlcGxpY2F0aW9uDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogJ3dzcmVwLW5ldy1jbHVzdGVyJyBvcHRpb24gdXNlZCwgYm9vdHN0cmFwcGluZyB0aGUgY2x1c3Rlcg0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IFNldHRpbmcgaW5pdGlhbCBwb3NpdGlvbiB0byA5MDA5ODdjYy03MDAzLTExZTYtYjI1Zi1kZTBhNTIzMTdmMWQ6MA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IHByb3RvbmV0IGFzaW8gdmVyc2lvbiAwDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogVXNpbmcgQ1JDLTMyQyBmb3IgbWVzc2FnZSBjaGVja3N1bXMuDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogYmFja2VuZDogYXNpbw0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IGdjb21tIHRocmVhZCBzY2hlZHVsaW5nIHByaW9yaXR5IHNldCB0byBvdGhlcjowIA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbV2FybmluZ10gV1NSRVA6IGFjY2VzcyBmaWxlKC9tYXJpYWRiLy9ndndzdGF0ZS5kYXQpIGZhaWxlZChObyBzdWNoIGZpbGUgb3IgZGlyZWN0b3J5KQ0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IHJlc3RvcmUgcGMgZnJvbSBkaXNrIGZhaWxlZA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IEdNQ2FzdCB2ZXJzaW9uIDANCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTY1NDQzMTYyODggW05vdGVdIFdTUkVQOiAoZTVhMzJkM2MsICd0Y3A6Ly8wLjAuMC4wOjQ1NjcnKSBsaXN0ZW5pbmcgYXQgdGNwOi8vMC4wLjAuMDo0NTY3DQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogKGU1YTMyZDNjLCAndGNwOi8vMC4wLjAuMDo0NTY3JykgbXVsdGljYXN0OiAsIHR0bDogMQ0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IEVWUyB2ZXJzaW9uIDANCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTY1NDQzMTYyODggW05vdGVdIFdTUkVQOiBnY29tbTogYm9vdHN0cmFwcGluZyBuZXcgZ3JvdXAgJ2V4YW1wbGVfY2x1c3RlcicNCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTY1NDQzMTYyODggW05vdGVdIFdTUkVQOiBzdGFydF9wcmltIGlzIGVuYWJsZWQsIHR1cm4gb2ZmIHBjX3JlY292ZXJ5DQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogTm9kZSBlNWEzMmQzYyBzdGF0ZSBwcmltDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogdmlldyh2aWV3X2lkKFBSSU0sZTVhMzJkM2MsMSkgbWVtYiB7DQoNCiAgICAgICAgZTVhMzJkM2MsMA0KDQp9IGpvaW5lZCB7DQoNCn0gbGVmdCB7DQoNCn0gcGFydGl0aW9uZWQgew0KDQp9KQ0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IHNhdmUgcGMgaW50byBkaXNrDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogZGlzY2FyZGluZyBwZW5kaW5nIGFkZHIgd2l0aG91dCBVVUlEOiB0Y3A6Ly8xNjkuMjU0LjAuNDo0NTY3DQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogZGlzY2FyZGluZyBwZW5kaW5nIGFkZHIgcHJvdG8gZW50cnkgMHg1NjUyYjAzNTJlZjANCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTY1NDQzMTYyODggW05vdGVdIFdTUkVQOiBkaXNjYXJkaW5nIHBlbmRpbmcgYWRkciB3aXRob3V0IFVVSUQ6IHRjcDovLzE2OS4yNTQuMC41OjQ1NjcNCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTY1NDQzMTYyODggW05vdGVdIFdTUkVQOiBkaXNjYXJkaW5nIHBlbmRpbmcgYWRkciBwcm90byBlbnRyeSAweDU2NTJiMDM1YjcyMA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IGRpc2NhcmRpbmcgcGVuZGluZyBhZGRyIHdpdGhvdXQgVVVJRDogdGNwOi8vMTY5LjI1NC4wLjY6NDU2Nw0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IGRpc2NhcmRpbmcgcGVuZGluZyBhZGRyIHByb3RvIGVudHJ5IDB4NTY1MmIwMzYzZWEwDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogZ2NvbW06IGNvbm5lY3RlZA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gV1NSRVA6IENoYW5naW5nIG1heGltdW0gcGFja2V0IHNpemUgdG8gNjQ1MDAsIHJlc3VsdGluZyBtc2cgc2l6ZTogMzI2MzYNCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTY1NDQzMTYyODggW05vdGVdIFdTUkVQOiBTaGlmdGluZyBDTE9TRUQgLT4gT1BFTiAoVE86IDApDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogT3BlbmVkIGNoYW5uZWwgJ2V4YW1wbGVfY2x1c3RlcicNCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTU5ODc2NzA3ODQgW05vdGVdIFdTUkVQOiBOZXcgQ09NUE9ORU5UOiBwcmltYXJ5ID0geWVzLCBib290c3RyYXAgPSBubywgbXlfaWR4ID0gMCwgbWVtYl9udW0gPSAxDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogV2FpdGluZyBmb3IgU1NUIHRvIGNvbXBsZXRlLg0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNTk4NzY3MDc4NCBbTm90ZV0gV1NSRVA6IFNUQVRFX0VYQ0hBTkdFOiBzZW50IHN0YXRlIFVVSUQ6IGU1YTNiYzQ1LTcwMWYtMTFlNi1iYTFjLTQ3MTU5MGZlYTQ5MA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNTk4NzY3MDc4NCBbTm90ZV0gV1NSRVA6IFNUQVRFIEVYQ0hBTkdFOiBzZW50IHN0YXRlIG1zZzogZTVhM2JjNDUtNzAxZi0xMWU2LWJhMWMtNDcxNTkwZmVhNDkwDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE1OTg3NjcwNzg0IFtOb3RlXSBXU1JFUDogU1RBVEUgRVhDSEFOR0U6IGdvdCBzdGF0ZSBtc2c6IGU1YTNiYzQ1LTcwMWYtMTFlNi1iYTFjLTQ3MTU5MGZlYTQ5MCBmcm9tIDAgKE1NTi0wKQ0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNTk4NzY3MDc4NCBbTm90ZV0gV1NSRVA6IFF1b3J1bSByZXN1bHRzOg0KDQogICAgICAgIHZlcnNpb24gICAgPSA0LA0KDQogICAgICAgIGNvbXBvbmVudCAgPSBQUklNQVJZLA0KDQogICAgICAgIGNvbmZfaWQgICAgPSAwLA0KDQogICAgICAgIG1lbWJlcnMgICAgPSAxLzEgKGpvaW5lZC90b3RhbCksDQoNCiAgICAgICAgYWN0X2lkICAgICA9IDAsDQoNCiAgICAgICAgbGFzdF9hcHBsLiA9IC0xLA0KDQogICAgICAgIHByb3RvY29scyAgPSAwLzcvMyAoZ2NzL3JlcGwvYXBwbCksDQoNCiAgICAgICAgZ3JvdXAgVVVJRCA9IDkwMDk4N2NjLTcwMDMtMTFlNi1iMjVmLWRlMGE1MjMxN2YxZA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNTk4NzY3MDc4NCBbTm90ZV0gV1NSRVA6IEZsb3ctY29udHJvbCBpbnRlcnZhbDogWzE2LCAxNl0NCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTU5ODc2NzA3ODQgW05vdGVdIFdTUkVQOiBSZXN0b3JlZCBzdGF0ZSBPUEVOIC0+IEpPSU5FRCAoMCkNCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTU5ODc2NzA3ODQgW05vdGVdIFdTUkVQOiBNZW1iZXIgMC4wIChNTU4tMCkgc3luY2VkIHdpdGggZ3JvdXAuDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQyODA2Nzg0IFtOb3RlXSBXU1JFUDogTmV3IGNsdXN0ZXIgdmlldzogZ2xvYmFsIHN0YXRlOiA5MDA5ODdjYy03MDAzLTExZTYtYjI1Zi1kZTBhNTIzMTdmMWQ6MCwgdmlldyMgMTogUHJpbWFyeSwgbnVtYmVyIG9mIG5vZGVzOiAxLCBteSBpbmRleDogMCwgcHJvdG9jb2wgdmVyc2lvbiAzDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE1OTg3NjcwNzg0IFtOb3RlXSBXU1JFUDogU2hpZnRpbmcgSk9JTkVEIC0+IFNZTkNFRCAoVE86IDApDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBXU1JFUDogU1NUIGNvbXBsZXRlLCBzZXFubzogMA0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gSW5ub0RCOiBVc2luZyBtdXRleGVzIHRvIHJlZiBjb3VudCBidWZmZXIgcG9vbCBwYWdlcw0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gSW5ub0RCOiAgSW5ub0RCOiAhISEhISEhISBVTklWX0RFQlVHIHN3aXRjaGVkIG9uICEhISEhISEhIQ0KDQoyMDE2LTA5LTAxIDE2OjQxOjM4IDE0MDcxNjU0NDMxNjI4OCBbTm90ZV0gSW5ub0RCOiAgSW5ub0RCOiAhISEhISEhISBVTklWX1NZTkNfREVCVUcgc3dpdGNoZWQgb24gISEhISEhISEhDQoNCjIwMTYtMDktMDEgMTY6NDE6MzggMTQwNzE2NTQ0MzE2Mjg4IFtOb3RlXSBJbm5vREI6IFRoZSBJbm5vREIgbWVtb3J5IGhlYXAgaXMgZGlzYWJsZWQNCg0KMjAxNi0wOS0wMSAxNjo0MTozOCAxNDA3MTY[truncated for moderation]

2 1

[Maria-discuss] Upgrade error: mariadb 10.1.16 to 10.1.17
by Erik de Waard 01 Sep '16

01 Sep '16

Hello, When upgrading from 10.1.16 to 10.1.17 on Debian Jessie i've received the following error: aptitude upgrade <snip> dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin (2.19-18+deb8u4) ... Errors were encountered while processing: mariadb-server-10.1 E: Sub-process /usr/bin/dpkg returned an error code (1) Failed to perform requested operation on package. Trying to recover: Setting up mariadb-server-10.1 (10.1.17+maria-1~jessie) ... dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered while processing: mariadb-server-10.1 Current status: 0 updates [-14] <snip> /var/log/syslog mysqld_safe[44689]: ERROR: 1136 Column count doesn't match value count at row 1 Was able to fix by running. /usr/sbin/mysqld --skip-grant --general-log & And running the upgrade again. See attached full logs.

2 1

[Maria-discuss] New Question: AES_ENCRYPT() and AES_DECRYPT() with other than ECB mode?
by AskMonty KB 01 Sep '16

01 Sep '16

Hello, A new question has been asked in "MariaDB Community" by w3goodies.com_64477. Please answer it at http://mariadb.com/kb/en/aes_encrypt-and-aes_decrypt-with-other-than-ecb-mo… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Since MySQL 5.6.17, MySQL supports block_encryption_mode to change encryption mode from ECB to other modes like 256-CBC http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_… I think MariaDB currently only supports 128-ECB for AES_ENCRYPT() and AES_DECRYPT(), will there be update in MariaDB to merge this block_encryption_mode feature any soon? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/aes_encrypt-and-aes_decrypt-with-other-than-ecb-mo…

1 0

[Maria-discuss] InnoDB plugin maturity
by Ian Gilfillan 01 Sep '16

01 Sep '16

If you look at the list of plugin maturities, say with: SELECT plugin_name,plugin_version,plugin_maturity FROM information_schema.plugins ORDER BY plugin_name; I notice that in 10.1, InnoDB/XtraDB is listed as Gamma (changed from Beta in 10.1.13), while in 10.0, with the same version of XtraDB, it's listed as Stable. What's the basis of the distinction between the two, especially since 10.1 itself is a stable release? It seems strange to have InnoDB listed as the same maturity as Spider :)

2 1

Re: [Maria-discuss] Don't replicate procedures in the mysql database
by Federico Razzoli 01 Sep '16

01 Sep '16

I never used replicate_ignore_db='mysql'. But I know some people does. Did you check if it has side effects? Federico -------------------------------------------- Mer 31/8/16, Игорь Пашев <pashev.igor(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql database A: "MariaDB discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 31 agosto 2016, 23:39 Thanks to everyone Here is the solution: On the slave: Replicate_Ignore_DB: mysql Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: foo.% Replicate_Wild_Ignore_Table: On the master: USE mysql; CREATE PROCEDURE whatever() BEGIN END; _______________________________________________ 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

2 1

[Maria-discuss] Don't replicate procedures in the mysql database
by Игорь Пашев 31 Aug '16

31 Aug '16

Hi all, I'm using multi-source replication with "white list" options only: foo.replicate_wild_do_table = foo.% foo.replicate_ignore_table = foo.beep foo.replicate_ignore_table = foo.tmp The masters are writing row-based binary logs as is (no filtering at masters). This works almost as expected: only the `foo` database gets updates, the mentioned tables are ignored. The `mysql` database does not get updates, even when I run GRANT / REVOKE on the masters quite often. But when I create a procedure on the master it get propagated to the slave: When I execute `CREATE PROCEDURE mysql.bar` on the master, this procedure appears on the slave. How could I avoid that? Did I miss some options? Is this a bug?

4 5

[Maria-discuss] New Question: MONyog Cluster Monitoring
by AskMonty KB 31 Aug '16

31 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/monyog-cluster-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to see all the monitoring information for galera cluster together..for eg In charts we get collected information of all the nodes of a cluster? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-cluster-monitoring/

1 0

[Maria-discuss] optimize table wait table level lock in MairaDB 10.1.16 ?
by Ljr Yang 31 Aug '16

31 Aug '16

Hi, all Today, we use optimize table in MariaDB 10.1.16. Table test01 have about 2 millions records. session 1: optimize table test01; session 2: select count(*) from test01 ; when session 1 run, In processlist session 2 state: Waiting FOR TABLE LEVEL LOCK we had set innodb_defragment=1 in my.cnf ,but run optimize table still have table lock？ reference link: https://mariadb.com/kb/en/mariadb/defragmenting-innodb-tablespaces/ -- Ljr

2 1

[Maria-discuss] MariaDB 10.1.17 and MariaDB Galera Cluster 10.0.27 now available
by Daniel Bartholomew 30 Aug '16

30 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.17 and MariaDB Galera Cluster 10.0.27. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.17 - Release Notes: https://mariadb.com/kb/en/mdb-10117-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10117-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.17 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 Galera Cluster 10.0.27 - Release Notes: https://mariadb.com/kb/en/mgc-10027-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10027-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.27/ About MariaDB Galera Cluster: - https://mariadb.com/kb/en/about-mariadb-galera-cluster/ - - 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] geo replication?
by l vic 29 Aug '16

29 Aug '16

Is replication between different data centers supported in MariaDB and is it supported in open source version, or in enterprise only? Thank you, -V

4 4

[Maria-discuss] Reg custom port for maxscale binlog router
by Karthick Subramanian 29 Aug '16

29 Aug '16

Hi all, When I try to configure maxscale for binlogrouter, I noticed that documentation examples using port as 5308. When I try to configure similarly, it says, 111 connection refused or unable to connect master from maxscale. I have enabled the port in centOs7 using firewalld on both master server as well maxscale server: firewall-cmd --add-port=5308/tcp But still,I couldn't able to establish connection from maxscale server to mariadb server(master): mysql -u maxscaleoper -h ip:ip:ip:ip --port 5308 -p ERROR 2003 (HY000): Can't connect to MySQL server on 'ip:ip:ip:ip' (111 "Connection refused") Can anyone please help me on how to resolve this error. Because of this error, I couldn't make maxscale up and running. Regards, Karthick S

2 2

Re: [Maria-discuss] Don't replicate procedures in the mysql database
by Federico Razzoli 29 Aug '16

29 Aug '16

You should keep those procedures in a different database, not mysql. Then you can avoid replication with replication filters: https://mariadb.com/kb/en/mariadb/selectively-skipping-replication-of-binlo… But first, be sure you understand what happens when you call the procedure on the master. Federico -------------------------------------------- Lun 29/8/16, Игорь Пашев <pashev.igor(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql database A: "Daniel Black" <daniel.black(a)au1.ibm.com> Cc: "MariaDB discuss" <maria-discuss(a)lists.launchpad.net> Data: Lunedì 29 agosto 2016, 15:44 2016-08-29 1:25 GMT+03:00 Daniel Black <daniel.black(a)au1.ibm.com>: > A question for you is why is it important not to have it on the slave? Because the slave already has this procedure with a slightly different implementation, and different owner (definer). > If the slave is a failover it should have the procedure. If I wanted a failover server I would not be fiddling with replication options and channels at all. >> When I execute `CREATE PROCEDURE mysql.bar` on the master, this >> procedure appears on the slave. > > Which is what replication is meant to do. This is not consistent with creating and modifying mysql users. That's why I'm asking. > Its probably also best not to populate the mysql database with your > stored procedures. It's totally fine for maintenance procedures. See for example http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.MySQL.SQLRef… > set session sql_log_bin=0; create procedure... This is not scalable and sometime impossible: for the SUPER privilege, at Amazon RDS, it could break other slaves. _______________________________________________ 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

1 0

[Maria-discuss] howto get MariaDB T-Shirts and Hoodies?
by Lukas Lehner 29 Aug '16

29 Aug '16

Hi I have lots (> 10) of MongoDB T-Shirts, but I prefer to run MariaDB. Howto get cool MariaDB Shirts and Hoodies? Witch a search engine I found only "Support MariaDB" products (CafePress). That's not my taste :-( thanks Lukas

2 1

[Maria-discuss] When using the getGeneratedKeys() method the keys are returned, but in which order?
by Péter Éberhardt 26 Aug '16

26 Aug '16

Hi, I want to insert multiple records into a table using one statement like this through jdbc: INSERT INTO demo (name) VALUES ('Jeff'),('Jones'),('Agnes'),...,('Wolfgang'); Then I want to get the generated ids with the getGeneratedKeys() method and match them to the inserted records but how can I be sure the method gives the ids in the same order as I listed the records in the statement? I can't find any related information in the documentation just the fact the method gives back those ids. DDL: CREATE TABLE demo (id bigint primary key auto_increment , name text); If this information would put into the document also then I can go with my implementation on this way. Thanks, Peter

3 4

[Maria-discuss] New Question: Locking/deadlocking on temp tables?
by AskMonty KB 26 Aug '16

26 Aug '16

Hello, A new question has been asked in "MariaDB Knowledge Base" by WebtrendsData. Please answer it at http://mariadb.com/kb/en/lockingdeadlocking-on-temp-tables/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello - I am coming up to speed on MariaDB, I have a MS Sql Server and Hadoop background but we are starting to use MariaDB heavily. We have some queries that hit tables with mediumtext datatype columns. My understanding is these types of queries will always generate temp tables directly to disk (because of the text/blob types). I've confirmed our temp table engine is Aria. >From what I've read, in the mysql world, this situation would end up with a MyIsam table on disk, which does not have row locking, only table locking. I've tried looking for info on how Aria tables would handle this as I suspect we are getting deadlocks on these tables. Our application is reporting many database deadlocks, our entire database is all ExtraDB tables, yet SHOW ENGINE INNODB STATUS does not report any deadlocks, which leads me to think it is the temp tables. So I guess my question is, does the Aria engine do row locking? Is it possible to get a status similar to SHOW ENGINE INNODB STATUS? Please forgive me if this is painfully obvious or unclear (I'm still learning!), and thank you for your time. -Aaron -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/lockingdeadlocking-on-temp-tables/

5 7

Re: [Maria-discuss] Backporting bug fixes to 1.0?
by Justin Swanhart 26 Aug '16

26 Aug '16

Thanks for your armchair diagnosis, but I'm not "striking out" at anybody. I'm outraged by the behavior of MariaDB. I'm passionate about open source, since my whole life has been spent on it. I joined because the company is open source. What I found after I joined was a total lack of regard for it, and a lack of ethics. Would YOU knowingly ask a customer to install software with known vulnerabilities reported ten years ago? Would you ship open source that doesn't compile? Would you extort your current users of your product for bug fixes? If you answered yes to those questions then you don't have ethics either. --Justin Sent from my iPhone On Aug 25, 2016, at 1:15 AM, Jan Steinman <Jan(a)EcoReality.org> wrote: >> On 2016-08-24, at 06:22, Justin Swanhart <greenlion(a)gmail.com> wrote: >> >> I'm bipolar > > Seems more like Borderline to me. Bipolars generally don’t strike out at others as much as you are doing. > > Jan Steinman > EcoReality Co-op, http://www.EcoReality.org > 2152 Fulford-Ganges Road > Salt Spring Island, BC V8K 1Z7 CANADA > +1 250.653.2024 > > >

1 1

[Maria-discuss] ibdata1 file grow quickly in MariaDB 10.1 ?
by Ljr Yang 26 Aug '16

26 Aug '16

Hi, All we use MariaDB 10.1.16 , about have 30 machines. Recently ,there one master and slave's ibdat1 growed to about 4GB, others machine are normal. mainly parameter in my.cnf : innodb_data_home_dir = /data/mysql/data innodb_data_file_path = ibdata1:2G:autoextend innodb_log_files_in_group=3 innodb_log_file_size = 1G innodb_undo_logs=128 innodb_undo_tablespaces=4 innodb_file_per_table= 1 ls -l /data/mysql/data -rw-r--r-- 1 mysql mysql 4429185024 Aug 25 21:38 ibdata1 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 21:38 ib_logfile0 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 21:38 ib_logfile1 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 20:13 ib_logfile2 -rw-r--r-- 1 mysql mysql 616562688 Aug 25 21:36 undo001 -rw-r--r-- 1 mysql mysql 411041792 Aug 25 21:27 undo002 -rw-r--r-- 1 mysql mysql 708837376 Aug 25 21:34 undo003 -rw-r--r-- 1 mysql mysql 981467136 Aug 25 21:34 undo004 Today, when found the problem, there are not some big transaction in show processlist. We guess ibdata1 had growed to 4GB in previous some time, but we want to know how confirm the cause and shrink ibdate1 file ? Thank . -- Ljr

2 1

[Maria-discuss] MariaDB 10.0.27 now available
by Daniel Bartholomew 25 Aug '16

25 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.27. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.27 - Release Notes: https://mariadb.com/kb/en/mdb-10027-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10027-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.27 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/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: Maria DB Account Deletion
by AskMonty KB 25 Aug '16

25 Aug '16

Hello, A new question has been asked in "MariaDB Community" by tomibic. Please answer it at http://mariadb.com/kb/en/maria-db-account-deletion/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi there, Does anybody know how to delete one's MariaDB account? Help would be really appreaciated! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-account-deletion/

1 0

[Maria-discuss] Spider Engine
by Suresh Rajagopal 24 Aug '16

24 Aug '16

Hi, I am looking for some references for Spider Engine in production. Any known issues/recommendations for setup ? ThanksSuresh Rajagopal

2 2

[Maria-discuss] Backporting bug fixes to 1.0?
by Justin Swanhart 24 Aug '16

24 Aug '16

I have created a GitHub fork of MaxScale which does not include the 2.0 branch. The repository is called GPLScale. There is a big potential problem with this. Take for example the file server/core/utils.c, which now has a new license: https://github.com/mariadb-corporation/MaxScale/blob/2.0/server/core/utils.c This file WAS covered under GPL: https://github.com/mariadb-corporation/MaxScale/blob/cb3213af6382c380df9fc4… When there is a bugfix in 2.0 for server code that existed in 1.0, can that code be backported directly into GPLscale? a) util.c in 2.0 is clearly derivative of 1.0, and is therefore a derivative work of 1.0 and therefore still covered by GPL and b) there is a "violation" of GPL, because 1.0 GPL code is being linked against code covered by an incompatible license (other code in MaxScale). Almost all of the files in MaxScale 2.0 derive from 1.0 so this problem is not just in one file of course. The FSF says that the owner of the software can't legally violate the GPL they can morally violate the GPL. Will MariaDB commit to backporting all bugs in 1.0 code into the 1.0 branch?

2 4

Re: [Maria-discuss] Backporting bug fixes to 1.0?
by Federico Razzoli 24 Aug '16

24 Aug '16

Thank you for expressing your honest opinions about the MySQL/MariaDB ecosystem. Best wishes for your next job and your open source projects. Federico -------------------------------------------- Mer 24/8/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Backporting bug fixes to 1.0? A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 agosto 2016, 14:21 I have been fired for speaking out about the GPL and MariaDB actions that have caused great harm to our ecosystem. It has been pointed out that I have a non-compete agreement. None of my tools compete with MariaDB and I have no non-public knowledge of MariaDB technology. GPLScale remains free software under the GNU GPL license and it is my right to fork a github repo. I am not paid to work on GPLScale and I don't intend to get paid to maintain it by anyone. All my projects are labors of love. Who wants to hire me? I'm dedicated, honest, open, and I have integrity. I'm willing to risk everything for what I believe in. Email me at:greenlion at gmail dot com ---- I have been a proponent of GPL for a long time, and I don't need publicity.http://swanhart.livejournal.com/128586r.html https://libraries.io/github/greenlion https://blog.jcole.us/2008/07/23/on-mysql-forks-and-mysqls-non-open-source-… Swanhart on July 23, 2008 at 12:09Brian, The “thing is” that we shouldn’t have to write it. MySQL may be ‘open source’, but it isn’t ‘open software’. With all the talk recently of proprietary extensions, the documentation licensing issues, the whole ‘enterprise’ vs ‘community’ debacle, well, MySQL has totally shown that they are not ‘Open Software’ company. WHEN I WAS SEVENTEEN I BROKE THE LAW AND DROVE FROM PITTSBURGH PA TO BOSTON MA FOR THE FIRST FREE SOFTWARE FOUNDATION CONFERENCE. I sat down and had breakfast with STALLMAN, TORVALDS, AND RAYMOND! My whole life is open source. I've made my living off it and I intend to make sure others have the same opportunities that I have. Sent from my iPhone On Aug 18, 2016, at 9:51 AM, Justin Swanhart <greenlion(a)gmail.com> wrote: I have created a GitHub fork of MaxScale which does not include the 2.0 branch. The repository is called GPLScale. There is a big potential problem with this. Take for example the file server/core/utils.c, which now has a new license: https://github.com/mariadb-corporation/MaxScale/blob/2.0/server/core/utils.c This file WAS covered under GPL: https://github.com/mariadb-corporation/MaxScale/blob/cb3213af6382c380df9fc4… When there is a bugfix in 2.0 for server code that existed in 1.0, can that code be backported directly into GPLscale? a) util.c in 2.0 is clearly derivative of 1.0, and is therefore a derivative work of 1.0 and therefore still covered by GPL and b) there is a "violation" of GPL, because 1.0 GPL code is being linked against code covered by an incompatible license (other code in MaxScale). Almost all of the files in MaxScale 2.0 derive from 1.0 so this problem is not just in one file of course. The FSF says that the owner of the software can't legally violate the GPL they can morally violate the GPL. Will MariaDB commit to backporting all bugs in 1.0 code into the 1.0 branch? -----Segue allegato----- _______________________________________________ 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

1 0

[Maria-discuss] New Question: Prepared statements support in MariaDB
by AskMonty KB 23 Aug '16

23 Aug '16

Hello, A new question has been asked in "Does MariaDB support..." by Sibin.. Please answer it at http://mariadb.com/kb/en/prepared-statements-support-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Can you please tell me if MariaDB supports Prepared statements (related instrumentation were added in MySQL-5.7.4)? If not, then please tell me in which MariaDB version support for prepared statements will be added ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/prepared-statements-support-in-mariadb/

1 0

[Maria-discuss] New Question: How to use Maxscale for maximum reliability?
by AskMonty KB 22 Aug '16

22 Aug '16

Hello, A new question has been asked in "MaxScale Routers" by patrik_63236. Please answer it at http://mariadb.com/kb/en/how-to-use-maxscale-for-maximum-reliability/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to use Maxscale in front of a Galera cluster. Performance is not an issue. The reason I'm using it is so that I can take down a node for maintenance and upgrades without downtime. But I'm not sure how to achieve this. When I run m my tests I get failures. I suspect that the problem occurs when Maxscale writes to one node and then immidiately tries to read that data from another node. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-use-maxscale-for-maximum-reliability/

1 0

[Maria-discuss] New Question: Connectin Excel with MariaDB
by AskMonty KB 22 Aug '16

22 Aug '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by alejandro_reyna_g. Please answer it at http://mariadb.com/kb/en/connectin-excel-with-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello ! A Question from a begginer. I have been trying to connect Excel 2007 with MariaDB. 1) I downloaded the latest ODBC connector. 2) I created in Windows a new ODBC connection fron the control panel 3) From excel I created selected the connection and I can only see the TEST and PERFORMANCE_SCHEMA Databases. I don´t see any of my DataTables. What could be happening? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connectin-excel-with-mariadb/

1 0

[Maria-discuss] New Question: MONyog ssh authentication using private key
by AskMonty KB 19 Aug '16

19 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/monyog-ssh-authentication-using-private-key/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- When we configure the ssh connection and we choose the key based authentication method we have to copy paste the private ssh keys...IS there any other way to get the private key or authenticate by giving the public key...something like that?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-ssh-authentication-using-private-key/

1 0

[Maria-discuss] New Question: MONyog SNMP Traps
by AskMonty KB 19 Aug '16

19 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/monyog-snmp-traps/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- When we are sending the traps seems like the tags are not present in the raw data. Also the server name is the name which we give rather than the actual host name.. Is it possible to add tags and get the original host via SNMP traps?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-snmp-traps/

1 0

[Maria-discuss] Query the list of dynamic variables
by Игорь Пашев 19 Aug '16

19 Aug '16

If there are way to query the list of dynamic variables, e. i. variables that can be changed globally without restarting the server?

2 2

[Maria-discuss] maxscale 2.0 bug fixes
by Federico Razzoli 18 Aug '16

18 Aug '16

Hi all I see that MaxScale 2.0 will not be open source until 2009.01.01. I have some questions. 1) I expect next releases to fix bugs, including critical and security bugs. When will these versions be open source? 2) At some point MaxScale 2.0 will be open and 3.0 will be released but not open. When a software exists in both an open and a closed source, I expect the open form to be low-quality. This applies to all examples I can think of. I will feel a bit better if you could explain why you will maintain 2.0 for a reasonable number of years. 3) From my understanding part of MariaDB code belongs to Oracle, thus cannot be closed-sourced by you. But what about connectors and some storage engines? Do you plan to change their license? Thanks in advance for your answers. Federico

5 4

Re: [Maria-discuss] maxscale 2.0 bug fixes
by Federico Razzoli 17 Aug '16

17 Aug '16

Hi Kaj Yes you did answer all my questions. Thanks for that. I disagree about point 2, precisely the "reasonable number of years" a server software should be supported. Even if a software is very old (say MySQL 5.0 for example) it is very possible that new security holes are found. That's why customers using servers/versions which reached their EOL should definitely upgrade to a more recent version. (yes there are exceptions, but I'm talking about the general case) Let's get back to your example: on 2019.01.02 MaxScale 3.0 could be out and GA. Should we expect the typical user to be ready to upgrade? Based on my experience, definitely not. They need time to decode, plan, test, etc. The possibility that 2.0 will be discontinued (or almost discontinued) immediately after the Change Date is scary, and your answer doesn't provide any guarantees that this won't happen. So, as much as I appreciate your honest answers, and as much as I like the software itself, I am seriously concerned. And also, let me add that I don't like to use a software that is not (yet) open source. I totally understand the problems explained by Monty in his blog post, but I don't like the solution you've found. However I am glad to hear that you don't have plans to do the same changes to connectors and storage engines. If I may give an advice, maybe the Foundation should officially "protect" that software to dissipate any doubt. Regards, Federico -------------------------------------------- Mer 17/8/16, Kaj Arnö <kaj(a)mariadb.com> ha scritto: Oggetto: Re: maxscale 2.0 bug fixes A: "Federico Razzoli" <federico_raz(a)yahoo.it>, maria-discuss(a)lists.launchpad.net Data: Mercoledì 17 agosto 2016, 20:23 Hi Federico, Thank you for your questions. Wed, 17 Aug 2016 08:15:33 +0000 (UTC) Federico Razzoli <federico_raz(a)yahoo.it>:Hi all I see that MaxScale 2.0 will not be open source until 2009.01.01. I have some questions. 1) I expect next releases to fix bugs, including critical and security bugs. When will these versions be open source? 1. Fixes to 2.0 will be in 2.0.1, 2.0.2, 2.0.3 and so on. All of these will become "GPLv2 or later" on 2019-01-01. 2) At some point MaxScale 2.0 will be open and 3.0 will be released but not open. When a software exists in both an open and a closed source, I expect the open form to be low-quality. This applies to all examples I can think of. I will feel a bit better if you could explain why you will maintain 2.0 for a reasonable number of years. 2. At some point (say: 2019-01-02), MaxScale 2.0 will be "GPLv2 or later", but another release (say: MaxScale 2.1 or MaxScale 3.0) will not yet be "GPLv2 or later" but still BSL, correct. MaxScale 2.0 will by then have gone through a list of bug fix releases. I don't expect there to be many bugs left in the MaxScale 2.0 code on 2019-01-02. In a way, what I am saying is that the period until the Change Date is already "a reasonable number of years". What the *exact* situation is on 2019-01-02 depends on how many new releases we will have by then. At any rate, we want to grow the user base of MaxScale. We are interested in large-scale adoption. There won't be much adoption if we don't fix bugs for a "reasonable number of years". All in all, on 2019-01-02, MaxScale 2.0 will be bug-wise of high quality and the only reason to use 2.1 (or 3.0 or whatever) instead of 2.0 will be the added functionality on top of what 2.0 has. So MariaDB Corporation has a high motivation to add desirable functionality. 3) From my understanding part of MariaDB code belongs to Oracle, thus cannot be closed-sourced by you. But what about connectors and some storage engines? Do you plan to change their license? 3. Correct, MariaDB Server cannot be closed sourced by us. We have no current plans for changing licenses of any connectors or storage engines. Thanks in advance for your answers.Federico Did this answer your questions? Kaj-- Kaj Arnö, Chief of Staff MariaDB Corporation

1 0

[Maria-discuss] New Question: Range of values for INT
by AskMonty KB 17 Aug '16

17 Aug '16

Hello, A new question has been asked in "Data Types" by cay_mia_g. Please answer it at http://mariadb.com/kb/en/range-of-values-for-int/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I believe the note for INT above: Integer from -2147483648 to 2147483648 signed Should be corrected to: Integer from -2147483648 to 2147483647 signed -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/range-of-values-for-int/

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.51 & Connector/J 1.5.1 now available
by Daniel Bartholomew 17 Aug '16

17 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.51 Stable (GA), and MariaDB Connector/J 1.5.1 Release Candidate (RC). See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.51 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mgc-5551-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5551-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.51 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.5.1 RC - Release Notes: https://mariadb.com/kb/en/mcj-151-rn/ - Changelog: https://mariadb.com/kb/en/mcj-151-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.1/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - 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: MONyog ssh authentication using key
by AskMonty KB 17 Aug '16

17 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/monyog-ssh-authentication-using-key/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have monyog installed on server a and mariadb on server b. When i give the key for ssh connection on a user on b it gives me error "Could not get private key:access denied. What is this error and why do we have to give private key?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-ssh-authentication-using-key/

1 0

Re: [Maria-discuss] Semi-sync replication hangs when changing binlog filename.
by Joseph Glanville 16 Aug '16

16 Aug '16

Hi Pavel. Yes, by "binlog filename changes" I mean the master begins writing to a new binlog file. Output of all the requested commands are in this gist: https://gist.github.com/josephglanville/7b96c34bb6e79ace33e56627672b98a5 Joseph Glanville Sent from Polymail<https://polymail.io/?utm_source=polymail&utm_medium=referral&utm_campaign=s…> On Fri, 29 Jul 2016 at 3:08 PM Pavel Ivanov <Pavel Ivanov <mailto:Pavel%20Ivanov%20<pivanof(a)google.com>> > wrote: By "binlog filename changes" you mean when master starts writing binlogs into a new file? Can you clarify how the replication stalls? What "show processlist" shows at that time on master and on slave? What does "show slave status" show on the slave? On Thu, Jul 28, 2016 at 10:03 PM, Will Fong wrote: > Hi Joseph, > > On Fri, Jul 29, 2016 at 10:11 AM, Joseph Glanville wrote: >> However whenever the binlog filename changes the replication stalls >> indefinitely. > > Interesting! I may have reproduced this, but it was only a quick test. > Let me (or someone else) dig into this more. > > Thanks for reporting this. > -will > > > -- > Will Fong, Senior Support Engineer > MariaDB Corporation > > _______________________________________________ > 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

4 16

Re: [Maria-discuss] can we use load data infile from moving a database to a 4 node cluster
by Guillaume Lefranc 16 Aug '16

16 Aug '16

unfortunately no, you can't do that. your cluster needs to be empty. Maybe have a look at mydumper/myloader that has parallel dump and restore capabilities? Regards GL On Tue, Aug 16, 2016 at 10:30 AM bbnlaccts acnts <bbnlaccts(a)gmail.com> wrote: > Thanks for the help Guillaume, > Can we take a snapshot of a standalone database and run against a cluster > which already has many other databases running on it ? > > Also an u please do point me to a link which talks about this methodology. > > Please do let me know > > Thanks in advance for helping out. > > Arun > > > On Tue, Aug 16, 2016 at 1:51 PM, Guillaume Lefranc < > guillaume.lefranc(a)mariadb.com> wrote: > >> Hi Arun, >> >> Galera requires only InnoDB tables, so the fastest way would be to take >> an Xtrabackup snapshot of your MariaDB 10 standalone database, restore it >> on one node of the Galera cluster and then turn on the 3 other nodes. >> >> Of course LOAD DATA INFILE is supported by Galera, but it would be slower. >> >> On Tue, Aug 16, 2016 at 9:55 AM bbnlaccts acnts <bbnlaccts(a)gmail.com> >> wrote: >> >>> Hi, >>> I am planning on moving a mariadb 10 database to a 4 node galera cluster. >>> Since the db is kind of big with around 40 gigs capacity and i am >>> getting very less maintenance window to complete this activity. >>> Hence planning on using load data infile on alll the big tables. >>> >>> Can anybody please do let me know if i am going to see any >>> drawbacks/bugs in this concept. >>> Are there any precautionary measures i need to take in order to >>> accomplish this task. >>> >>> Your help is greatly appreciated >>> >>> Thanks >>> Arun >>> _______________________________________________ >>> 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 >>> >> -- >> Guillaume Lefranc >> Remote DBA Services Manager >> MariaDB Corporation >> > > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation

1 0

[Maria-discuss] can we use load data infile from moving a database to a 4 node cluster
by bbnlaccts acnts 16 Aug '16

16 Aug '16

Hi, I am planning on moving a mariadb 10 database to a 4 node galera cluster. Since the db is kind of big with around 40 gigs capacity and i am getting very less maintenance window to complete this activity. Hence planning on using load data infile on alll the big tables. Can anybody please do let me know if i am going to see any drawbacks/bugs in this concept. Are there any precautionary measures i need to take in order to accomplish this task. Your help is greatly appreciated Thanks Arun

2 1

[Maria-discuss] Regarding Automatic fail-over - Maxscale
by Karthick Subramanian 16 Aug '16

16 Aug '16

Hi All, Can anyone help me to figure out this. I am planning to use Binlogrouter for replication (single master and single slave topology). I read from google forums for maxscale that with binlog router, it'snot possible to use automatic failover. Did anyone try this. >From google forum ( https://groups.google.com/forum/#!msg/maxscale/DnFT4eb0BbQ/cHQ3TLEfBAAJ;con… ) "With the 1.3.0 version of MaxScale, the binlogrouter accepts STOP SLAVE, START SLAVE and CHANGE MASTER TO ... commands. These can be used to change the master server but automating this process with the repmgr is not currently possible. Since the binlogrouter supports the normal slave management commands, using something like MHA could be possible: https://code.google.com/p/mysql-master-ha/ " Could anyone help me to understand whether I can use binlog router along with automatic failover feature using maxscale. I have read this blog using shell script we can achieve, but not sure whether with binlog router, it ll work? ( https://mariadb.com/blog/mariadb-automatic-failover-maxscale-and-mariadb-re… ) Regards, Karth

2 2

[Maria-discuss] replication failing to recover due to HA_ERR_KEY_NOT_FOUND
by bbnlaccts acnts 16 Aug '16

16 Aug '16

Hi, I am trying to set up a master slave replication between 2 servers running mariadb 10 on centos 6.7 In the initial setup itself i keep getting HA_ERR_KEY_NOT_FOUND. I have tried all methodology based on my novice knowledge ro rectify but in vain. i am new to this env. Any help will be greatly appreciated. - Server version 10.0.23-MariaDB-log - Protocol version 10 - UNIX socket /var/lib/mysql/mysql.sock. The scenario I have followed is this: 1. Shut the prod (mc1), took a cold backup and restored on slave (mc2). 2. On master ran show master status; prodarchivedlogs-bin.000001 and the pos as 582240 3. Set these info in slave. 4. Started the slave, it started throwing up error: 160812 3:31:50 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table radius1.radacct; Can't find record in 'radacct', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log prodarchivedlogs-bin.000001, end_log_pos 587695, Gtid 0-1-79, Internal MariaDB error code: 1032 160812 3:17:18 [Warning] Slave: Can't find record in 'radacct' Error_code: 1032 160812 3:17:18 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'prodarchivedlogs-bin.000001' position 587072 I have tried all methods based on my knowledge, but it is just not functioning. I tried using mysqlbinlog tool to extract to a file and then tried inserting, even then it is failing. Any help will be greatly appreciated. The prod my.cnf is as follows symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=1 The slave my.cnf is as follows skip-name-resolve skip-slave-start datadir=/var/lib/mysql/data1 socket=/var/lib/mysql/mysql.sockuser=mysql symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=2

1 0

[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

[Maria-discuss] New Question: How to trace events status?
by AskMonty KB 03 Aug '16

03 Aug '16

Hello, A new question has been asked in "Events" by dzlsnw53r4_60336. Please answer it at http://mariadb.com/kb/en/how-to-trace-events-status/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I want to trace the events last results and fail events at 3 days, how can i do this? Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-trace-events-status/

1 0

[Maria-discuss] Orphaned TokuDB tables
by Rich Prohaska 02 Aug '16

02 Aug '16

Hello All, Sometimes, TokuDB gets left in a state where it thinks that parts of a table exist (as observed in TokuDB's file map), but not all of the underlying files (the TokuDB data files and/or the frm file) exist. This probably occurs due to the interaction between the non-transactional DDL that MySQL/MariaDB uses to create or drop tables, and the transactional TokuDB engine underneath. There is some bug there. So, what can one do to remove broken TokuDB file maps? There is an internal fractal tree called the tokudb.directory that names high level data names to an underlying file that the data is stored in. The tokudb_file_map information schema dumps out the contents of this tree. The key to this tree is the high level data name (called a dname). In TokuDB, this data name consists of the database name, the table name, and the index name. There is also a tree for the table (called status) that contains table wide metadata. I added the tokudb_delete_dnames_from_directory tool to the https://github.com/prohaska7/mariadb-server/tree/fix-tokudb-filemap branch. This standalone tool can be used to delete dnames from the tokudb.directory. Standalone means that MariaDB must have been previously shutdown cleanly (which puts the tokudb recovery logs in a nice clean state so that the tool does not have to run crash recovery). The input to the tool is the MariaDB data directory with nice and clean tokudb recovery logs along with a sequence of dname's. The tool transactionally deletes rows from the tokudb.directory fractal tree, which updates the recovery logs. Building the tool requires a MariaDB build environment a simple compile sequence something like this: gcc -g -o tokudb_delete_dnames_from_directory tokudb_delete_dnames_from_directory.cc -I$TFT/buildheader -L$TFT/src -ltokufractaltree Running the tool looks something like this: Get the dnames of interest from the tokudb_file_map. In this case, they are ./test/s-main and ./test/s-status. shutdown MariaDB ./tokudb_delete_dnames_from_directory ~/projects/mariadb-server-install/data ./test/s-main ./test/s-status

2 2

[Maria-discuss] New Question: Missing CentOS7 RPM: MariaDB-10.1.16-centos7-x86_64-cassandra-engine.rpm?
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by justin.w.calloway_60714. Please answer it at http://mariadb.com/kb/en/missing-centos7-rpm-mariadb-10116-centos7-x86_64-c… as the person asking the question may not be subscribed to the mailing list. -------------------------------- It appears the rpm for the Cassandra storage engine is not available in your repository for centos7 or rhel7. The package exist in in centos 6 repository but not 7, is this on purpose? Is the Cassandra storage engine supported on CentOS7? Example of Cassandra storage engine rpm in the CentOS6 repo: http://yum.mariadb.org/10.1/centos6-amd64/rpms/ Example of the CentOS7 repo not containing the Cassandra storage engine rpm: http://yum.mariadb.org/10.1/centos7-amd64/rpms/ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/missing-centos7-rpm-mariadb-10116-centos7-x86_64-c…

1 0

[Maria-discuss] New Question: MONyog Monitoring
by AskMonty KB 02 Aug '16

02 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/monyog-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is MONyog capable of monitoring INNODB table locks and mutex locks?? Also can it monitor binary logs of MariaDB database.?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-monitoring/

1 0

[Maria-discuss] New Question: MONyog Table Alert
by AskMonty KB 02 Aug '16

02 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/monyog-table-alert/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i set up an alert for all the tables in all databases if they grow more than specified size ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-table-alert/

1 0

[Maria-discuss] Semi-sync replication hangs when changing binlog filename.
by Joseph Glanville 29 Jul '16

29 Jul '16

Hi, I am using semi-sync replication with the `rpl_semi_sync_master_timeout` set to a very high value to ensure commits aren't committed on the master unless they have been replicated to the slave. However whenever the binlog filename changes the replication stalls indefinitely. A trace of this interaction between the master and the semi-sync slave is here: https://gist.github.com/josephglanville/e87ae96b9be9125427b58cd3a43d5c1e The semi-sync settings I have configured on the master are: rpl_semi_sync_master_wait_point = "AFTER_SYNC" rpl_semi_sync_master_timeout = 18446744073709551615 # effectively infinite as we don't want to fallback to async repl rpl_semi_sync_master_enabled = 1 rpl_semi_sync_master_wait_no_slave = 1 # don't allow writes if slave isn't connected Up until the binlog filename change everything works as expected. Anyone have any ideas on how to fix the problem or is this a bug in semi-sync replication? Joseph.

3 3

[Maria-discuss] Orphaned TokuDB tables
by Reinis Rozitis 29 Jul '16

29 Jul '16

Hello, tldr - Is there a way (similarly as with the InnoDB workaround of DROP TABLE `#mysql50##sql-..') to delete an orphaned TokuDB table (and/or clean the information_schema.tokudb_file_map)? Or should I address this to Percona/Toku people? The long version: I have noticed on one db instance (currently running 10.0.26) and orphaned table (no idea how it got there): ls -la /data/mysql/db/ -rw-r----- 1 mysql mysql 1114 Jul 29 01:41 #sql-6f2d_9.frm -rw-r----- 1 mysql mysql 908 Jul 29 01:41 #sql-6f2d_9.par Also: MariaDB [(none)]> SELECT * FROM information_schema.tokudb_file_map limit 10; +--------------------------------+-----------------------------------------------------+--------------+------------+-----------------------+ | dictionary_name | internal_file_name | table_schema | table_name | table_dictionary_name | +--------------------------------+-----------------------------------------------------+--------------+------------+-----------------------+ | ./db/#sql-6f2d_9#P#p1-key-aid | ./_db_sql_6f2d_9_P_p1_key_aid_1734_2_1b_B_0.tokudb | db | #sql | 6f2d_9#P#p1-key-aid | | ./db/#sql-6f2d_9#P#p1-main | ./_db_sql_6f2d_9_P_p1_main_1734_2_1b_B_1.tokudb | db | #sql | 6f2d_9#P#p1-main | | ./db/#sql-6f2d_9#P#p1-status | ./_db_sql_6f2d_9_P_p1_status_1609_1_1b.tokudb | db | #sql | 6f2d_9#P#p1-status | .... While I can DROP the table: MariaDB [db]> drop table `#mysql50##sql-6f2d_9`; Query OK, 0 rows affected, 1 warning (3.99 sec) And even physically delete the ./_db_sql_6f2d_9_P* files from the root datadir it never disappears from the information_schema tables. It doesn't seem to currently affect anything but I wanted to know if maybe there is a workaround or other ways to rebuild to Toku directory (without dumping/reimporting the whole database). rr

2 2

[Maria-discuss] Crash when adding a column to a very large table
by Mark Wadham 27 Jul '16

27 Jul '16

Hi, MariaDB 10.1.16 with a 3-node galera cluster. We had 187GB free disk space and had the gcache set to 800GB. We started firing write traffic at the cluster and then began testing the process of performing DDL on a single node in RSU mode. Our command was a single ALTER TABLE statement that added a column to a ~160GB table. While this was occurring we were firing around 20GB/hour of write traffic at the cluster which was being collected in the gcache for catchup after the node completed the DDL. At around 3h 45min into the DDL process the node performing it crashed with an error indicating it was unable to write to a temporary ibdata file. There was still plenty of disk space available. Full crash log is below, if anyone can shed light on this we'd be very grateful. My own research so far suggests that the problem is because the ALTER TABLE statement inserts all of the rows into the newly rebuilt table at once, effectively requiring a rollback to be created for every row in the table and this is just too much for *some limit* that I haven't worked out yet. I saw a suggestion[1] to increase the number of ibdata files but this doesn't really make sense to me given that we have two and the second one is set to autoextend. It's a very slow debug process so I'd like to get a reasonable idea of what happened here before starting another test run. Thanks, Mark [1] http://dba.stackexchange.com/questions/68319/mysql-index-creation-failing-o… -------------------- 2016-07-27 8:45:59 140258863733504 [Note] InnoDB: Online DDL : Start 2016-07-27 8:45:59 140258863733504 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files 2016-07-27 9:42:23 140258863733504 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files 2016-07-27 9:42:23 140258863733504 [Note] InnoDB: Online DDL : Start merge-sorting index `PRIMARY` (1 / 4), estimated cost : 14.7886 2016-07-27 9:42:23 140258863733504 [Note] InnoDB: Online DDL : merge-sorting has estimated 72714 runs 2016-07-27 11:47:05 140258863733504 [Note] InnoDB: Online DDL : End of merge-sorting index `PRIMARY` (1 / 4) 2016-07-27 11:47:05 140258863733504 [Note] InnoDB: Online DDL : Start building index `PRIMARY` (1 / 4), estimated cost : 22.1242 2016-07-27 12:26:52 7f908fbfdb00 InnoDB: Error: Write to file ./db/#sql-ib16588-3044794026.ibd failed at offset 54409560064. InnoDB: 1048576 bytes should have been written, only 991232 were written. InnoDB: Operating system error n2016-07-27 12:26:52 140258863733504 [Note] InnoDB: Online DDL : Completed 2016-07-27 12:26:53 7f908fbfdb00 InnoDB: Assertion failure in thread 140258863733504 in file handler0alter.cc line 137 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 160727 12:26:53 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.1.16-MariaDB key_buffer_size=33554432 read_buffer_size=16777216 max_used_connections=4 max_threads=770 thread_count=11 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 37895560 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x7ebbabfb9008 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f908fbfd180 thread_stack 0x48400 (my_addr_resolve failure: fork) /usr/sbin/mysqld(my_print_stacktrace+0x2b) [0x555e557caaab] /usr/sbin/mysqld(handle_fatal_signal+0x475) [0x555e55327ef5] /lib64/libpthread.so.0(+0xf100) [0x7f90982ce100] /lib64/libc.so.6(gsignal+0x37) [0x7f909663b5f7] /lib64/libc.so.6(abort+0x148) [0x7f909663cce8] /usr/sbin/mysqld(+0x734ff9) [0x555e55491ff9] /usr/sbin/mysqld(+0x736eec) [0x555e55493eec] /usr/sbin/mysqld(+0x3a4c24) [0x555e55101c24] /usr/sbin/mysqld(mysql_alter_table(THD*, char*, char*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool)+0x27f9) [0x555e5523dff9] /usr/sbin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x5d7) [0x555e5527f8b7] /usr/sbin/mysqld(mysql_execute_command(THD*)+0x140f) [0x555e551b533f] /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x28d) [0x555e551bd1ed] /usr/sbin/mysqld(+0x4602ec) [0x555e551bd2ec] /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1c63) [0x555e551bf673] /usr/sbin/mysqld(do_command(THD*)+0x16b) [0x555e551c023b] /usr/sbin/mysqld(do_handle_one_connection(THD*)+0x17f) [0x555e5527c74f] /usr/sbin/mysqld(handle_one_connection+0x47) [0x555e5527c8a7] /lib64/libpthread.so.0(+0x7dc5) [0x7f90982c6dc5] /lib64/libc.so.6(clone+0x6d) [0x7f90966fcc9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7ebb7102f020): is an invalid pointer Connection ID (thread ID): 212 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. We think the query pointer is invalid, but we will try to print it anyway. Query: alter table delivery_person add column boris int(11) null 160727 12:26:58 mysqld_safe Number of processes running now: 0 160727 12:26:58 mysqld_safe WSREP: not restarting wsrep node automatically 160727 12:26:58 mysqld_safe mysqld from pid file /mysql/data/galera0.pid ended

1 0

[Maria-discuss] Finicky syntax with RETURNING?
by Rhys.Campbell＠swisscom.com 27 Jul '16

27 Jul '16

Hello All, I'm having a bit of an issue with the RETURNING feature of DELETE<https://mariadb.com/kb/en/mariadb/delete/>. This was introduced in MariaDB 10.0.5. Specifically there seems to be an issue when using aliases with the RETURNING keyword. It involves a query like this. A user came to me with queries of this form that were running slowly. Here is the explain plan... EXPLAIN DELETE from t1 where id in (select id from t1 where acc_id = 9999) \G *************************** 1. row *************************** id: 1 select_type: PRIMARY table: t1 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4675 Extra: Using where *************************** 2. row *************************** id: 2 select_type: DEPENDENT SUBQUERY table: t2 type: unique_subquery possible_keys: XXXXXXXXXX key: PRIMARY key_len: 4 ref: func rows: 1 Extra: Using where 2 rows in set (0.00 sec) You can see it's being forced to run a table scan and run the subquery for each row. This was fixed by properly aliasing the query... EXPLAIN EXTENDED DELETE uc from t1 AS uc where uc. id in (select p. id from t2 p where p.acc_id = 9999) \G *************************** 1. row *************************** id: 1 select_type: PRIMARY table: p type: ref possible_keys: XXXXXXXXXXXXXXXXXXXXXXXX key: uk_XXXXXXXXXXXXXXXXXXXX key_len: 4 ref: const rows: 1 filtered: 100.00 Extra: Using index *************************** 2. row *************************** id: 1 select_type: PRIMARY table: uc type: ref possible_keys: XXXXXXXXXXXXXXXXXXX key: XXXXXXXXXXXXXX key_len: 4 ref: XXXXXXXXXXXXXX rows: 1 filtered: 100.00 Extra: 2 rows in set (0.00 sec) There now seems to be an issue when attempting to use the RETURNING keyword with this aliases version of the query. I have tried numerous versions of this query... EXPLAIN DELETE uc FROM t1 AS uc WHERE uc.id IN (SELECT p.id FROM t2 AS p WHERE p.account_id = 9999) RETURNING uc.some_id; EXPLAIN DELETE uc FROM t1 uc INNER JOIN t2 p ON uc.id = p.id WHERE p.acc_id = 9999 RETURNING some_id; All of these produce a SQL syntax error. I've tried a range of ways of writing this, using different joins, subqueries, with and without the AS keyword. The issues seems to be with aliases. The only version I can seem to get to work is this (note the removal of the aliases)... EXPLAIN DELETE FROM t1 WHERE id IN (SELECT id FROM t2 WHERE acc_id = 9999) RETURNING some_id; But then that creates the slow table scan problem again. Anyone have any experience of this? Cheers, Rhys

2 3

[Maria-discuss] New Question: Maria DB and Pro*C
by AskMonty KB 25 Jul '16

25 Jul '16

Hello, A new question has been asked in "MariaDB Connector/C" by Koyeli Roy. Please answer it at http://mariadb.com/kb/en/maria-db-and-proc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Is there any plugin/code convertor available to perform DB operations on maria DB from Pro*C code? I have a huge application written using C and Pro*C and I want to migrate to maria DB without changing the Pro*C layer or making very few changes in it. Thanks, Koyeli -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-and-proc/

1 0

[Maria-discuss] New Question: Cobol and Maria DB
by AskMonty KB 25 Jul '16

25 Jul '16

Hello, A new question has been asked in "MariaDB Connector/C" by Koyeli Roy. Please answer it at http://mariadb.com/kb/en/cobol-and-maria-db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Can I write a routine using C connector provided by Maria DB and call that routine from Cobol code? Will it work? If not , what do I need to do perform database operations on Maria DB from Cobol code. Thanks, Koyeli -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cobol-and-maria-db/

1 0