Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [mariadb]

MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.

MariaDB is an open source database server that offers drop-in replacement functionality for .

This MySQL fork has been made by its own original developers, triggered by doubts over the future management of MySQL after its acquisition by Oracle (through Sun Microsystems) in 2009. MariaDB is now released under the GNU GPL, and maintained by the community with the intent to maintain a high compatibility with MySQL APIs and commands.

Supported Storage Engines:

  • MyISAM
  • BLACKHOLE
  • CSV
  • MEMORY
  • ARCHIVE
  • Aria
  • XtraDB (drop-in replacement for InnoDB)
  • PBXT
  • FederatedX (drop-in replacement for Federated)
  • OQGRAPH
  • SphinxSE
  • IBMDB2I
  • Cassandra
  • CONNECT
  • SEQUENCE

Resources:

10 questions
103
votes
3 answers

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 languages differ? Wikipedia only mentions the…
chrisjlee
  • 2,060
  • 4
  • 17
  • 19
4
votes
2 answers

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 table for every user? I tried to logicaly think…
Meletis Flevarakis
  • 143
  • 1
  • 3
2
votes
0 answers

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.LAZY,cascade=CascadeType.REFRESH) @JoinTable(name…
ThinkTank
  • 121
  • 4
2
votes
1 answer

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 setting this query option. Values given in the query…
David Starkey
  • 131
  • 5
0
votes
1 answer

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 data output/analysis/export (which is hosted on…
TomCrow
  • 11
  • 2
0
votes
1 answer

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? What happens under the hood when you do all three…
Victor
  • 3
  • 2
0
votes
1 answer

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 result set through pagination. This is how a typical…
user2180613
  • 1,752
  • 3
  • 14
  • 17
0
votes
1 answer

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 very rarely modified, the total number of…
Dunams
  • 9
  • 1
0
votes
1 answer

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: Dockerfile args: XDEBUG_HOST: 172.17.0.1 …
Dimitrios Desyllas
  • 451
  • 2
  • 4
  • 16
-1
votes
1 answer

Amazon RDS read replica without support from application

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 lot. Unfortunately, I have a PHP application that…
Tero Lahtinen
  • 99
  • 3