47 lines
1.3 KiB
Bash
47 lines
1.3 KiB
Bash
#!/bin/bash
|
|
MYSQL_HOST=ENV_MYSQLHOST
|
|
MYSQL_USER=ENV_MYSQLUSER
|
|
MYSQL_PASS=ENV_MYSQLPASS
|
|
PATH_LOG=/var/lib/sphinxsearch/log
|
|
PATH_BIN=/usr/bin
|
|
PATH_SQL=$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )/sql
|
|
|
|
# Indexation déjà lancé
|
|
FILEINDEX=$PATH_LOG/ciblage-$(date '+%Y%m%d').idx
|
|
if [ -f "$FILEINDEX" ]; then
|
|
exit 0
|
|
fi
|
|
|
|
# Indexation sur le master ?
|
|
output=$(mysql -h$MYSQL_HOST -u$MYSQL_USER -p$MYSQL_PASS sdv1 < $PATH_SQL/slave-ciblage.sql)
|
|
idx='';
|
|
for line in "$output"; do
|
|
idx="$line";
|
|
done
|
|
# Suppression fin de ligne
|
|
idx=$(echo $idx|sed -e "s/^[idx ]*//g"||sed -e "s/[ ]*$//g")
|
|
|
|
# Lancement de l'indexation
|
|
if [ -n "$idx" ]; then
|
|
if [[ "$idx" > 0 ]]; then
|
|
|
|
echo "$(date '+%Y-%m-%d %H:%M:%S') === INDEXATION CIBLAGE" >> $PATH_LOG/indexer.log
|
|
|
|
# Create file to indicate indexing on slave
|
|
rm -v $PATH_LOG/ciblage-*.idx
|
|
echo "START $(date '+%Y-%m-%d %H:%M:%S')" >> $FILEINDEX
|
|
|
|
# Sphinx rotate
|
|
echo "$(date '+%Y-%m-%d %H:%M:%S') - Sphinx - Debut" >> $PATH_LOG/indexer.log
|
|
$PATH_BIN/indexer --config /etc/sphinxsearch/sphinx.conf --rotate ciblage >> $PATH_LOG/indexer.log
|
|
echo "$(date '+%Y-%m-%d %H:%M:%S') - Sphinx - Fin" >> $PATH_LOG/indexer.log
|
|
|
|
echo "FIN $(date '+%Y-%m-%d %H:%M:%S')" >> $FILEINDEX
|
|
|
|
echo "$(date '+%Y-%m-%d %H:%M:%S') === FIN INDEXATION CIBLAGE" >> $PATH_LOG/indexer.log
|
|
|
|
fi
|
|
fi
|
|
|
|
|