Questions tagged [mariadb]
MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.
10 questions
0
votes
1
answer
90
views
Data backup/slave node with replicated data, to be writeable while master is offline
I'm developing and designing a system which runs mostly on intranet of client companies. The system consists of one main database which is MariDB, for now one web-application as system management and ...
- 11
1
vote
1
answer
1k
views
How do you work with closing pools/connections?
I wanted to know when you are done processing some query or transaction do you usually close a connection only? do you close the pool? or do you close both? Does it even matter which one you close? ...
- 13
0
votes
1
answer
921
views
Is deterministic SELECT possible without specifying an ORDER BY?
When we show a table with many thousands of records, we only show a small part of the total result set so as not to send too much data to the client at once. Clients can request more parts of the ...
- 1,792
0
votes
2
answers
657
views
Database dictionary table versus code defined enum
For the following table structure, for the metric_id column, what are the advantages of having a JOIN dictionary table versus an ENUM dictionary defined in the code?
Assuming the metrics dictionary is ...
- 9
2
votes
0
answers
39
views
DataBase design generated by hibernate Many to Many for MariaDB
Hi I am in middle of designing DB and Got a little bit confused about DB Design.
I am Using Hibernate as ORM Tool ahd mapping between Page and Step entity in hibernate.
@ManyToMany(fetch = FetchType....
- 121
2
votes
1
answer
1k
views
Why are unnamed placeholders recommended over named ones?
While setting up a nodejs server with a mariadb database, I found this:
While the recommended method is to use the question mark placeholder, you can alternatively allow named placeholders by ...
- 201
0
votes
1
answer
154
views
Using mysql's\mariadb's root user for development on a docker development environent running multiple application instances
I have setup a docker-based development environment having the following images as you can see in docker-compose.yml:
version: '2'
services:
phpBB_dev:
build:
context: .
dockerfile: ...
-1
votes
1
answer
93
views
Amazon RDS read replica without support from application [closed]
I'm very new to this,so please correct if I'm wrong.
I've understood that with Amazon RDS one can create read replicas and use those for all read-only operations. This helps scaling the application a ...
4
votes
2
answers
8k
views
One table for all transaction VS. Table for each user
I'm making a website which has to do with money transactions. Everything was okay untill I came across the dilemma
Should I have one table to store all transaction history or I should have a seperated ...
104
votes
3
answers
104k
views
What's the difference between MariaDB and MySQL?
What's the difference between MariaDB and MySQL? I'm not very familiar with both. I'm primarily a front end developer for the most part.
Are they syntactically similar? Where do these two query ...
- 2,090