- discuss - lists.mariadb.org

[Maria-discuss] max_connections variable
by Tanstaafl 08 Jul '14

08 Jul '14

Hello all, How is the max_connections variable used? Apparently it counts the max number of connections for all users combined, but is there a time factor? Ie, is it just simultaneous connections? Or max_connections per day? per hour? Thanks

4 3

[Maria-discuss] Galera cluster with asynchronous slave
by Johnny Antonsen 03 Jul '14

03 Jul '14

Hi! First off let show you what we are trying to achieve: Galera Cluster: MariaDBNode1 - HAProxy - keepalived <- MariaDBNode2 - HAProxy - keepalived <- MariaDB Slave node with GTID MariaDBNode3 - HAProxy - keepalived <- I'm currently working on a high-availability project where we want to use MariaDB 10 and Galera as the backend. Running this system as it is with Haproxy and keepalived works great. We are able to write to the VIP that is being moved between each node and haproxy takes care of redirecting the server with least connections. The problem comes when we want to do a standard master/slave replication from the cluster to an external slave. The slave is set up to connect to the VIP (or I have also been testing with connecting directly to the haproxied ip), and Using_gtid is set to Slave_pos. However, after some time, once the connection changes to a different node through haproxy, the following error occurs: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 3-1-422, which is not in the master's binlog' And the Slave_IO_State shows that it's no longer in sync. I have run SELECT @@GLOBAL.gtid_slave_pos; to check what the current GTID for each node is, and they all return: 1-1-2145, however, sometimes if I add a lot of data, that value is different on some nodes, which is why I think the slave gets confused. On the slave, when activating using_gtid=slave_pos, the following gtid_IO_pos appear: 1-1-2464,2-3-420,3-1-422 From what I have read, this should be somewhat correct, as the first value is the server id. However, in the config I have specified that node 1 has server id 1, node 2 has id 2 and so on, and that the same goes for gtid_domain_id. Is this the correct setup or do the nodes need to have the same server-id or gtid_domain_id? Surely there must be a good way to solve this? Is the system not built to handle an asynchronous slave replicating from one random node? Hope I can get some good feedback on this. Just as a side-note, I'm fairly new to mariadb and galera cluster, so be gentle :) With best regards Johnny Antonsen

1 0

[Maria-discuss] information about functions
by Roberto Spadim 02 Jul '14

02 Jul '14

hi guys! does information plugin show something about, what functions i'm using in my mariadb server? for example, i want know what udf functions are being executed and for a second step, there's something to block functions ? like some user only use sum() and min() max(), i want to block count() function -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 1

Re: [Maria-discuss] Utexas MariaDb Repository Down?
by Colin Charles 30 Jun '14

30 Jun '14

Hi! On 30 Jun 2014, at 09:25, Dirk Collins <collins.dirk(a)gmail.com> wrote: > I have not been able to download MariaDB from the UTexas Austin secured archive... The files are being corrupted by the server there, and it doesn't seem like the Java Web Publishing app they are using down there is working properly. > > Is there any alternative cloud servers or torrents where I can download 10.0.12 for Windows, either as an MSI or Zip file? You might try: http://ftp.osuosl.org/pub/mariadb/mariadb-10.0.12 And for the Windows files, they are: http://ftp.osuosl.org/pub/mariadb/mariadb-10.0.12/winx64-packages/ HTH -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] New Question: Support for non autoincrement kes
by AskMonty KB 28 Jun '14

28 Jun '14

Hello, A new question has been asked in "Archive" by openiduser42: -------------------------------- This documentation says "ARCHIVE allows a maximum of one key. The key can be a PRIMARY KEY on an AUTO_INCREMENT column. However, it has a limitation ...". This sounds like AUTO_INCREMENT is an optional setting that causes a limitation, but trying to create an archive without auto increment gives an error: CREATE TABLE t1 (id int NOT NULL, PRIMARY KEY (id)) ENGINE = ARCHIVE; Error: Can't create table `test`.`t1` (errno: 140 "Wrong create options") Just adding AUTO_INCREMENT solves the problem. So, is this a bug or AUTO_INCREMENT is mandatory for ARCHIVE tables? If so, the documentation should say MUST, not CAN. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/support-for-non-autoincrement-kes/

1 0

[Maria-discuss] New Question: Connect Spring Hibernate and C3p0 application to Mariadb through SSL certificate authentication.
by AskMonty KB 25 Jun '14

25 Jun '14

Hello, A new question has been asked in "MariaDB FAQ" by ashishjagtap: -------------------------------- I have created application in Spring,Hibernate and c3p0 which is now connecting to Mysql database. now we are migrating our application to MariaDB (Server version: 5.5.5-10.0.7-MariaDB Source distribution) through SSL. following is the configuration file that we are using to connect to Mysql database JDBC.properties jdbc.initialPoolSize=10 jdbc.maxPoolSize=30 jdbc.minPoolSize=5 jdbc.acquireIncrement=3 jdbc.acquireRetryAttempts=0 jdbc.preferredTestQuery=SELECT 1 jdbc.idleConnectionTestPeriod=600 jdbc.numHelperThreads=10 jdbc.debugUnreturnedConnectionStackTraces=true jdbc.mydbUrl=jdbc:mysql://myhost.com:3306/mydb?verifyServerCertificate=true&useSSL=true&requireSSL=true&characterEncoding=utf8 jdbc.mydbUsername=myuser datasource-context.xml <bean id="mydbCommon" class="com.mchange.v2.c3p0.ComboPooledDataSource" abstract="true" destroy-method="close"> <property name="driverClass" value="${jdbc.rptdbDriverClassName}"/>  <property name="initialPoolSize" value="${jdbc.initialPoolSize}"/> <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/> <property name="minPoolSize" value="${jdbc.minPoolSize}"/> <property name="acquireIncrement" value="${jdbc.acquireIncrement}"/> <property name="acquireRetryAttempts" value="${jdbc.acquireRetryAttempts}"/> <property name="preferredTestQuery" value="${jdbc.preferredTestQuery}"/> <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/> <property name="numHelperThreads" value="${jdbc.numHelperThreads}"/> <property name="debugUnreturnedConnectionStackTraces" value="${jdbc.debugUnreturnedConnectionStackTraces}"/> </bean> <bean id="mydb" parent="mydbCommon"> <property name="jdbcUrl" value="${jdbc.mydbUrl}"/> <property name="user" value="${jdbc.mydbUsername}"/> </bean> we are able to connect to DB server through command line using following command mysql -h myhost.com -P3306 -umyuser --ssl-ca ca.crt --ssl-cert app.crt --ssl-key my-key.key now how can I specify --ssl-ca,--ssl-cert and --ssl-cert files while connecting to MariaDB through Hibernate and c3p0. or what is the steps to connect to MariaDB database through SSL using c3p0 and hibernate. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-spring-hibernate-and-c3p0-application-to-m…

1 0

[Maria-discuss] New Question: MariaDB Galera 10 stable?
by AskMonty KB 25 Jun '14

25 Jun '14

Hello, A new question has been asked in "Galera" by massimilianoadamo: -------------------------------- I am using MariaDB-Galera 10 on preprod & test environments and I haven't seen any problem so far. Any chance to see a so-called stable version? Hurry up: Percona XtraDB Cluster 5.6 is out from quite long time... -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-10-stable/

1 0

[Maria-discuss] User feedback statistics
by Colin Charles 21 Jun '14

21 Jun '14

Hi, http://mariadb.org/feedback_plugin/ in question -- where do we find out information about storage engines in use? List of loaded plugins? So far I see: http://mariadb.org/feedback_plugin/stats/features/ - which has some information but clearly not all information Can we also get access to all the information like if people are using the threadpool or not? I know that information is generated and we're receiving it, but we're just not exposing it (I mean I see this from SELECT * FROM information_schema.feedback;) Its also a good way to see if users are using something like the PERFORMANCE_SCHEMA Let me know how one can access this information (and even better how this can be exposed in the web interface) cheers, -colin -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

3 3

[Maria-discuss] New MariaDB book: Building a Web Application with PHP and MariaDB
by Daniel Bartholomew 18 Jun '14

18 Jun '14

I just received an email from Packt about a new MariaDB book they've just published, Building a Web Application with PHP and MariaDB: A Reference Guide, by Sai Srinivas Sriparasa. If you're interested, check it out: http://www.packtpub.com/building-a-web-application-with-php-and-mariadb/book I was not aware that this book was in the works, so it was a nice surprise! I'm going to pick up a copy, give it a look through, and write up a review on my personal blog. It's been a looong time since I've done anything with PHP (over ten years), so I won't have a lot to say about that part of the content, but I'm reasonably current with MariaDB. ;-) Thanks. -- Daniel Bartholomew, MariaDB Release Manager MariaDB | http://mariadb.com

1 0

[Maria-discuss] Easy way to see different users@hosts connected to all databases?
by Tanstaafl 18 Jun '14

18 Jun '14

Is there a simple command I can issue to see a list of the current users@hosts connected to all of the databases of a running mariadb server? I'm trying to troubleshoot a problem where an update from 5.5.30 to 5.5.37 recently caused all of the connections from my groupware host to start coming from a different hostname, and so were being denied. I need to be able to see if changes that I make change the hostname being used. Thanks, Charles

3 5