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

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, changes are stored in the agent DB, and then…
RedNet
  • 101
0
votes
0 answers

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' number of processes running in the server, which…
Iowa
  • 111
  • 1
  • 4
0
votes
1 answer

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 spare frequently, specially during busy hour , I…
qtwrk
  • 176
  • 1
0
votes
2 answers

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 promtail for labeling and then promtail sends them to…
Sinux
  • 75
  • 9
0
votes
0 answers

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. So the values might be stored in the incorrect order. Are…
Rui Lima
  • 101
0
votes
0 answers

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 load data infile ?
HARI
  • 11
  • 1
  • 1
0
votes
0 answers

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 by lambda functions? I'm using RDS Proxy + Lambda…
Titan
  • 143
  • 7
0
votes
0 answers

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 installed mysql and everything is working fine for the…
Afifa
  • 1
0
votes
1 answer

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 during query' when trying to dump…
peter
  • 93
  • 13
0
votes
1 answer

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 an instance, with each database containing 20+…
raven-king
  • 101
  • 1
0
votes
0 answers

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 we can access the db let's say using PGadmin but…
John Speavack
  • 1
0
votes
1 answer

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", "bootCounter":"35", "lateBootReportEvent":{…}}
Antwan Tawadros
  • 1
0
votes
1 answer

Tomcat - Persistent Object

I am running a servlet that recommends items based on a data model. The data model has to be loaded into an object from a database each time user makes a request to the sever and since the data is the same for all the users I would like this object…
David
  • 145
  • 1
  • 2
  • 7
0
votes
1 answer

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 user SQL server will use, SQL instance running…
Hrvoje T
  • 101
  • 3
0
votes
1 answer

Why my simple searching query is too slow?

I don't know why searching in my "cities" table is so slow. My query looking for a table "cities" located about 25km from the city. I use this simple query and the database takes almost 20 seconds to return results. SELECT city_destination,distance…
Sahasrar
  • 3
  • 1
  • 3
1 2 3
…
99
100