November 2016 - discuss - lists.mariadb.org

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 05 Dec '24

05 Dec '24

Binaries have been uploaded for both x86 and amd64 platforms. due to github file size limitations , the directories have been uploaded unarchived. for Win33 binaries , please checkout https://github.com/YannNayn/galera-mariadb-win32.git and for Win64(amd64) binaries (being uploaded/pushed): https://github.com/YannNayn/galera-mariadb-win64.git they are not recommended for a production environment. in the my.cnf file: _________ wsrep_provider=galera_smm.dll wsrep_sst_method=msqldump # percona xtrabackup will be tested soon _________ libevent and openssl(the provided binaries use respectively 2.1.3-alpha and 1.1.0-dev versions ) will be added next on github some limitations are stated on openssl website copied here for convenience: ____________ from http://www.openssl.org/ ____________ This software package uses strong cryptography, so even if it is created, maintained and distributed from liberal countries in Europe (where it is legal to do this), it falls under certain export/import and/or use restrictions in some other parts of the world. PLEASE REMEMBER THAT EXPORT/IMPORT AND/OR USE OF STRONG CRYPTOGRAPHY SOFTWARE, PROVIDING CRYPTOGRAPHY HOOKS OR EVEN JUST COMMUNICATING TECHNICAL DETAILS ABOUT CRYPTOGRAPHY SOFTWARE IS ILLEGAL IN SOME PARTS OF THE WORLD. SO, WHEN YOU IMPORT THIS PACKAGE TO YOUR COUNTRY, RE-DISTRIBUTE IT FROM THERE OR EVEN JUST EMAIL TECHNICAL SUGGESTIONS OR EVEN SOURCE PATCHES TO THE AUTHOR OR OTHER PEOPLE YOU ARE STRONGLY ADVISED TO PAY CLOSE ATTENTION TO ANY EXPORT/IMPORT AND/OR USE LAWS WHICH APPLY TO YOU. THE AUTHORS OF OPENSSL ARE NOT LIABLE FOR ANY VIOLATIONS YOU MAKE HERE. SO BE CAREFUL, IT IS YOUR RESPONSIBILITY. ________________________________________________ msvc 1600 redistributables SP1 need to be installed/available on the target machine: vcredist_x86.exe : http://www.microsoft.com/en-us/download/details.aspx?id=8328 vcredist_x64.exe : http://www.microsoft.com/en-us/download/details.aspx?id=13523 MSys binaries are provided and msqld.bat should then be used instead of mysqld.exe (e.g. mysld.bat --console --wsrep_cluster_address=gcomm:// ) in order to have a working sh shell(cygwin has been proved to do it as well) Please note that oqgraph is disabled (boost trunk is used , that is 1.55) Comments and suggestions are welcome.

3 2

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] Missing MariaDB Seal logos?
by Colin Charles 20 Mar '17

20 Mar '17

Hi! Visiting: https://mariadb.com/kb/en/mariadb/branding-guidelines/ You’ll note that the Powered by MariaDB badges still exist (https://mariadb.org/about/logos/) — they should really say Powered by MariaDB Server But what is missing are all the seal logos? Currently beyond the archives at Wikimedia Commons (https://commons.wikimedia.org/wiki/File:Mariadb-seal-browntext.svg) they seem to have disappeared Is this just an oversight and something that needs fixing? Thanks -- 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] ON update timestamp replication
by Artem Kuchin 14 Jan '17

14 Jan '17

Hello! Both master and slave run: Server version: 10.1.14-MariaDB FreeBSD Ports Replication is based on mixed format. Slave is used for backups without locking and going off line. I have a script that runs once a day and checksums all tables, so all tables are 100% in match (it wait for sync, locks and checksums). One table is very often out of sync. ON MASTER: show create table Message193; CREATE TABLE `Message193` ( `Message_ID` int(11) NOT NULL AUTO_INCREMENT, `User_ID` int(11) NOT NULL, `Subdivision_ID` int(11) NOT NULL, `Sub_Class_ID` int(11) NOT NULL, `Priority` int(11) NOT NULL DEFAULT '0', `Keyword` char(255) NOT NULL, `ncTitle` varchar(255) DEFAULT NULL, `ncKeywords` varchar(255) DEFAULT NULL, `ncDescription` text, `ncSMO_Title` varchar(255) DEFAULT NULL, `ncSMO_Description` text, `ncSMO_Image` char(255) DEFAULT NULL, `Checked` tinyint(4) NOT NULL DEFAULT '1', `IP` char(15) DEFAULT NULL, `UserAgent` char(255) DEFAULT NULL, `Parent_Message_ID` int(11) NOT NULL DEFAULT '0', `Created` datetime NOT NULL, `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `LastUser_ID` int(11) NOT NULL, `LastIP` char(15) DEFAULT NULL, `LastUserAgent` char(255) DEFAULT NULL, `Type` char(255) DEFAULT NULL, `Title` char(255) DEFAULT NULL, `Background` char(255) DEFAULT NULL, `Link` char(255) DEFAULT NULL, PRIMARY KEY (`Message_ID`), UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`), KEY `User_ID` (`User_ID`), KEY `LastUser_ID` (`LastUser_ID`), KEY `Subdivision_ID` (`Subdivision_ID`), KEY `Parent_Message_ID` (`Parent_Message_ID`), KEY `Priority` (`Priority`,`LastUpdated`), KEY `Checked` (`Checked`), KEY `Created` (`Created`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 | ON SLAVE CREATE TABLE `Message193` ( `Message_ID` int(11) NOT NULL AUTO_INCREMENT, `User_ID` int(11) NOT NULL, `Subdivision_ID` int(11) NOT NULL, `Sub_Class_ID` int(11) NOT NULL, `Priority` int(11) NOT NULL DEFAULT '0', `Keyword` char(255) NOT NULL, `ncTitle` varchar(255) DEFAULT NULL, `ncKeywords` varchar(255) DEFAULT NULL, `ncDescription` text, `ncSMO_Title` varchar(255) DEFAULT NULL, `ncSMO_Description` text, `ncSMO_Image` char(255) DEFAULT NULL, `Checked` tinyint(4) NOT NULL DEFAULT '1', `IP` char(15) DEFAULT NULL, `UserAgent` char(255) DEFAULT NULL, `Parent_Message_ID` int(11) NOT NULL DEFAULT '0', `Created` datetime NOT NULL, `LastUpdated` timestamp NOT NULL, `LastUser_ID` int(11) NOT NULL, `LastIP` char(15) DEFAULT NULL, `LastUserAgent` char(255) DEFAULT NULL, `Type` char(255) DEFAULT NULL, `Title` char(255) DEFAULT NULL, `Background` char(255) DEFAULT NULL, `Link` char(255) DEFAULT NULL, PRIMARY KEY (`Message_ID`), UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`), KEY `User_ID` (`User_ID`), KEY `LastUser_ID` (`LastUser_ID`), KEY `Subdivision_ID` (`Subdivision_ID`), KEY `Parent_Message_ID` (`Parent_Message_ID`), KEY `Priority` (`Priority`,`LastUpdated`), KEY `Checked` (`Checked`), KEY `Created` (`Created`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 | Notice that `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, on slave becomes `LastUpdated` timestamp NOT NULL, This is already bad enough because if master is lost then slave will not be the same as master, trigger are not restored. Now check records: MASTER MariaDB [anapolisdom_ru]> select * from Message193 limit 1\G *************************** 1. row *************************** Created: 2016-11-25 13:25:09 LastUpdated: 2016-11-25 13:25:09 MariaDB [anapolisdom_ru]> select * from Message193 limit 1\G Created: 2016-11-25 13:25:09 LastUpdated: 0000-00-00 00:00:00 As you see lastupdated field is not replicated at all. Two questions, problems: 1) How to replicate default value and on update part for this field? 2) How to make it replicate the timestamp value? Artem

3 5

[Maria-discuss] rejoin timeout?
by l vic 30 Nov '16

30 Nov '16

How long can it take for a node to sync during a rejoin? Is there environmental variable for that? Thanks, -V

1 0

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Federico Razzoli 30 Nov '16

30 Nov '16

Woops, sorry, I missed the GLOBAL word :) Federico -------------------------------------------- Mer 30/11/16, Ian Gilfillan <ian(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) A: maria-discuss(a)lists.launchpad.net Data: Mercoledì 30 novembre 2016, 15:13 On 30/11/2016 15:13, Federico Razzoli wrote: > This always shows the global value: > SHOW VARIABLES LIKE ... > > This always shows the current session value: > SHOW SESSION VARIABLES LIKE ... This is not correct. SHOW VARIABLES shows the session value: SET GLOBAL wait_timeout=601; SET SESSION wait_timeout=599; SHOW SESSION VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 599 | +---------------+-------+ SHOW GLOBAL VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 601 | +---------------+-------+ SHOW VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 599 | +---------------+-------+ _______________________________________________ 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] Aborted connection (CLOSE_CONNECTION)
by Federico Razzoli 30 Nov '16

30 Nov '16

This always shows the global value: SHOW VARIABLES LIKE ... This always shows the current session value: SHOW SESSION VARIABLES LIKE ... Global value is read from the files when the server starts, and later can be changed with SET GLOBAL var = val. Session value is copied from global value when the session starts (so changing the global value doesn't affect existing sessions) and can later be changed with SET var = val. In other words, the global value is important because it is used by all new sessions by default, but the session value is what really takes effect. I beleive that your application sets a session value. Federico -------------------------------------------- Mer 30/11/16, Florent B <florent(a)coppint.com> ha scritto: Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) A: "Federico Razzoli" <federico_raz(a)yahoo.it>, maria-discuss(a)lists.launchpad.net Data: Mercoledì 30 novembre 2016, 10:44 Ok, I found the problem thanks to you Federico. On Debian, mysql-common package provided by MariaDB repository contains "wait_timeout = 600" in my.cnf. This is not the default value specified in documentation (28800). And when I use "mysql -u root -p -h my_host" command to show variables, the default value is displayed (28800), I never saw 600 in here ! Why ? But displaying variables in my PHP app showed me that wait_timeout was effectively set to 600. Setting wait_timeout=28800 in a config file in /etc/mysql/conf.d directory fixes this. Should we consider "wait_timeout = 600" in my.cnf as a bug ? That's not default value... On 11/29/2016 11:17 PM, Federico Razzoli wrote: > Interesting. A couple ideas: > > 1 > Try this query: > SHOW SESSION VARIABLES LIKE '%timeout%'; > But this time, this should be executed by PHP, using the same library used by the application. Why? To check if a library changes a timeout at session level. > > 2 > Have you checked if your application reconnects N times? For example, 600 could be a 60 seconds timeout * 10 attempts. > > Federico > > > -------------------------------------------- > Mar 29/11/16, Florent B <florent(a)coppint.com> ha scritto: > > Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) > A: "Reindl Harald" <h.reindl(a)thelounge.net>, maria-discuss(a)lists.launchpad.net > Data: Martedì 29 novembre 2016, 12:22 > > On 11/29/2016 12:03 PM, > Reindl Harald wrote: > > > > > > Am 29.11.2016 um > 11:49 schrieb Florent B: > >> For > example, if I try this in PHP: > >> > >> 1/ Connect to mariadb > >> > >> 2/ sleep 610 > seconds > >> > >> 3/ > ping mariadb > >> > >> => I got Server has gone away > error. > >> > >> > With a 590 sleep time, no error. > >> > >> I use MariaDB 10.1, didn't change > any "timeout" value in MariaDB : > >> interactive_timeout & wait_timeout > are 28800 > > > > http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout > > > > Hi, and > thank you. But I cannot find any timeout of 600 > seconds... > default_socket_timeout = 60 > mysqlnd.net_read_timeout = 31536000 > > And I have the exactly same > problem using this algorithm in Python, it's > not related to PHP... > > _______________________________________________ > 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 > > > _______________________________________________ > 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

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Federico Razzoli 29 Nov '16

29 Nov '16

Interesting. A couple ideas: 1 Try this query: SHOW SESSION VARIABLES LIKE '%timeout%'; But this time, this should be executed by PHP, using the same library used by the application. Why? To check if a library changes a timeout at session level. 2 Have you checked if your application reconnects N times? For example, 600 could be a 60 seconds timeout * 10 attempts. Federico -------------------------------------------- Mar 29/11/16, Florent B <florent(a)coppint.com> ha scritto: Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) A: "Reindl Harald" <h.reindl(a)thelounge.net>, maria-discuss(a)lists.launchpad.net Data: Martedì 29 novembre 2016, 12:22 On 11/29/2016 12:03 PM, Reindl Harald wrote: > > > Am 29.11.2016 um 11:49 schrieb Florent B: >> For example, if I try this in PHP: >> >> 1/ Connect to mariadb >> >> 2/ sleep 610 seconds >> >> 3/ ping mariadb >> >> => I got Server has gone away error. >> >> With a 590 sleep time, no error. >> >> I use MariaDB 10.1, didn't change any "timeout" value in MariaDB : >> interactive_timeout & wait_timeout are 28800 > > http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout > Hi, and thank you. But I cannot find any timeout of 600 seconds... default_socket_timeout = 60 mysqlnd.net_read_timeout = 31536000 And I have the exactly same problem using this algorithm in Python, it's not related to PHP... _______________________________________________ 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] Aborted connection (CLOSE_CONNECTION)
by Reindl Harald 29 Nov '16

29 Nov '16

Am 29.11.2016 um 12:22 schrieb Florent B: > On 11/29/2016 12:03 PM, Reindl Harald wrote: >> Am 29.11.2016 um 11:49 schrieb Florent B: >>> For example, if I try this in PHP: >>> >>> 1/ Connect to mariadb >>> 2/ sleep 610 seconds >>> 3/ ping mariadb >>> => I got Server has gone away error. >>> With a 590 sleep time, no error. >>> I use MariaDB 10.1, didn't change any "timeout" value in MariaDB : >>> interactive_timeout & wait_timeout are 28800 >> >> http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout > > Hi, and thank you. But I cannot find any timeout of 600 seconds... > default_socket_timeout = 60 > mysqlnd.net_read_timeout = 31536000 > > And I have the exactly same problem using this algorithm in Python, it's > not related to PHP... then pretty sure you mysqld timeouts are not what you think, otherwise we would see the same issues on our dbmail machines when after hours of idle postfix tries to re-use it's connections (and we did have such events when that values where too low) so why don't you ask the server instead pretend they are not lowered? MariaDB [(none)]> show variables like 'wait_timeout'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 300 | +---------------+-------+ 1 row in set (0.00 sec) MariaDB [(none)]> show variables like 'wait_timeout'; +---------------+--------+ | Variable_name | Value | +---------------+--------+ | wait_timeout | 604800 | +---------------+--------+ 1 row in set (0.00 sec) wait_timeout = 604800 interactive_timeout = 604800

1 0

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Stephane VAROQUI 29 Nov '16

29 Nov '16

Stéphane Varoqui, Senior Consultant Phone: +33 695-926-401, skype: svaroqui http://www.mariadb.com <http://www.mariadb.com/> > Le 29 Nov 2016 à 12:22, Florent B <florent(a)coppint.com> a écrit : > > On 11/29/2016 12:03 PM, Reindl Harald wrote: >> >> >> Am 29.11.2016 um 11:49 schrieb Florent B: >>> For example, if I try this in PHP: >>> >>> 1/ Connect to mariadb >>> >>> 2/ sleep 610 seconds >>> >>> 3/ ping mariadb >>> >>> => I got Server has gone away error. >>> >>> With a 590 sleep time, no error. >>> >>> I use MariaDB 10.1, didn't change any "timeout" value in MariaDB : >>> interactive_timeout & wait_timeout are 28800 >> >> http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout >> > > Hi, and thank you. But I cannot find any timeout of 600 seconds... > default_socket_timeout = 60 > mysqlnd.net_read_timeout = 31536000 > > And I have the exactly same problem using this algorithm in Python, it's > not related to PHP… > Have you check your TCP settings or may be some firewall or proxy that would just sit in the middle ? > _______________________________________________ > 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] Aborted connection (CLOSE_CONNECTION)
by Reindl Harald 29 Nov '16

29 Nov '16

Am 29.11.2016 um 11:49 schrieb Florent B: > For example, if I try this in PHP: > > 1/ Connect to mariadb > > 2/ sleep 610 seconds > > 3/ ping mariadb > > => I got Server has gone away error. > > With a 590 sleep time, no error. > > I use MariaDB 10.1, didn't change any "timeout" value in MariaDB : > interactive_timeout & wait_timeout are 28800 http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout

1 0

[Maria-discuss] semi-sync replication issue
by Rhys.Campbell＠swisscom.com 28 Nov '16

28 Nov '16

Hello All, I recently upgraded to MariaDB 10.0.28 and I am having sporadic issues with semi-sync replicating timeouts. Lots of these are logged.... [ERROR] Read semi-sync reply network error: (errno: 1159) [ERROR] Semi-sync master failed on net_flush() before waiting for slave reply Is anyone else experiencing this? Cheers, Rhys

1 0

[Maria-discuss] jdbc failure after restart
by l vic 23 Nov '16

23 Nov '16

i have the following jdbc exception in my jdbc client for the node 1 after another node (node2) is removed: om.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: WSREP has not yet prepared node for application use at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3833) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3283) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2297) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) at java.sql.DriverManager.getConnection(DriverManager.java:664) I wonder why i have this failure when i just trying to read db from the unaffected node? The failure seems to be permanent, once it happened - all subsequent reads fail

2 3

Re: [Maria-discuss] master and slave binlog question?
by Pavel Ivanov 18 Nov '16

18 Nov '16

I guess you can do it like that, yes. I wonder what do you need it for though. On Thu, Nov 17, 2016 at 9:45 PM, Ljr Yang <dbmsprog(a)gmail.com> wrote: > Thank you. > > innobackup backup info on slave: > #cat xtrabackup_binlog_info > mysql-bin.000003 83882214 0-118-60061898358 > > Only filter GTID 0-118-60061898358 in all binlog file of slave ? > > mysqlbinlog -vv mysqbin.000001 | grep -B5 "0-118-60061898358" > mysqlbinlog -vv mysqbin.000002 | grep -B5 "0-118-60061898358" > ........ > > 2016-11-18 13:24 GMT+08:00 Pavel Ivanov <pivanof(a)google.com>: >> >> There is no way to find corresponding binlog file and position on the >> slave. You should use GTIDs to find corresponding binlog positions. >> >> On Thu, Nov 17, 2016 at 7:19 PM, Ljr Yang <dbmsprog(a)gmail.com> wrote: >> > >> > Hi, >> > we config master slave and set log_slave_updates = 1 on slave. >> > on master server‘s binlog file and pos , example: mysql-bin.000005 >> > 2036891 , >> > how could quick find corresponding binlog file and pos on slave? >> > Thanks. >> > >> > -- >> > Ljr >> > >> > _______________________________________________ >> > 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 >> > > > > > > -- > Ljr

1 0

[Maria-discuss] master and slave binlog question?
by Ljr Yang 18 Nov '16

18 Nov '16

Hi, we config master slave and set log_slave_updates = 1 on slave. on master server‘s binlog file and pos , example: mysql-bin.000005 2036891 , how could quick find corresponding binlog file and pos on slave? Thanks. -- Ljr

2 1

[Maria-discuss] Download speeds on archive.mariadb.org
by Guillaume Lefranc 14 Nov '16

14 Nov '16

Hi everyone, Download speeds on archive.mariadb.org have reached an abysmal level - 6kb/s today. Honestly, what is the foundation waiting for to solve this issue that has been lasting for years? I am ready to donate server space and bandwidth myself if needed.

4 7

[Maria-discuss] galera replication specs?
by l vic 14 Nov '16

14 Nov '16

Is there online docs to describe Galera in detail, such as specs/RFC? Thanks,

2 1

[Maria-discuss] rsync failure?
by l vic 08 Nov '16

08 Nov '16

Have the rsync failure (see the trace below): 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' --datadir '/var/lib/mysql/' --parent '114' '' Read: '(null)' 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' --datadir '/var/lib/mysql/' --parent '114' '' : 1 (Operation not permitted) 2016-11-08 15:17:34 139960239241984 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable. 2016-11-08 15:17:34 139960239241984 [ERROR] Aborting Can someone with better understanding of replication process explain the nature of this problem? Can it be caused by hostname resolution failure, or would it be storage related? Thank you,

2 6

[Maria-discuss] rsync timeout?
by l vic 08 Nov '16

08 Nov '16

Is it possible to increase rsync timeout? I checked http://galeracluster.com/documentation-webpages/galeraparameters.html but couldn't find corresponding parameters... Thanks, -V

2 2

[Maria-discuss] on stored procedures
by Federico Razzoli 08 Nov '16

08 Nov '16

Some good points from Bill Karwin: https://www.quora.com/What-are-the-reasons-not-to-use-or-not-use-stored-pro… Federico

5 10

Re: [Maria-discuss] on stored procedures
by Federico Razzoli 08 Nov '16

08 Nov '16

Hi Sergei! I was wondering the same! Justin's explanation is probably correct, but I think that various discussions in this list proven that a part of the community badly wants this feature. I wrote a unit tester in SQL some time ago (I know it may sound weird, but I needed it to test several things, from procedures to query time, and even metrics). It was insanely hard. I mean - I think I can write a unit tester in JavaScript or PHP or even BASH in a few hours, with all the features I want. But SQL is full of traps, so it took weeks (of course it was not my only task). Some of the features that have been discussed in this list could have been implemented as stored procedures. For example, extensions to KILL. It may not be the perfect solution but, well, it is not reasonable to expect that you implement every single need/idea I have during my work. If I could write general purpose stored procedures in any decent language, I would do it, and then would push them to GitHub. It seems that some people agree on this but... still nothing happens. Even PL/SQL parser seems to have higher priority than external languages! :( Is there anything we can do to convince the team? Bye, Federico -------------------------------------------- Lun 7/11/16, Sergei Golubchik <serg(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] on stored procedures A: "Justin Swanhart" <greenlion(a)gmail.com> Cc: "Federico Razzoli" <federico_raz(a)yahoo.it>, "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Lunedì 7 novembre 2016, 22:42 Hi, Justin! On Nov 07, Justin Swanhart wrote: > We discussed it here and it seemed vary popular. WL-820. I know, right? A cool and useful feature, I'd say. I cannot understand why it's constantly being pushed down for the last 10 years. I still hope we get it someday. > On Mon, Nov 7, 2016 at 10:43 AM, Sergei Golubchik <serg(a)mariadb.org> wrote: > > Hi, Federico! > > > > On Nov 07, Federico Razzoli wrote: > > > Some good points from Bill Karwin: > > > https://www.quora.com/What-are-the-reasons-not-to-use-or- > > not-use-stored-procedures/answer/Bill-Karwin > > > > Thanks. > > > > These are valid points, and some of them are related. > > For example, "does not have a rich library of functions or standard > > procedures" that follows from "does not support packages". > > Which might be fixed in https://jira.mariadb.org/browse/MDEV-10591 > > > > External languages for stored procedures - that's a very cool feature, > > and patches exist for many years. But, apparently, it's more cool than > > practically useful? There were almost no requests for it, not when I was > > in MySQL, not in MariaDB. And, frankly, I do not know why, this looks > > insanely useful to me. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org

1 0

[Maria-discuss] MariaDB 10.1.19 and other releases now available
by Daniel Bartholomew 07 Nov '16

07 Nov '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.19, MariaDB Galera Cluster 10.0.28, and MariaDB Connector/ODBC 2.0.13. These are all stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.19 - Release Notes: https://mariadb.com/kb/en/mdb-10119-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10119-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.19 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.28 - Release Notes: https://mariadb.com/kb/en/mgc-10028-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10028-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.28 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.13 - Release Notes: https://mariadb.com/kb/en/mco-2013-rn/ - Changelog: https://mariadb.com/kb/en/mco-2013-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.13 About MariaDB Connector/ODBC: - 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/mariadbfdn - 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] Community Involvement - GSoC Mentor Summit impressions
by Vicențiu Ciorbaru 07 Nov '16

07 Nov '16

Hi everyone! Since MariaDB has completed another Google Summer of Code program this year, with some great projects as well, the MariaDB Foundation was able to send 2 mentors to the summit in California this year. I was one of the people that had the privilege to go. There were a lot of talks there about community involvement and how to encourage people to contribute. I've picked the ideas that I've found to be most interesting and useful and have blogged [1] about them. I intend to try and apply some of them if possible. Since this is a community matter (albeit more GSoC related), it makes sense to ask for feedback from the community. I think some of the ideas are at least partly implemented but we can always do better. If you're interested, lets have a discussion on this. Vicențiu [1] http://vicentiu.ciorbaru.io/community-involvement-gsoc-mentor-summit-impres…

1 0

[Maria-discuss] GRANT PROXY access denied with proxied User
by Fabian Jucker 04 Nov '16

04 Nov '16

Hi, At our enterprise we have a DBA-User proxied with "GRANT PROXY ON 'dba'@'%' TO ''@'%'" and backed by pam module (roughly according to [1]) to login from our ldap-accounts. When logging in via pam into the DBA-Role I'm unable to grant the proxy privileges to other users. Following [2] (MySQL docs, because the MariaDB docs are lacking any further information about this) I already tried to "GRANT PROXY ON 'dba'@'%' TO ''@'%' WITH GRANT OPTION" and "GRANT PROXY ON ''@'' TO 'dba'@'%' WITH GRANT OPTION" (as [2] is ambiguous about if the "proxied_user" or the "proxy_user" should have the "WITH GRANT OPTION"), but neither the first grant nor the second one showed any effect. When I grant the proxy privilege with grant option to a local user, this user is able to grant the proxy privileges to other users. So my question is, if it's not possible to grant proxy privileges while one's logged in with a proxy user? Thanks in advance, Fabian References: [1]: https://mariadb.com/blog/configuring-pam-authentication-and-user-mapping-ma… [2]: https://dev.mysql.com/doc/refman/5.5/en/proxy-users.html

1 1

[Maria-discuss] MYSQL_OPT_CONNECT_TIMEOUT default?
by Peter Laursen 03 Nov '16

03 Nov '16

MySQL docs page http://dev.mysql.com/doc/refman/5.7/en/mysql-options.html *MYSQL_OPT_CONNECT_TIMEOUT (argument type: unsigned int *)* *The connect timeout in seconds.* However I don't find it documented anywhere what the default (client-initiated) connect_timeout will become if not specified in mysql_options(). Or will the client never initiate a timeout in connection phase in such case? We are usng MariaDB C-conn 2.31 so the question here on this list is specifically for MariaDB connector. I didn't find it documented here either. But both MySql and MariaDB have probably inherited this from the old LGPL 3.x connector so this are probably the same in both. Asked a docs request here as well: http://bugs.mysql.com/bug.php?id=83600 --- Peter

2 3