System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
0answers
9 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
6 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
7 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
44 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
74 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
41 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
24 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
37 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
25 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
0answers
5 views

msxbse35.dll intermitent error accessing shared opera foxpro database file

I have traced the failure of an Access 97 DB, where it works some of the time and not others. It can take a few page changes in the DB to get the error up, just as easily as it can come up right away. ...
0
votes
1answer
42 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
50 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
87 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
43 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
24 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
50 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
0answers
9 views

VCenter and SSO Database

We are using external dedicated Database Server During VCenter SSO installation RSA Database got created using the script (RSA_DATA.mdf,RSA_INDEX.ndf,translog.ldf)and pointed the SSO to it Now During ...
0
votes
1answer
75 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 ...
0
votes
1answer
18 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
15 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
97 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
75 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
85 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
37 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
29 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
44 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
21 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 ...
0
votes
1answer
501 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
0answers
43 views

Database Organizational Structure, DB Groups

I'm setting up a web server where users can create their own databases. In order to prevent name clashing, I've typically seen hosting companies handle this by prefixing any DB name the user creates ...
0
votes
1answer
83 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 ...
1
vote
1answer
174 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
132 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
48 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 ...
1
vote
2answers
37 views

Does a server use bandwidth when connecting to itself?

I have a dedicated server (CentOS 7) with Storm on Demand. I have a rails application running on the server served by nginx and unicorn. I'm using MariaDB on the same server. The rails app handles ...
0
votes
1answer
35 views

prevent replace sql database files with old one

i have a database that i use in my application. the operation i want to prevent is if i stop sql server and take the database files to another location then start the sql server and make some ...
0
votes
1answer
210 views

Is mongorestore ditrectly to a path with the --dbpath faster than restoring to a running mongod instance?

What and how much is it faster: #mongod not running mongorestore --dbpath /var/lib/mongodb --db test /some_dump or #mongod running mongorestore --db test /some_dump ? I could not quickly find ...
-2
votes
2answers
63 views

How to work on 2 MySQL databases at the same time using PHPMyAdmin through Plesk? [closed]

I am trying to open 2 instances of PHPMyAdmin by clicking on the "manage database" link in Plesk. But the challenge is I seem to be only allowed to work on 1 database at a time as when I try and open ...
0
votes
0answers
23 views

Recommended servers for small databases [duplicate]

I work in a research institute in India. We have old Windows server 2003 SP-2 Standard Version. Of course we need to switch to a newer one. What are the recommendations for complete new setup ...
0
votes
1answer
36 views

Riak setup and LB?

Quick question about setting up riak cluster. Do I need load balancer in front of the cluster ? The cluster will have 3 nodes with N =3, so successful write must have the data in 3 nodes. Any ...
0
votes
0answers
29 views

Duplicate DB and files

I'm creating a group of websites using the CMS Concrete5 has models to be presented to my clients. My idea is that they can choose each one they want and deploy a new subdomain with a model ready to ...
0
votes
1answer
44 views

Securing Webserver and Database

I need to secure an internal web server and sql db, that is going to be made public(www) At this stage im only looking to provide a reasonable amount of security($$) until it gets bigger at which ...
1
vote
0answers
83 views

MSSQL Server 2008R2 Replication stall, no latency, no errors, missing data on subscriber

This morning after performing a routine database deployment of two new tables I noticed that transactional replication had stopped for more than 3 hours. When replication resumed it picked up 3+ hours ...
1
vote
1answer
168 views

Execute Trigger as Login

Is it possible to impersonate a login when running a trigger? I able able to run execute as 'username' but not execute as login='username' I can usee execute as as such with EXECUTE AS login='smr' ...
0
votes
1answer
167 views

OpenShift allow permanent external access to PostgreSQL [closed]

I have an OpenShift gear with Nginx and PostgreSQL, and need to allow a Java applet (served from Nginx) direct access to the PG database. I've already tried to edit ...
0
votes
0answers
44 views

Percona connectivity issue, user cannot connect?

I am trying to authenticate a user in percona but I am seeing the error message below each time I try... 2014-09-29 12:43:37 5028 [Warning] The plugin '0' used to authenticate user 'user@' is not ...
-1
votes
2answers
2k views

DATABASE ERROR: CONNECTION FAILED! - when accessing round cube webmail after installing latest Mac Updates for OS X server

My server is a Mac Pro (2.4 Dual Xeon) with OS X 10.9.5 and running OS X Server version 3.2.1 - I installed the latest OS X updates for both Mavericks and Server on 9/20/2014 - round cube webmail ...
0
votes
0answers
51 views

jboss 7 connection to database vip fail

Jboss 7 is connecting to HA database with VIP. When master db fails, the HA kicks in and slave db takes over as master. Querying directly the new master db works fine. However, at Jboss level, the ...
0
votes
1answer
29 views

WLS: Identifying the managed server where a DB session originates from

We are using WLS servers, on which we configure data sources (DS) and managed servers. For failover reasons, our main application is depolyed on two separate managed servers (lets call them app_1 and ...
0
votes
1answer
36 views

Can OpenVPN routes be stored in a database?

I'm trying to develop a simple custom intranet web-based tool to manage OpenVPN routes so that they can be added and removed without having to edit the config file. Is there any way to make OpenVPN ...
0
votes
0answers
42 views

Write Failed Request Tracing logs to a database

I'm using Failed tracing logs on my IIS 7 which are a very good source of debugging information. Theses logs are written on the hard drive but I would like IIS to write them directly to a database, ...