System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

-1
votes
2answers
241 views

How can I synchronous two databases

I have two databases. First one is local and the other is at Internet, in my domain. I want to synchronous two databases. Is it possible to do so ? How can I synchronous two databases ? Some detailed ...
0
votes
1answer
33 views

Install mysql 5.5 without remove old version

I am using CentOS 5.7 (64-bit). By default mysql 5.0.88 version is installed in my machine. Now i wants to install mysql 5.5, without remove mysql 5.0.88. I didn't get any clear document to install a ...
0
votes
1answer
788 views

cpanel account transfers failing: ERROR: Failed to dump one or more databases

Getting this error when transferring multiple accounts via whm transfer utility: ERROR: Failed to dump one or more databases I was told this by a cpanel tech Here is the specific error I'm seeing ...
0
votes
1answer
1k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
1
vote
1answer
2k views

Why can't I connect to my PostgreSQL database?

I'm trying to install tentd-admin. The install fails during this step: $ DATABASE_URL=postgres://localhost/tent_server bundle exec rake db:migrate I also tried this: $ ...
0
votes
1answer
48 views

missing data after attach mdb

Recently, one of my customers had a server crash. Unfortunately, the 3th party who was responsible for the backup had 'forgotten' to schedule a backup of the DB (I know, I should have noticed that). ...
0
votes
0answers
41 views

Need some information about using SQL-Express 2012 with an OLD databse software

I have a friend who has managed to go for many years running their company on an old piece of software that is no longer supported. The original software vendor is no longer in business and the one ...
0
votes
2answers
156 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one ...
0
votes
2answers
3k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
-4
votes
1answer
32 views

how to connect my server to internet [closed]

We have a project which very resource consuming in databse part and we found that database hosting which is satisfied our needs is lot money consuming. We want to built own server and connect our ...
0
votes
0answers
2k views

Reducing memory usage of MySQL

Conclusion: if you really want to use little memory out-of-the-box drop MySQL and use PostgreSQL: it has a ~30Mo memory footprint, i.e. more than 10x less than MySQL; the migration was quite easy be ...
0
votes
2answers
412 views

MariaDB set maximum database size to 1 GB

I'm using MariaDB on my hosting. I would like to limit database size to 1 GB. How to do this properly in /etc/my.cnf ?
1
vote
2answers
1k views

How to install Sphinx on CentOS 6 where the DB and App server are separate servers

First what is the best way to install Sphinx on a centOs server rpm -ivh http://sphinxsearch.com/downloads/accept.php?file=sphinx-2.0.6-1.rhel6.x86_64.rpm yum install sphinx didn't seem to work. ...
2
votes
2answers
4k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
0
votes
0answers
24 views

Storing and accessing common non-sql database live from the cloud?

Let's say the database is non-sql, something completely archaic like paradox or whatever. I have no power over it as I'm not the developer. However, I would really like to have the database live on a ...
1
vote
2answers
2k views

MySQL Table not repairing

Table info: Database name: user_motiva Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
4
votes
1answer
3k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
3answers
2k views

Cannot connect to mysql database remotely using jdbc

I am trying to connect to my database which is hosted on 000webhost. I am connecting from SmartFoxServer, and they allow database connections. All you have to do is change some of the settings in the ...
0
votes
2answers
116 views

Is looking up a filename in a directory of 20,000 items as efficient as looking up a row in a database? [closed]

I'm trying to decide between storing some XML data either under uniquely identified file paths on a Linux filesystem, or in text columns in a database table. All other things being equal, is access ...
0
votes
1answer
124 views

Do database triggers have performance impact on overall database functioning?

I have a trigger defined on a table, which for every insert, update or delete, will populate another table. Will this have any performance impact on the overall database functioning? Are there any ...
0
votes
1answer
271 views

Is the Ejabberd default DB suited for large cluster deployments? [closed]

Im setting up a cluster of Ejabberd nodes to to host 1M+ active connections. Is the internal Mnesia database on every cluster the best solution in terms of reliability and load balancing, or would ...
1
vote
2answers
2k views

Mailboxes moved and whitespace isn't increasing… aka logical mailbox space not being freed

I understand the difference between "logical" and "physical" free space and have a problem with whitespace not increasing (logical space, formerly event 1221 in Exchange 2003). Given that I have ...
3
votes
3answers
796 views

if I select more than 15 fields, I get catastrophic failure

Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it. When I do select * or select field1,field2,field3....field15 I am getting this error: Msg 7399, Level 16, State 1, ...
0
votes
1answer
459 views

Setup HA postgres database, failover concept

I want to setup a HA postgres database. I setup master and slave database with synchronous streaming replication on different physical servers. When there is an error in the replication, the slave db ...
-1
votes
1answer
234 views

MySQL Configuration on my.cnf [closed]

[mysqld] core-file default-storage-engine=MyISAM max_connections = 5000 max_user_connections = 5000 key_buffer = 1024MB myisam_sort_buffer_size = 512M join_buffer_size = 256M read_buffer_size = 256M ...
1
vote
2answers
61 views

How to control databases replicated by Mongo DB replica set

I have 2 databases in my mongo DB namespace, lets name them db1, db2 and db3 which are on the same dbpath. Is it possible to configure mongo db replica set in that way that db3 wont be replicated ...
0
votes
2answers
233 views

MySQL Database Problems - Growing too quick, Performance

I have some problems with my database setup: The MySQL Database is written to every few seconds and it grows in size very quickly. My disk space is limited though, so I have to work around that. ...
1
vote
0answers
431 views

SSD Performance under Oracle

I have serious performance issues with oracle running over ssd. I have two OCZ Vertex 3 MAX IOPS drives (firmware 2.15). It runs on a INTEL C600 SATA Chipset. Windows 2008 R2. So the issue is ...
0
votes
1answer
269 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
0
votes
2answers
164 views

Coverting MySQL SQL statements to SQL Server

I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation guide has instructions only on how to make ...
-2
votes
1answer
191 views

Database synchronization [closed]

What is the most efficient way to sync/mirror certain data from a large remote database with a local version? The scenario is, there is a central remote database on a hosted server, which will share ...
0
votes
1answer
79 views

Amazon SImpleDB Architecture for an user with a friends list

I am relatively new to database designing. I am currently using amazon SimpleDB to provide my application with information, so far its been relatively good and efficient until just now. Basically, I ...
1
vote
1answer
5k views

How can I convert an MS Access database (.mdb) file to a Sqlite database (.db) file? [closed]

Can anybody help me convert an MS Access (.mdb) file to an Sqlite database (.db) file? I need to convert all the tables and dump the data inside. Are there any tools available, or is there any API ...
0
votes
2answers
108 views

Get dedicated server for the websites and keep shared hosting for the database, good idea? [closed]

We're thinking about moving from a shared hosting to a dedicated server (a managed one, we don't want to manage/maintain it for now). I keep reading that it's best to have a server for the websites ...
0
votes
1answer
130 views

Recovering InnoDB

Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
0
votes
1answer
60 views

Getting exposure to big data without having to set up the environment [closed]

Is anyone aware of any sandbox where an environment is already set up for big data processing? It can be hadoop, cassandra, pig etc... I'm a sql server programmer, and trying to get into big ...
1
vote
2answers
2k views

Connecting to oracle database instance running on VM(Guest Computer) from remote computer

I have oracle database instance up and running on vmware player on Redhat linux(Guest OS). This virtual machine is running on on windows 7 computer(Host OS). I am able to connect to the database ...
0
votes
2answers
141 views

Redundant Database [closed]

This has been killing me for weeks - I'm finally breaking down and asking for advice. I'm currently in the process of setting up database servers for a startup web application. The application ...
1
vote
2answers
330 views

Nothing Can Access MySQL

I have been trying to install WordPress, but I get the error, "Error establishing a database connection". I realize this is a common error, but after a few hours, I haven't found any solutions that ...
-1
votes
3answers
758 views

Redirect MySQL queries to another server [closed]

In order to lower system usage I'm planning to use another server to store my databases. so how can I redirect MySQL queries to another server or make MySQL to store databases on another server?
2
votes
1answer
595 views

Should a connection pooler be run on my database server or my app server?

I'm getting ready to start using PGBouncer, but I'm unsure of whether it should be used on my database server or on the app servers. If it's on the app servers, there will necessarily be multiple ...
-1
votes
1answer
179 views

ZFS System on Production [closed]

Do you know/have any system which works on ZFS such as RDMS? If yes, what is your setup? FreeBSD, ZFS on Linux etc.
0
votes
1answer
40 views

Database server [duplicate]

Possible Duplicate: Can you help me with my capacity planning? I am going to make an Internet project. The sizes of it I don't know now. But I want to ask some questions. : 1. What database ...
5
votes
1answer
617 views

Removed Old Domain Trust. Now Progress (9.1D) can't open DB File

My company has an old server, running Progress 9.1D on a Windows 2000 VM, which was used by our company OS (Vantage 6 by Epicor.) Vantage was our primary OS for a very long time. About 2 years ago, we ...
6
votes
4answers
2k views

PostgreSQL scaling up to 64 cores?

In this Computer World article, it specifies that PostgreSQL can scale up to a core limit of 64. Does this mean for one multi-core processor of 64 cores? Or multiple processors with fewer cores? The ...
0
votes
2answers
56 views

Problems locating Redmine database

I have an active redmine but I can not find the database where it is running right now. It should be on PostgreSQL but the database where it should be running is empty. Does anybody have any idea how ...
0
votes
0answers
351 views

ORA-00942: table or view does not exist & ORA-01031: insufficient privileges

I can't access any tables on my oracle database. When selecting the table product I get ORA-00942: table or view does not exist I have tried this solution but I don't have sufficiënt rights to add a ...
-1
votes
1answer
87 views

Choosing a database management system to maximize availability and scalability [closed]

If I was planning on choosing a database management system and know that the data needs to be available as close to 100% as possible and that it needs to scale as well as possible, is there a "best" ...
0
votes
2answers
648 views

How to use read replica instance for websites? Amazon RDS MySQL

Amazon RDS FAQs stated that it is up my application to distribute traffic to the read replica. My websites have mostly visitors - non-logged in users. So, I suppose most database activities are ...
1
vote
0answers
319 views

Corrupt mysql system tables

I am having issues with the columns_priv table in the mysql system database. I cannot add new users currently. I have tried repairing it using mysqlcheck --auto-repair --all-databases --password but ...