What are the points to be taken care of when designing a database on Linux?

351965 pts.
Tags:
Database design
Database replication
Linux databases
What are the points to be taken care of when designing a database on Linux? What are the different replication methods available?

Answer Wiki

Thanks. We'll let you know when a new response is added.

The same as designing a database on any other platform.

On the hardware side make sure that you have enough RAM and CPU power. Make sure that you have enough disk space, and that the storage is fast enough. Make sure you have a way to back everything up.

Within the database, use the correct data types, and the correct recovery model and database engine for the project. A properly designed relational model is key to maintaining good performance as the database grows.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    As for the replication methods, it will depend on the database you choose.
    70,200 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following