System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

-1
votes
0answers
24 views

SSD vs RAM - Optimal ratio for different data sets / databases [duplicate]

I am looking for an advice or even better some studies / benchmarks to read for different scenarios (data sets) when it comes to the best ratio between actual RAM and SSDs. I know that fitting the ...
1
vote
1answer
3k views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the innodb-force-...
2
votes
2answers
179 views

Database backup encryption

I've been trying to work out an effective database backup encryption scheme lately. I have a Postgres 9.4 server, I have most of the backup scheme fleshed out I think. Backups will be stored in a ...
1
vote
0answers
28 views

Setting up SQL server on EC2?

I would like to set up a SQL server in AWS on an EC2 server. I originally wanted to use an RDS instance however we require the bulk admin privilege for some of our operations which is not allowed in ...
1
vote
0answers
62 views

SQL Server seems to be taking 40GB of RAM but keeps reading disk… Why?

So I have allocated 40GB of RAM for SQL Server. I can see that after I first run a query on database, that 40GB memory limit will be quickly filled during first run, however when I will do exactly ...
-2
votes
4answers
1k views

When should I consider a 2 socket motherboard for Server? [duplicate]

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 ...
1
vote
0answers
200 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 couldn'...
0
votes
0answers
316 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
33 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
171 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
0answers
177 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
38 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 ...
-1
votes
1answer
38 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 ...
2
votes
1answer
158 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
66 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 ...
0
votes
1answer
95 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
26 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 ...
0
votes
1answer
414 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, ...
0
votes
1answer
327 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 ...
0
votes
1answer
270 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 ...
1
vote
1answer
435 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
1answer
285 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 '...
2
votes
1answer
41 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 Stripe::...
-4
votes
1answer
139 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, ...
0
votes
1answer
418 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 ...
0
votes
2answers
762 views

CentOS 7 won't connect to external MySQL database. Database works from other servers

I have a new CentOS server set up, with Apache and php-fpm. The php application fails to connect to an external MySQL server. This server is reachable from other servers, the firewall on the database ...
0
votes
1answer
69 views

cant turn on mysqld. I moved mysql to an XFS directory and pointed it there

hey guys hopefully someone has the answers for this but these are my errors ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) and in my /etc/log/...
-3
votes
1answer
101 views

Coose server hardware for private server [closed]

I am planning to run a Linux server for hosting a java spring application with Tomcat. I need some help to choose the right server hardware to buy. NOTE: I am a student and cannot afford any really ...
0
votes
1answer
65 views

SP with xp_cmdshell gives an error in the MessageQueue, but executes successfully in Management Studio

I have a SP, which calls xp_cmdshell in it. This SP is being used in a MessageQueue. The SQL server and Agent services are configured using a Domain service account, and this service account has a ...
0
votes
1answer
106 views

db servers direct ethernet connection

We are planning to setup 2 mysql servers in master-master replication Is it possible to use direct Ethernet connection over gigabit ethernet port on the 2 servers? Is there a way to bind mysql ...
0
votes
0answers
160 views

How do I migrate a database between servers from SQL 2008 Std to SQL 2014 Std using T-SQL without losing data?

What is the process using T-SQL to copy/move/relocate a database from one server to another? Do I need to take a log backup on the source as well and restore it on the new server? I am pretty sure ...
0
votes
1answer
558 views

ldap_add: Constraint violation (19) additional info: some attributes not unique

Well I have already gone through ldap_add: Constraint violation (19) but couldn't solve my problem! Problem I'm facing is that, when I'm trying to add users from bckup.ldif file by issuing following ...
3
votes
1answer
70 views

Is it unusual for a database client to install the server's SSL certificate?

We use Amazon RDS for our databases at work. Recently we got an automated email from Amazon stating they'd be updating the SSL certificates and that if we didn't upgrade our database instances within ...
0
votes
1answer
33 views

multi-master databases in low connectivity environments

I'm working on a project that has many client devices distributed in remote environments where connectivity losses are frequent and expected. Clients continue to operate when offline, but when these ...
2
votes
0answers
295 views

Using database for storing text files and images [closed]

I need to build a image/static file cache which would host maybe few hundred up to thousand static files from 1kb to ~200kb. I'd need super fast reads (I'm using redis, but it's one threaded and I'm ...
0
votes
1answer
733 views

How to attach a database created by sql 2008 to sql 2012 when full text catalog missing? [closed]

I have an already created mdf file which was created by sql server 2008.But when I attach this mdf file to sql server 2012 it asks me to add necessary full text catalogs. I have no idea what to do....
0
votes
1answer
37 views

After restoration of .stm file i unable to open emails.

We use Exchange server 2007 as a mail server where mailboxes don`t synced to Outlook. We had some problems with a .stm file and we restored it. After that we unable to open any emails located in these ...
1
vote
0answers
70 views

Commvault, how to generate a report by time scheduled?

I'm using commvault at the moment to manage backups, but i need to creata a report of some kind that can show me the days of the week , and what server is backing up at that moment. A bit like this: ...
0
votes
0answers
450 views

MySql server keep crashing inside docker

I am running mysql inside docker with its /var/lib/mysql mounted on HOST. Eveything was working fine . Then i upgraded the docker from 1.4 to 1.5 . I rebuild the mysql image and but /var/lib/mysql ...
0
votes
1answer
428 views

How to update system databases in SQL Server

I am having problems updating a system database in SQL Server 2008. Perhaps there is a different way to do it, but I basically need to change/remove growth restrictions on certain log files for a ...
2
votes
1answer
425 views

How can postfix hash: databases be replaced by static: or inline:?

What is the syntax to replace a postfix hash-Database, for example domain.tld PREPEND my-header: foobar with a static map? docs define it as Example: "inline:{ key=value, { key = text with ...
-3
votes
1answer
49 views

How should my company bring its product, a line-of-business MVC application, into the cloud? [closed]

I am a recently-hired junior software engineer at a small company that develops and sells a normal client/server MVC application to small and mid-level enterprise clients in a particular line of ...
-2
votes
1answer
64 views

Set rules on exchange and save it to database [closed]

I wanna set exchange rules for my incomming backup mails. After receiving one message with "Backup Exec Alert: Job Success (Server: "SERVERNAME") (Job: "JOBNAME") " in the subject a script should be ...
3
votes
0answers
63 views

OlegDB in production [closed]

When evaluating available NoSQL solutions, our team identified following product for evaluation: OlegDB. Site looks pretty decent and documentation is available. While site says it's production-ready ...
1
vote
1answer
35 views

Size of MYI index smaller on slave server

I've recently altered a huge MyISAM table (80 million entries) by adding a new value in an enum field. After I did this I've checked the health of the table on 2 slave servers which are used to ...
1
vote
1answer
4k views

Third-party SSD solutions in ProLiant Gen9 servers

has anyone experience with using consumer SSDs like the Samsung 850 Pro in an HP ProLiant Gen9 server with a Smart Array P440ar controller? Judging by various reports about older versions (Gen6 to ...
0
votes
1answer
358 views

How to query database(s) on daily schedule and generate an email report with the results?

I have a website that runs off a Node web server, a Redis server for temporary storage, and a Postgres database. Once a day, I would like to run a batch of Redis and Postgres queries to generate a ...
3
votes
1answer
698 views

AWS RDS Nightly Staging Database

I am trying to determine if it is possible to configure the RDS service in AWS to do the following, but have not had much luck with my Google searches. When it does its instance backup, have it ...
0
votes
2answers
353 views

How to pipe all log files entries to a database on linux?

I am thinking about building an application that would read my different server log files, save the parsed data to a database, and then remove the line from the log file. This is my programer side ...
0
votes
1answer
131 views

Deploying grails application to iplanet webserver

I asked this question in stackoverflow and was advised to ask here. I have project that connects to a few Oracle 11g databases. So I have 3 different logins. This does fine when I run it locally from ...