System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
0answers
28 views

Is there a simpler way to manage this Private Tuition classes' system? [closed]

I'm making a website for a private tuition classes. Here, the concept is that a teacher goes to teach to the student's house. There are many teachers operating this way teaching many students at their ...
-1
votes
1answer
27 views

Installing postgres on Cent OS

I am having a hard time getting postgres re-installed on Cent OS 7.2.Here is what I tried. Went to YUM repo of postgres Created a temporary folder on my machine for the RPM file Did wget ...
0
votes
1answer
59 views

ownCloud Unable to Connect to Local Database on Fedora 23 (LEMP stack, selinux permissive)

The Problem I am having a very strange issue where ownCloud seems unable to access my SQL database, using nginx, mariadb, and php-fpm running on Fedora 23. When I attempt to access the page, I get ...
0
votes
2answers
19 views

MariaDB taking ages to restore backup

So I did a mysqldump of a pretty huge db and I'm trying to restore it now using: mysql db_test < db_test.sql but it looks like it's not gonna end by the end of this year. It's been about an hour ...
1
vote
2answers
33 views

cassandra data migration from regular drive to SSD on production server

we want migrate our data from regular drives on production server to new SSD drives. how we can do that without taking down the node no longer than 4 hours(hinted hand-off is 4 hours) our data is in ...
-2
votes
1answer
43 views

Fix WSUS related DB bloating, Uninstall & Install issues on SBS Server 2008?

Environment: SBS Server 2008 DC/ Domain Server: Windows Server 2008 FE Microsoft Windows Server Update Services 3.0 SP1 - MMC SUSDB.MDF started at 14.x GB and when trying to use the Updates ...
1
vote
0answers
16 views

Certificate is not showing up in SQL Server

I need to say first that I am not a DBA and so, my problem is getting SQL Server Configuration Manager to recognize a certificate. I have 3 SQL Instances I work on, 2 are on the same network, the ...
0
votes
1answer
18 views

Best performance- and backup-strategy with running multiple Webapps and databases on dedicated servers

my company is soon going to move our webservice-hosting to a new hoster and therefore i'm currently planing how everything will run in the future. I have to deploy at least: MsSQL-Database Server ...
0
votes
0answers
7 views

Where should migrations be run on elasticbeanstalk deployment process?

I'm very curious as to how people run a command like db migrate on their eb apps. If you add it as an .ebextensions I fear that when you have multiple instances for one app, there could be conflicts ...
0
votes
1answer
35 views

Does AWS support DBF files or Samba Shares?

We have DBF files running in our local network. It's on an Ubuntu Server running Samba shares. The DBF files are used by our in-house system running on xBase. Now we're moving everything to Amazon ...
0
votes
2answers
49 views

How to connect postgresql with LDAP user?

I have a server with postgresql-9.4 fresh install and I have another server with LDAP already installed. I want to connect postgresql with LDAP user that already exists. What's the basic ...
0
votes
0answers
47 views

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all ...
-1
votes
2answers
64 views

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible? [closed]

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running ...
0
votes
1answer
17 views

Does transferring a database to a new SQL Server instance lose statistics and execution plans?

I am transferring a database to a new SQL Server and was wondering, will it lose it's execution plans and statistics that its collected over the years for the benefit of performance and have to start ...
0
votes
2answers
23 views

cassandra nodetool drain running for days

We are having performance problems with our cluster regarding to timeouts when repairs are running or massive deletes. One of the advice I received was update our casssandra version from 2.0.17 to ...
-1
votes
1answer
27 views

Shared nothing database systems with SAN

Cloud data warehousing being so popular recently, I am wondering if there is an inherent contradiction in the manner in which they are architected: Terradata, Greenplum etc. require 'Shared Nothing' ...
0
votes
0answers
19 views

“error establishing a database connection” On my wordpress website - with indexes problems?

I keep getting this: "error establishing a database connection" and this is not ending. This is /var/log/apache2/error.log: [Thu Mar 31 11:38:45.865505 2016] [autoindex:error] [pid 22782] ...
0
votes
0answers
41 views

MongoDB setup for Rocket.Chat error message

I'm following this tutorial for a Rocket.Chat setup on an Ubuntu 14.04 LTS installation. After installation of Mongod, it says to setup a replica set and gives the instructions to insert the following ...
1
vote
2answers
41 views

Script to combine data from one file to another [closed]

I have a file containing folders name/value pairs: peter:/home/peter/ max:/home/max-lucas/ judith:/home/judith/documents/ I have another file containing files name/value pairs, with the same ...
-6
votes
1answer
31 views

Database File In Drop Box Shared Folder

Can a software database file be saved and kept in a shared folder like drop box and be accessed and used (whether simultaneously or not) from more than one computers? A quickbooks database file is an ...
0
votes
1answer
30 views

from security perspective one instance with Multiple Databases or multiple instance for multiple clients

We have 20 clients which currently every client has his own database on his own server(in his own environment) all the databases have the same structure(schema) and all of them has MS Sql Server 2008 ...
0
votes
0answers
33 views

SYNC MYSQL database instantly from one Digital ocean server to another

I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second. I am hosting the public site on another Digital ocean server ...
0
votes
1answer
43 views

mongodb - authentication failure on phpmongodb with username

I have a problem to authenticating to mongodb. The system is ubuntu 14.04 LTS. I can connect locally: $ mongo mytestdb -u mongotest -p MYPASSWORD MongoDB shell version: 3.2.3 connecting to: mytestdb ...
0
votes
0answers
22 views

MONGO - mongod - no connection to database [duplicate]

i have an testserver running under ubuntu 14.04 with public ip address. On this i have plesk 12.5 and mongodb 3.2. For administration of mongo i installed phpmongodb. Then created an database, an ...
3
votes
0answers
26 views

How to handle point in time restore without binlogs/How to split database

I thought about this 3 days already and asked in IRC but I wanna consult your expertise too. Basically it is about a High Traffic Site that uses Drupal (don't get me started, I have no choice in this ...
0
votes
1answer
27 views

Opening ports on a remote DB server

I'm running a RHEL7 box, running MySQL-5.7.11 and I'm simply trying to allow remote connections... I followed the documentation here on opening a port and have done so successfully. When I run ...
0
votes
0answers
70 views

Docker postgres database errors

I started using Docker PostgreSQL 9.5. Im using Docker and docker-composer to start my 2 containers: I followed the following link for reference: ...
0
votes
2answers
100 views

Name [ ] is not bound in this Context. Unable to find [jdbc] Tomcat Issues

I just created a fresh Oracle Linux 7 VM with Tomcat 7 and Java 8_40. I've created several servers with Apache and Tomcat before, but never connecting to databases before. SELinux and firewalld are ...
0
votes
0answers
27 views

Database Server froze - High IO - how do I find out whats the reason? (Pics)

got a db server(KVM) running mariadb 10.1, runs fine since months, only servers 2 databases (drupal). Last night it went tits up. Here 2 screenshots from zabbix I checked the logs, they show ...
1
vote
1answer
50 views

Do I need to restart SUSE when upgrade glibc?

I plan to upgrade glibc version (HAVE to install by rpm command) on 30 SUSE machines, all the machine are using for running test on Jenkins. Could someone tell me the reboot is needed in this case?
0
votes
1answer
88 views

Exchange 2013 - 0kb EDB File after ISCSI Drop

I am unsure if anyone will be able to help me out. I have a 0kb EDB file after an ISCSI failure. I cannot run "eseutil" on the file as I get the error: Extensible Storage Engine Utilities ...
1
vote
0answers
61 views

Correct Azure VM firewall settings for Azure SQL Database v12

One of the recommendations when a client runs on an Azure VM and needs to connect with your Azure SQL Database v12 is to: Ensure that the port ranges of 11000-11999 and 14000-14999 on your Azure ...
1
vote
1answer
33 views

MySQL Error Code: 1017 permission denied

I have downloaded the German version of the Northwind sample database. I moved the folder to /var/lib/mysql and set the rights to drwxr-x---. Here is an output of /var/lib/mysql drwxr-x--- 2 mysql ...
-1
votes
1answer
67 views

Use Google Drive for live DB backup? [closed]

I am currently trying to define my backup strategy for my AWS EC2 server. I already use Google Drive to backup my apache root folder. This also automatically doubles as a deployment strategy since the ...
3
votes
1answer
30 views

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
0
votes
0answers
37 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...
0
votes
0answers
9 views

Telling how big an oracle DB dump will be when imported

I have an oracle DB dump file that is 30GB and i would like to build a filesystem to support its size once imported - is there a tool/method i can use to tell how big it will be post import ? Thanks ...
0
votes
0answers
19 views

Linking fail2ban with a RDBMS

I would like to maintain a highly dynamic RDBMS table that will be insert/update/deleted from from multiple hosts (a kind of global blacklist for all my servers). The table would have a couple basic ...
-2
votes
1answer
51 views

best configuration for database server [duplicate]

Okay I have a VPS (DO 512 MB) and AWS RDS free tier . I wanna get the maximum performance , please help me cause I'm a little confused . I run a nginx server on the VPS and it can handle 1K ...
0
votes
0answers
21 views

Get the most out of VPS and AWS [duplicate]

I have a static website running on shared hosting and doing good (not slow) And having a bandwidth of about 3Gb / month and I'm adding 2 other dynamic website with database and php scripting(I assume ...
0
votes
1answer
57 views

How can I securely access a Rackspace Cloud Database in AWS?

Rackspace limits access for Cloud Databases to their ServiceNet. How can I securely and efficiently connect to a database instance there from AWS (over the public internet)?
1
vote
1answer
105 views

Unable to restore postgresql data dump for Django app hosted on Azure VM

I am trying to restore a postgres data dump for a Django app of mine. The data dump was extracted from Heroku, and pg_restore is being run on an Azure VM with Linux on it. There are around 40 tables ...
0
votes
1answer
35 views

How to change MySQL user permission temporarily (Per Connection)

I do not know if it is possible at all or not. What I want is that, when a certain connection is established, the user not be able to modify data with that connection. This is the scenario: ...
3
votes
1answer
29 views

Connect server A to database on server B and forward remote database port on server A

Edited: I'm quite new to all this admin stuff though! So: Whats the best way to connect a port on server A to the database on server B. The reason i want to do this: I want to connect server A to a ...
0
votes
0answers
45 views

Wordpress showing article title, but content is showing blank

I recovered from a disaster situation on the server, database is not affected. My wordpress files were old, from previous version (maybe 4.3). When I recovered those file and setup nginx with it, I ...
1
vote
0answers
16 views

CouchDB Authentication and Security

i used this link to install CouchDB on virtual machine http://depth-first.com/articles/2010/01/28/pubcouch-install-couchdb-on-ubuntu-karmic-from-source/ everything goes fine, after that i tried to ...
-1
votes
1answer
62 views

All MySQL databases appear to have disappeared

I'm running CentOS 6.7 with MySQL 5.1.73 and it appears as if all of the MySQL databases have disappeared within the past hour. MySQL starts up without any issues, however when running show ...
0
votes
0answers
8 views

How do I resynchronize a Bacula catalog?

I tried performing a Bacula upgrade, but found there were issues with our architecture. Our team tried powering through the upgrade testing backups, but eventually decided to do a downgrade and ...
1
vote
1answer
74 views

What is the best practice for deploying dev database to live system?

My developers in a project want to have the dev db on dev server synced with live db on live servers, which I think is a bad idea. Despite that, what is the best way to deploy a codebase+db to live? ...
0
votes
1answer
78 views

VSFTPD setup on Centos new virtual user cant connect

I have a vsftpd server configured on centos. Old users that are listed in logins.txt can login via wb browser. Problem is that when I create a new user I can't login 530 bad login error. Steps taken ...