Hi all, We are currently evaluating how to perform full text search at the database level for C5 based API Manager. We will be evaluating this for different types of databases to find their implementation complexities and limitations. Other option available for us to use indexing based approach (use Solr)
*Database full text search * *Pros* - Less complications when using container based approach - Clustering will require only database syncing. - No need to maintain and ship external search engine. *Cons* - Implementation may vary significantly based on the database type - There can be limitation in full text search for particular database types (For ex: mysql full text support only prefix search) - Queries will differ based on database type - Document search will not be available, because they are stored as blobs *Indexing based approach * *Pros* - Document search - Search will be efficient (No need to access database) *Cons* - Since indexing data is written to file system , when going for container based approach we would require mechanisms to file system mounting - Syncing indexers in a cluster would require something similar to existing C4 based registry architecture (use of REG_LOG table) - Maintaining (for ex: Version updates) and shipping external search engine. Your valuable input regrading this is highly appreciated. Thanks! Rajith -- Rajith Roshan Software Engineer, WSO2 Inc. Mobile: +94-72-642-8350 <%2B94-71-554-8430>
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
