Hi Steve, That would definitely be the easiest and simplest answer. Unfortunately I only have power over these two machines. What I'm trying to do is create a site that if one machine dies/hangs, the system will continue to work on the alternate server. I just read about the master-master mysql server setup and though that seems a little complicated, I suppose my desires are more difficult than I thought at first.
Any other ideas out there? Is SQLite a possibility or is master-master the way to go? thanks, --Tim On Sep 20, 9:22 pm, Steve Holden <holden...@gmail.com> wrote: > On 9/20/2010 11:11 AM, Tim Arnold wrote:> hi, I have two machines for a > Django-powered site and they are setup > > to be duplicates to provide redundancy. Each one runs its own apache > > instance and accesses the same Django apps on a shared disk. > > > The problem I have is that I need a single database. The users should > > not need to know which machine they're actually connecting to. As I > > understand it, I can't do that with MySQL. I can make one a master and > > one a slave, but that's not duplication of machines. I tried making a > > symlink from /usr/local/mysql/var to a shared disk location for both > > MySQL servers, but that is a Bad Idea (from what I read this weekend). > > > So finally, my question is how to solve the problem and maybe whether > > SQLite would be a better database since AIUI, it is simply file-based. > > If the two web servers are sharing a disk they are presumably fairly > local to each other. Why not just a single database server with each > Django server connecting to it over a LAN? You may need to think more > deeply abut transaction isolation. Just an idea ... > > regards > Steve > -- > DjangoCon US 2010 September 7-9http://djangocon.us/ -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
