Questions tagged [database]

System that handles large amounts of data in an organised fashion

Filter by
Sorted by
Tagged with
-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 ...
StopSign's user avatar
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 ...
Isla Yoder's user avatar
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 ...
erwann le guevedec's user avatar
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 ...
Muzamel Saleem's user avatar
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 ...
ebarak's user avatar
  • 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 ...
Ror's user avatar
  • 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 ...
cookie_marsh's user avatar
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 ...
6a5h4's user avatar
  • 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 ...
swegbarca's user avatar
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 ...
Shamsudeen McHalwai's user avatar
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 ...
Kay's user avatar
  • 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 ...
robin's user avatar
  • 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 ...
slondr's user avatar
  • 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 ...
tnk479's user avatar
  • 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 ...
uozzyy's user avatar
  • 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 ...
Ryan's user avatar
  • 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 ...
dll's user avatar
  • 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 ...
goldilocks's user avatar
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 ...
Rhecil Codes's user avatar
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 ...
best_of_man's user avatar
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-...
sudojarvis's user avatar
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 ...
Mathieu's user avatar
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 ...
biplab 's user avatar
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 ...
linus's user avatar
  • 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,...
RedNet's user avatar
  • 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' ...
Iowa's user avatar
  • 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 ...
qtwrk's user avatar
  • 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 ...
Sinux's user avatar
  • 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....
Rui Lima's user avatar
  • 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 ...
HARI's user avatar
  • 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 ...
Titan's user avatar
  • 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....
NOC_Ninja982134's user avatar
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 ...
André Chrisostomo's user avatar
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 ...
rita1989's user avatar
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 ...
WICHPONG KAO-IAN's user avatar
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 ...
A X's user avatar
  • 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 ...
Afifa's user avatar
  • 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 ------------------------------------------ ...
Seeking solution's user avatar
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 ...
Waqas's user avatar
  • 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 ...
Andy McRae's user avatar
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 ...
peter's user avatar
  • 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 ...
Sam's user avatar
  • 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 ...
Alcides's user avatar
  • 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 ...
raven-king's user avatar
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 ...
John Speavack's user avatar
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", "...
Antwan Tawadros's user avatar
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 ...
Rohini's user avatar
  • 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 ...
Hrvoje T's user avatar
  • 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 ...
Slartibartfast's user avatar
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 ...
Satish Lamak's user avatar

1
2 3 4 5
34