This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:servers [2011/03/14 19:38] els |
integration:rdbms:servers [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| [[integration:rdbms:queries|Queries]] | | [[integration:rdbms:queries|Queries]] | | ||
| [[integration:rdbms:updates|Updates]] | | [[integration:rdbms:updates|Updates]] | | ||
| - | [[integration:rdbms:creation|Generating Data Files]] | | + | [[integration:rdbms:integration|Integration Guides]] |
| - | [[integration:rdbms:implementation|Implementation Guides]] | + | |
| Line 17: | Line 16: | ||
| ==== Servers ==== | ==== Servers ==== | ||
| - | Omnidex benefits from being on a separate server from the relational database, although there is no requirement to do so. Relational databases usually adopt a strategy that consumes most of the resources on a server. It is not uncommon for a relational database to consume nearly all of the memory and CPU while processing large quantities of data using multiple threads. While this maximizes the performance of the relational database, it does not preserve many resources for other processes such as Omnidex. | + | Omnidex benefits from being on a separate server from the relational database whenever possible. Relational databases tend to use strategies that consume most of the resources on a server. It is not uncommon for a relational database to consume nearly all of the memory and CPU while processing large quantities of data using multiple threads. While this maximizes the performance of the relational database, it does not preserve many resources for other processes such as Omnidex. |
| - | Typically, Omnidex is places on an Omnidex Server and the relational database is placed on a Relational Database Server. This allows Omnidex to utilize the system resources of the Omnidex Server in the manner it needs, while also allowing the relational database to do the same. | + | Typically, Omnidex is placed on an Omnidex Server and the relational database is placed on a Relational Database Server. This allows each to utilize system resources as they need without interference from the other. |
| - | {{:integration:rdbms:server_architecture.png|}} | + | Applications can be written to direct all query traffic to Omnidex, or the application can split the traffic between Omnidex and the relational database. Applications that direct all query traffic to Omnidex simply switch the connections from the relational database to Omnidex. Applications that will split the traffic maintain concurrent connections to Omnidex and the relational database. |
| + | {{:integration:rdbms:rdbms_server_architecture.png|}} | ||
| + | Most companies rely on a Storage Area Network (SAN) for accessing their data. Omnidex indexes will usually reside on the SAN as well, though this is not a requirement. High-quality SANs provide great flexibility and excellent performance, though it is important to insure sufficient cache in the SAN as well as a sufficient number of paths to the servers. | ||
| ===== ===== | ===== ===== | ||