System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

-2
votes
0answers
14 views

Simple website interface to a simple single-table database. What tools to use? [on hold]

I need to create a simple website interface to a single-table database. The web interface should allow users, with appropriate permissions, to easily edit and/or add/remove entries to the database. ...
1
vote
1answer
32 views

MySQL Optimization for write-heavy DB, single connection [on hold]

I have a cloud machine with 1 core CPU, 1GB RAM and 24GB SSD. It is running CentOS 6.5, mysql 5.1.73 with default my.cnf. I have a PHP job that runs and fetches data from some other websites, ...
0
votes
0answers
25 views

How to raise max no of file descriptors for daemons running on Debian Jessie?

I'm playing with pgBouncer as a connection pooling system for PostgreSQL. My system is a 12-core with 64GB RAM and 1Gbps network interface running Debian 8.1. Now I want to raise the limit for open ...
0
votes
1answer
19 views

Removing a mySQL database without password? [duplicate]

So about 6 months ago I set up a wheezy server and at the same time I installed MySQL even though I didn't need it. I've now updated to Jessie and need the database but can not remember the password ...
0
votes
0answers
24 views

Bridge server for connecting two databases?

I'm in a bit of a pickle. I currently have 2 database servers. One is hosted in the US and is online on the internet. The other is local, working only on LAN and external connections are not allowed. ...
-5
votes
0answers
19 views

Software Developers Learning Path To A System Architect [closed]

I am a system developer with 10 years of development experience my aim is to be a solution architect, typically responsible of 1) designing the enterprise software, seeing through the implementation ...
0
votes
0answers
7 views

How are databases able to process queries in parallel while still retaining correct order? [migrated]

How do databases process queries in parallel (more than one query at a time) while still keeping the correct order (queries are performed in the same order that they are submitted)? Is there a kind of ...
0
votes
0answers
9 views

Attempt to write readonly database , Skype main.db [closed]

im trying to write and delete something from a skype database, but i get this attempt to write a readonly database If anybody do that before, can please say me the solution? thankyou very much ...
0
votes
0answers
14 views

Conservative Azure Windows VM to Run SQL Server 2008 R2 [duplicate]

For testing purposes I need to set up three Azure Windows VMs to each run an instance of SQL Server 2008 R2 each holding one DB of approx 100GB. There will be quite a few complex stored ...
0
votes
1answer
16 views

Slony PostgreSQL replication - Can I create an index on a table on a slave that isn't on the master?

I have just set up a slony replication set up between 2 postgres servers. One master, and one slave host. Data is being copied. We don't want to use this for data backup or anything, but want to do ...
0
votes
1answer
41 views

How do I quickly tell the structural differences between two databases?

I am upgrading a web application to a newer version and need to migrate the data manually. The newer version uses slightly different database structure. It has added a few tables, but all of the old ...
0
votes
2answers
48 views

Postgresql: restoring database from dump fails

I am using psql (9.3.9) on Ubuntu 14.04. I created dump of a database using command: pg_dump db1 > db1.backup I deleted the db and recreated it. Trying to restore it with psql -d db1 -f ...
9
votes
3answers
605 views

Best practice for 24 Disk Array

we have just migrated for our old fibre SAN storage to an IBM v3700 storwize with 24 SAS 600GB disks. This storage is connected directly to two IBM ESXi 5.5 servers each with two 6Gbps multipath SAS ...
0
votes
2answers
34 views

Pros and cons of database choice for OwnCloud [closed]

OwnCloud provides 3 choices for its database: SQLite MariaDB PostgreSQL Obviously SQLite is not a practical choice, since it can rarely handle the load. What about the other two? Is MariaDB or ...
1
vote
4answers
42 views

reliably write database dump directly to remote filesystem (Linux)

I need to move a very large database (~320 GB) from server1 to server2 (Linux). Because of different extension versions, the database can only be restored on server2 from a dump file as described ...
0
votes
0answers
14 views

How can I access to a database on OpenShift?

I created an application on OpenShift, everything is working and there are no problems. I now need to attach the database that is on OpenShift with my desktop application developed in C #. The desktop ...
-2
votes
0answers
15 views

Which db choose to concurrent work of 2000 connections and more? [duplicate]

Let's assume. I have some credentials data which plan to store in mariadb. And I have two php scripts: worker.php - must work 2,000 workers(it is condition!). This workers must use same db for select ...
0
votes
1answer
35 views

Connecting to Oracle DB hosted on Windows 8.1 Azure VM

I have a windows 8.1 vm created on azure, it has 14 GB of memory and 200 some GB storage. I have installed Oracle with a templated database onto it. Everything is fine with the installation and I can ...
0
votes
0answers
22 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 ...
0
votes
0answers
16 views

How to Restore from sql Maintenance plan backup

I have a SQl 2005 Instance in my PROD SQL server. I have been given a task to migrate databases inside that instance to different SQL box ( SQl 2008 r2 in Win 2008 r2 box) Database. Current sql ...
1
vote
1answer
218 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 ...
2
votes
2answers
160 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
18 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
37 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
77 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
26 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 ...
0
votes
0answers
120 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
28 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
48 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
34 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 ...
0
votes
1answer
21 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
38 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
33 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
23 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
0answers
28 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
0answers
25 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 ...
0
votes
0answers
78 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
47 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
94 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 ...
0
votes
1answer
108 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
44 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 ...
1
vote
0answers
25 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
13 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 ...
-4
votes
1answer
88 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
224 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
194 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
39 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 ...
-3
votes
1answer
48 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 ...