Search, Persistance Manager in AEM/CQ

Search:

There are two supported query languages in AEM

• SQL2
• XPATH

Accessing query browser

Tools>Query open query browser

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

To read on integrating CQ with Solr search, visit blog: Integrating AEM/ CQ with Solr search

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 file system in form of tar file at 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 provide online & offline backups.

Online: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.

Read More: 
Solr and AEM
JSON for Solr
AEM INTERNALIZATION
Search Persistance
Navigation in AEM
Website design steps in AEM