Overview on Search, Persistence Manager in AEM/Adobe CQ5

Search, Persistence Manager in AEM/CQ

Search:
There are two supported query languages in AEM
· SQL2
· XPATH
Accessing query browser
Tools>Query open query browser


Reference: http://helpx.adobe.com/experience-manager/using/querying-experience-manager-data-using1.html

Persistence manager:
Persistence manager helps to save the repository content to a permanent storage solution, such as the file system or a database.
All content is stored in a file system in the form of a tar file at the below location.

Location of persistence manager
AEM/CQ install directory-> Author->crx-quickstart->repository->workspaces->crx.default->data_00000.tar

Configuring/modifying the persistence manager location/type default tar is <PersistenceManager class="com.day.crx.persistence.tar.TarPersistenceManager"/>
AEM/CQ install directory-> Author->crx-quickstart->repository->repository.xml
MySQL Persistence Manager: Stores the workspace content in a MySQL database.

Configuration:
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost:3306/crx"/>
<param name="user" value="userid"/>
<param name="password" value="password"/>
</PersistenceManager>

Backups & restore CQ files
AEM provides online & offline backups.
Online: The online method creates a backup of the entire repository, including CQ5. We can perform this method while the repository is in use.
Offline: Creates a backup of the CRX repository files including all of the information stored in CRX, so you can restore the exact state of the repository during backup.
Also incremental so it updates only next day components to backup.