Questions tagged [database]
System that handles large amounts of data in an organised fashion
1,605
questions
1
vote
1answer
29 views
How can I track user requests to my external API on AWS?
I'm a bit of a beginner but I'm working on creating an external API with AWS SAM (using API Gateway and Lambda), and I want a way to track & monitor usage.
Some options I was considering:
1. Store ...
0
votes
0answers
44 views
kubernetes mariadb-galera cluster - bitnami helm chart - Readiness probe failed
I am trying to setup a mariadb-galera cluster through the bitnami helm chart in my kubernetes cluster (1 master, 3 nodes). I have modified the myvalues.yaml to include an existingClaim: dbstorage and ...
0
votes
1answer
17 views
How to best setup SQL 2019 with 6 drives?
SQL 2019; Dell R710 2x2.93 GHz x5670; 144 GB RAM; 6 - 2 TB drives
Derived from a previous question (posted here 10 years ago), I figure 3 x RAID 1 is the best way to go. Please correct me if I am ...
0
votes
0answers
14 views
Cant Remote mongodb using public IP ubuntu 18.04 , GCP
I created a virtual machine ubuntu18.04 and install mongodb using sudo apt install -y mongodb then uncomment PORT in .conf then change 127.0.0.1 to 0.0.0.0 then restart mongodb then when i try to ...
1
vote
0answers
36 views
Best MySQL/MariaDB scaling strategy for shared hosting provider
As a small shared hosting service provider our MariaDB server is going to face a hardware limit very soon. So we want to add another machine for another MariaDB instance.
Our goals are:
Reduce disk/...
-1
votes
0answers
33 views
Azure: An attempt was made to access a socket in a way forbidden by its access permissions 10.0.0.4:3306
I created a mysql database instance in North Europe, then a Web app there in
North Europe, via VS published in Azure and at startup I get an exception as in the screenshot. Everything works locally in ...
0
votes
0answers
14 views
Efficient lookup from file in nodejs?
I am wanting to write a node application that looks up a bunch of blacklists from plain text files. Basically are all under directories representing different categories, and in each there is a file ...
0
votes
0answers
9 views
Monitor postgres resources “per database” within a single server (Running within RDS)
Scenario:
One database server (hosted in RDS) is running multipe databases within it.
Within server my-db-server:
customer
rpt
analyze-db
Goal:
Split the rpt database out of my-db-server and move ...
0
votes
2answers
54 views
Is Azure Managed Disks enough to ensure high-durability for a database?
I want to set up a database in a high durability set-up on Azure. I've previously relied on DB-as-a-service offerings, but can't do that in this case, so I'd like your feedback on the plan below. Is ...
1
vote
0answers
33 views
PostgreSQL cannot work when opens SSL on Windows 10
I am not sure this topic will fit here but I don't know ask it where.
I am trying to open the SSL of PostgreSQL 10.16 on Windows10.
I read a lot of documents about creating an SSL certificate to ...
0
votes
0answers
24 views
Is this a normal number of database connections?
Check out this graph of my database connections. I am running a Postgres database on Lightsail, and I am connecting to it from a single Ubuntu instance running a single instance of Express and ...
0
votes
0answers
4 views
Wordpress Feedback -> NimbleCRM
I just upgraded to a business account. I know that the default contact form feeds into a feedback table which can be exported to a CSV file. How do I automate the process so that the data in the ...
0
votes
0answers
44 views
mysql not answering haproxy calls
I have to build a fallback system, if the main mysql server fails. So, i wanted to do this with the haproxy, instead of implementing it into the software (because via proxy it should be much easier)
...
0
votes
0answers
38 views
Drupel 9, GD not enabled
I have for hours been attempting to set up a Drupel database, but have been stumped on this error message:
"PHP extensions
Disabled
Drupal requires you to enable the PHP extensions in the ...
0
votes
0answers
22 views
How can I automate the importing of txt files to a MySql database?
I'm running a database on AWS Lightsail and I have a bunch of .txt files I want to import into the database. I can't merge the files because I want to create one table per text file (table name = txt ...
0
votes
2answers
51 views
Mysql Server, with Mariadb Slaves, disk usage high and many binlog files
I have a Mysql Master server and a few MariaDB slaves connected to it. I have an issue in that my disk usage on the slaves have gone a bit mad.
My master server is 163GB with bin log files of 100Mb ...
-1
votes
2answers
38 views
phpMyAdmin in a seperate domain in centos 7 [closed]
The issue right now is that I want to maintain a database and I have planned to manage that with phpmyadmin and i have configured it but right now what it looks like is
mydomain.com/phpmyadmin
What ...
0
votes
1answer
48 views
Could I create a Postgres user without unix User?
I'm newbie in Postgres and I having trouble creating users.
I have created a Unix user and a Postgres user:
sudo adduser aubudb
sudo -u postgres createuser --interactive # Same name
sudo -u postgres ...
1
vote
1answer
33 views
What is the best way to keep files in sync between an EC2 instance and a local Win Machine?
Premise: I'm a complete newb. So any gentle hints are much appreciated :)
So, I spun up an EC2 instance and dumped my scraper I had built in Python. I've set up cronjobs to run my scraper at scheduled ...
0
votes
1answer
51 views
Which is my SQL server name for connecting to the online database by SSMS?
I created a database 'dbDemo' (MS SQL Server 2012) by Plesk on Google Cloud Platform and for connecting to this database from another local machine I changed the TCP Port 1433 on my online server ...
google-cloud-platform
1
vote
1answer
34 views
What could go wrong if I let users create their own Mongo collections?
I am in the process of building a basic no-code solution to build RESTful APIS that support CRUD operations on a MongoDB collection. Right now it is just a Proof of Concept project that I use ...
0
votes
0answers
21 views
What data storage services in AWS provide strong consistency?
I am trying to draw a comparison of data storage solutions provided by Amazon AWS and one of the main aspects of such analysis I’m trying to address is consistency vs performance/throughput, as that ...
0
votes
1answer
47 views
Security issue with pg_hba.conf
I have a PHP script on my server that needs access to a database user to work properly . The person who programmed that PHP script has told to add the following to pg_hba.conf :
host all all 127.0.0.1/...
1
vote
0answers
31 views
Why is my mongodb setup not reaching EBS IOPS limit?
I have an application that is constantly pumping data to MongoDB. MongoDB instance is running with 2-replicas, each with 3TB gp2 EBS volume.
As you can see on the following graph of
irate(...
0
votes
0answers
32 views
CouchDB template for Zabbix not working
I have CouchDB2 and template found on GitHub https://github.com/wanadev/zabbix-agent-extension-couchdb3. I know this template is for version 3 but I went and gave it a try since the templates for ...
1
vote
0answers
34 views
How are Prometheus Snapshots stored on disk?
I am trying to understand how to scale my Prometheus and look at the storage mechanic for this.
Lets assume the following:
Prometheus data storage Directory: 20GB in size
Snapshots amount: 3
Snapshot ...
2
votes
2answers
82 views
High CPU usage of Mysqld process in Mariadb 10.3.24
We have migrated Our database from Mysql version 5.1.73 MyISAM to Mariadb 10.3.26 Innodb engine.
Ever since we are observing slowness in inserts and very high cpu usage of Mysqld process.
Our my.cnf ...
0
votes
0answers
735 views
mariadb-server error table doesn't exist in engine status : Operation failed
I tried import a db template into the server and during the process the server has got corrupted. All kind of error come up.
Anyway the most crucial step is get it back to work.
...
Error : Table '...
0
votes
1answer
51 views
If I request data from localhost vs web-address, does the data go through the network
Apologies if my wording is not fully correct - I am quite new to all of this.
Goal: I am trying to improve the speed at which I get data from my database
Setup:
I am hosting the DB on server A. The DB ...
1
vote
0answers
14 views
Cost-Effective Database Architecture for 2000-3000 concurrent users | AWM Cloud
We have conducted the exam of 2000 concurrent users this week. And it went smoothly.
Our Architecture was, we used an AWS AutoScaling setup with 5 servers running at the start (each has 2CPU, 8GB RAM)....
0
votes
1answer
191 views
ARM Template - Azure SQL Database Diagnostics & Log Analytics Workspace
Using an ARM Template I want to enable diagnostics settings for my Azure SQL Database and have that data stored in a Log Analytics workspace I created. I want to enable the errors, timeouts, blocks ...
0
votes
1answer
325 views
Azure Sql Database stuck “Restoring”
I aborted the restore of an Azure Sql database over 2 weeks ago. While no longer visible in the Azure Portal it continues to appear in the list of database In Sql Server Management Studio. "(...
0
votes
0answers
24 views
OpenVPN connecting via CLI versus Client App
My DB is hosted by a third party and in order to connect to it I must whitelist IPs. I have setup an OpenVPN server so that our engineers and CI servers can connect to the DB via the VPN. When I ...
1
vote
1answer
127 views
Strange behaviour of MySQL on Windows (CPU 100% with simple query)
We run MySQL 8 on Windows 2019 server (Dell R420, 32 cores, 64GB, SSDs on Raid10). Every now and then, our website goes completely offline, as the CPU on the MySQL server is completely bottlenecked (...
2
votes
1answer
46 views
MariaDB 10.2.35 Memory Spikes
On an AWS EC2 T3.large instance I'm hosting a website built with the Cake PHP framework. It utilises the MariaDB version 10.2.35. I'm having an issue whereby the memory for the server is spiking.
When ...
0
votes
0answers
16 views
Oracle12c standard edition SNMP monitoring
I have Oracle12c "standard" edition database running. I would like to enable SNMP to monitor this database.
All the documentation I found so far pointing that I need "enterprise edition&...
0
votes
1answer
25 views
Postgres Table size & record counts
I want to understand the below result behavior for finding a size for a table with x MB while try to count record in this table but no records found in postgres database
db_server=# \dt+
...
1
vote
0answers
19 views
Would a flat or tree-like file structure allow for faster fetching of files by Path?
Would a flat file structure allow for faster locating/fetching of files by Path in an NTFS (Windows 10 File System) or would it essentially be as efficient as a highly structured tree with a bunch of ...
1
vote
1answer
121 views
Integration of Azure with Oracle Cloud Infrastructure (OCI) ORA-03113: end-of-file on communication channel
I'm trying to integrate Azure and OCI using this approach and this article.
Now, I have the infrastructure up and running. It consists of a VM in Azure, an Autonomous Database (ATP) Oracle Cloud ...
1
vote
0answers
174 views
“Access Denied” when trying to access AWS Lightsail database
I'm trying to connect to my AWS Lightsail database instance with Navicat Premium 15.0.21 (newest available version at the time of posting).
My database is in public mode. I copied and pasted the ...
0
votes
1answer
44 views
Why is my database not deleted?
I have seen in several tutorial that the "DROP" command will drop the database, but it is not deleted. Why is my database not deleted ?
mysql> DROP DATABASE www_example_com;
Query OK, 645 ...
0
votes
1answer
33 views
Oracle Database Realtime Sync
Client is using Oracle Database Standard Edition so Active Data guard feature is not available and he wants to have a standby replica of the database which can take over the environment as soon as the ...
0
votes
0answers
159 views
Openstack Nova hypervisor list is empty
I have deployed OpenStack with JuJu + MaaS, the stack is working, but some time ago I upgraded the OpenStack and then I dont known why was created a new Nova Cell on database, then I deleted that cell ...
0
votes
0answers
47 views
How to actually set up MariaDB replication/high availability
I'm setting up a high availability LAMP stack - so far, I have two servers with HAProxy running on both their frontends that own a floating IP. HAProxy redirects requests to backend Apache servers ...
0
votes
0answers
17 views
Does Azure SSMA (SQL Server Migration Assistant) provide an SDK?
We would like to use Azure SSMA through Java or C# code. Does SSMA provide an API through SDK (for either Java or C#)?
0
votes
0answers
15 views
Trigger updates for all server farm instances
Our web servers (IIS 10) share a common database (SQL Server 2016). They poll some data from the database on a regular interval. When one of the web servers processes a request leading to a change in ...
0
votes
1answer
71 views
how can i install Mysql alongside MariaDB without losing my data?
I am trying to install snort, barnyard2 and base that uses Mysql in the same machine where is MISP (platform sharing information) installed and that uses the MariaDB database.
I do the following steps ...
1
vote
1answer
112 views
Ubuntu MongoDB server not responding?
I have amazon aws ubuntu 18.04 server 8GB RAM and 50GB Storage. I have installed MongoDB 4.2 and Node JS 12 LTS.
In current server has 30 GB MongoDB storage. I have 4 micro service on same server. I ...
0
votes
2answers
207 views
Cannot back up my database
I am trying to backup my MySQL 8 database with the command line below but I got an error message.
How to make the backup ?
ubuntu@www-example-com ~ $ mysqldump -u root -p www_example_com > /var/www/...
0
votes
1answer
68 views
How to install MySQL 8.0?
I will be moving my site from an Ubuntu 18.04 server to an Ubuntu 20.04 server
On my old server I had installed MySQL this way :
$ wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb
$ ...
