Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion

A database is a system of handling and organising large amounts of data that can be easily created, reference or edited.

SQL (Structured Query Language) is a database computer language that is designed for managing the data in a relational database management system.

Some popular database systems include:

  • FileMaker Pro
  • IBM DB2
  • Microsoft Access
  • MySQL
  • Microsoft SQL Server
1684 questions
0
votes
0 answers

InfluxDB influxQL v1.8 : Wrong timestamp used for writing to database

I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a systemd-timer. That's a pretty nice working workaround for the…
6a5h4
  • 1
  • 1
0
votes
1 answer

Postfixadmin can't connect to mysql database (MariaDB)

I am trying to make my own mail service using Postfix, but I run into an issue in the setup phase, and it's that postfix can't connect to the database. Here's what the error log says: ⛔Database connection string :…
swegbarca
  • 1
0
votes
0 answers

How to handle scaling upto 3k concurrent connections

So here's our use case: We have firmware that connects to server (simple php file - that takes post request) and add the data (350-500 bytes per request) to database. Now here's a issue we have 3k units in the market and non-technical manager wants…
Shamsudeen McHalwai
  • 1
0
votes
0 answers

Undestanding how to connect remotely to a Mysql database

Even if I found many old questions around this topic, I'm still unable to connect to a mysql database remotely. Beside my own specific issue I'd like to point out what are my doubts, in hope to serve whoever comes next, and it's a newbie like…
Kay
  • 1
  • 1
0
votes
1 answer

What's a good approach to finding the source application that's attempting to access a database with an incorrect password?

In order to improve our security posture, we changed several dozen internal applications over to using a new username and password to access an AS400 database a few months back. However, there is some mystery process running on a Windows Server…
tnk479
  • 113
  • 3
0
votes
1 answer

HAProxy and postgres

My haproxy configuration is as below, in the backend there is pg_autoctl cluster, another VM (bunty4) hosts the monitor and haproxy is installed on it. global maxconn 100 defaults log global mode tcp retries 2 timeout client…
uozzyy
  • 23
  • 3
0
votes
0 answers

Configuring HAProxy on EC2 to listen on 0.0.0.0 then using security group to whitelist IPs to DB in private subnet

Right now I have a VPC with an EC2 instance in a public subnet and a Redshift DB in a private subnet, allowing traffic inbound from the EC2 instance. My company does not use a traditional intranet setup, so Redshift is not immediately accessible by…
Ryan
  • 101
  • 1
0
votes
0 answers

mysql metadata locks persist after thread is terminated

this is tested on mysql 8.0.28, but other versions show it too we get occasions where a metadata lock persists after the thread that created it has terminated. For example for these locks in performance_schema.metadata_locks | OBJECT_TYPE |…
dll
  • 1
  • 1
0
votes
0 answers

Optimal Firebase Realtime Database user groups and permissions design

I'm attempting to design a Realtime Database with Firebase that will be scalable as our company grows, and I'm not sure what will be most beneficial long term. I'm looking to create user groups to restrict access to different nodes in the database…
goldilocks
  • 1
  • 1
0
votes
0 answers

What are the AWS "equivalents" for these DO products and services?

We are currently running a web application with a Laravel back-end and a Vue JS front-end on DO managed IaaS products: App Platform Managed Database Cluster (MySQL) We are planning to migrate to AWS to satisfy customer requirements around security…
Rhecil Codes
  • 145
  • 4
0
votes
2 answers

What database my applications will use if I have a locally installed database beside it's pod running on local Kubernetes?

I have installed mysql on my Ubuntu machine. I also have a locally running Kubernetes and deployed a mysql deployment on Kubernetes and can reach to that using kubectl exec -it mysql-b4769786-5hf4m sh command, then mysql -p. I am a little confused…
best_of_man
  • 367
  • 1
  • 3
  • 12
0
votes
0 answers

Unable to connect to the database

I am using docker-compose to set up umami.But it seems that umami is not up. I have checked log file umami. Here it is what looks like. yarn run v1.22.19 $ npm-run-all check-db update-tracker start-server $ node scripts/check-db.js ✓ DATABASE_URL is…
sudojarvis
  • 1
  • 1
  • 2
0
votes
1 answer

How to upgrade a MariaDB database to utf8mb4_unicode_ci?

I have a Drupal 9.4.8 website a MariaDB database and phpMyAdmin. My website is already active with data in its 220 MB database. How to upgrade a MariaDB database to utf8mb4_unicode_ci ? Here is my website setup : enter image description here Here is…
Mathieu
  • 1
0
votes
0 answers

zabbix connection to external database

0 I am trying to setup zabbix with two database , one on localhost and another on diffrent machine. zabbix server: 192.168.0.100 external database :192.168.0.154 I setup zabbix with localhostdatabaase and its working perfectly,Then I created sql…
biplab
  • 5
  • 2
0
votes
0 answers

How to expose multiple databases in local network for other applications to connect with them

I am following up this question here, in which I made the incorrect assumption of being able to access a database using HTTP. Because I seem to lack conceptual knowledge, I would like to ask a more general question first: What's a good way to expose…
linus
  • 101
  • 2
1 2 3
…
99
100