|
Web Hosting, web serveri i operativni sistemi Komercijalni hosting, web serveri, bezbednost, operativni sistemi na serverima |
|
Alati teme | Način prikaza |
07. 01. 2009. | #11 |
Ivan Dilber
Sir Write-a-Lot
|
mysql replikacija je cudo jedno.. i onda samo u cron-u mysqldump na lokalni disk, na obe masine i nema problema, sanse da na dva razlicita servera crknu diskovi istovremeno su minimalne..
__________________
Leadership is the art of getting people to want to do what you know must be done. Poslednja izmena od ivanhoe : 07. 01. 2009. u 07:02. |
08. 01. 2009. | #12 |
Milan Cvejic
Wrote a book
|
Ali ako su serveri u istoj prostoriji moze da se desi da crknu oba istovremeno... (pozar, poplava...)
__________________
http://weevify.com |
08. 01. 2009. | #13 |
Ivan Dilber
Sir Write-a-Lot
|
slazem se, ali u mom slucaju su razlicite hosting firme (jedan server moj, drugi od ortaka), pa je mala sansa... sem ako kometa udari u Ameriku
__________________
Leadership is the art of getting people to want to do what you know must be done. |
14. 01. 2009. | #14 |
133t
Master
|
danas sam sredjivao ovo..
radi backup u lokalu i rsync celog backup dir-a sa remote serverom zgodno, ako treba nesto dodatno da se bekapuje vezano za mysql, samo ga ubacim u taj dir i sledeci put kad ga cron pokrene to se bekapuje na remote server... backup_mysql.sh Kôd:
#!/bin/bash ##################################### ### MySQL Configuration Variables ### ##################################### # MySQL Hostname DBHOST='localhost' # MySQL Username DBUSER='kodi ' # MySQL Password DBPASSWD='shatromojpass' # Local Directory for Dump Files LOCALDIR='/development/backup/_mysql_/' # Remote Directory for Offsite Backup REMOTEUSER='backup' REMOTEHOST='linux-backup' #this linux-backup is defined in /etc/hosts REMOTEDIR='/home/backup/powerMacBackup' # Prefix for offsite .tar file backup TARPREFIX='powerMacLocal' ##################################### ### Edit Below If Necessary ######### ##################################### cd $LOCALDIR SUFFIX=`eval date +%y%m%d` DBS=`/Applications/xampp/xamppfiles/bin/mysql -u$DBUSER -p$DBPASSWD -h$DBHOST -e"show databases"` for DATABASE in $DBS do if [ $DATABASE != "Database" ] then FILENAME=$SUFFIX-$DATABASE.gz /Applications/xampp/xamppfiles/bin/mysqldump -u$DBUSER -p$DBPASSWD -h$DBHOST $DATABASE | gzip --best > $LOCALDIR$FILENAME fi done #TAR FILES INTO ONE FILE tar -cf $TARPREFIX-$SUFFIX.tar $SUFFIX-*.gz chmod 400 $LOCALDIR*.tar rm *.gz #RSYNC TO REMOTE BACKUP SERVER # (set up ssh to auth using public keys first) rsync -avz -e ssh --progress $LOCALDIR $REMOTEUSER@$REMOTEHOST:$REMOTEDIR edit: zasto je code box ovako uzak? |
|
|
Slične teme | ||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Kako saznati koji firefox tab koristi puno resursa i blokira citav FF? | misk0 | Web aplikacije, web servisi i software | 4 | 03. 08. 2009. 01:30 |
cookies radi/ne radi | Marko_ | Sva početnička pitanja | 6 | 18. 10. 2007. 21:30 |
Backup | dark_mark | Opušteno | 3 | 12. 01. 2007. 09:42 |
Backup Backup Backup | boleq | Programiranje | 7 | 15. 10. 2006. 13:30 |
Malo parsuje HTML malo ne. | Dzordz | Programiranje | 2 | 21. 05. 2006. 22:22 |