June 2016 - discuss - lists.mariadb.org

[Maria-discuss] New Question: MONyog Monitoring when password changed
by AskMonty KB 27 Jun '16

27 Jun '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-when-password-changed/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to get an alert whenever the user with which we are monitoring changes password in the mariadb database ?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-monitoring-when-password-changed/

1 0

[Maria-discuss] New Question: Snchronizing MONyog on two servers
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/snchronizing-monyog-on-two-servers/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to monitor MariaDB database from two servers where MONyog is installed and keep them synchronized. By Synchronization i mean if i add a new monitor on one server then that monitor should automatically be added on the second server?? This is important as if one server where monitoring is done goes down MONyog wil stop monitoring the database. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/snchronizing-monyog-on-two-servers/

1 0

[Maria-discuss] Reg .Net with Entity Framework (ORM)
by Karthick Subramanian 27 Jun '16

27 Jun '16

Hi All, We would like to check whether any of you using .Net with Entity Framework to access Maria DB. If yes, 1. What connector is being used 2. What challenges are facing 3. Any other points that I need to take care while workign with .Net Entity Framework with MariaDB Regards, Karthick

3 2

[Maria-discuss] Include TokuDB Hot Backup in the bundled plugin list
by jocelyn fournier 26 Jun '16

26 Jun '16

Hi, In MariaDB, TokuDB is bundled as a plugin, but it's not the case for the Hot Backup plugin (https://github.com/percona/tokudb-backup-plugin) I have to compile it manually against the server source code to have it working properly. Would it be possible to include it in the bundled plugins ? Thanks! Jocelyn -- Jocelyn Fournier Founder M : +33 6 51 21 54 10 https://www.softizy.com Softizy - At your side to Optimize your PHP / MySQL applications

2 1

[Maria-discuss] New Question: Enabling SSL in mariaDB running on Synology NAS
by AskMonty KB 26 Jun '16

26 Jun '16

Hello, A new question has been asked in "Secure Connections" by og_117488504109613889882. Please answer it at http://mariadb.com/kb/en/enabling-ssl-in-mariadb-running-on-synology-nas/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am having problems with enabling SSL in MariaDB running on Synology NAS (DSM version 6.0) using self signed certificates. I have modified the my.cnf file to point to certificate files and the DB seems to be loading the .cnf file ok, the ssl variables are listing the corect location of the cert files (verified over phpmyadmin) however it still says that ssl is diabled (variable have_ssl=disabled) and the DB is refusing incoming ssl connections. This is my first time working with Synology NAS so I have no idea what to try, so any help or suggestion is most welcome. Thank you in advance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/enabling-ssl-in-mariadb-running-on-synology-nas/

1 0

[Maria-discuss] MariaDB 10.0.26 now available
by Daniel Bartholomew 24 Jun '16

24 Jun '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.26. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.26 - Release Notes: https://mariadb.com/kb/en/mdb-10026-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10026-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.26 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: Traffic Handling For Database Monitoring
by AskMonty KB 24 Jun '16

24 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/traffic-handling-for-database-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- MONyog uses port 5555 for Monitoring the mariadb database which creates a connection on port 3306 on database server. Does this connection creates more load on the 3306 port??? and is there any way to change the port and get the connection established at some other port on which mysqld is not running?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/traffic-handling-for-database-monitoring/

1 0

[Maria-discuss] New Question: US Export Control Classification Number (ECCN)
by AskMonty KB 21 Jun '16

21 Jun '16

Hello, A new question has been asked in "MariaDB Community" by Gareth Smith. Please answer it at http://mariadb.com/kb/en/us-export-control-classification-number-eccn/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I can't find reference to this on any of the pages, so apologies if this is a duplicate. Does MariaDB (specifically 10.1, although others if that version doesn't) have an ECCN from the US Bureau of Industry and Security? If so, what is it please? Thanks very much, Gareth -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/us-export-control-classification-number-eccn/

1 0

Re: [Maria-discuss] MariaDB non-blocking with EPOLL
by Kristian Nielsen 20 Jun '16

20 Jun '16

Dave C <dave.zap(a)gmail.com> writes: > With you help I was able to get the whole thing working this afternoon, > although I will need to spend a lot more time testing and checking I've > caught all the traps. Ok, great! > The core application uses edge triggered epoll for the sake of efficiency > and so far I have not found any problems running the queries now with the > non-blocking API. Yes, I agree edge-triggered is a good way, and it is supposed to work (and if you should find something that does not, I'll fix it). > At this point it's simple so I'm only checking POLLIN as that seems to work > for the connect and query and fetch_row that I'm going. > > I guess the MYSQL_WAIT_TIMEOUT is not being passed because I've just not > run in to that case yet, but will unset it as you mention before passing it > to _cont() > > The timeout on epoll_wait() is set to 1 second, but we never reach that due > the amount of traffic. One second is the max because we must service other > things no later then that, for things such as automatically destroying non > responsive sockets after 30 seconds, including the MariaDB ones. The case > of queries that timeout can be handled in the same way, or else I can check > for standard mysql error codes? Yes, I think you can handle it the same way. It is probably safe to ignore MYSQL_WAIT_TIMEOUT completely. Then the MYSQL_OPT_*_TIMEOUT options for mysql_options() will do nothing, but if you handle non responsive sockets differently anyway, that might be fine. > Thanks again for your help. If I find anything weird I'll drop a post here, > but more often then not the weirdness is on my side. > > One interesting side effect of passing 0 to _cont() functions was the > multitude of segfaults I was getting on other random / unrelated functions > I'll see If I can replicate that once I've bedded everything down. - Kristian.

1 0

[Maria-discuss] MariaDB non-blocking with EPOLL
by Dave C 20 Jun '16

20 Jun '16

Originally posted to : http://stackoverflow.com/questions/37909652/mariadb-non-blocking-with-epoll Edited for context. I have single threaded server written in C that accepts TCP/UDP connections based on EPOLL and supports plugins for the multitude of protocol layers we need to support. That bit is fine. Due to the single threaded nature I wanted to implement a database layer that could utilize the same EPOLL architecture rather then separately iterating over all of the open connections. We use MariaDB and the MariaDB C connector that supports non blocking functions in it's API as described here. https://mariadb.com/kb/en/mariadb/using-the-non-blocking-library/ But what I'm finding is not what I expected, and what I was expecting is described below. First I fire the mysql_real_connect_start() and if it returns zero we dispatch the query immediately as this indicates no blocking was required, although this never happens. Otherwise I fetch the file descriptor that seems to be immediate and register it with EPOLL and bail back to the main EPOLL loop waiting for events. s = mysql_get_socket(mysql); if(s > 0){ brt_socket_set_fds(endpoint, s); struct epoll_event event; event.data.fd = s; event.events = EPOLLRDHUP | EPOLLIN | EPOLLET | EPOLLOUT; s = epoll_ctl(efd, EPOLL_CTL_ADD, s, &event); if (s == -1) { syslog(LOG_ERR, "brd_db : epoll error."); // handle error. }... So then some time later I do get the EPOLLOUT indicating the socket has been opened. And I dutifully call mysql_real_connect_cont() but at this stage it is still returning a non-zero value, indicating I must wait longer? But then that is the last EPOLL event I get, except for the EPOLLRDHUP when I guess the MariaDB hangs up after 10 seconds. Can anyone help me understand if this idea is even workable? Thanks David

2 1