System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
2answers
25 views

Deleted transaction logs on microsoft exchange

We run into a big problem in our company. The disk of our Microsoft Exchange server was full and we could not receive any more emails. We seek help from another source, the guy have shown me a place ...
0
votes
0answers
3 views

What's the best practice to ensure atomic read of a database table using JDBC? [migrated]

I have an java application reading from a database table for jobs to process, and I may have multiple instances of this application running on different servers as each job is independent. Once a job ...
-4
votes
0answers
29 views

How to a database chat works? [closed]

I want create a chat with PHP and SQL. How the database chat (with messages, nick etc.) works? I've tried to create this idea: User -> Write something on the input and send it. DB: Save this ...
0
votes
0answers
5 views

Starting an Oracle database in upgrade mode?

I have an Oracle database instance running on a Windows 2012 server. I need to start it up in upgrade mode to run some configuration changes. However, I cannot find the right command to get it going. ...
0
votes
0answers
24 views

Best way to avoid server outage for gaming company [closed]

I recently moved to a company that provides gaming solutions for Bingo Halls across the globe. We have handheld game devices that run our gaming apps that connect to Windows Servers (2008). Each bingo ...
0
votes
0answers
16 views

External email from specific database going to junk folder

I have migrated from Exchange 2010 to Exchange 2013, after which things are okay. I have four server plus two databases as below: Servers: CAS01, CAS02, MBX01, MBX02 Database: DB1 mounted on MBX01 ...
0
votes
0answers
69 views

Fatal error: mysql.user table is damaged. Please run mysql_upgrade

I resized an Azure VM and now the MySQL DB running in Windows inside the VM is dead. I am seeing the below fatal error on startup. I tried to run mysql_upgrade as it suggests but that just errors ...
1
vote
2answers
72 views

In MySQL, what do I put inside my.cnf so that all tables are UTF-8 that works with emojis by default?

I'd like every table and database (to be created) to be utf-8 that works with emojis. I understand that there are a few variables I need to define inside my.cnf: init_connect='SET ...
0
votes
1answer
28 views

MySQL behaviour and disk space handling after deletions and insertions with MyISAM

I have a question about the way MySQL with MyISAM engine handles the free/empty space after deletions and how it behaves when new records are inserted. For example, think about a new and empty DB (...
0
votes
0answers
7 views

what are max_connections in amazon RDS?

I have seen a field called connections under current activity tab. My database instance has a max_connection of 52 . What does it exactly mean?
1
vote
0answers
29 views

Access database using Public External IP - Bandwidth

In an amazon EC2 instance, we pay for each GB of data transfer in/out. Which means, when are sent to server, it's data transfer in. When a user access some website hosted there, data is being ...
0
votes
0answers
22 views

Use Mysql as backend to Bind

I've bind installed on my server. I want to manage dns records and zone files through a web interface instead of directly editing the zone files on the file system. Developing a web app that ...
0
votes
0answers
30 views

small client-server app & db install location

We're running Server 2008 R2 on dual 2.8 GHz processors with 32 GB memory and a partitioned 1 TB, 3-disc RAID. Seems plenty robust for our purposes. Our primary application, however, has been lagging ...
0
votes
1answer
57 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 https://...
0
votes
1answer
125 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
24 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
48 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
94 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
22 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
29 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
17 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
41 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
78 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
53 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
89 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
18 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
61 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 2.2....
-1
votes
1answer
31 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
20 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
73 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
33 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
31 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
46 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
45 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
27 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
30 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
95 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: https://www.andreagrandi.it/2015/02/21/how-to-create-a-...
0
votes
2answers
161 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
28 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
64 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
108 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
72 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
37 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
81 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 ...
4
votes
1answer
35 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
42 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 ...