Questions tagged [database]
System that handles large amounts of data in an organised fashion
1,682
questions
-1
votes
0
answers
15
views
Allowing users to register on a website and thus adding entry via a form to database [closed]
we were recently requiered to add an account system to a website.
The website is running with Nginx, and we use PhpMyAdmin to manage the databases.
The forms to register and login were both made in ...
- 1
0
votes
0
answers
20
views
Creating a non-public DNS alias for a database in Google Cloud Platform (GCP)
I am currently working on setting up a database in Google Cloud Platform (GCP), and I would like to create a non-public DNS alias for it. The purpose of this alias is to provide a more user-friendly ...
google-cloud-platform
0
votes
1
answer
25
views
How to add a new database on replication?
I have a mysql replication with two servers.
There are actually 3 databases on it.
On master :
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days ...
0
votes
0
answers
40
views
How to see what is my Amazon elastic beanstalk rds password?
How can I retrieve the database password for my Elastic Beanstalk environment running on the "Aurora MySQL" engine?
I have an IAM user with the necessary permissions to manage the ...
0
votes
0
answers
38
views
Openstack DB issues
Had a power issue and my openstack will not fully come up.
It is showing that I have VM's but from 5 years ago and not recent ones.
I need help bringing it up.
I am running an OLD version of the ...
- 1
0
votes
1
answer
87
views
Mariadb creates a subprocess after crash
We recently had a crash on our Mariadb server (10.6.5) on a Debian 9 VM. The process was restarted without error but now there's a second mariadb process like so :
mysql 26718 5.1 42.4 15062644 ...
- 321
0
votes
0
answers
65
views
Apache Ignite - Automatic Cluster Snapshot Create / Restore Procedure
When trying the Apache Ignite cluster snapshot procedure (snapshot create, restore), the restore operation is not successful.
Before the restore procedure, we have destroyed the cache which we want to ...
0
votes
0
answers
30
views
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 ...
- 1
0
votes
1
answer
150
views
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 ...
0
votes
0
answers
25
views
How to handle scaling upto 3k concurrent connections [duplicate]
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 ...
0
votes
0
answers
27
views
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 ...
- 1
1
vote
0
answers
32
views
Haproxy 2 domain ssl crt conflit
Haproxy load balancer - I configured 2 different domain SSL certificates and get a conflict. For example I have two domains api.xxx.com and api.yyy.com. If try to get api.xxx.com its showing yyy cert ...
- 11
2
votes
1
answer
167
views
How do I give a postgres user all privileges to a specific database?
I'm setting up a new database server which I intend to use as a backend for many services. Each of these services generally only care about a single database in the system, so I'd like to isolate the ...
- 121
0
votes
1
answer
42
views
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 ...
- 113
0
votes
1
answer
461
views
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
...
- 23
0
votes
0
answers
68
views
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 ...
- 101
0
votes
0
answers
35
views
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 ...
- 1
0
votes
0
answers
20
views
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 ...
0
votes
0
answers
19
views
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 ...
- 145
0
votes
2
answers
30
views
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 ...
- 337
0
votes
0
answers
180
views
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-...
0
votes
1
answer
203
views
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 ...
- 1
0
votes
0
answers
161
views
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 ...
- 5
0
votes
0
answers
108
views
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 ...
- 101
0
votes
0
answers
50
views
PostgreSQL Subscribers and Publishers (Multi-Master Scenario)
I'm currently trying to develop a solution that would be trying to focus on Multi-Master Databases
So here is how it's supposed to operate
I want so that whenever an Agent makes a change to a database,...
- 101
0
votes
0
answers
20
views
Determine the number of connections initiated to the database
We have a 3 tier architecture application wherein there is a recent surge in the number of inactive sessions in the database. We are using oracle database and weblogic application server. We have 'n' ...
- 111
0
votes
1
answer
54
views
does it benefit if split multiple sites into multiple database in shared hosting env?
I have been wondering this for long time
let's say I run a server where I hosted 2 PHP sites , they are both heavy on database query
server is multi-core , let's say 4 core 8 thread with bunch of RAM ...
- 176
0
votes
2
answers
390
views
How to calculate log per second?
I have a log management system in which the Clickhouse database has been used alongside metrico/qryn, rsyslog on all the servers (Debian 11) send gathered logs from the system and applications to ...
- 75
0
votes
0
answers
42
views
Synchronization concerns regarding MQTT and InfluxDB
I'm trying to implement mosquitto broker with InfluxDB.
My concern is that the data won't be stored properly, because InfluxDB is a "real-time" database and the MQTT protocol is asynchronous....
- 101
0
votes
0
answers
32
views
LOAD BLOB COLUMN INSTEAD OF FILE
Is there a way to load data from blob column instead of file like
LOAD DATA FROM (SELECT A.B FROM A) INTO TABLE TEMP FIELDS
TERMINATED BY ' ' ENCLOSED BY '"' LINES TERMINATED BY '\n'
instead of ...
- 11
0
votes
0
answers
281
views
Alternatives to RDS Proxy for PG serverless database usage
What other managed Postgres database services exist that are designed for serverless use?
i.e hosted databases that have a similar proxy layer that can handle thousands of connection requests spawned ...
- 143
1
vote
0
answers
294
views
Postgresql - Master\Slave Async Replication - How to quickly fail back and forth?
I have two hosts set up as very simple master\slave. All servers connect to the floating IP 10.1.1.10.
Host A:
Designation: Master
Floating IP - 10.1.1.10
Standard IP - 10.1.1.11
relevant pg_hba....
0
votes
0
answers
48
views
Fixed IP address to an EC2 Instance in CloudFormation
I'm developing an infrastructure in CloudFormation where the database and the application is separated, but since I don't know what IP my application will receive, I can't create a filter for the ...
0
votes
0
answers
213
views
error connecting sequel pro to mysql on mac localhost
i just installed mysql on my mac, with brew. I then started the service and made the secure installation to add a password.
now i can login into my sql from terminal but i'd like to connect also ...
- 11
0
votes
0
answers
73
views
Hard Limit of The Number of AWS RDS Instance
As I checked in this document > https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html#:~:text=DB%20instances,the%20current%20Region it shows the default limitation(Soft-Limit) as ...
- 151
2
votes
1
answer
385
views
Azure SQL Elastic Pool: increase data size max GB with no downtime
We have an Azure SQL elastic pool with a data size max GB setting. We would like to increase this setting to a larger value.
The question is: can you increase the size of the elastic pool max size ...
- 459
0
votes
0
answers
786
views
ERROR 2003 (HY000): Can't connect to MySQL server on '1.2.3.4' (10060)
I've tried to look for a solution and there are many similar questions but somehow none of the solutions are working.
I have a laravel app running on one of my ubuntu servers at 1.2.3.4 IP. I ...
- 1
-1
votes
1
answer
2k
views
Mysql is not starting in UBUNTU 20.4
Mysql fails to start in UBUNTU 20.4. i have no idea what the issue is. Almost i tried everything. nothing worked.
sudo journalctl -u mysql.service -n 100
------------------------------------------
...
0
votes
0
answers
192
views
Restoring MySQL in Jenkins Job - ERROR 2003 (HY000): Can't connect to MySQL server on '172.18.0.3:3306' (111)
I am trying to restore db from a file with commands run as Build step 'Execute shell' in Jenkins. I am getting ERROR 2003 (HY000) when I run the restore command through Jenkins jobs.
However same ...
- 131
1
vote
2
answers
195
views
Connect Access 2016 to remote SQL Server - SQL Server Error 17
Good morning,
I am trying to connect to a SQL server from a remote machine, with ACCESS 2016, using the "External data" option. Both are on the same network.
It is important to note that I ...
- 125
0
votes
1
answer
305
views
mysql crashes when accessing database after upgrade from 5.5 to 5.7
After upgrading mysql from 5.5 to 5.7, one of innodb databases seems corrupted.
mysqldump -u root -p mydatabase > mydatabase.sql Enter password:
mysqldump: Error: 'Lost connection to MySQL server ...
- 83
-1
votes
1
answer
71
views
Unable to get subdomain to connect to MariaDB
So far I can reach the DB from the main domain lets say example.com but connection from the subdomain lets say portal.example.com, don't work. I am currently running Nginx & Varnish & Apache ...
- 1
0
votes
0
answers
59
views
How to know the DB SSH Tunnel credentials from the server itself
I'm a dev and I need to connect to a DB from an external database client, like Navicat or DataGrip in my case, this is very useful because it allows me to create a project and store queries in ...
- 101
0
votes
1
answer
192
views
Minimise client side connection to multi-tenant Postgres databases
My employer currently have multiple Postgres instances (one per customer, having a unique site code) which are physically separated on customer premises. Each customer has 1-4 databases running inside ...
- 101
0
votes
0
answers
458
views
Can I recover a db password?
For our project in GCP, the app has a production Postgres db instance, we don't have the current password, therefore we can't access the db other than through the app. If we change the password, then ...
0
votes
1
answer
99
views
Receving 502 Bad Gateway when trying to access via URL
Unable to access my VM using SSH and receiving 502 Bad Gateway when trying to access via URL.
Get below error :
{"@type":"type.googleapis.com/cloud_integrity.IntegrityEvent", "...
2
votes
1
answer
87
views
How to install cbexport and cbimport on a standalone linux vm to connect to remote couchbase server
I need to use cbexport to export buckets in couchbase and place it in S3. Although I have the credentials to access couchbase I cannot login to the vm on which it is running. So I cannot use the ...
- 55
0
votes
1
answer
343
views
Can I use an UNC path on remote MSSQL server in a store procedure to access remote file?
I have a store procedure on a remote MSSQL server. It has bulk insert from a file.That file is on another server. The file is shared on Ubuntu via Samba.
Can that store procedure access my file? What ...
- 101
-1
votes
1
answer
103
views
Regarding how Big companies set up their databases [closed]
I am trying to understand how do companies which handle a large database requests set up their infrastructure. I have recently created a few python applications which store data in PostGres and ...
- 163
2
votes
1
answer
12k
views
Not able to backup of postgres DB from DBeaver
Hope you are doing great.
We have postgres install on centos server and accessing it through DBeaver from Ubuntu machine.
Whenever we try to take backup of Database it is giving error as "Native ...
- 41