Reddit | MariaDB
0 FOLLOWERS
Reddit gives you the best of the internet in one place. The subreddit is for the maria database.
Reddit | MariaDB
3d ago
Do I have to add index manually?
Or MariaDB adds an Index for me?
Create table posts ...
CONSTRAINT FOREIGN KEY (user_id)
REFERENCES users (id)
ON UPDATE CASCADE
Post table has user_id. Will it be index automatically? Do I have to add an index manually now?
How do I check if there is an index already?
submitted by /u/Mahesh-Thought
[visit reddit] [comments ..read more
Reddit | MariaDB
3d ago
putting mariadb on a server?
submitted by /u/savant78
[visit reddit] [comments ..read more
Reddit | MariaDB
6d ago
I was thinking to design tables for quiz.
Quiz Table
‘’’id primary key title/name varchar other infos (createdon, user id, status…)’’’
Questions table
id question fk_quiz_id
Choices id choice fk_question_id
This is by basic idea. Alternatively i can create something like this.
Quiz
id title questions json (array of questions with choices)
I feel the json variation is better than relational..
What is the advantage and disadvantage with JSON?
This is the first time i am thinking to use JSON.
submitted by /u/Naive-Staff6186
[visit reddit] [comments ..read more
Reddit | MariaDB
1w ago
Hello MariaDB Community,
We are currently using DBeaver to import a CSV?
We need that CSV import, but we want to automate it; hence we need to actually write the SQL for it.
How can we replicate that import we do with DBeaver in a SQL Statement?
https://preview.redd.it/16hsjgravttc1.png?width=619&format=png&auto=webp&s=58fb73b441d3877f0034f0eacc2d068438c9601e
submitted by /u/Mr_LA
[visit reddit] [comments ..read more
Reddit | MariaDB
1w ago
Hello from the MariaDB team! We are specifically part of the teams that develop the roadmap for MariaDB database products, and provide support and services for our customers. Join our head of product Joe Cotellese and head of technical operations (i.e. our support and services organizations) Ben Stillman in this upcoming AMA. Our focus will be on answering questions we know best – features and functionality around MariaDB Server and other MariaDB products (MaxScale, ColumnStore, etc), best practices for deploying and operating MariaDB, and questions about us or our product and technical opera ..read more
Reddit | MariaDB
1w ago
Hello, I am more or less following redmine documention for installing and running mariaDB and redmine but seem to have gotten stuck at one of the steps.
I need to input command "RAILS_ENV=production bundle exec rake db:migrate" but when I do I get error "Unknown system variable 'transaction_isolation'". When I search for this error I get a solution to execute
select @@transaction_isolation;
select @@version;
in the mariaDB server command line. When I do this though I just get next line ">" and nothing happens. Any thoughts on how to proceed from here?
Ver: MariaDB 10.6.16
submitted by /u ..read more
Reddit | MariaDB
1w ago
In case you're interested in attending the live Q&A on Apr 17th at 12 PM CST, sign up here.
https://go.mariadb.com/GLBL-WBN-AMA-webinar1-2024-04-17_Registration-LP.html
submitted by /u/Enrique-M
[visit reddit] [comments ..read more
Reddit | MariaDB
1w ago
This may or may not be the best place to ask - longtime lurker, first time poster, RHCSA certified. Be gentle!
I am trying to restore an application database dump provided by a cloud vendor and it's very clear it came from MariaDB.
When importing the database I'm reaching an error that says the database/schema exceeds 64 indexes in a table. From what I see the community default is 64 - it looks like there is a way to manually compile it from source for more (./configure --with-max-indexes=256) but so far I still get the 64 index limit when importing. Has that option been removed since Enterpr ..read more
Reddit | MariaDB
2w ago
Hi
I have a galera cluster that I'm building up as below. I bootstrap the cluster from node1. My issue is that when node1 and 2 go down I can't get them back up again. I'd assume node3 and 4 could orchestrate the rebuild but it is totally dead. That and building node2 makes the whole of site A useless. Should I get a third node on Site A and Site B? This was a recommended configuration so I'm not sure if I'm doing something else wrong.
https://preview.redd.it/vehgppu26gsc1.png?width=674&format=png&auto=webp&s=50fd3cfc180f8c93f27d59645e868f82704127be
submitted by /u/pucky_wins ..read more