Subversion Repositories SmartDukaan

Rev

Rev 13515 | Rev 14467 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13515 Rev 14138
Line 61... Line 61...
61
cd ${PRGDIR}
61
cd ${PRGDIR}
62
 
62
 
63
 
63
 
64
mysqldump -uroot -pshop2020 catalog --tables similaritems source sourceitempricing category voucheritemmapping freebieitem entitytag amazonlisted storepricing brandinfo privatedeals iteminsurermapping > ${MYSQL_DUMP}
64
mysqldump -uroot -pshop2020 catalog --tables similaritems source sourceitempricing category voucheritemmapping freebieitem entitytag amazonlisted storepricing brandinfo privatedeals iteminsurermapping > ${MYSQL_DUMP}
65
 
65
 
66
if [ -z "$a1" -o "$a1" = "NULL" ]
-
 
67
then
-
 
68
	echo "a1 is empty"
-
 
69
else
-
 
70
	echo "All items - $a1"
-
 
71
	mysqldump -uroot -pshop2020 catalog item --replace --no-create-info --where="id in ($a1)" >> ${MYSQL_DUMP}
-
 
72
	if [ "$1" == "PROD" ]
-
 
73
	then
-
 
74
		mysql -uroot -pshop2020 catalog -e "truncate tmpitem;insert into tmpitem SELECT * FROM item"
-
 
75
	else
-
 
76
		mysql -uroot -pshop2020 catalog -e "delete from tmpitem where id not in ($a1);insert ignore into tmpitem SELECT * FROM item"
-
 
77
	fi
-
 
78
fi
-
 
79
 
66
 
80
 
67
 
81
 
68
 
82
#get dump for siteContent
69
#get dump for siteContent
83
mongodump -d CONTENT -c siteContent
70
mongodump -d CONTENT -c siteContent
Line 92... Line 79...
92
echo "Rsyncing generated content to staging and production servers"
79
echo "Rsyncing generated content to staging and production servers"
93
echo "======================================================="
80
echo "======================================================="
94
#Update media content on staging, store and production
81
#Update media content on staging, store and production
95
cd /var/lib/tomcat6/webapps/export
82
cd /var/lib/tomcat6/webapps/export
96
rsync -az --delete media/ ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/media-offline
83
rsync -az --delete media/ ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/media-offline
97
cd /var/lib/tomcat6/webapps/export
84
#cd /var/lib/tomcat6/webapps/export
98
rsync -az --delete media/ ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/media-offline
85
#rsync -az --delete media/ ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/media-offline
99
cd /var/lib/tomcat6/webapps/export/media
86
cd /var/lib/tomcat6/webapps/export/media
100
for PROD_SERVER in ${PROD_SERVERS}
87
for PROD_SERVER in ${PROD_SERVERS}
101
do
88
do
102
	echo "Server name  ${PROD_SERVER}" 
89
	echo "Server name  ${PROD_SERVER}" 
103
	rsync -az --delete website ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/media-offline
90
	rsync -az --delete website ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/media-offline
Line 112... Line 99...
112
cd /var/lib/tomcat6/webapps/export
99
cd /var/lib/tomcat6/webapps/export
113
 
100
 
114
rm -f javascripts.tgz
101
rm -f javascripts.tgz
115
mv javascripts javascripts-${DATE}; tar -zcf javascripts.tgz javascripts-${DATE}; mv javascripts-${DATE} javascripts
102
mv javascripts javascripts-${DATE}; tar -zcf javascripts.tgz javascripts-${DATE}; mv javascripts-${DATE} javascripts
116
scp javascripts.tgz ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/
103
scp javascripts.tgz ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/
117
scp javascripts.tgz ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/
104
#scp javascripts.tgz ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/
118
for PROD_SERVER in ${PROD_SERVERS}
105
for PROD_SERVER in ${PROD_SERVERS}
119
do
106
do
120
	echo "Server name  ${PROD_SERVER}"
107
	echo "Server name  ${PROD_SERVER}"
121
	scp javascripts.tgz ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/
108
	scp javascripts.tgz ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/
122
done
109
done
Line 126... Line 113...
126
	echo "Server name  ${STATIC_SERVER}"
113
	echo "Server name  ${STATIC_SERVER}"
127
	scp javascripts.tgz ${STATIC_SERVER}:/var/www/
114
	scp javascripts.tgz ${STATIC_SERVER}:/var/www/
128
done
115
done
129
echo "Server name  ${STAGING_SERVER}"
116
echo "Server name  ${STAGING_SERVER}"
130
rsync -az --delete documents/ ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/documents-offline
117
rsync -az --delete documents/ ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/documents-offline
131
echo "Server name  ${STORE_SERVER}"
118
#echo "Server name  ${STORE_SERVER}"
132
rsync -az --delete documents/ ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/documents-offline
119
#rsync -az --delete documents/ ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/documents-offline
133
 
120
 
134
for STATIC_SERVER in ${STATIC_SERVERS}
121
for STATIC_SERVER in ${STATIC_SERVERS}
135
do
122
do
136
	echo "Server name  ${STATIC_SERVER}"
123
	echo "Server name  ${STATIC_SERVER}"
137
	rsync -az --delete documents/ ${STATIC_SERVER}:/var/www/documents-offline
124
	rsync -az --delete documents/ ${STATIC_SERVER}:/var/www/documents-offline
Line 153... Line 140...
153
mv ${PROD_ENTITIES_EXPORT_PATH} entities-${DATE}
140
mv ${PROD_ENTITIES_EXPORT_PATH} entities-${DATE}
154
tar -zcf ${PROD_ENTITIES_EXPORT_PATH}.tgz entities-${DATE}
141
tar -zcf ${PROD_ENTITIES_EXPORT_PATH}.tgz entities-${DATE}
155
mv entities-${DATE} ${PROD_ENTITIES_EXPORT_PATH}
142
mv entities-${DATE} ${PROD_ENTITIES_EXPORT_PATH}
156
 
143
 
157
scp ${STAGING_ENTITIES_EXPORT_PATH}.tgz ${STAGING_SERVER}:${ENTITIES_DEST_PATH}
144
scp ${STAGING_ENTITIES_EXPORT_PATH}.tgz ${STAGING_SERVER}:${ENTITIES_DEST_PATH}
158
scp ${STORE_ENTITIES_EXPORT_PATH}.tgz ${STORE_SERVER}:${ENTITIES_DEST_PATH}
145
#scp ${STORE_ENTITIES_EXPORT_PATH}.tgz ${STORE_SERVER}:${ENTITIES_DEST_PATH}
159
for PROD_SERVER in ${PROD_SERVERS}
146
for PROD_SERVER in ${PROD_SERVERS}
160
do
147
do
161
	scp ${PROD_ENTITIES_EXPORT_PATH}.tgz ${PROD_SERVER}:${ENTITIES_DEST_PATH}
148
	scp ${PROD_ENTITIES_EXPORT_PATH}.tgz ${PROD_SERVER}:${ENTITIES_DEST_PATH}
162
done
149
done
163
 
150
 
164
#Update helpdocs on production and staging
151
#Update helpdocs on production and staging
165
cd /var/lib/tomcat6/webapps/export/html
152
cd /var/lib/tomcat6/webapps/export/html
166
rm -f helpdocs.tgz
153
rm -f helpdocs.tgz
167
mv helpdocs helpdocs-${DATE}; tar -zcf helpdocs.tgz helpdocs-${DATE}; mv helpdocs-${DATE} helpdocs
154
mv helpdocs helpdocs-${DATE}; tar -zcf helpdocs.tgz helpdocs-${DATE}; mv helpdocs-${DATE} helpdocs
168
scp helpdocs.tgz ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/
155
scp helpdocs.tgz ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/
169
scp helpdocs.tgz ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/
156
#scp helpdocs.tgz ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/
170
for PROD_SERVER in ${PROD_SERVERS}
157
for PROD_SERVER in ${PROD_SERVERS}
171
do
158
do
172
	scp helpdocs.tgz ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/
159
	scp helpdocs.tgz ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/
173
done
160
done
174
 
161
 
Line 201... Line 188...
201
#Update solr data on staging, store and production servers
188
#Update solr data on staging, store and production servers
202
cd /var/lib/tomcat6/webapps/export
189
cd /var/lib/tomcat6/webapps/export
203
rm -f solr.tgz
190
rm -f solr.tgz
204
mv solr solr-${DATE}; tar -zcf solr.tgz solr-${DATE}; mv solr-${DATE} solr
191
mv solr solr-${DATE}; tar -zcf solr.tgz solr-${DATE}; mv solr-${DATE} solr
205
scp solr.tgz ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/
192
scp solr.tgz ${STAGING_SERVER}:/var/lib/tomcat6/webapps/export/
206
scp solr.tgz ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/
193
#scp solr.tgz ${STORE_SERVER}:/var/lib/tomcat6/webapps/export/
207
for PROD_SERVER in ${PROD_SERVERS}
194
for PROD_SERVER in ${PROD_SERVERS}
208
do
195
do
209
	scp solr.tgz ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/
196
	scp solr.tgz ${PROD_SERVER}:/var/lib/tomcat6/webapps/export/
210
done
197
done
211
 
198
 
Line 216... Line 203...
216
do
203
do
217
	scp ${MYSQL_DUMP} ${PROD_SERVER}:/catalog-dumps
204
	scp ${MYSQL_DUMP} ${PROD_SERVER}:/catalog-dumps
218
done
205
done
219
 
206
 
220
ssh ${STAGING_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
207
ssh ${STAGING_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
221
ssh ${STORE_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
208
#ssh ${STORE_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
222
ssh ${SUPPORT_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
209
ssh ${SUPPORT_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp"
223
for PROD_SERVER in ${PROD_SERVERS}
210
for PROD_SERVER in ${PROD_SERVERS}
224
do
211
do
225
	ssh ${PROD_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp;echo ${a1}>/catalog-dumps/catalog.items"
212
	ssh ${PROD_SERVER} "echo ${DATE}>/catalog-dumps/latest.timestamp;echo ${a1}>/catalog-dumps/catalog.items"
226
done
213
done
Line 231... Line 218...
231
done
218
done
232
 
219
 
233
echo "Done copying content to staging and production servers"
220
echo "Done copying content to staging and production servers"
234
echo "======================================================="
221
echo "======================================================="
235
echo 0 > $PRGDIR/status
222
echo 0 > $PRGDIR/status
-
 
223
if [ -z "$a1" -o "$a1" = "NULL" ]
-
 
224
then
-
 
225
	echo "a1 is empty"
-
 
226
else
-
 
227
	if [ "$1" == "PROD" ]
-
 
228
	then
-
 
229
		mysql -uroot -pshop2020 catalog -e "truncate tmpitem;insert into tmpitem SELECT * FROM item"
-
 
230
	else
-
 
231
		mysql -uroot -pshop2020 catalog -e "delete from tmpitem where id not in ($a1);insert ignore into tmpitem SELECT * FROM item"
-
 
232
	fi
-
 
233
fi
236
234