System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

2
votes
2answers
112 views

Database server (MySQL) on SSD - trim command

I can't seem to find much expert information about using a database servers on SSD with regards to trim. I know I can enable RAID and LVM discard, and use an fstrim / cron job or the discard mount ...
2
votes
5answers
94 views

MySQL DB Backups: Lockless, Per-Table Restore, MyISAM/InnoDB

The Problem I'd like to implement a MySQL backup strategy on a dedicated server. It has multiple databases on, combined total is about 150GB. Most of this is weighted toward one of the databases. ...
-2
votes
1answer
50 views

Should internet access be disabled on production servers? [closed]

We have Weblogic server and Database server on our production environment. Should we disable internet access on these servers to protect them from hacking ?
0
votes
1answer
59 views

Cannot open './/ib_buffer_pool' for reading: No such file or directory

I've realised that my Percona DB which has several InnoDB tables doesn't actually have InnoDB buffer pool running as it wasn't specified in the my.cnf. I had a buffer pool size specified of 256MB, ...
-4
votes
2answers
82 views

Is RAM size related to SQL performance? [closed]

I have some simple code that generates 3 millions insert queries. I have two VPSes, one with 512MB RAM and one with 2GB RAM. On the 512MB RAM VPS, I can insert about 50,000 rows in 5 minutes. On the ...
1
vote
0answers
141 views

Zabbix no free space on disk

I have zabbix 2.2.1 and 252 monitors the hosts. Currently, the database is in local and size database is 65GB is running housekeeper who clears history entries older than 30 days. Entries are deleted, ...
1
vote
2answers
45 views

Scaling web application across multiple services

We're developing our web application and have been working on reducing our load times. When we began developing the application, we signed up with a well known hosting provider offering "dedicated ...
-1
votes
1answer
49 views

How to find a database location on server using phpmyadmin?

I am pretty new to managing servers, right now I have trouble to find the location of our database. I see the DB in phpmyadmin, is there a way to find the real location using phpmyadmin ? Running ...
1
vote
2answers
71 views

How to force sqlite3 table to take next available id for auto increment in firefox sqlite3 manager?

We delete some records in a sqlite3 table (re-id record manually) and compact the db. However when adding a new record in firefox sqlite3 manager, the auto incremented id is not the next available id ...
-1
votes
1answer
46 views

Site security - how to filter incoming traffic to a specific port

Just ran a security test on ScanMyServer.com, the results showed a medium risk vulnerability: Database Reachable from the Internet Summary: The remote host is running a database server that is ...
0
votes
1answer
45 views

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple ...
0
votes
2answers
82 views

How to benchmark maxCache 3.0 with SSDs? [duplicate]

We're a software development company and previously outsourced the HW side of business but now we're looking into building our own private cloud. We recently purchased a few servers, one of which is ...
0
votes
0answers
57 views

Riak Backup restore process is very slow for large database

I have 5 node cluster of riak database. I have take backup of this database & trying to restore it with riak-admin. But it take too much much already 7days has passed & still restoration ...
1
vote
4answers
197 views

Random IP's constantly trying to connect to SQL Server

We are building a cloud-based application that relies on a login database as well as many individual client databases. Using rackspace we have setup a server (windows server 2012) with SQL Management ...
1
vote
1answer
15 views

Serverlocked Ip because of passing special characters to database

Hi My server blocked my ip and sent me the reason below, Kindly check the logs and above path with your developer and take necessary action to avoid this in future. Logs: ------ [Tue Jan ...
-1
votes
1answer
39 views

Scalable Cloud solution for High Availability [closed]

Scenario: I am about to launch a cloud software in a couple months. This will be a SaaS solution for multiple clients. The software deals with Healthcare o Encryption at rest is a requirement. It is ...
0
votes
2answers
295 views

MySQL - Slow query - wp_options table. Website unable to handle traffic

After spending several days researching, I have placed a website on a c1.medium instance, Amazon Linux, and the MySQL database on a db.m1.instance. The RDS is running MySQL version 5.6.13. I have ...
0
votes
1answer
82 views

WordPress - MySQL server has gone away

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB). The WordPress install includes many plugins - 50 active plugins. Most important to note is the WPML plugin to ...
0
votes
1answer
33 views

debian stable raid autogrow filesystem database

I need to setup a debian stable system meeting the following needs: Hard disks should be mirroring : Raid 1 Filesystem(s) should autogrow if possible (just in case we replace one hdd with a bigger ...
2
votes
2answers
94 views

SSH access for hundreds of thousands of users

I need to setup a solution similar to GitHub, where users can SSH to their git repository. This should scale for hundreds of thousands of users, so my idea is to use a distributed filesystem for the ...
0
votes
1answer
57 views

Is an ms-sql/excel connection two way?

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel? I have a user (the DBA, funny ...
0
votes
1answer
145 views

Is weblogic 10.3.6 data source connection pool maximum capacity per domain or server?

My WLS server is connecting to an Oracle DB that has a maximum concurrent connection limit of 3. I have created a data source in WebLogic and set the "Maximum Capacity" value to 3. Is this value ...
0
votes
3answers
78 views

Amazon Linux EC2 Webserver / MYSQL Upgrade – Traffic causing error establishing a database connection

To give you a little background, I currently have a website that allows users to upload photos. The website was initially on a GoDaddy shared server, but recent surges in traffic have forced me to ...
1
vote
0answers
48 views

Tell proftp to allow connections only to the users that have permissions in PostgreSQL

I'm trying to set up an ftp server for the first time (under Debian Squeeze) and after searching through Google, I decided to use proftp. NOTE: I have a PostgreSQL server running in the same machine ...
1
vote
2answers
98 views

mysql fails every day at the same time and when many requests occurs

I am some problems with my mysql database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems. The first: Every day ...
1
vote
2answers
125 views

Indepedent pairs of RAID 1 is superior to RAID 10

I am rather new to databases. I was reading up on RAID Storage and it seems that the consensus is that RAID 10 is RAID 10 is best is terms of performance and redundancy However at the end ...
-1
votes
1answer
35 views

CISCO router GUI management

Is there any simple solution to connect to routers database with GUI? I mean is it even possible to find an application which could do the configuration without the need to push commands? Thank you ...
5
votes
4answers
407 views

Is MySQL required on both the database server and the webserver? why?

Is MySQL required on both the MySQL database server and the web server that it is connecting to? If it is required on both the web server and database server, please explain why this is. Moreover, if ...
1
vote
1answer
90 views

Choosing the right database/storage engine for iptables ulogd

I'm looking for some help choosing a database backend for a iptables ulogd setup. We are going to swap out our current proprietary firewall solution with iptables and one of the requirements is to ...
1
vote
1answer
126 views

How do I change the config_file location of a postgresql database for “service postgresql start”?

I had a PostgreSQL 9.1 db that I just upgraded to 9.3 using /usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.3/bin -d /var/lib/postgresql/9.1/main/ -D ...
2
votes
0answers
32 views

Alternatives to oracle flashback database/table functionality

Does anyone know of an open source tool or similar that covers the same functionality as the Oracle EE built-in flashback database and flashback table features? I'm considering going from Oracle EE ...
0
votes
1answer
58 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
324 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
48 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 ...
1
vote
0answers
27 views

Cannot split Access 2010 database, cannot export or import either. [closed]

I have an access db that I need to split. It was not created properly and there have been multiple users trying to access it unsuccessfully. I made a backup then went into access 2010 and tried to ...
0
votes
0answers
38 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
290 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
3k 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
64 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
60 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
53 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
769 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
72 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
97 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
51 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
30 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
71 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
124 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
49 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. ...