On Wednesday, 19 May 2010 22:02:57 DT Piotr Wadas wrote:
Hello,
Does it make any sens to enable indexing of any attribute on read-only slave syncrepl replica?
Whether or not indexes make sense is not dependant on whether the LDAP service is a provider or consumer or not, but dependent on what searches the LDAP service serves.
For example, if a provider only provides writes and changes to consumers, but no searches from clients, it only makes sense to index attributes required for replication. If a consumer is run purely for making offline backups of the master (e.g. by slapcat), and serves no searches, it may also make sense to index only replication attributes.
I mean, isn't it just waste of resources, or, actually, is not a waste a resources at all, since replica is read-only and does not write anything anyway?
While a replica doesn't accept any changes from clients, it will write just as much as it's provider does on the same dataset, or it isn't doing a good job of replicating.
Typically, one normally configures the environment to direct read operations to slaves, so typically they have a higher read/write ratio, and it makes sense to have more indexes on slaves (the additional write IO for maintaining indexes is justified).
Regards, Buchan