I am a newbie to mongodb.I have set an mongodb architecture with a single mongo shard(mongos) connected to three shards(replica sets) with three config servers. The architecture looks as below:
Now ...

Coming from this topic on SO a user suggest me to enable implicit casts in my PostgreSQL and I don't know how to do that. I also don't know if this is a good practice or if it's the solution to the ...

I am creating a physical standby database for which I am creating a standby control file using command = ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oracle/dbs/stbycf.ctl';
but It creates only one ...

My company is developing an internal application with a SQL server database which was started earlier by another developer.
Now I am Looking at the model,the developer has stopped at 1NF. I proposed ...

I have a question that has been bugging me, but I just don't know how to validate it. We run DB2 LUW on AIX in our shop. Our AIX is currently at 7.1. Our DB2 is at 9.7 FP 4 for most installations and ...

For automation, I have to dynamically construct the restore commands and thus I have created a script. A .bak file is created on a remote server and I receive it daily. The script builds the restore ...

Operating system used is linux. I have tried Navicat and SQL Power Architect. They did display relations between tables in the same schema. I have some foreign key constraints which reference tables ...

I have a MySQL 5.6.21 slave and a MySQL 5.1.73 slave that are both replicating from the same MySQL 5.1.73 master.
I noticed that for several of the tables ( I said several because when I try to rerun ...

Does Seconds_Behind_Master always show the correct number of seconds the slave is behind the master?
I have also Implemented the mk-heartbeat replication monitoring.
It was showing the other result ...

I have two SQL server 2012 instances and I want to configure mirroring between the 2 servers with database.
My questions are:
How can it automatically change host of one if the other one was dropped ...

I have some Production servers whose ibdata files increases in size day by day.
It has already consumed 290GB of space.
The tables in the servers are mostly InnoDB and there are high read and write ...

I have 20 MySQL databases and in each there are about 20 tables. All the data is saved in a file called ibData1. Now I discovered about the file per table mode but if I change the value in the my.ini ...

I found out that my MySQL server is configured with only 128MB for innodb_buffer_pool_size. That is not enough considering that I have a 8GB RAM server. It hosts MySQL server and an Apache/Catalina ...

I have MySQL and Nagios installed Linux PC (Centos5.5)
I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table)
The data fetching working properly (confirmed ...

I'm experimenting with the proxy user feature of oracle.
My sample: user_a has only object privileges and user_b has only system privileges. user_b is allowed to log in as user_a. So DDL and DML are ...

I tried creating availability group (AOH) many times but no luck , It got failed every time. Please help me on this case.
I configured Windows cluster (Name as 'WINCLUSTER') with two nodes. They are
...

Hi i am facing a problem while shipping my database log
I have three database server dev, beta and master
and i maintain log files for dev on github
and every log file has a version given to it like ...

I know this is a newbie question, but really I can't find some precise info on this issue.
I'm trying to figure out how to create a new user with admin server role on SQL Server 2012 x64.
I mean, I ...

The database is almost of size 55GB. This database should have never grown to this size as some of the maintenance jobs were not running.
I have deleted almost 30GB of data. Now the database size is ...