System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
1answer
93 views

Which db managment software can copy from one sqlite3 table to another for fields which are common in both?

We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has ...
0
votes
1answer
18 views

OpenBase server database connection troubleshoot?

I am troubleshooting a workstation/server instance in which an application hangs while interacting with our Windows 2003 Server OpenBase-hosted database. In short, the application will go into "Not ...
0
votes
1answer
477 views

Migrate to AWS from Linode

Migration to another server is not easy when we have a large database. We want to move our database in Linode to amazon RDS database, i tried to pg_dump and pg_restore and it succeeds but it consume a ...
1
vote
1answer
64 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
0
votes
0answers
40 views

rails 3 ruby 1.8.7 app slow startup on the web

I've been working with rails 3 and ruby 1.8.7 and ALWAYS (in all my apps), I have problems with the STARTUP time delay. It sometimes loads OK, and sometimes takes more than 12 seconds just to start ...
1
vote
2answers
382 views

Can remote queries cause locks?

We have a SQL Server 2005 (SERVER-A) server that holds the database for an application that has been locking a lot lately. We suspect that the problem are transaction locks, so we decided to capture ...
1
vote
2answers
4k 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
80 views

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
2
votes
1answer
78 views

Protect a public-facing PostgreSQL server against abuse

I have a Postgres database containing public information that I'd like to expose to the internet, for anyone to use. What steps can I take to prevent: Excessively expensive queries that could hog ...
-5
votes
1answer
54 views

Ticketing server database security [closed]

I want to setup a ticketing system which will show the seats available instantly. However, for security, I do not want to open my database in internet. I want to setup a server which has public IP and ...
0
votes
1answer
1k views

sql error “Service Broker needs to access the master key in the Database ”xxx" Master Key has to exist

I am pretty new to SQL and administration of databases and still learning. We receive one SQL error for quiete a long time, which has as far as we know no effect on our application. So we put that to ...
0
votes
2answers
82 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
0
votes
1answer
127 views

Several Server Errors (No database connect, can't create TCP/IP socket etc

My server stops taking requests on my website today. It works for some time, but then the server just stops working and throws several errors: 500 Internal Server Error Warning: mysql_connect(): ...
0
votes
2answers
56 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
0
votes
1answer
40 views

MySQL Replication fix after server shutdown/start

Server1 is Master Server2 is Slave Both are in our AWS testing env and we stop them once done with our work. When start again, Master rotates/creates new binary log file but slave keep looking for ...
0
votes
0answers
82 views

In Linux, what's the best way to delegate administration responsibilities, like for Apache, a database, or some other application?

In Linux, what's the best way to delegate administration responsibilities for Apache and other "applications"? File permissions? Sudo? A mix of both? Something else? At work we have two tiers of ...
0
votes
1answer
190 views

MySQL Creating a Database CentOS (6 - 64bit) Error 1064 (42000)

When ever I type in : GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********'; It gives me an error of : ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
-2
votes
1answer
54 views

Adding and Removing MySQL Databases via CentOS 6 - 64 bit

I have a VPS, and am having troubles with MySQL. I think I have created a database, but got lost. I need to know how to: Add a database, with the username, name of the database, and password. ...
0
votes
1answer
172 views

Rails application keeps timing out when attempting to connect to Postgresql DB

I'm hosting a postgresql database on a small windows azure Ubuntu 13.04 VM with a default postgresql.conf. I have a Rails application running on a medium windows azure Ubuntu 13.04 VM. When accessing ...
0
votes
1answer
480 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 ...
-2
votes
1answer
77 views

Is There any way to change Active Directory Users Database Source?

I need Active Directory Use My Own Custom Database (or shell or ...) for Authentication Users. Is there any extention or something like this to change User Passwords Database of active directory? I ...
0
votes
2answers
312 views

Connect to MySQL EC2 Instance outside of VPC

I have a VPC setup with a few EC2 instances inside. I'm attempting to connect to a MySQL database on an EC2 instance outside the VPC, with no luck. I have the security groups on the VPC EC2 ...
1
vote
1answer
124 views

Cannot Connect to MsSql2008 R2 Database Engine, While Connecting to Other Services

I have installed MsSQL 2008 R2 on my computer as I have installed always before. But unfortunately this time, I cannot connect to Database Engine while I can easily connect to the other services like ...
0
votes
2answers
56 views

Recommended Setup

I have been running into issue with my MSSQL Database setup with speed. Here is my scenario. About 100M Rows Average: 1k Updates Per Second Hard Drives: RAID 10 SSD MDF --Active Time: 0 Log ...
1
vote
0answers
116 views

Changing Cassandra Tokens on 1.2.1 From 4 to 256

We initially started our cluster using one datacenter, one rack, and the Simple replication strategy. We have keyspaces with several hundred gigabytes of data. When we changed the tokens in the ...
0
votes
1answer
198 views

how to copy sql server database on same server

I've got a SQL Server 2008 and want to make a copy of a database so I've got a 2nd Version of the database for testing on the same server. The database copy wizard is not able to copy the database, ...
0
votes
1answer
35 views

Mysql Db replication

I have the following setup: 3 servers, B1, B2, B3. A database from B1 is being replicated to B2. B1 is master and B2 is slave. Now, I want an another database from B2 to be replicated to B3. I need ...
0
votes
1answer
43 views

Confusing MySql Error

I am trying to install an application on CentOS, and see this error in my apache log. If any can help me understand what exactly is the case, I can try to work on a solution for the error. This is ...
-2
votes
1answer
64 views

Transfer database from Red Hat Linux to WAMMP [closed]

I've currently got a MySQL 5.X database on a server running Red Hat Linux 4 (from memory), which I currently shell into with Putty. I now need to replicate the server in WAMP for offline debugging, ...
0
votes
1answer
33 views

Amazon RDS - Create a Security Group NOT in Virginia? [closed]

It seems as though the management console only allows security groups to be created while in the "Virginia" selection. Is there a way to create a security group for an Oregon (or other)-based ...
0
votes
2answers
118 views

Will re-installing phpmyadmin will have any effect on my Databases?

I am quiete new and somehow I crashed my phpmyadmin website, it can't be displayed without errors after changing the port of it once. So does it has any effect on my databases when I reinstall my ...
2
votes
1answer
1k views

Database (MySQL) and SSD lifetime - “lot” of writes to DB

In company where I work we started using SSD for our internal 3 GB MySQL database Difference in perfomance is HUGE, which is great. What I am worried about is lifetime of SSD Writes to DB are ...
1
vote
1answer
407 views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
0
votes
1answer
156 views

Exchange database doesn't decrease its space after remove-storemailbox [closed]

I need to free some space in the exchange's volume. I proceed with some mailbox deletion also with "remove-storemailbox" for softdeleted mailboxes. However the database size doesn't decrease. May I ...
0
votes
2answers
129 views

Connecting to SQL Server from Python Django

I have a Django site running on a Linux based server. My partner has SQL Server running on a IIS Windows server behind a Cisco router. We are looking for a secure way for the Django site to connect to ...
-1
votes
1answer
32 views

Why is SQL Server seperate from the roles in Windows Server 2008 Server Manager?

I have an instance of Windows Server 2008 running on my machine. Within the OS there is a useful application called Server Manager, where I can manage several roles for my machine (such as web server, ...
1
vote
0answers
64 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
0
votes
1answer
109 views

Securing database server with IPTables

I have my app (WordPress) and database (MySQL) on separate servers; they are connected on a private network provided by the hosting service provider, and I've taken all the preliminary steps (that I ...
0
votes
1answer
289 views

SSH Tunnel or OpenVPN to securely connect app and database servers?

I have my app (a PHP forum) and database on separate servers, and want to make sure that the connection between them is secure. I've taken all the preliminary steps that I've come to know of, and am ...
6
votes
3answers
189 views

Protocol choice for Machine-to-Machine communication - level:n00b

I am building a monitoring system for an irrigation pump and the connected pipeline. So far I have completed the sensor network. Everything connects to a micro-controller board (actually 4 Teensy 3.0 ...
-1
votes
2answers
51 views

Database based Mail Server [closed]

I have a single case problem, it relates to selecting the correct mail server. A group wants to create their own business PHP website, where the public can read articles, news etc. and the staff can ...
0
votes
1answer
243 views

Restore Database of deleted Domain -Parallels

I accidentally deleted a domain from parallels plesk.Is it possible to restore the database related to the domain
0
votes
1answer
84 views

owncloud regeneration of database's tables

I happen to be interested by the PHP syncing software ownCloud. I set it up quite correctly, except for the database, that I had to create after I had installed ownCloud for some obscure reasons. As ...
-3
votes
1answer
123 views

Can postgres go faster? [closed]

My question is simply: have i missed any configuration settings that might make postgres achieve better read throughput? Background I'm modeling a very simple twitter program. My schema has only 3 ...
0
votes
1answer
87 views

Which Database (SQL/NoSQL) is the best fit? [closed]

I have 2 nodes, one gateway and one worker. Data must be passed from gateway to worker (without direct connection). I would like to store a Key into a database identified with an ID and a Time To ...
-7
votes
1answer
46 views

How to acquire a unique IP address [closed]

How do I assign a unique IP address for my remote server? I am using windows 7 Operating System. Any other security configurations and recommendations are welcome.
1
vote
0answers
461 views

Connections being intermittently left open on JBoss for requests from clients

The issue I'm having is that occasionally a connection for a clientside request + the assosiated DB connection (using Oracle 10g RAC) get left open on JBoss EAP 4.3.0 CP10. Also a JBM JMS queue ...
1
vote
2answers
1k views

Weird behavior using Active Directory group mapped to SQL Server user/login

I've run across a very odd behavior on SQL Server 2008R2. I have a third-party application which acts as a SQL Server client. I have a subset of my users who should have access to this application. ...
9
votes
2answers
6k 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
1answer
277 views

MariaDB Galera Cluster hang after issue cluster command

When trying to cluster two MariaDB Galera servers on RHEL 6 together using the command: mysqld -uroot --wsrep_cluster_address=gcomm:// and the screen then sits there, and looks at me with this ...