TheLogick Posted June 17, 2007 Share Posted June 17, 2007 Hi, I have a website but its hosted on a PC, its all very good but sometimes its very slow and down is there a way of making a script when I click a button it will send all the files over by FTP to the backup server, also could I get it to send over the mysql database? If I could do a thing like this or something similair it would be great. I would then have a problem with the domain because it the dns server takes 24hours to update so what setting could I how could I overcome this? Thanks Quote Link to comment Share on other sites More sharing options...
the_oliver Posted June 25, 2007 Share Posted June 25, 2007 Are both the servers inside the same network? Relly the only soltion to the domain problem would be to have a router with a static ip, redirecting requests. Some what complex and expencive. As for the MySQL you could have a scrip that would dump the current database to a file, FTP it to the other server, and a schedualed task on the other server that checks for new files, and restorse them to its database when they appear. Same for the webfiles. Your probably looking at some form of .vbs script, although i cant be sure. If they are in the same network the best option would be some kind of cluster, but again, advanced expencive and complex! What ever route you chose its not going to be easy! Quote Link to comment Share on other sites More sharing options...
steviewdr Posted June 25, 2007 Share Posted June 25, 2007 You need to look into MySQL replication, where you have a master and a slave MySQL database server. DNS does not take 24 hours. If a client cache's a DNS record, then it may take up to 24 hours to take effect. Once you change DNS records, the effect for new clients is instant. I suggest you choose the pc/server which is up the most and set it up to be reliable. -steve Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.