Questions tagged [database]

System that handles large amounts of data in an organised fashion

Filter by
Sorted by
Tagged with
0
votes
1answer
21 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 ...
0
votes
0answers
10 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
37 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
39 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 $ ...
0
votes
0answers
10 views

Get current usage of postgres DB as a percents of maximum

Is there any way to get current metrics (average transactions per seconds, KB read/write, etc) and potential maximum of postgres database?
-1
votes
0answers
15 views

System Requirement for Running Cassandra Cluster in Docker [duplicate]

I am quite new to Cassandra and the concept of Distributed Databases, and also to docker. I have access to official docker image of Apache Cassandra, but I couldn't find any official statement on what ...
0
votes
0answers
16 views

collect remotely docker metrics on device A from remote-device B

I would like to collect docker metrics remotely with Telegraf [inputs.docker] plugin from InfluxData on device A. Telegraf and InfluxDB themselves are docker container on another device B. Both ...
0
votes
0answers
8 views

Cognos Analytics 11 - Difference Between Data Server and Data Source Connections

I stood up a report server hosting Cognos Analytics 11.1.6. I can access the analytics web interface and there's an option to create data server connections. If I access the administration console ...
0
votes
1answer
64 views

what does the ldapadd error: "additional info: objectClass: value #2invalid per syntax mean?

I'am tryin to migrate from active directory windows server to Openldap i found a problem while importing .ldif database exported from AD to my new Openldap ! when i try to do : ldapmodify -Y EXTERNAL ...
2
votes
0answers
22 views

How do I secure my PHP forms that communicate with my MySQL Server? [closed]

They are just the basic forms, they take in $input from the form and then store that directly in to the database, there is another form where it takes $input and searches for a hashed match for it. ...
0
votes
0answers
12 views

Transfer (replicating?) large tables from remote location

A provides generates periodically data tables in a remote location, that I should have transferred locally (via Internet) in order to trigger a subsequent local process. The problem we have is that ...
0
votes
0answers
7 views

EC2 Windows 2008 & SQL Server 2008 Instance Not Reading New Disks

I have a Windows Server 2008 instance running SQL Server 2008 in AWS. I attached an existing volume (previously attached to a different server running windows 2012) to this 2008 server. The volume ...
-1
votes
2answers
42 views

PHP not connecting to my database on Linux? [closed]

I use mariadb as my database and phpmyadmin to access on databases web on Linux. Although I am able to connect to the database on the commandline as root but cannot check connection to the database ...
2
votes
1answer
107 views

MySQL user has “usage” privileges but RW works

I have migrated Grafana from SQLite database to MySQL (in fact, MariaDB 10.3.22), so database is now located on a different machine. It is obvious that the software needs a database account now, so I ...
0
votes
0answers
25 views

Best mysql database architecture for a worldwide project

I would like to know your opinion about how to build the best database architecture posible. This is a website, let's say it is a forum, with traffic from everywhere around the globe. I'm trying to ...
0
votes
1answer
121 views

Is there any upfront cost for Azure SQL Database Reserve Capacity Monthly Pay option?

Planning to go with Azure reserved capacity for SQL Databases. Azure price calculator not showing any option to get the pricing monthly as it shows like for virtual machines. Wants to know whether ...
1
vote
2answers
42 views

Accidentally Uninstalled Mysql Database But I have Database Folders How do I restore the database [closed]

I confused our production server as staging server and accidentally uninstalled MySql. I still have the /var/lib/mysql folder intact. My server is in ubuntu 16 This is the uninstallation process that ...
0
votes
0answers
30 views

How to store many files that are updated frequently in a centralised location that can be accessed live

I have many server instances in google cloud that are running all day collecting data from various edge devices. I have around a 100 servers each collecting from around 50 devices. The data for each ...
0
votes
0answers
45 views

Cannot open files in FileMaker Server 19 (message: The host's capacity was exceeded)

I am just learning out with FileMaker and have run into a problem with FileMaker Server 19. I have a client file that I have shared with the server which is showing up as expected in the FMS Admin ...
0
votes
0answers
26 views

mysql storage filling up unexpectedly (RDS)

I am total newbie to database game. & I am using mysql 8.0 RDS 20GB free tier. I don't have much data on it.(just 300 Mb) But I always get a mail that you have exceeded 85% of storage limit.(...
0
votes
0answers
21 views

Application cannot connect to HAProxy Database

I am trying to connect my GLPI project to my HAProxy DB Server, I followed this guide to set it up. I am using CentOS 8 with Nginx and here's my HAProxy config: global log 127.0.0.1 local2 ...
0
votes
0answers
8 views

Do Galera (or MSSQL) support this clustering scheme?

Clustered databases can be scaled relatively easily. However, even assuming zero latency to spin up a new instance, there is a considerable delay before the newly added node is ready to serve requests....
0
votes
1answer
21 views

When creating a managed database should I have one instance per application?

Let's say I have 10 different applications that all have a postgresql database dependency and these applications must be deployed on Azure using Azure managed postgresql instances. Would it be best ...
0
votes
0answers
14 views

Persistent storage failure or Authorization Failure after Mongocontainer restart using docker-compose rebuild after Machine restart

I have set up a mongo container connected to a nodejs app. First I do docker-compose up --build where I start mongo as a service without auth, i.e commented out. Then I login to the mongo terminal ...
0
votes
0answers
21 views

Run MongoDB with Unbreakable Enterprise Kernel (UEK) on Oracle Linux

I am running MongoDB v3.4.9 on Oracle Linux Server release 7.7 with the Unbreakable Enterprise Kernel (UEK) 4.14.35-1902.3.2.el7uek.x86_64 for testing purpose. UEK is not official supported on Oracle ...
0
votes
0answers
24 views

How does nagios store monitoring data captured?

I have a few questions about nagios and databases: How and where does nagios store the data it collects? How can I transfer this data to the database? Thanks in advance.
1
vote
1answer
416 views

Why can't my AWS Lambda connect to my AWS RDS proxy?

I can connect to my database locally just fine (of course with the normal DB endpoint, not the proxy endpoint). However, I just can't seem to get my lambda function to connect to the same database ...
0
votes
0answers
17 views

Connection String OLEDBSQL Using Trusted Connection

I'm trying to switch my MSOLEDBSQLB connection string to support older ADO Recordset & MS DataShape connections to use TRUSTED style connection string and not able too. I have SQL native client ...
0
votes
1answer
13 views

Cross-region database latency much slower than ping?

We were recently discovering that an API request had about 500ms response times as seen in the logs from our server. We realized this was because we had our API running in aws-west-1 but a remote DB ...
0
votes
1answer
23 views

Migrating MS SQL Server database to Azure

I have an issue migrating my database from my PC to Azure. I cannot install the Data Migration Manager. I have already allowed port 1433 in my firewall and I am getting further in the installation ...
0
votes
0answers
8 views

Asterisk Integration Issue with CRM

I have configured V-tiger CRM. I want to integrate v-tiger CRM from Vici-dial asterisk but in v-tiger CRM there are not showing phone calls extension in extension store. I have configured the call ...
0
votes
2answers
37 views

Read DNS Zones from database

I've developed an application with Laravel (it's same as a site builder), clients can add their information to their profile, and finally, they can park a domain to the profile (by setting my DNS for ...
0
votes
1answer
35 views

Is it safe to backup volumes of running mariadb docker containers

Is it safe to backup data volumes of a running mariadb / postgres / mysql container? Should I stop the container prior to backing up the volumes?
1
vote
1answer
597 views

mariadb.service start stuck at activating

I just installed the mariadb in my ubuntu 19.10 by sudo apt install mariadb-server mariadb-client after when I am trying to start the server by sudo systemctl start mariadb.service shell get freeze I ...
1
vote
0answers
18 views

Why would files appear corrupt but then be fine days later?

The Setup: Dedicated CentOS 7 web server hosting a CRM database on a company’s internal network. Everyday, the server backs up to itself and then the backups are copied offsite. The Problem: This ...
0
votes
1answer
86 views

Exported MariaDB dump different size

I'm trying to copy a database from a MariaDB server on another. I made a dump of the database on server A with : sudo mysqldump -u root -p --databases database1 > /var/tmp/database1.sql I created ...
0
votes
0answers
42 views

Created Azure Database for PostgreSQL Servers with Private Endpoint, Wanted Public

I newly created a PostgreSQL server on Azure. As far as I remember, I chose the option "private endpoint" instead of "public endpoint". After its creation, I copied the connection strings from the ...
0
votes
2answers
22 views

Network Exception thrown after session timeout

My site will run fine and I can go through the entire site, but after my session times out, when I make another request to a page I get this exception: Server Error in '/' Application. The system ...
0
votes
1answer
72 views

How do I access my non-public AWS RDS MySQL database with MySQL WorkBench?

Trying to access my database in AWS with MySQL Work Bench, but the only way I'm able to access it is by making the database public and open to all inbound traffic. This is a huge security risk and I ...
0
votes
0answers
19 views

Open-Xchange Installation “The maximum number of contexts in every database cluster has been reached”

I'm currently trying to configure my Ubuntu Server with Open-Xchange for personal use. I've got Open-Xchange up and running (all the databases and users have been created, the site is reachable via ...
0
votes
1answer
70 views

Import of .SQL file is very slow with HeidiSQL

I have a database on a MariaDB server that I need to copy on a Galera Cluster on other machines. I used HeidiSQL to create a dump file which is pretty fast actually. The database is about 500Mb. ...
0
votes
1answer
199 views

Azure Database for MySQL servers: Location: service not available in this location for your subscription

I am trying to create an Azure DB MySQL server and under location I keep getting this error. " service not available in this location for your subscription." Could you guide me what needs to be ...
1
vote
0answers
23 views

Experimental setup of PostgresXL on Kubernetes with Local volumes

I'm making a Gedankenexperiment about deploying PostgresXL on Kubernetes (k8s) where each datanode uses local (Directly Attached) storage. Imagine we have the following nodes: 2x highend machines ...
2
votes
1answer
33 views

Perc H710 on Windows 2016

Excuse me for a naive question. I just got R720 with 4x3T on RAID 5 using H710. In the server manager, I saw disk with 8T which I suppose is the virtual disk I set up using H710; In volumes, there is ...
0
votes
1answer
136 views

fio numjobs & iodepth Values to Simulate Database PostgreSQL Workload?

I am trying to benchmark a ZFS RAID-10 array of SATA SSDs using fio with settings that are somewhat representative of database workloads like for PostgreSQL. For example, for random reads: fio --...
1
vote
2answers
43 views

How to create read replica from MSSQL to MySQL through RDS

I have a RDS instance with SQL Server Standard edition. This DB is used for transactions, I want to create read replica but I want the new replica to be MySQL/MariaDB or PostgreSQL. This is because we ...
0
votes
1answer
26 views

Upgrade mongodb replicaset 3.2 to 3.6 on live servers

I want to upgrade mongodb version(3.2 to 3.6) on prd environment W/O downtime. We have one primary node, one secondary node and one arbitrary. We are using ubuntu 16.04. So please guide me how can I ...
1
vote
1answer
22 views

Databases “Synchronized / In Recovery” after adding server to SQL Avaylability Group

I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network). ...
0
votes
1answer
72 views

Kubernetes, pods with unique database server vs one shared database server

I'm developing an application that is shipped as a cloud service, that is there are n instances of that application and each is completely separated from one another and each of those separated clones ...
0
votes
0answers
16 views

How do you update services to talk to new IP in a master/slave database setup

I'm using postgresql. I have done a lot of reading into setting up redundant SQL setup and most of them boil to having a simple master-slave setup where the slave can become master at any point. Now ...

1
2 3 4 5
32