Re: MySQL redundancy/backup

2001-12-10 Thread Benjamin Pflugmann
Hi. You can use the built-in replication feature to sync a MySQL instance on the web server (slave) with the database server (master). Then you always have a recent snapshot of the database. You can also use the database on the slave to make your backups. Temporarily halt replication, make your

MySQL redundancy/backup

2001-12-10 Thread Igal Rubinstein
Hello, I would like to hear your opinions, recommendations, ideas, etc., about the following subjects: I have two servers. Both of them have MySQL, PHP, Apache. The first server is used as SQL server and the second server is used as Web sever. The problem is that it is "mission critical" and ver