These are my beginning notes on what I hope will be an alternative staging/live setup for LAMP geeks.
The steps in the setting up mysql replication are very good in the onlines docs at:
http://www.mysql.com/doc/en/Replication.html
I was able to set up 2 slaves for my midgard (development) database. I make sure to start the production database server with skip-slave-start in the my.cnf so that it will not begin a slave connection on server startup.
Back on the Development (master) server I use a few databases besides midgard , so I the only db I don't want replicated the access privs so I add this to the config: replicate-ignore-db=mysql
The master/slave process was suprisingly quick! these database servers
are all on different isps. All of them are connected to at least a T1 (E1) so I cannot say how good this method is over slower connection.
The next stage is to create a wrapper program for starting/stopping the slave on the production server. Might be php,java or maybe this will be my excuse to learn python.
The next problem was copying the contents of the blobs directory from development to the production server. rysyn -e ssh solved that problem. A good how-to is here, customize to your taste: http://killyridols.net/rsyncssh.shtml
All I can say is that so far it works fine.
Will try to write something more comprehensive later.
smime.p7s
Description: S/MIME Cryptographic Signature
