Questions tagged [database]
System that handles large amounts of data in an organised fashion
2
votes
0answers
22 views
MongoDB Very slow queries since yesterday
Since yesterday I am having huge trouble with my MongoDB. I have a 100GB collection with over 50M documents. Making a find on them and a .count() was never an issue until yesterday.
Somehow, since ...
0
votes
0answers
10 views
ODBC Client is extremely slow over network [on hold]
I'm Working On a project where ODBC Driver is Provided by a third party software where our data feed generated real-time
When I configure ODBC to work with local Database (SQL Server and SQL Server ...
0
votes
0answers
15 views
Azure Database for MariaDB and log_bin_trust_function_creators
I am trying to create a function on Azure Database for MariaDB like below:
CREATE FUNCTION hello (s CHAR(20))
RETURNS CHAR(50) DETERMINISTIC
RETURN CONCAT('Hello, ',s,'!');
but I am getting the ...
0
votes
0answers
17 views
mysql permission and domain pointing
I use debian, apache and wordpress, new fresh installation, i have problem with DB permissions and domain pointing to wordpress installation. so, privmat.net is ordinary index.html file and ospok....
0
votes
0answers
17 views
How to restore MariaDB Databases from files
After the whole server went FUBAR I managed to retrieve website files (php,html and such) and the DBs. Now I have these files:
aria_log.00000001
aria_log_control
ib_buffer_pool
ib_logfile0
...
0
votes
2answers
69 views
How do I get SQL Server Management Studio to find a .bak file to restore?
I am trying to turn a .bak file into a database. I can't find the "Restore Database" button when I left-click "databases" when connected. This is what I should see. However, this is what I see.
I ...
1
vote
1answer
24 views
Migrating from DynamoDB to RDS
I'm considering the different options available for migrating a DynamoDB Database to RDS. The data structure makes much more sense in a relational format.
There are 8 tables with around 1 million ...
1
vote
0answers
37 views
ERR_PROTECTED ERROR: nsfsem2.c/ln In IBM Domino
My customer has been getting a series of errors at the Domino console, "ERR_PROTECTED". The Domino version is 8.5.3FP6 HF1020. The error is causing Domino to think that the database files are read-...
0
votes
1answer
35 views
AWS Database Migration Service requires a role not mentioned in documentation
I am trying to perform a database migration using AWS Database Migration Service (DMS) from a self-managed database on EC2 to AWS RDS. I get this message when I try to run the task to perform the ...
0
votes
2answers
110 views
local mysql was hacked with ransomware hack. How to check if database data was downloaded?
I had a test mysql database running on Vagrant dev box. Turns out the network wasn't that secure.
All of the databases were deleted (and replaced with a DB ransomware note) and in the logs I can see ...
0
votes
0answers
14 views
Amazon's Database Migration Service (DMS) - Exact meaning of “Partially supported datatypes”
I have several columns in my db that are float8, I'm looking to do a direct postgres10 to postgres10 migration between two RDS instances.
Upon doing the Assessment for the task, it states there are ...
0
votes
1answer
40 views
Where are Azure SQL Database Backups Stored
I've got 5-6 Azure SQL Databases running. They run in the Basic and Standard pricing tiers. From what I've read backups run by default which allow for the Point in Time restore options to work.
...
3
votes
2answers
138 views
Nosql autoscaling of compute
Most of the nosql autoscaling faces issue due to the fact the data have to be migrated during peak load. What if data is stored in a shared storage like CLVM which has less overhead(compared to NFS or ...
3
votes
2answers
62 views
Restrict access to S3 bucket folders to specific website users? (not using IAM Users)
I have a website where users need to log in. They can upload and delete their own pictures BUT these pictures are supposed to be private so images are not set to public that anyone can view.
I know ...
0
votes
1answer
24 views
Get-Command Changing Drive
I wrote a powershell script that includes a check for the invoke-sqlcmd cmdlet. Script runs fine under Windows Server 2016. On 2012 R2, the script fails with:
Add-Content : Cannot use interface...
...
2
votes
2answers
291 views
Unknown Database when trying to connect to an AWS RDS instance
I created a MySQL RDS instance, however, when I try to connect without writing the database name, it connects but does not allow me to create any tables. When I do write the name, the connection fails ...
-1
votes
1answer
185 views
How to create a SQL Server Database from DBML [closed]
I have corrupted an entire database and I have no access to it or backups. Is there a way to recreate the structure of it using a .dbml from visual studio project?
Thank you in advance.
1
vote
1answer
109 views
accidentally delete mysql files in /var/lib/mysql
I made a big mistake!, I have a vps(centos7) server and for deleting temp files have a command:
sudo find /tmp -type f -atime +10-delete
this command is good but this time by mistake i forgot to ...
0
votes
0answers
74 views
Error ORA-03113: end-of-file on communication channel
I installed a BD 12c, and every day at a certain time the BD stops working and when I want to start it again, it throws me the following error:
Error ORA-03113: end-of-file on communication channel
To ...
1
vote
1answer
37 views
Unable to create rds instance using cloud formation?
Iam trying to create an rds mysql instance using cloud formation.But when iam creating the stack iam getting rollback.Under events the error for creating rds instance is "Encountered unsupported ...
0
votes
0answers
15 views
Do memories from different manufacturers impact performance? Is there a way to measure it?
Memory in one of my systems:
% lshw -C memory|grep vendor | grep -v NO | grep -v 'American Megatrends' | grep -v 'Intel'
vendor: Samsung
vendor: Samsung
vendor: Micron
...
1
vote
0answers
100 views
MariaDB Cluster is having timeout issue between nodes
I'm having some hard time diagnosing MariaDB Cluster issue that I would like to have some advices.
We're running a 3-nodes MariaDB Cluster, each node is on a dedicated ESXi server, and connected by ...
2
votes
1answer
54 views
Query database in Cloud Platform / PaaS {AWS, Azure, GCP} from outside the platform/PaaS?
Is it generally possible to query a database housed in PaaS "A" from a request originating in a different PaaS "B" (or does it depend on the PaaS)?
Asked in another way: Can an app that is hosted in ...
google-cloud-platform
1
vote
1answer
88 views
Scale out Azure SQL Database
I have a SQL Database in Azure. An S0 instance with 10 DTUs. This is enough 95% of the time.
However, when the App Service plan scales out (can go up to 20x in rare cases), I need 200/400 DTUs. Since ...
0
votes
1answer
16 views
Postgres on Ubuntu Server 16.04 - automatically backups
I have Ubuntu Server 16.04 and PostgreSql database. How to organize automatically backups? Is this better idea to move my database to AWS RDS instead having database on my server?
0
votes
0answers
10 views
389 server - trim replication changelog does not seem to wrok
DB size is currently ~25 GB. I tried to do what they suggested:
https://access.redhat.com/documentation/en-us/red_hat_directory_server/10/html/administration_guide/trimming_the_replication_changelog
...
1
vote
1answer
241 views
systemd not shutting down MariaDB properly?
We are running a LAMP stack on CentOS 7. We have SCL enabled but only PHP and Apache are using it. We were not able to get MariaDB to successfully cutover on a test machine so we never attempted a ...
0
votes
0answers
229 views
Does a Galera equivalent for Postgres exist?
I've been working with Galera for a number of months and like the failover along with the redundancy. I've got a Postgres DB that is in testing and will probably move to production. Is there a Galera ...
0
votes
1answer
37 views
Azure SQL to On-Premise SQL Server Data Transfer
I need to securely transfer data from a SQL Server in Microsoft Azure to a SQL Server on-premises. I have been researching different methods but I have not found the right way.
Following is the list ...
0
votes
0answers
12 views
How can I further improve Oracle 12.1 performance on RDS m4.large instance?
I'm having performance issues with my current Oracle setup. Queries are taking half a second and I can't figure out how to speed it up further.
I've upgraded my RDS instance from a t2.medium to m4....
1
vote
1answer
3k views
What does “GC (Allocation Failure)” mean in my ElasticSearch 5.6 logs?
I see these constantly in my Elasticsearch 5.6.3 logs. Is this a signal that I should scale up and add more RAM? Or is this just normal operations for ElasticSearch?
[GC (Allocation Failure) [...
0
votes
0answers
32 views
SQL SERVER 2014 copy a multi file group database to a single file group db for transferring to azure
I have been trying to transfer a 1TB sql server db to azure sql db for performance assessment. I tried using Data Migration Assistant many times but it hangs and exits every time during data transfer. ...
0
votes
0answers
48 views
Sql server on ubuntu doesn't respnod
I have installed sql server 14.0.3030 express with .netcore 1.1 on ubuntu 16.04 and everything was fine till last night suddenly i encountered with this err message from my dot net core web app
...
0
votes
1answer
57 views
Looking for a way to pause or quiesce a database on google cloud platform
Is there a way to pause or quiesce a database on google cloud platform to reduce costs yet maintain the data?
If not, do any of the cloud database providers offer such a feature?
0
votes
1answer
258 views
How to Change Replica Set Protocol Version in MongoDB.
I'm trying to change Replica Set Protocol to pv1. I have 5 replica set servers Mongo 3.6. I'm using the documentation from here https://docs.mongodb.com/manual/reference/replica-set-protocol-versions/ ...
0
votes
0answers
67 views
SQL Server 2016 replication monitor from the slave ( subscriber ) without admin access to the publisher
Question:
Is it possible to check the replication status of SQL Server 2016 from the slave ( subscriber ) without admin access to the publisher?
We have an SQL Server 2016 which is a slave ( ...
1
vote
2answers
186 views
How to install a MySQL plugin with Ansible?
So far we've been using the Geerlingguy Ansible role for all of our database deployments, but now I'm expanding our usage of it for a new project, and it doesn't seem installing plugins is a supported ...
0
votes
1answer
38 views
database connection error & Database was not shutdown normally
I need some solution for my wordpress site database error. I have face this DB error last one month. I don't know what is the reason for this Database connection error. Please review my error.log ...
0
votes
1answer
32 views
Difference between mysql.user table and mysql -u -h
Usually I run mysql using something like this:
mysql -h hostname -u user -p
(and then type password here)
but I wanted to know how is this related to the mysql.user table.
When I log in into mysql, ...
0
votes
0answers
250 views
Connecting to MongoDB Atlas throws Exception 'No suitable servers found'
Connecting to the mongodb atlas and trying to write a simple document gives the following error. What am I doing wrong?
$manager = new MongoDB\Driver\Manager("mongodb://admin:admin@test-shard-00-00-...
0
votes
1answer
896 views
AWS EB and RDS: Invalid storage size for engine name mysql and storage type gp2
I'm trying to deploy my (python/django) application to AWS Elastic Beanstalk, but I am getting the error. Deployments have been working fine for the last few months, so I'm confused what could be the ...
0
votes
2answers
178 views
pg_dump fails as a cron job in one script but not another
I have two cron jobs on my AWS server (triggered via crontab -e) to invoke pg_dump on specific databases.
The two scripts are identical with the exception of the target database they're backing up ($...
0
votes
0answers
24 views
How much RAM should a my DB Server have for a typical WordPress Installation? [duplicate]
my first question here.
I am managing a high traffic wordpress website (mypianonotes.com) which gets upto 300 Real time users.
Now, this is absolutely fine and is easily managed. The front end of ...
0
votes
1answer
41 views
Ejabberd mysql prefix on database tables
How can I use prefixes on database table names in Ejabberd? I have the mysql.sql file with the schema and I would to use the prefix "ejabberd_" on all the tables.
I can't seem to find anything on the ...
0
votes
1answer
62 views
OpenSSH/Dropbear using MYSQL Database - Linux [ubuntu]
Is it possible to use MYSQL to store user accounts and use it to authenticate with your SSH (OpenSSH/Dropbear) and is it possible to use remote mysql database?
Basically, I want to use MYSQL as user ...
0
votes
0answers
188 views
Ubuntu Server Performance Issues with CockroachDB
I have a cockroachdb node I am playing with. My box has Ubuntu 16.4, 64 GB of RAM, 4 physical cores (Quad Core Intel Xeon 3.3 GHZ).
Inserts to this DB are very slow. On a 100000 sample set, average ...
0
votes
1answer
174 views
Galera or master/slave MariaDB
What would be the recommended choice for database replication with failover? I know this is a broad question but I'm curious what the general experiences are when it comes to real life setups.
As far ...
1
vote
1answer
64 views
Real World Architecture [closed]
I am kind of confused about the way real-world web applications are architectured and I would be happy for some clarification . I know that there are many methods and different approaches but an ...
0
votes
0answers
51 views
wordpress Got packet bigger than 'max_allowed_packet' bytes when dumping table `wp_options`
For over 6 months now, by automatic daily database backups are failing every time. My wordpress database is around 100MB but the backups are only 700KB.
Every single backup fails after backing up ...
-1
votes
1answer
31 views
How to create (or use the existing) database on an SQL 2017 deployed via Azure VM?
Please note the question is about the SQL 2017 that comes inside an Azure VM, not the Azure Databases.
Basically, I deployed an Azure VM with SQL 2017 Enterprise installed on it already, by MS.
Now, ...
