- discuss - lists.mariadb.org

[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