Questions tagged [rdbms]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
28 views

Debate about server shutdown (RDBMS) [closed]

For some time now, I have been fighting against CIOs who are imposing increasingly frequent shutdowns of database servers under the pretext of security. I nevertheless think that these regular ...
SQLpro's user avatar
  • 121
1 vote
1 answer
62 views

Benefits of separate RDBMS server

I'd like to compare the benefits of two hosting architectures for a small server (meaning a 2-core CPU and 250GB SSD, with 100GB dedicated for data, is more than enough), consisting mostly of a custom ...
fgrieu's user avatar
  • 432
2 votes
1 answer
1k 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?
ogbofjnr's user avatar
  • 183
0 votes
1 answer
61 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 ...
user1034912's user avatar
  • 1,364
1 vote
0 answers
537 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 ...
FoxEdu's user avatar
  • 25
2 votes
1 answer
796 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 /...
noonex's user avatar
  • 248
-1 votes
2 answers
148 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 ...
theGamblerRises's user avatar
0 votes
1 answer
65 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 ...
user181929's user avatar
-1 votes
1 answer
210 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" ...
O_O's user avatar
  • 645
1 vote
1 answer
70 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 ...
vowel-house-might's user avatar
1 vote
3 answers
254 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 ...
Suhail Gupta's user avatar
1 vote
1 answer
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 ...
Suhail Gupta's user avatar
2 votes
1 answer
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 ...
Database User's user avatar
3 votes
4 answers
4k 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 ...
Michael's user avatar
  • 133
1 vote
1 answer
90 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: ...
Ibrahim's user avatar
  • 11
3 votes
2 answers
574 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 ...
polemon's user avatar
  • 595
0 votes
1 answer
219 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"?
Tim McNamara's user avatar
2 votes
1 answer
291 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 ...
warren's user avatar
  • 18.7k
1 vote
3 answers
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 ...
Stu's user avatar
  • 2,218
0 votes
1 answer
495 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 ...
polyphony's user avatar
5 votes
2 answers
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-...
dance2die's user avatar
  • 2,031