System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
2answers
25 views

When should I consider a 2 socket motherboard for Server?

We are buying a new server and the idea of dual socket motherboard comes up. Is 2 socket motherboard worth the price and hassle for an application that hosts a couple of websites and databases for a ...
-2
votes
0answers
14 views

AWS: Amazon Linux vs. Ubuntu for Meteor [on hold]

I'm creating a Meteor app solely dependent on AWS. In doing so, I'm staying far away from the usual Modulus.io for the app and Compose.io for the database. I'm just having trouble picking the AMI. ...
-2
votes
0answers
20 views

Migrating webprojects from Windows server 2003 SP2 to another Windows Server 2012 R2 [closed]

I need to migrate my Visual Studio 2003 website (written in asp.net and vb) having a Oracle database connected to it, to Visual Studio 2012 on Windows server 2012 R2. I imported website.sln file ...
1
vote
0answers
4 views

Huge oplog size after full sync on one secondary causing performance issues - MongoDB

I'm a MongoDB newbie. I have a replica set with 3 members (1 primary and 2 secondaries) on CentOS 6 and Mongo 2.6.8. One of the secondaries crashed because of high consumption of memory and I ...
-4
votes
0answers
16 views

PHPMyAdmin Full Export Issues [closed]

So today i was switching to my new webserver and when i backed up my mysql databases a did a full export.... is there anyway to import my full.sql file and still have all the databases separate and ...
2
votes
2answers
6k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
1answer
2k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
0
votes
1answer
2k views

Command to list event monitors in DB2

I see the following commands: drop event monitor set event monitor create event monitor But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event ...
0
votes
1answer
792 views

Users database empty after Samba3 to Samba4 migration on different servers

I have to migrate a Samba 3 to a new Samba 4 server. My problem is that the database on the samba 3 server seems a bit empty. The secrets.dtb file is only 20K whereas the “pbedit -L |wc -l”command ...
1
vote
3answers
10k views

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
0
votes
0answers
35 views

Repairing corrupt MS SQL master database - no SQL client access

Apologies for any duplication but I feel like I'm falling at the first hurdle. I have a MS SQL 2005 Server which is refusing to start and for which I don't have a password (including the 'sa' ...
-3
votes
1answer
27 views

How to set default file permissions? [duplicate]

I have ran these codes: sudo chown -R / sudo chmod 755 / And now my server is not working. I need to get backup copy of MySQL database How can I fix it?
0
votes
1answer
14 views

Cassandra NetworkTopologyStrategy

I would like to configure the following multi-datacenter Cassandra cluster: DC-EUROPE has 3 Cassandra nodes (1.1.1.1, 1.1.1.2, 1.1.1.3) DC-ASIA has 3 Cassandra nodes (2.2.2.1, 2.2.2.2, 2.2.2.3) Each ...
0
votes
1answer
16 views

Exchange 2013 high read on mailbox database

I have an exchange 2013 server with 5 mailboxes, on one of them there is a constant read of about 2MB/s, and this has happened for almost an entire day now. From looking into resource monitor I can ...
0
votes
1answer
32 views

how to create public SQL server [closed]

I installed sql server on my computer. I can work with it as localserver. But i want to it to be a public server. I followed lot of tutorials but it's still don't work(I can't connect the server ...
3
votes
2answers
4k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
0
votes
1answer
16 views

Restoring From Another Dev's MDF on Same Database: MDF Cannot be Overwritten

Here is the situation: We have multiple developers. We want to import/export(restore/backup) .bak files whilst working on the same, but local, databases(Each dev has a local instance of DB: A). The ...
0
votes
0answers
22 views

DataFileSync flushing mmaps takes a long time

We are running MongoDB 2.6.9 on a 64 bit Ubuntu Linux VM. When I look in the database folder, this is what I see with ls -lh: -rw------- 1 mongodb mongodb 64M Apr 15 14:26 admin.0 -rw------- 1 ...
0
votes
1answer
2k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
1
vote
1answer
2k views

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

I am trying to get authentication and authorization working with my ASP MVC project. I've run the aspnet_regsql.exe tool without any problem and see the aspnetdb database on my server (using the ...
2
votes
1answer
18 views

Apache Spark infrastructure - combining compute and storage nodes

I have an infrastructure question around Apache Spark, which I'm looking at rolling out in a greenfield project with (at most) approximately 4 TB of data used for modelling at any given time. ...
0
votes
0answers
27 views

SSH tunnel is up, but cannot connect to database

I am working on a project where we are using an SSH Tunnel with port forwarding. Our server contains a website which references a database on our customers server. We have established an SSH ...
2
votes
2answers
4k views

Command to create MySQL database with Character set UTF-8

I use create database dbname; to create database. but I want it to created with Character set UTF-8 Anyone know what is the command to use?
0
votes
0answers
18 views

SSH Connect to remote computer to query database on local server

I'm having real difficulty with an SSH tunnel to a customer server. This is needed as we are developing a site on their behalf, hosted on our server but referencing the database on their server. The ...
0
votes
1answer
1k views

Need DB2 OLEDB Driver / ODBC Driver

I am trying to establish a connection between excel and db2. I am able to successfully query and retrieve data from my DB. I am using the below connection string ...
5
votes
3answers
7k views

When to relink Oracle?

Various sources on the internet suggest relinking of Oracle binaries is necessary after each OS upgrade and / or patch. I can understand relinking would be necessary when upgrading glibc. Some ...
0
votes
0answers
15 views

Web and Business Azure Tiers sunset (Deprecation)

The problem I am struggling to understand which is the best option to move to from this as their is no direct replacement. What would be the best step forward? I have flagged that optimization needs ...
0
votes
1answer
24 views

Protecting the database against bad queries [closed]

I want to build a clustered and/or replicated relational database so that all of the company's apps can use the same data without manually shuffling it between databases. However, this raises two ...
-1
votes
0answers
23 views

Not enough MySQL connections

I am using clearDB database for my windows azure based php application. I am getting intermittent error on mysql connections. Currently we have nearly 2000 online customers. And we have 30 connections ...
1
vote
1answer
1k views

DB2 Integrity Checks and Exception Tables

I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on. A few notes on this ...
0
votes
0answers
40 views

Clean up AD References to now deleted mailbox Exchange 2013

We recently separated one of our mailbox databases into three databases to better manage its growing size. The migrations all went well, and the old database has been dismounted for some time. Today, ...
2
votes
1answer
185 views

nodejs postgresql database connection string

Is there a way where I can specify(include) both the master and slave server in nodejs db (postgresql) connecetion string in a replicated envirnment? My aim is 'if master is down then the read/write ...
0
votes
1answer
33 views

Error when defragging Exchange Server 2010 mailbox Database

I am trying to perform an offline defrag on our Mail server. We are running Windows Server 2008 R2 Standard, but have Exchange 2010 installed. I am using eseutil to perform the defrag - however I ...
18
votes
2answers
15k views

How can I do a dump of only the table structure in PostgreSQL?

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?
0
votes
1answer
39 views

MySQL - Can not connect from local network, but can connect from any other IP

Facing a really strange issue. The original requirement was to have a development server which can be accessed from our office in Sweden and from India. In our server in Stockholm, I created a new ...
4
votes
7answers
6k views

Is there any equivalent of mysqlhotcopy for InnoDB?

Currently I'm using mysqldump to make backups which is slow, but OKish. The big problem is restoring database, which takes a few days. The dump is around 7GB gzipped, so it's not a tiny database, but ...
0
votes
1answer
43 views

Adding an admin user to a MongoDB

I'm using MongoDB 3.0.3, and I've been having issues with creating users. I created a user on the admin database using db.addUser('admin', '....'). I gave it dbAdminAnyDatabase privilege. The output ...
0
votes
0answers
27 views

tfsbuild.exe delete / destroy keeps orphans in database

We're using TFS 2012 since 2013. In the mean time the database has increased up to ~60GB. This has several drawbacks like increased backup time, wast of drive space, ... After having a look into to ...
0
votes
0answers
13 views

Managing data created with an API in multiple environments

I have a staging and production environment for my application and store Stripe::Customer ids in my database. Occasionally, I want to copy production data to my staging database, but the ...
0
votes
0answers
9 views

percona cluster schema change with RSU issues?

I have a setup with three percona cluster servers. I am doing some tests with online schema changes using the manual RSU method [1]. I have a question regarding what happens when you drop a column on ...
-1
votes
1answer
391 views

Servers / ram for social network- how many? [duplicate]

Possible Duplicate: Can you help me with my capacity planning? I am launching my social network soon and am looking into hosting. The question I am lost considering is: Do I need separate ...
3
votes
2answers
566 views

Best approach to design this MySQL big database

I'm planing to design a database that contains only 2 tables (stats1 and stats2), but, this tables will contain rows going to 40 000 000 records! All the records will be "positive/unsigned" integers. ...
-4
votes
1answer
67 views

Consumer vs Enterprise SSD [closed]

I'm deciding what SSD's to use in our infrastructure. Enterprise drives are obviously more reliable but storage items are expendable and will fail anyway. So considering that we have proper RAID, ...
3
votes
2answers
5k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
-1
votes
5answers
6k views

Error! File In use: SQLSERVER

I am trying to copy a database from one folder to another. There is no program at all running except operating system.(I mean all windows shut) I keep getting this : The action cannot be ...
1
vote
1answer
149 views

How do I make multiple instances in AWS use the same data source?

I would like 3 instances to all pull data from the same data source. I want all three instances to pull the exact same index.php for example from an HD or storage medium. What is the preferred way ...
13
votes
2answers
14k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
3answers
1k views

How do I redirect Weblogic logging to database?

Is there a way to send or redirect Weblogic (or Fusion Middleware) logging output to a database, without having to write a custom application? All the documentation I've read seem to deal exclusively ...
2
votes
1answer
35 views

Server error with large posts

On a large drupal site, the database server is on a separate server connected directly to the web server. The web server uses apache and memcached. The problem is that whenever the post is a large, ...
0
votes
1answer
160 views

Access db with dynamic IP using windows Application C#

I want to connect a Desktop Application (C#) with a website which is hosted on BLUEHOST Server (Shared Hosting). I have to add an IP on server to allow for remotely access to mysql database. But the ...