Stack Overflow
Stack Overflow

Questions tagged [mariasql]

A node.js binding to MariaDB's non-blocking (MySQL-compatible) client library

mariasql is a node.js binding to the non-blocking client library provided with MariaDB. It is compatible with MySQL.

This binding is different from other libmysqlclient bindings in that it uses the non-blocking functions available in MariaDB's client library.

Install it with the npm package installer:

npm install mariasql

The source code is located at github:node-mariasql.

References

143 questions
91
votes
12 answers

How to turn on/off MySQL strict mode in localhost (xampp)?

I want to know how to check whether MySQL strict mode is on or off in localhost(xampp). If on then for what modes and how to off. If off then how to on. I already followed http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-full and…
Ipsita Rout
  • 4,945
  • 4
  • 36
  • 40
9
votes
2 answers

mariadb IF statements error message?

I test sql querys. IF 3 = 3 THEN SELECT 'TRUE' ELSE SELECT 'FALSE' END IF; I excuted that query on SQLyog. I got the error message below. You have an error in your SQL syntax; check the manual that corresponds to your…
Mr.Park
  • 123
  • 1
  • 3
  • 10
6
votes
1 answer

Node https callback not firing when loop exits

My problem is probably straight forward, but I can't figure out what's happening behind the scenes. I'm looping through a series of domains in a database table, calling out to them, grabbing the SSL certificate and storing information about it back…
Mblake
  • 383
  • 2
  • 9
6
votes
1 answer

100% CPU usage using clusters and mariaSQL, when cluster is exit and restarted

On my Node.JS app I'm using clusters to utilize my multi-core CPU. I'm using the node's mariasql library to communicate with my database. Since the node-mariasql library does not support pooling, I am using the third party - generic-pool to maintain…
Abijeet Patro
  • 2,842
  • 4
  • 37
  • 64
6
votes
5 answers

Sequelize error with MariaDB

I am trying to setup sequelize as ORM for my MariaDB. Here is my setup: var sequelize = require('sequelize'); var db= new sequelize('dbname', 'user', 'pass', { dialect: 'mariadb' }); When I run my app I get the following error…
Aaron Ullal
  • 4,855
  • 8
  • 35
  • 63
5
votes
2 answers

Hide meta object data in mariaDB when using nodejs

I'm logging the result of some certain query and it's working fine, but I have noticed there are too much metadata are logged as well, how can I disable these metadata from being logged in? screenshot const pool = mariadb.createPool({ …
user15281199
4
votes
3 answers

Php not returning the latest updated sql procedure result

Im using mariaDB, codeigniter php when execute the procedure in workbench it showing correct result. But when i run the same procedure using the php codeigniter its return different result set. array(1) { [0]=> array(1) { [0]=> array(2)…
438sunil
  • 188
  • 1
  • 2
  • 13
4
votes
4 answers

MySQL using Indexes for multiple ORs, but no index for IN and so much slower

I have been busy changing some SQL queries around so that they look more readable to the human eye, i was also told that they would be maybe 5-10% faster. The previous SQL statements would look like this. SELECT * FROM teams WHERE Team1='Joe…
Twingo
  • 43
  • 3
4
votes
2 answers

'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")'

I am trying to setup mariadb galera cluster on Debian Wheezy 7.5. I have found many different instructions, all a bit different, but none have worked thus far. I am trying to setup a two node cluster. On the primary node, I am using the default…
Levon Tamrazov
  • 530
  • 2
  • 9
  • 20
3
votes
1 answer

Mariadb syntax error in multipleStatements

When i am trying to execute the multipleStatements in Mariadb like this db.Connection.query("CALL tep_procedure_out(?,@out_value);Select @out_value",["rahul"], I set {multipleStatements: true} in my connection even though i am getting Error. {…
RAHUL SRV
  • 262
  • 3
  • 24
3
votes
3 answers

what is the correct way to use async await with mariadb query in NodeJs?

I'm new to async/await. I'm trying to use async and await but the query is not waiting and it happens at last and the page renders before the query so I can't get the correct answer on rendered page. Here is my code before using async…
JohnReese
  • 103
  • 2
  • 6
3
votes
3 answers

How to insert json data into MariaDB using Nodejs?

I'm inserting JSON data into MariaDB using NodeJs. Getting below error while inserting data. Please advise what cause to get error. Actually Column data1 no empty or null values.Why am i getting below error ? { [Error: Column 'data1' cannot be…
user2848031
  • 187
  • 12
  • 36
  • 69
3
votes
1 answer

Maria DB configuration on Swisscom cloud

We are going to use next stack: Tomcat 8/Java 8 buildpacked + ELK + S3 + Maria DB. We prepared our package and deployments process is starting ok, but we are stuck on configuring Maria DB. More specifically we need at least next parameters to be set…
Eugene Gy
  • 107
  • 8
3
votes
3 answers

Tailing MariaDB database changes like tailing the MongoDB oplog

Is there a way to listen for database changes in MySQL/MariaDB, in the same way you can tail the MongoDB oplog? I am having trouble finding information on this online. Perhaps it's only available in Postgres and not with MySQL.
Alexander Mills
  • 90,741
  • 139
  • 482
  • 817
2
votes
1 answer

Maxscale readwritesplit show the same number of connections

I've set up Maxscale to ReadWriteSplit with no reads to master (the default) to a Galera cluster (3 nodes). # # Global configuration # [maxscale] threads=auto local_address=10.1.0.11 query_retries=2 # #…
ac_s_fer
  • 53
  • 4
1
2 3
…
9 10