Questions tagged [rdbms]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
65 views

Fio disk test which block size to chose for mysql?

If my fs use 4k block size, mysql use 16k page size. But which block size to choose for fio test?
-1
votes
1answer
50 views

Could facebook minimize the number of servers if they used a faster database rather than MySQL? [closed]

Facebook needs 30,000 Servers to run. Seriously that's a lot! Facebook is old. It uses MySQL. I was wondering if they started with a much faster and efficient database, my question: 1. What database ...
1
vote
0answers
295 views

After some minutes oracle database is down, but listener still active

I installed Oracle 12c R2 on my fedora 24 server. Before its updates and the last upgrade to fedora 26 it was running ok, but then neither the listener nor the database can be bringed up. After some ...
1
vote
1answer
470 views

Simulate power loss with force unmount?

I want to test disaster recovery of RDBMs after power loss under high load. My idea is to mount data directory under new mountpoint and then execute umount -f during the load and investigate outcome /...
-1
votes
2answers
80 views

How can I handle heavy Database interaction at peak hours? [duplicate]

We run an application more like competition organizing websites like HackerEarth.com, HackerRank.com. When the tasks start, we see huge load on our server. The problem is, we need to interact with ...
0
votes
1answer
62 views

Oracle application and DB scale out in private cloud

I have a client who was looking to migrate their Oracle environment to Amazon - probably Amazon RDS but were unable to get the SLA they wanted from it. I need to know if deploying something to ...
-1
votes
1answer
169 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" ...
1
vote
1answer
65 views

Is there a “rigorous” method for choosing a database? [closed]

I'm not experienced with NoSQL, but one person on my team is calling for its use. I believe our data and its usage isn't optimal for a NoSQL implementation. However, my understanding is based off ...
1
vote
3answers
104 views

where can I find the database file and table files?

I installed MySql using : yum install mysql-server It is working fine from the terminal.I created a database named music and created some tables inside this database . Now I want to port the entire ...
1
vote
1answer
2k views

starting MySql on fedora

To install MySql I tried this after downloading the rpm package from the official website : yum install MySQL-server-5.5.27-1.linux2.6.i386.rpm Everything went fine and process was completed but now ...
2
votes
1answer
1k views

What exactly is “pinning” in relation to indexes? [closed]

When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions. It is part of a test question, where ...
1
vote
4answers
3k views

RDBMS: Is it possible to scale out a RDB?

Is it possible to scale out a RDB ? If it's possible, how can one achieve it? I'm asking this question because I assisted to a NoSQL event in which the speaker told many times that the one of the ...
1
vote
1answer
86 views

clustering MS SQL 2008 [duplicate]

Possible Duplicate: Sql server active/passive vs active/active clustering I have a Project in DBMS just I need something like a BIG TITLES of What TO DO. Here a brief way about the Project: ...
3
votes
2answers
561 views

When - if at all - should I switch from MySQL to MariaDB?

Now that MySQL is owned by Oracle, the future of the RDBMS seems uncertain. The fork by the main developer of MySQL, Monty Widenius, called MariaDB, is a drop-in replacement for MySQL. Version numbers ...
0
votes
1answer
216 views

What does the management system in RDBMS mean?

When I hear someone mention any particular RDBMS, they generally refer to it as a database. What is intended by the term "management system"?
2
votes
1answer
265 views

Shadowing MySQL and PostgreSQL to each other

I have a project currently based on PostgreSQL 8.1. However, some of the data processing for it needs to happen on a server for which 7.4 is the latest version (for now, only official packages via yum ...
1
vote
3answers
2k views

can sybase replication be used to synchronize sybase and mysql databases?

I see that mysql replication can synchronize from sybase, but can sybase replication server write to and read from sybase? I'm trying to figure out a migration path of a big old legacy sybase system ...
0
votes
1answer
469 views

How to migrate from Oracle RDB for OpenVMS to MySQL in Windows?

I have a legacy Alpha server with a RDBMS database. This db is replicated in a MySQL db with many bad php scripts that drops all the tables and takes everything from the Alpha. This works very slow ...
5
votes
2answers
2k views

What is Data Scrubbing in the context of database?

Even after reading on Data Scrubbing on Wikipedia, I am still not clear on what Data Scrubbing really is when the term is used for database. Is it a formal engineering principal that there is a pre-...