Herci
asked on
High performance Database
Hi,
I am looking to build a cloud system that would have a central Database system, that would store the core client data and then feed this data to various external applications. External applications will also be updating the centralised database. The external applications can be PHP websites, mobile applications, back office systems, ect..
The centralised DB must to be able to handle high volumes of data and therefore must be a high performace DB.
I want to know what are the best high performance opensource database system out there that I can use for my central DB. I know there is MySQL, PostgreSQL, Firebird but I don't know if they are powerful enough. I've read that Amazon Relational Database service is pretty fast too. Can someone please enlighten me on what is the best out of these? or if there is any other DBs that would be better for this kind of job? for Also, would it be best to use a Relational DB or NoSQL DB?
Thanks.
I am looking to build a cloud system that would have a central Database system, that would store the core client data and then feed this data to various external applications. External applications will also be updating the centralised database. The external applications can be PHP websites, mobile applications, back office systems, ect..
The centralised DB must to be able to handle high volumes of data and therefore must be a high performace DB.
I want to know what are the best high performance opensource database system out there that I can use for my central DB. I know there is MySQL, PostgreSQL, Firebird but I don't know if they are powerful enough. I've read that Amazon Relational Database service is pretty fast too. Can someone please enlighten me on what is the best out of these? or if there is any other DBs that would be better for this kind of job? for Also, would it be best to use a Relational DB or NoSQL DB?
Thanks.
greetings Herci , , I do not see any relevance for this Database Question to the "PHP" language.
Seems to me that your question may need more business specifics for any "Database Performance" considerations.
I am NOT a database administrator, but I have been around some discusions about "Database Slowdowns" and server upgrades to get faster DB returns . You can add stacks of server motherboards and processors to handle the DB load, you can use "Multiple instances" or "Multiple schemas" or "Database Mirroring" (and other database setups) for a database performance increases, These all seem to have some positives and negatives to consider as to the type of server DB loads you need to handle. I hope that there's a EE expert in a "database administrator" attitude that can shed some light on this, but you may need to get some experienced pay-for consulting in database administration for this type of professional business considerations. I would think this is a consideration for many "Give and Take" factors in DB server set-up, as if you increase one performance factor, then another performance factor slows down. Although there are considerations for the DB brand (oracle, PostgreSQL, etc.), none of these can do hi loads on crapy hardware setups.
Seems to me that your question may need more business specifics for any "Database Performance" considerations.
I am NOT a database administrator, but I have been around some discusions about "Database Slowdowns" and server upgrades to get faster DB returns . You can add stacks of server motherboards and processors to handle the DB load, you can use "Multiple instances" or "Multiple schemas" or "Database Mirroring" (and other database setups) for a database performance increases, These all seem to have some positives and negatives to consider as to the type of server DB loads you need to handle. I hope that there's a EE expert in a "database administrator" attitude that can shed some light on this, but you may need to get some experienced pay-for consulting in database administration for this type of professional business considerations. I would think this is a consideration for many "Give and Take" factors in DB server set-up, as if you increase one performance factor, then another performance factor slows down. Although there are considerations for the DB brand (oracle, PostgreSQL, etc.), none of these can do hi loads on crapy hardware setups.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think that unless all the applications are using the same data, there is no point in a centralized database system like that. If there are different applications with different data sets, distributing the databases across the many servers where the applications are running will keep the speed up for all of them.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys for all your comments..they are going to be very useful. Sorry about the delay in posting my comment.
Regards.
Regards.
ASKER
Thanks guys for all your comments..they are going to be very useful. Sorry about the delay in posting my comment.
Regards.
Regards.
Any DB will perform well if you use good table design and appropriate indexing. MySQL is soon to be deprecated by PHP so you might want to consider MySQLi instead. PostGreSQL is a lot like MySQL, but with relatively lame support tools (compare phpMyAdmin and phpPGAdmin).
When you hire your DBA she will want to see transaction arrival rates, logic diagrams, etc. Might as well start building that body of information now. The more specific you can be as you ask the questions, the better your answers will be. A set of CREATE TABLE statements would be helpful.