Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [database]

System that handles large amounts of data in an organised fashion

Filter by
Sorted by
Tagged with
0 votes
1 answer
15 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 ...
user avatar
  • 101
-1 votes
1 answer
37 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 ...
user avatar
0 votes
1 answer
29 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 ...
user avatar
0 votes
0 answers
5 views

Difference between DB having user-password protection, DEK, TDE

I am a total noob in systems and have questions about DEK. What are differences(or advantages of one over the other) between knowing your username and password for your DB(mysql or mariadb) and DEK. ...
user avatar
0 votes
0 answers
20 views

Allowing docker to access local webhost Database

I am creating a webapp for my business using AppSmith, hosted on Docker. AppSmith requires access to a database in order to read/write information. Previously I have used MariaDB which is also hosted ...
user avatar
  • 101
0 votes
2 answers
43 views

How to find joins performed without indexes?

I run a WordPress website on Mariadb 10.6, and recently I saw an error Joins performed without indexes in Mysqltuner. Although the number is not very large, Mysqltuner recommends that you keep ...
user avatar
0 votes
1 answer
27 views

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 ...
user avatar
0 votes
0 answers
29 views

Can't install/uninstall SQL Server

When I try to install SQL Server Express I got this error Unable to install SQL Server (setup.exe) Then I'm trying to uninstall everything related to the SQL server to avoid previous installation ...
user avatar
  • 101
0 votes
1 answer
33 views

Mysql database often stops and won't restart

Server: Linode Dedicated 4G Ubuntu 18.04, Webmin + Virtualmin Every now and then, mysql server stops and fails on restarting. Here is the logs I was able to find: Apr 11 20:54:57 bamboo kernel: [ 2082....
user avatar
  • 199
1 vote
1 answer
32 views

Idle database connection lost

I am able to connect to the database server (Firebird), run queries, all those fun things, but after an undetermined period of inactivity, the next query attempt generates the following error Unable ...
user avatar
0 votes
0 answers
84 views

MySQL (MariaDB) Not Starting '/usr/sbin/mariadbd: Shutdown complete - mariadb.service: Failed with result 'exit-code'.'

I'm getting an error when i try to start mariadb.service service: Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" ...
user avatar
0 votes
0 answers
12 views

Quorum at Scylla. DR orchestrator

I have a strech cluster with Scylla for 2 data centers with a balancer. The principle of operation is Every_Quirum. (After reading the documentation, I came to the conclusion that all DPCs should work)...
user avatar
0 votes
0 answers
33 views

Are MySQL/MariaDB and Postgresql compatible?

I want to install multiple applications on my web server. For most of them, using PostgreSQL is possible or the only option. But in one of them's installation guide, only MariaDB is mentioned. If I ...
user avatar
  • 1
0 votes
1 answer
47 views

Best way to store database file on a NAS and run the server on a computer

I have a txt file more than 250go I want to create a database with that and access it by a python program that I'll be coding. I have a NAS server on my local network ( 1gbit network ) And I would ...
user avatar
0 votes
0 answers
9 views

Best server option for Django project [duplicate]

I have a Django on Postgres web application. It's a business management software. There are no serious calculations going on, but there's a lot of requests from a database. Right now it's running on ...
user avatar
  • 115
0 votes
0 answers
65 views

Only rdsadmin account on AWS RDS with full master permissions

Good afternoon all, I'm hoping someone is able to help with the following. On our main live database it's just been brought to our attention that we need to be able to kill user processes that are ...
user avatar
0 votes
0 answers
38 views

Best Parctice of High Availability For MariaDB

I'm preparing to run a MariaDB Cluster with HA and I'm Looking for the best practices. Years back I used to run MariaDB in master-master mode, and there was a big issue. whenever any of the nodes(two ...
user avatar
0 votes
0 answers
41 views

Manually close database connections for AWS Aurora Serverless PostgresDB?

Is there any way to manually close all open connections to an AWS Aurora Serverless Postgres database? Because the database is serverless, it is not possible to restart the database.
user avatar
  • 101
0 votes
0 answers
75 views

How do I use the pgpass.conf file to allow promptless connection to a database

for testing purposes I have a postgres service/database running on my local computer. Right now I am using a batch file to change default userlogin, but I cannot use SET PGPASSWORD to pass along a ...
user avatar
0 votes
0 answers
23 views

Server Layout for Web-, API-, Database-, VPN- and SIP Server

i have the possibility to redo our Server Infrastructure - i need your advices and best practices to design a good foundation for future expansion. As we are a quite small company with a very limited ...
user avatar
0 votes
0 answers
21 views

I want to know how to change ip from expire pool to normal after date is extended

I been searching for a solution regarding freeradius revert from expired pool to normal pool when the user paid. I just entered a date and time for a particular user for expiry in mysql. MYSQL ...
user avatar
  • 1
0 votes
0 answers
7 views

How to get Azure Policy Rule JSON script for existing resource

I want to create the custom policy for our databases. the default PITR Backup policy is 7 days but I want that all our newly added databases should be 35 days backup policy, Please any one guide ma ...
user avatar
0 votes
0 answers
14 views

Changing database Elastic Pool disturb the indexes of the database

I have more the 5000 database and 15 Elastic Pools in Microsoft Azure and when I feel the database performance issue we change the Elastic Pool of that database. But today I note that our database ...
user avatar
0 votes
1 answer
55 views

postfix container kubernetes - setting up encrypted secret, configmap for successful db connection

I am trying to run postfix as a container in k8s. The container starts (including the svcs) but my config maps and secrets don't want to play nice. I tried the following: setup the config map with ...
user avatar
0 votes
1 answer
34 views

Does packet size influence the response latency?

I am testing my web application locally against an amazon micro database thats situated in north virginia. I live in Groningen the netherlands. When i send a select query over the public internet it ...
user avatar
  • 107
0 votes
0 answers
153 views

Should the maximum number of request threads be similar to the maximum number of database connections?

I have a spring boot application with an embedded tomcat server. The max-threads setting of tomcat is currently set to 250. Next to that the spring boot application also uses a MySql database as the ...
user avatar
  • 107
0 votes
0 answers
19 views

Mariadb replication - Ignore users changes

I need to set up multi-source replication (3 masters and 1 slave). Since all masters have users with the same name but not the same rights, I'd like to avoid replicating users' changes on the slave ...
user avatar
  • 91
0 votes
1 answer
48 views

Connect to an installed mysql db

I have installed on my application server mysql mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)). My operating system on my VPS is Ubuntu 20.04.1 LTS. To manage this database I ...
user avatar
  • 117
1 vote
0 answers
179 views

Error: File home.asp Unexpected error. A trappable error (C0000005) occurred in an external object. Using ODBC Connector

How can I get my application pool to stop crashing on me? Background All was working well for many years, until I updated Windows 10 Pro to the suggested update Windows Feature Experience Pack. ...
user avatar
  • 203
0 votes
1 answer
14 views

Setting up an architecture for analyses flows of time stream data from multiple sources [closed]

What would be the best practice in terms of AWS for the following: Many IOT medical devices gather data at around 256kBps The data is a time series data (a matrix of [Channels X Samples], there can ...
user avatar
  • 1
-1 votes
1 answer
47 views

mongodb 3.2 cluster database compatibility to mongodb 5.0

We have a mongodb 3.2 production cluster that we need to upgrade to mongodb 5.0. Instead of upgrading in place, we are considering creating a new mongodb 5.0 cluster, export the DB from 3.2, and ...
user avatar
  • 1
0 votes
2 answers
827 views

Why can't I grant select privileges to all table in schema with PostgreSQL?

I have a database my_database, and it have some tables named my_table_1, my_table_2, ... , my_table_128 under schema public. I need to grant select privileges for all tables in schema public to user ...
user avatar
  • 145
-1 votes
3 answers
48 views

Is it possible to host the database on one server, but the actual data on another? [closed]

We're planning to do AI research using an HPC. This HPC will use datasets that we've created. These datasets are fairly big subsets of the entire dataset (~1TB). All the data we've gathered from ...
user avatar
0 votes
1 answer
66 views

AWS architecture - traffic mirroring

We are going to migrate our database from Aurora Serverless to Aurora Cluster. Before that, we'd like to test the performance of the new database in a real-time traffic scenario. We have thought about ...
user avatar
  • 3
1 vote
1 answer
52 views

One user for all databases or different user for different databases?

I have multiple (Wordpress) websites that use different mysql databases. I would like to know if I should use different users for different databases, or just use one user (such as root) for all ...
user avatar
  • 133
0 votes
0 answers
60 views

MySQL 8.0.21 error log is cluttered with [Note] [MY-012102] [InnoDB] Open file list len in shard X is Y

Since we have upgraded our MySQL server to 8.0.21 from 5.7, our error log is cluttered with the following message (if it is even an error message?), which takes a lot of space in our log and it is ...
user avatar
0 votes
1 answer
119 views

Should replica DB be in 'recovery' - PostgreSQL

I have two databases that are using streaming replication and appear to be in this state postgres 16319 0.0 0.5 137949952 3077260 ? Ss Aug22 0:11 /usr/pgsql-12/bin/postmaster -D /var/lib/pgsql/...
user avatar
0 votes
0 answers
18 views

Remove sticky session setup with clustered database - sync delay duplication?

I am currently trying to remove my server setup with "Sticky Sessions" and go over to a setup with a Database for the session storage. Instead of one database (single point of failure) we ...
user avatar
  • 1
0 votes
0 answers
33 views

occasionally momentary loss of name resolution or connectivity between Azure app. instance and AWS DB

We have a PHP application running in an Azure app. instance and it communicates with a Postgres database hosted in AWS. Very occasionally it is unable to communicate with the database: [11-Nov-2021 ...
user avatar
0 votes
2 answers
109 views

What is the best & safe & fastes way to backup a large mysql database?

I have a mysql server running on a Debian server. I have a mysql database wich is 150GB... What is the best way to take a backup of it? I'll say: screen then mysqldump -u user -p database > ...
user avatar
  • 11
1 vote
1 answer
48 views

How could I found net.exe activity log in windows server 2019?

I have Windows Server 2019. it is a database server(MSSQL Server) in the intranet environment. I monitor Its Process and I found sometimes the below process runs automatically without any cause. "...
user avatar
0 votes
0 answers
38 views

How important is it to have authentication on a dockerized database

The docker-compose example on the MongoDB docker hub page has a root password provided to the database and the app, but as far as I know, with docker's networking, only the other containers defined in ...
user avatar
0 votes
0 answers
114 views

I am getting ”The term 'python' is not recognized…” error in Visual Studio

With this error I am not able to run my Django project. python: The term 'python' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name,...
user avatar
0 votes
1 answer
66 views

Need help deciding best MariaDB storage engine for our use case and server hardware limitations [closed]

I work for a small company and we are in need of a data warehouse. Our production database have around 50Gb of data (grows ~10GB/year, currently), our server is running a little over it's capacity and ...
user avatar
0 votes
0 answers
33 views

MySQL not saving to separate data directories

Lately I've been struggling with MySQL and it's data directory a lot. At first, I've tried docker for multiple instances but our company doesn't prefer docker no one knows why. So I come up with a ...
user avatar
0 votes
0 answers
25 views

Getting error while trying to install MariaDB on CentOS

I've got a VPS which runs CentOS 7, and i need to install MariaDB 10.6.4 instead of the default version (5.5), so i completely uninstalled the previous version alongside mariadb-libs However, when i ...
user avatar
0 votes
1 answer
270 views

Master DB latency with AWS RDS cross region replication

I have my app setup in 3 regions (EU, AP, US) and the master MySQL RDS resides in eu-west-1, with read replicas in the other regions. This works great for read queries, with the region specific app ...
user avatar
  • 21
0 votes
1 answer
202 views

Provide Unix Socket connection information for Apache Superset

I have a docker image of Apache Superset running in Google Cloud Run. I have configured it to use our Cloud SQL host for its metadata DB. Due to how you connect Cloud Run to Cloud SQL, this required ...
user avatar
  • 101
1 vote
2 answers
957 views

Can't create free-tier AWS RDS DB

I can't seem to create a 12-month free-tier AWS RDS DB running MySQL. According to AWS, the following requirements need to be met for a 12-month free-tier RDS DB: 750 Hours per month of db.t2.micro ...
user avatar
  • 13
0 votes
1 answer
39 views

Where is the advantage of a professional database (MySQL) over my system?

I have a website and I need to store data about customers, so I made the following system: I made on my server a folder that I called database. In it I created a folder called customers. In this ...
user avatar

1
2 3 4 5
33