- discuss - lists.mariadb.org

[Maria-discuss] New Question: Spider
by AskMonty KB 30 Oct '15

30 Oct '15

Hello, A new question has been asked in "MariaDB Community" by siliconplains44. Please answer it at http://mariadb.com/kb/en/mariadb-community-spider/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, we are looking for scale up options for mariadb. We wanted to try spider out but there was not enough information on this site. Some of the questions I had were what is the maxiumum number of nodes you can have. Does the database balance the shards, etc.? I am looking to see how much storage we can get out of spider. Can anyone out there help us with this request? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-spider/

1 0

[Maria-discuss] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes
by Reindl Harald 29 Oct '15

29 Oct '15

* why does that happen at all instead finish whatever is not finished after get SIGTERM * "try to restart the slave with --slave-exec-mode=IDEMPOTENT" must be a joke when "slave-exec-mode = IDEMPOTENT" is part of my.cnf for years *because* of that failure happening randomly when stop a slave at a wrong moment 151029 9:15:44 [ERROR] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes. If the group consists solely of row-based events, you can try to restart the slave with --slave-exec-mode=IDEMPOTENT, which ignores duplicate key, key not found, and similar errors (see documentation for details). Gtid 0-1-2058483, Internal MariaDB error code: 1593

1 0

[Maria-discuss] New Question: Want to start contributing in MariaDB
by AskMonty KB 28 Oct '15

28 Oct '15

Hello, A new question has been asked in "MariaDB Community" by aman_var. Please answer it at http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to contribute to this project. I have ample knowledge of C,C++ and want to start my open source contribution. It would be great if i get some directions from you all guys as to where to start from. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/

1 0

[Maria-discuss] New Question: Want to start contributing in MariaDB
by AskMonty KB 28 Oct '15

28 Oct '15

Hello, A new question has been asked in "MariaDB Community" by aman_var. Please answer it at http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to contribute to this project. I have ample knowledge of C,C++ and want to start my open source contribution. It would be great if i get some directions from you all guys as to where to start from. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/

1 0

[Maria-discuss] New Question: MariaDB Error Code -> Windows ERRORLEVEL
by AskMonty KB 26 Oct '15

26 Oct '15

Hello, A new question has been asked in "Error Codes" by patkoshar. Please answer it at http://mariadb.com/kb/en/mariadb-error-code-windows-errorlevel/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, Is there a known issue or problem with how/when MariaDB returns error codes from calling '--execute' on *.sql scripts in Windows? It seems like certain errors are detected and returned as such, and others are not. For example, a *.sql file of completely random bytes will set the Windows ERRORLEVEL=1 after failing, reporting the following error: ERROR: ASCII '\0' appeared in the statement... Another *.sql file that references an unknown database will set the Windows ERRORLEVEL=0, but still textually report an error after failing: ERROR 1049 (42000) at line 1 in file... Any ideas? Thank you! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-error-code-windows-errorlevel/

1 0

[Maria-discuss] New Question: Converting unix timestamp stored as bigint to readable date time
by AskMonty KB 26 Oct '15

26 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by thanmaya. Please answer it at http://mariadb.com/kb/en/converting-unix-timestamp-stored-as-bigint-to-read… as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are storing the timestamp as a bigint. In the SQL query trying to convert this timestamp to date time. have used the function FROM_UNIXTIME but it just returns a NULL value. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/converting-unix-timestamp-stored-as-bigint-to-read…

1 0

[Maria-discuss] MySQL Meetup NL slides
by Colin Charles 25 Oct '15

25 Oct '15

Hi! So we had many MariaDB Server and other developers speak at the MySQL Meetup NL in Amsterdam a week ago. The slides (except Otto’s — it’ll be added soon!) are all at: https://drive.google.com/folderview?id=0B7HE7L1OgKJFcXVrX05Ea25zb2c&usp=sha… I wrote a quick post with an index — http://www.bytebot.net/blog/archives/2015/10/24/mysql-nl-community-meetup-w… I think the attendees had a great time overall, and there was plenty of good conversation. Also, much thanks to eBay (venue, food, drink), Booking.com (Daniël van Eeden organised, and JF ensured we were all appropriately whipped to make this happen!), and all the speakers. cheers, -colin -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

3 3

[Maria-discuss] MariaDB Galera Cluster Wrsep not ready
by Bertrand Caplet 24 Oct '15

24 Oct '15

Hi all, I have a galera cluster of 4 MariaDB server and sometimes a node fail. But when a node fail, others nodes doesn't want to respond to query. I have in log : "MYSQL: query failed: WSREP has not yet prepared node for application use" It's really embarrassing, because it happen like once a week. Is there a parameter to modify to get this working even when split brain ? Like If 2 of the 4 server are ok, I can still make query ? Thanks in advance, -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

2 2

Re: [Maria-discuss] CentOS Docker Container Image not only for OpenShift
by Honza Horak 24 Oct '15

24 Oct '15

Thanks for the feedback, Kolbe. On 10/23/2015 06:41 PM, Kolbe Kegel wrote: > I find the use of environment variables to hold passwords to be a really troubling feature of the way many Docker images are built and used. I agree this is not a very good solution and we need to come up with something better, that will also work in kubernetes. If anybody knows about something handy, I'd be glad to hear about it. So far, we've just used what other images do, which is not ideal at all. > In an environment where Docker linking is not used, perhaps the environment variable problem is somewhat less severe. But I'm really troubled by this statement: > > "Changing database passwords through SQL statements or any way other than through > the environment variables aforementioned will cause a mismatch between the > values stored in the variables and the actual passwords. Whenever a database > container starts it will reset the passwords to the values stored in the > environment variables." > > That sounds to me like a security catastrophe. In cases user cares about keeping the container password unknown to other containers and docker daemon itself, the stack can be initialized with some init-only root password and changed afterwards. If I understand what your concern is, it's the reset of the password, right? I guess we may change that behavior to not do anything if password is not set and data directory is already initialized. Is it something what would help here from your point of view? Honza > Kolbe > >> On Oct 22, 2015, at 11:26 PM, Honza Horak <hhorak(a)redhat.com> wrote: >> >> For those who are interested in containers, I'd like to share a Docker image that we've produced in Red Hat in cooperation with OpenShift guys. And will be really glad for any feedback you have. >> >> The image can be used in OpenShift or run directly. But what I find really interesting is a PoC implementation of master/slave, that is not documented as official feature yet, but it can be used as simple as that: >> >> docker pull centos/mariadb-100-centos7 >> >> docker run -e MYSQL_MASTER_USER=master \ >> -e MYSQL_MASTER_PASSWORD=master \ >> -e MYSQL_DATABASE=db \ >> -e MYSQL_USER=user \ >> -e MYSQL_PASSWORD=foo \ >> -e MYSQL_ROOT_PASSWORD=rootpasswd \ >> -d centos/mariadb-100-centos7 mysqld-master >> >> docker run -e MYSQL_MASTER_USER=master \ >> -e MYSQL_MASTER_PASSWORD=master \ >> -e MYSQL_DATABASE=db \ >> -e MYSQL_MASTER_SERVICE_NAME=<master_ip> \ >> -d centos/mariadb-100-centos7 mysqld-slave >> >> More info about the image available here: >> https://hub.docker.com/r/centos/mariadb-100-centos7/ >> >> As said above, any feedback welcome :) >> >> Honza >> >> _______________________________________________ >> 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] mysql_install_db.exe failing on Dutch Windows Machine(s) on some Folders
by Derek R Magee 23 Oct '15

23 Oct '15

Hi, I'm trying to debug a mariadb failure on a machine in Holland. It seems mysql_install_db doesn't work for some folders, but does for others (e.g. c:\temp\db). We've typed exactly the same thing into the Dutch machine as my UK machine. On the UK machine it works fine, on the dutch machine it claims to work, but the mysql folder is empty on completion (and sunsequently the database doesn't start for obvious reasons). I've asked the guy in Holland to check folder write permissions on the parent folders created, and obviously the logged in user must be the owner as they are created with mkdir (see below): =========================================================== Dutch machine: =========================================================== Microsoft Windows [versie 6.1.7601] Copyright (c) 2009 Microsoft Corporation. Alle rechten voorbehouden. C:\Users\g10031702>cd c:\ c:\>mkdir MIM c:\>cd MIM c:\MIM>mkdir MIMDB c:\MIM>cd "c:\program files\mariadb 10.1\BIN" c:\Program Files\MariaDB 10.1\bin>mysql_install_db.exe --datadir=c:/MIM/MIMDB/db --password=password Running bootstrap Creation of the database was successfull c:\Program Files\MariaDB 10.1\bin> [On exit the db sub-folder is created, as is the mysql sub-folder, but the latter is empty. N.B. We tried both 5.5 and 10.1 versions, same issue, same output.] =========================================================== UK Machine =========================================================== C:\Users\cscdrm>cd c:\ c:\>mkdir MIM c:\>cd MIM c:\MIM>mkdir MIMDB c:\MIM>cd "c:\Program Files\MariaDB 5.5\bin" c:\Program Files\MariaDB 5.5\bin>mysql_install_db.exe --datadir=c:/MIM/MIMDB/db --password=password Running bootstrap Removing default user <------- Extra Setting root password <------- Extra Creating my.ini file <------- Extra Creation of the database was successfull c:\Program Files\MariaDB 5.5\bin> [On exit the db sub-folder is created, as is the mysql sub-folder, and the lattercontains ~80 files] Has anyone got an idea how to fix this? We've seen similar things on a range of Dutch machines in the same institution where it always works if you use a sub folder of c:\temp, but other locations fail (e.g. under c:\Users, c:\). I've never seen it fail on a UK machine. Thanks a lot Derek

1 0