System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

1
vote
3answers
74 views

Is it possible to detect that a database connection is to a copy rather than to the original database? [closed]

I have an application that needs to know if it is connected to the original database that it was installed with or if the connection is to a copy of that database. Is there any known method to know if ...
0
votes
1answer
767 views

innodb corrupt tables

Running shared hosting cpanel box with Mysql 5.5. Restoring or packaging (using pkgacct) is giving off some serious database errors, on multiple various users sum_joom954.jos_wf_profiles OK warn ...
3
votes
2answers
870 views

Puppet: how to use data from a MySQL table in Puppet 3.0 templates?

I have some data whose source-of-truth is in a MySQL database, size is expected to max out at the some-thousands-rows range (in a worst-case scenario) and I'd like to use puppet to configure files on ...
2
votes
1answer
53 views

Website search function working from one location but not another

The company I work for does a lot of business with a government program, U.S. General Services Administration. Their website is located here. For the last two weeks, we have been unable to perform ...
0
votes
2answers
173 views

Creating a local database instance from the RDS snapshot

I am running a AWS RDS large instance for the production. I am taking mysqldumps everyday at mid-night. But it take too long to take the mysql dump and the website does not respond during the mysql ...
0
votes
1answer
41 views

DB Migration switching from MySQL [closed]

I currently have a massive MySQL Data but would like to move over to Cassandra nosql. How hard of a move over would this be? I've not found any examples yet on this being done. It is possible right.
1
vote
1answer
78 views

Is it safe to use password in script to backup database of remote server?

Currently, Im using a small script to automatically backup my database (of a webserver). To backup the database, I have created a user account with only read and lock privilages. The script will use ...
1
vote
1answer
313 views

postgreSQL replication and failover with repmgr on Ubuntu

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now. What I ...
1
vote
1answer
29 views

Changing dataDir in mysql

I have an mysql server and I want to change the datadir from /var/lib/mysql to dif_dir/mysql. Is it a simple scp? If not, what are the steps that I need to take?
1
vote
0answers
195 views

How to manage postgres server cpu load and idle in transaction warning? [closed]

I am using postgres db with django app. I created two daemon process out of it, one is used for scheduling some tasks(APScheduler) and other one is to dump events into database subscribing them via ...
0
votes
1answer
216 views

2 RAC node clusters with different RAID layouts?

I am comparing RAID 10 and RAID 5 configurations for Oracle database in order to determine the best choice in terms of performance for mixed workloads. Is it possible to have 2 RAC node clusters and ...
1
vote
0answers
109 views

Is memcache impacting my performence negatively?

I am using pressflow 6 and NewRelic seems to suggest that memcache is infact hurting performance as shown below : My settings.php file : # Varnish reverse proxy on localhost $conf['reverse_proxy'] ...
1
vote
5answers
1k views

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 ...
0
votes
2answers
85 views

Amazon RDS and users, security

By default you got a username and password for your RDS database. Would it be dangerous to use the credentials on your production website, say in php files? Or is it necessary to create a user with ...
0
votes
1answer
135 views

whois returns correct changed date but wrong nameservers [closed]

I was just told by 1&1 customer support that "the date in the whois could show correctly while the nameservers information being the old one" I though the whole document was stamped at once, not ...
0
votes
2answers
147 views

Setting up MySQL database replication [without restarting mysql]

I'm trying to setup MySQL db replication, it seems pretty straight forward. I was using this tutorial: http://www.howtoforge.com/mysql_database_replication Now I run a rather large MySQL database ...
0
votes
1answer
245 views

What are invalid table names in SQLServer?

So, apparently you can't name a table Trigger in SQLServer. Someone in my office found out the hard way porting an application from MySQL, I'm suspicious of whether or not that's a valid table name in ...
0
votes
1answer
2k views

Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This ...
1
vote
1answer
116 views

ScaleMP vs SAS Grid

At my workplace we have a heavily used SAS server, but its workload is such that obtaining 1 minute of CPU time often takes 10 minutes of real time. This isn't just due to an I/O or network bottleneck ...
1
vote
0answers
28 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
95 views

ft_stopword_file not picked up

I have a VPS server with a company called Webfusion. I want to remove some or all of the FULLTEXT stopwords because some specific words needs to be searchable with my DB content. I opened ...
2
votes
1answer
559 views

Is it possible to recover MongoDB databases from .ns and .0, .1, . … files?

I have a MongoDB 2.0.4 installation on Ubuntu 12.10. Recently I had some problems connecting to the database from the outside, and figured out there was something which prevented MongoDB from starting ...
-1
votes
1answer
136 views

Can I connect VM to Wamp installation of Mysql running on same machine? [closed]

On my Windows 7 PC I have Virtual Box running a Centos VM that has PHP installed on it but no MySQL that I brought from the office. I am trying to set up a database for it. I have Wamp installed on ...
1
vote
1answer
164 views

Database backup with T-SQL script - Issue with Declare and Set Variables

Can someone tell me why I can't backup my database with the script below? I can run the script but it didn't create the backup. I"m using SQL Server 2008 DECLARE @pathName NVARCHAR(512) SET @pathName ...
0
votes
1answer
176 views

Binding MySQL to run from the public or private LAN IP address - which one is faster

So we have 2 servers all running at the same web host. We have bind MySQL to listen on the public ip-address of the database server and the web server connects to it from the public ip. Both servers ...
0
votes
2answers
389 views

Binding MySQL to run from the public or private LAN IP address - which one is faster [duplicate]

Possible Duplicate: Binding MySQL to run from the public or private LAN IP address - which one is faster So we have 2 servers all running at the same web host. We have bind MySQL to listen ...
0
votes
1answer
318 views

cannot connect to sql server express from sql server standard

... like my title says... I cannot connect to my instance on sql server express from sql server standard... I have tried disabling firing wall and checked sqlbrowser is started but for some reason I ...
1
vote
1answer
263 views

Update mysql database with arpwatch textfile database

I'm looking to keep arpwatch entries in a mysql database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
2
votes
2answers
48 views

Creating a test database with copied data *and* its own data

I'd like to create a test database that each day is refreshed with data from the production database. BUT, I'd like to be able to create records in the test database and retain them rather than ...
0
votes
1answer
116 views

RDS upgrade to large from small [closed]

I am running a Small RDS of Mysql 5.1 instance with Multi AZ on. I need to upgrade to large instance now. What will be the down time of the RDS instance while upgrading it. Please let me know
1
vote
1answer
113 views

Postgresql init.d script not working

I installed Postgresql 8.4 on my VPS with Ubuntu 10.04. Default setup, nothing unusual. After the installation the dbserver is automatically started and is running great. The installer also sets a ...
0
votes
2answers
247 views

How can I move a MySQL database to a new localhost? [closed]

I have a localhost (XAMPP) on an old pc. I need the MySQL database on my new mac with a localhost (MAMP). Issue is, pc doesn't have internet connection. Any way I can move the database over? Detailed ...
0
votes
3answers
74 views

Letting tenants host their own data [closed]

We are developing a web app and planning to deploy it in a multi-tenant model. However, some of our potential customers are having a great deal of discomfort with the idea of not having the control ...
0
votes
1answer
147 views

MSSQL Incremental Database-to-Database backup/clone

I'm trying to save some time on a repeated task I keep getting asked to do. We have an internal application we'll call "App". This App has a database called "AppLive" We have a "Test" instance of ...
0
votes
2answers
61 views

Added an index to my MySQL database, now queries get locked

I just added another index to a table in my database but now the site is crashing, queries get locked and not unlocked and queries are not executed (I can see them in the process list and they usually ...
0
votes
1answer
148 views

Should I use vm or set the maxmemory with Redis' 2.4

In redis 2.4 the vm-enabled no is the default, so I am using redis as database (not cache), and maybe occasionally the db size is larger than the memory, should I enable it? Or should I enfore ...
1
vote
0answers
307 views

Server quit without updating PID file on multiple mysql installation in linux

Iam trying to install one version of mysql in a LINUX machine. The system contain already another version of mysql installation. I prefer manual installation. Copy the extracted tarball into a ...
0
votes
1answer
130 views

Limit Database Size for a particular Package on VPS with cPanel

Is it possible to limit mySQL database size for a particular package (created via whm)? So we can offer a kind of trial hosting account. Trial should obviously have catches or we won't really earn. I ...
0
votes
3answers
94 views

MySQL and User level logging

I have been looking at logging only certain users activity in MySQL. I found that the logging could be enabled or disabled for all users but one of the service using the db does a lot of queries and ...
0
votes
2answers
133 views

database on SSD: data only or the DBM program too?

I plan on moving the data I use for statistical analysis (100-ish Gb) onto an SSD. The data is either sqlite single-file db's, or postgresql-managed data. The SSD is 240 Gb, 550 MB/s read and 520 MB/s ...
1
vote
3answers
529 views

Exchange: encrypted mail database?

For an Microsoft Exchange server, is it possible to encrypt the email database such that the sysadmin cannot see the emails? In other words, the admin would be responsible for all aspects of running ...
1
vote
2answers
582 views

Ulimit settings in Oracle 11g on Linux 5

Is there an issue with "Ulimit -Hn" being set too low (at 1024) when (Oracle recommend 65536)? This is for Oracle 64-bit 11g on Linux 5. It is one of the settings that appears to be woefully short ...
0
votes
1answer
581 views

Command line import of database using latin1 encoding

I'm using a particular cloud hosting solution (one which i won't name) and they don't provide ssh access so i'm at a whim on how the database is dumped. I downloaded the dump which is packed into a ...
1
vote
1answer
1k views

Mysql PID Error, Locking Database

I changed my.cnf file to add some parameters in it but after restarting the service it failed to start giving locking error. i removed locks using rm command and again trying to restart but it not ...
0
votes
1answer
289 views

Ubuntu automysqlbackup configure to have separate databases in one folder with gzip

I have automysqlbackup running on Ubuntu 10.04 and it works perfectly fine. I currently have it performing daily backups for all databases, but I would like to adjust the configuration to do the ...
0
votes
1answer
70 views

How does Oracle Streams prevent the execution of code during the distribution process?

I thought about Oracle Streams and stumpled into a question. Oracle Streams is used on the database I am programming for, but I am not the DBA. Therefore I am not familiar with the configuration of ...
1
vote
0answers
195 views

Installation of Access Database Engine 32-bit Fails

I am trying to install Access Database Engine 2007 32-bit. The splash screen comes up, you click "Next", then it fails with the error: Installation ended prematurely because of an error You click ...
3
votes
2answers
2k views

Maximum execution time of 300 seconds exceeded error while importing large MySQL database

I'm trying to import 641 MB MySQL database with a command: mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql but I got an error: ERROR 1064 (42000) at line 2351406: You have an error ...
0
votes
1answer
104 views

What is the most reliable way to copy access front end files to client PCs

I have several in house databases which have access 2003 front ends, either adp or ade files. I need to copy these from my server to every client machine. In the past I have used a rollout scripts ...
0
votes
0answers
120 views

cannot connect to ssms local database windows7

i am running SQL Server 2012 Management Studio Express in windows 7, i am having issues connecting to the local db. i tried all the above mentioned solutions, didnt work. please help. thanks in ...