Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql server?or create a small php script to do this? The reason is because, we all know that database is very improtant if we have dynamic website. I have my forum hosted and i want to automatically mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid that i forgot to backup my database..also i have one central backup database. Thanks for the help..Im looking forward for this posibility.

Reply

Hi sirknight,
    [/tab]MySQL in itself provides an excellent way of mirroring your databases - but for that you have to set up another server somewhere known as a Replication Server - usually the Master Server and the Replication Server exist on the same network, to enable faster updates.

[tab]Problem with this is, you Master Server has to be configured to recognize the Slave Replicator (you can specify this in the my.cnf file) and the Slave will also have to be trained to get updates from the master. The process is very simple and can be done in a short few steps.

    [/tab]If the setup is done in this format, the Master Server keeps generating some files called Binary Logs, that contain information about incremental changes to your databases. The Slave's run TWO threads - one which keeps fetching these Binary logs down to the Slave, and another thread, which acts upon the logs, figures out what changes have been made and immediately updates its own databases with the changes pulled out from the master.

[tab]You can periodically keep deleting the binary logs, as they keep on being generated and eat up ur disk space. The thread that fetches the logs, maintains a persistent connection - which means, as soon as the master generates a log, it's pulled out by the slave. The updates can happen anytime later on coz the slave has already got hold of the update information. Even if the link fails in between, the slave can later on work on the logs stored on it's own drive and do the updates properly. The process is extremely efficient and I've got one running on my own LAN for testing purposes. It's works out AWESOME

    But with free hosting services and even with most paid ones, I don't think they'll be ready to change their my.cnf to point to your replication server - still it's worth a try...

Hope this will guide you to the right direction. If you need more information, post again...

Regards,
m^e

 

 

 

Reply

You get my point. Thanks,.But i want to replicate or mirror my database here in asta host to another site.Actually this is much related to my other post, and as you have said astahost did not allow to access my mysql database from other site. which i want to do so im no longer worry i dont have backups.

Reply

See as far as I <-- know, asta databases limit the access to only the asta web-server. But then again, I might be wrong You should ask OpaQue instead - he'll be able to clarify better. What I said was from my own observation, but I might be mistaken and there could be a way to directly access your db from another IP.

Regards,
m^e

Reply

this might be very helpful to your prob.. see this : http://codingtricks.blogspot.com/2008/02/c...ysql-db-to.html

Reply