MariaDB

Application and Data / Data Stores / Databases

Joshua Dean Küpper

CEO at Scrayos UG (haftungsbeschränkt)·Mar 14, 2019

Shared insights

Scrayos UG (haftungsbeschränkt)

(

JustChunks

)

We primarily use MariaDB but use PostgreSQL as a part of GitLab , Sentry and Nextcloud , which (initially) forced us to use it anyways. While this isn't much of a decision – because we didn't have one (ha ha) – we learned to love the perks and advantages of PostgreSQL anyways. PostgreSQL's extension system makes it even more flexible than a lot of the other SQL-based DBs (that only offer stored procedures) and the additional JOIN options, the enhanced role management and the different authentication options came in really handy, when doing manual maintenance on the databases.

11 upvotes·326.9K views

Needs advice

and

I have a lot of data that's currently sitting in a MariaDB database, a lot of tables that weigh 200gb with indexes. Most of the large tables have a date column which is always filtered, but there are usually 4-6 additional columns that are filtered and used for statistics. I'm trying to figure out the best tool for storing and analyzing large amounts of data. Preferably self-hosted or a cheap solution. The current problem I'm running into is speed. Even with pretty good indexes, if I'm trying to load a large dataset, it's pretty slow.

2 upvotes·74.4K views

Replies (1)

akarsh3007

Sep 18, 2020

Recommends

Druid

Druid Could be an amazing solution for your use case, My understanding, and the assumption is you are looking to export your data from MariaDB for Analytical workload. It can be used for time series database as well as a data warehouse and can be scaled horizontally once your data increases. It's pretty easy to set up on any environment (Cloud, Kubernetes, or Self-hosted nix system). Some important features which make it a perfect solution for your use case. 1. It can do streaming ingestion (Kafka, Kinesis) as well as batch ingestion (Files from Local & Cloud Storage or Databases like MySQL, Postgres). In your case MariaDB (which has the same drivers to MySQL) 2. Columnar Database, So you can query just the fields which are required, and that runs your query faster automatically. 3. Druid intelligently partitions data based on time and time-based queries are significantly faster than traditional databases. 4. Scale up or down by just adding or removing servers, and Druid automatically rebalances. Fault-tolerant architecture routes around server failures 5. Gives ana amazing centralized UI to manage data sources, query, tasks.

4 upvotes·1 comment·67.5K views

pionell

September 23rd 2020 at 7:58AM

thanks, looking into this!

Needs advice

and

I'm researching what Technology Stack I should use to build my product (something like food delivery App) for Web, iOS, and Android Apps. Please advise which technologies you would recommend from a Scalability, Reliability, Cost, and Efficiency standpoint for a start-up. Here are the technologies I came up with, feel free to suggest any new technology even it's not in the list below.

For Mobile Apps -

native languages like Swift for IOS and Java/Kotlin for Android
or cross-platform languages like React Native for both IOS and Android Apps

For UI -

React

For Back-End or APIs -

Node.js
PHP

For Database -

PostgreSQL
MySQL
Cloud Firestore
MariaDB

Thanks!

11 upvotes·133.5K views

Replies (7)

awesomebanana2018

CEO at ME!·Jul 25, 2020

Recommends

Flutter

My Recommendations: Front End: Flutter because of developer tooling and powerful declarative widget system Back End: Node.js or Go because Node.js has a large ecosystem and Go has a good built in http setup Database: Cloud Firestore because of ease of use, NoSQL, and the ability to set data from the client

14 upvotes·2 comments·11.2K views

anandarao493

July 27th 2020 at 4:46PM

Thanks, since Google cloud Firestore is a NoSql database, I'm wondering how does it work for an app where it does daily transactions in a user checkout flow, etc.. ?

awesomebanana2018

July 27th 2020 at 5:50PM

I'm not entirely sure what the question is about, as I don't see any problem using Cloud Firestore for transactions, but here is a use case for using Firestore with stripe: https://firebase.google.com/docs/use-cases/payments

Ezra Fayet

FullStack Dev ·Jul 27, 2020

Recommends

Node.js

If you go with react / react native I advice you to go with node. Why ? I first didn't believe coding in javaScript everywhere (back, front and db queries) was making life SO much more easy. I still followed the advice, in the end this is a huge relief. For a small startup project with 1/2/3 devs, using only one langage increases efficiency a lot. You can switch very fast from a topic to another.

8 upvotes·9.5K views

View all (7)

Mary Kehner

Developer at Karsun·Apr 7, 2021

Needs advice

MySQL WorkBench

and

HeidiSQL

My Stack

I'm a SQL Server person and researching which tool is more like SSMS for use with MariaDB? Thank!

2 upvotes·3.9K views

Greg Smethells

CTO and Software Architect at Medstrat·Sep 10, 2020

Needs advice

Datadog

and

AppOptics

My Stack

We use AppOptics. I am curious what are the current leaders for APM for small companies (50 employees) that use Python, MariaDB, RabbitMQ, and Google Cloud Storage. We run both Celery and Gunicorn services. We are considering Datadog or some other deep code profiling tool that can spot I/O, DB, or other response time/request rate issues

3 upvotes·68.8K views

Replies (1)

Maik Schröder

CIO at Instana·Sep 19, 2020

Recommends

Instana

If you want to get deep insights and fast issue resolution have a look at INSTANA.

There is a public sandbox to get first insights and feeling for the tool. If you like it you can also run a free trial if you like.

Instana - Getting Started with APM (instana.com)

2 upvotes·2 comments·3.7K views

Gal Cohen

February 2nd 2021 at 7:47AM

We are running Python & Celery, our stack is based on AWS ECS. We are using NewRelic. This tool is just amazing, both for API and Offline workers. It would provide any metric I was looking for, including a profiler, SLA / SLO dashboards, infrastructure metrics. It has alerting capability that is easily integrated with Pingdom / PagerDuty / Webhooks.