- discuss - lists.mariadb.org

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

23 Oct '15

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

1 0

[Maria-discuss] mysqldump mishandling DB name?
by Felipe Gasper 23 Oct '15

23 Oct '15

In client/mysqldump.c, there is a command: mysql_real_escape_string(mysql, db_name_buff, db, strlen(db)); … which appears to be doubling up and backslashes in the database name when the “--routines” argument is passed to mysqldump. This bug affects MySQL 5.7.9 (and back at least to 5.1); I’ve filed a MySQL bug here: https://bugs.mysql.com/bug.php?id=78932 -FG

1 0

[Maria-discuss] New Question: Where is the "Restrictions and Limitations" documentation of MariaDB?
by AskMonty KB 22 Oct '15

22 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by openiduser59. Please answer it at http://mariadb.com/kb/en/where-is-the-restrictions-and-limitations-document… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi! MySQL has the "Restrictions and Limitations" documentation section: http://dev.mysql.com/doc/mysql-reslimits-excerpt/5.7/en/subquery-restrictio… Where is the same section of MariaDB docs? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/where-is-the-restrictions-and-limitations-document…

1 0

[Maria-discuss] New Question: Unable to create after insert trigger on mariadb
by AskMonty KB 22 Oct '15

22 Oct '15

Hello, A new question has been asked in "SQL Structure and Commands" by girish2477. Please answer it at http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I followed trigger instructions from documentation. When i run the script from command line, cursor does not come back. i have to kill the execution Server version: 5.5.46-MariaDB MariaDB Server Tried various formats CREATE TRIGGER company_insert AFTER INSERT ON companyMain FOR EACH ROW INSERT INTO companytest (ID, Value) VALUES (20, CONCAT(NEW.`Code`,' - ',NEW.`Name`)); ------------ DELIMITER // DROP TRIGGER IF EXISTS company_insert ; CREATE TRIGGER company_insert AFTER INSERT ON companyMainFOR EACH ROW BEGIN DECLARE vFormatID int; SET vFormatID=20; INSERT INTO companytest (ID,Value) VALUES ( vFormatID,NEW.`Name`); END; // DELIMITER; Tried running from command directly or pass as .sql file. both ways its stuck no response back on command. Have to kill. ^CCtrl-C -- query killed. Continuing normally. ERROR 1317 (70100) at line 3: Query execution was interrupted Your help will be appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/

1 0

[Maria-discuss] CONJ SSL connection with client cert and key
by Beeton, Carolyn (Carolyn) 20 Oct '15

20 Oct '15

From: Beeton, Carolyn (Carolyn) Sent: Monday, October 19, 2015 3:39 PM To: 'maria-discuss(a)lists.launchpad.net' Subject: CONJ SSL connection with client cert and key I am using the MariaDb Connector/J to connect to a remote database which requires a client cert and key in addition to the server cert. Is there any way to configure this (similar to MySql clientCertificateKeyStoreUrl)? Thanks, Carolyn

1 0

[Maria-discuss] New Question: Please update procedures to upgrade Galera cluster from MariaDB 10.0.21/22 to MariaDB 10.1.8
by AskMonty KB 19 Oct '15

19 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by robin_anil_g. Please answer it at http://mariadb.com/kb/en/please-update-procedures-to-upgrade-galera-cluster… as the person asking the question may not be subscribed to the mailing list. -------------------------------- It seems like wserp replication is now part of MariaDB. I would appreciate insights into correct rolling upgrade procedure for the same. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/please-update-procedures-to-upgrade-galera-cluster…

1 0

[Maria-discuss] Moving from Launchpad lists to something else... ?
by Colin Charles 19 Oct '15

19 Oct '15

Hi, I was speaking to Otto (CEO, MariaDB Foundation) and discussing that we should move the lists from Launchpad to something else. We obviously want to preserve the archives, and this isn’t going to happen overnight (something like an aim by the end of the year). Would you be ok with running on Google Groups? Would you prefer being on Mailman? Do you have another self-hosted or (preferably free) hosted solution as your preference? Today, we have several lists (maria-discuss, maria-developers, maria-docs) that are hosted on Launchpad. We also have a few lists (ambassadors, announce, commits, mirroring, maria-buildbot-reports) hosted on Mailman at lists.askmonty.org. Let us know what you think about this Kind Regards, Colin Charles -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

6 6

[Maria-discuss] New Question: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
by AskMonty KB 17 Oct '15

17 Oct '15

Hello, A new question has been asked in "MariaDB Community" by wraith. Please answer it at http://mariadb.com/kb/en/couldnt-execute-show-events-cannot-proceed-because… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi! Being new to MariaDB, I'm unsure if this is the correct forum to pose my question. Please forgive and forward me in the right direction if it is not :) I've recently upgraded from MySQL to MariaDB on my QNAP TS-410 server and commenced using. I've recently attempted to backup my tables and have been faced with a "Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)". I've browsed the web and the "mysql_upgrade" command is regularly touted; however, this doesn't appear to be on my TS-410. I've also attempted restarting the server via the TS-410 web interface. I approached QNAP who responded they were unable to assist. Which leads me here. Has anyone encountered a similar or same scenario? And able to provide assistance in resolving? Thanks in advance -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/couldnt-execute-show-events-cannot-proceed-because…

1 0

[Maria-discuss] MariaDB version string in initial handshake
by Felipe Gasper 17 Oct '15

17 Oct '15

Hi all, I’m seeing a version string like this from the server in the initial handshake: 5.5.5-10.1.16-MariaDB Why does MariaDB negotiate with a different-format version string than MySQL? Is this documented somewhere? -FG

3 2

[Maria-discuss] New Question: INSERT IGNORE refuses to ignore foreign key constraints. Bug maybe?
by AskMonty KB 15 Oct '15

15 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by stillsmil. Please answer it at http://mariadb.com/kb/en/insert-ignore-refuses-to-ignore-foreign-key-constr… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is this a bug? INSERT IGNORE refuses to ignore ERROR 1452, as is described in http://stackoverflow.com/questions/6849393/mysqls-insert-ignore-into-foreig…. To regenerate the error: CREATE TABLE parent (id INT AUTO_INCREMENT NOT NULL , PRIMARY KEY (id) ) ENGINE=INNODB; CREATE TABLE child ( id INT AUTO_INCREMENT , parent_id INT , INDEX par_ind (parent_id) , PRIMARY KEY (id) , FOREIGN KEY (parent_id) REFERENCES parent(id) ) ENGINE=INNODB; INSERT INTO parent VALUES (1) (2); INSERT IGNORE INTO child VALUES (NULL, 3); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`financedb`.`child`, CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`)) Server version: 10.0.21-MariaDB-log MariaDB Server -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/insert-ignore-refuses-to-ignore-foreign-key-constr…

1 0