Questions tagged [database]
System that handles large amounts of data in an organised fashion
1,649
questions
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 ...
- 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 ...
- 101
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 ...
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.
...
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 ...
- 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 ...
- 3
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 ...
- 3
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 ...
- 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....
- 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 ...
- 111
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" ...
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)...
- 1
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 ...
- 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 ...
- 3
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 ...
- 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 ...
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 ...
- 471
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.
- 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 ...
- 11
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 ...
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 ...
- 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 ...
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 ...
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 ...
- 41
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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.
...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 109
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 ...
- 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 ...
- 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 ...
- 101
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/...
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 ...
- 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 ...
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 > ...
- 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.
"...
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 ...
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,...
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 ...
- 103
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 ...
- 1
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 ...
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 ...
- 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 ...
google-cloud-platform
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 ...
- 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 ...
