I have two intranet servers and want to have the blog on each one. How can I keep data current on both servers? Can I host the data on my staging server, which automatically uploads to each production server? Can I write the data twice - once to each production server.
Any help appreciated. Thanks
Load balanced servers installation
-
- Regular
- Posts: 765
- Joined: Tue Oct 17, 2006 2:36 pm
- Location: Vienna/Austria
- Contact:
Re: Load balanced servers installation
A posibility could be useing MySQL cluster and a tool that synchronises the upload-folder.
An other posibility could be, to use a master-server for all the writing queries and severel slaves with mysql replication. You would also need a tool that distributes the upload folder.
An other posibility could be, to use a master-server for all the writing queries and severel slaves with mysql replication. You would also need a tool that distributes the upload folder.
Re: Load balanced servers installation
My publishing environment requires the use of SQLite, and I can't get write permissions for the directories on the production servers. I was hoping to use my staging server as db host and storage, but I don't see a way to make the connection from production to staging. Perhaps some of the config files can be manually edited, but I haven't located anywhere to do that.kleinerChemiker wrote:A posibility could be useing MySQL cluster and a tool that synchronises the upload-folder.
An other posibility could be, to use a master-server for all the writing queries and severel slaves with mysql replication. You would also need a tool that distributes the upload folder.