Mysql database server failover

2007-11-08 Thread Jonathan Share
Hi, I hope this is a stupid question but I'm trying to work out how to configure a database connection in pylons to use a database failover. I currently have 2 database servers set up in a master-master replication set up and wish for the pylons app to fail over to the second database server

Re: db update notifier for pylons app

2007-11-08 Thread kettle
thanks a bunch. that was a great lead! On Nov 7, 7:33 pm, Marek Stępniowski [EMAIL PROTECTED] wrote: 2007/11/7, kettle [EMAIL PROTECTED]: Hi, I am fairly new to pylons and have what may be a simple implementation question. I have an html table which displays the (partial) contents

Update on Pylons-izing zunzun.com

2007-11-08 Thread zunzun
Pylons-izing? Pylons-ification? Pylons-ation? Anyway, I'm finally ready to embark on the conversion of http://zunzun.com from skunkweb to Pylons. Here is a high-level diagram (made with Dia) for the new site's core architecture. http://zunzun.com/images/Diagram.png James

Re: Reloading on changes to i18N *.po/*.mo files..

2007-11-08 Thread Philip Jenvey
On Nov 8, 2007, at 2:30 PM, Tomasz Nazar wrote: Hi there! I'd really like, that when changing translations (localized i18n/**/*.po/mo files) pylons/paster are reloaded with newly, updated texts. (similar like changes to templates, public files are instantly visible). Is it possible?

Reloading on changes to i18N *.po/*.mo files..

2007-11-08 Thread Tomasz Nazar
Hi there! I'd really like, that when changing translations (localized i18n/**/*.po/mo files) pylons/paster are reloaded with newly, updated texts. (similar like changes to templates, public files are instantly visible). Is it possible? And btw, is it possible to get rid of PO-to-MO-compilation

Re: UNS: Re: cleaner ToscaWidgets

2007-11-08 Thread Matt Feifarek
On Oct 24, 2007 5:06 PM, Alberto Valverde [EMAIL PROTECTED] wrote: Yep, was planning to do that when I cover tweaking the layout. Finally didn't have time to start part 2 today but will tomorrow... Hey Alberto -- did a part 2 ever fall out of your brain? We're eager to learn more about TW,

Re: Mysql database server failover

2007-11-08 Thread Mike Orr
On Nov 8, 2007 8:06 AM, Jonathan Share [EMAIL PROTECTED] wrote: I currently have 2 database servers set up in a master-master replication set up and wish for the pylons app to fail over to the second database server when the first goes down. By master-master you mean each database updates the

Re: mysql exceptions

2007-11-08 Thread David Geller
AFIK, all db operations are using Session, and I am not doing any alters, etc, only selects. I finally did get the errors while logging was enabled, but not sure what sort of light has been shed on this: snippet: 2007-11-08 05:44:44,336 INFO sqlalchemy.engine.base.Engine.0x..8c BEGIN

Re: Mysql database server failover

2007-11-08 Thread Atilla
There is anothe rapproach that doesn't require you to do anything specific in your code and is generic for many simmilar situations - using heartbeat deamons and automatic network address switching. You can do this with keepalived and some configuration, or just check the Linux HA project on

Re: Must WSGI Applications Respond to Requests?

2007-11-08 Thread Graham Dumpleton
On Nov 9, 10:17 am, Randy Pearson [EMAIL PROTECTED] wrote: Hi. First time caller. We're studying WSGI and Pylons as a likely environment to which to port existing applications and framework. In our current environment, we often have 2 or more applications running under a single process, where

Must WSGI Applications Respond to Requests?

2007-11-08 Thread Randy Pearson
Hi. First time caller. We're studying WSGI and Pylons as a likely environment to which to port existing applications and framework. In our current environment, we often have 2 or more applications running under a single process, where an app manager object sequentially offers the request to each

Re: Mysql database server failover

2007-11-08 Thread Damjan
By master-master you mean each database updates the other when a change comes in? How did you structure that? http://www.howtoforge.com/mysql_master_master_replication MySQL master-master is kind of like bidirectional master-slave. This is supported in version 5.0 and above. In previous

Re: Must WSGI Applications Respond to Requests?

2007-11-08 Thread Mike Orr
On Nov 8, 2007 3:17 PM, Randy Pearson [EMAIL PROTECTED] wrote: Hi. First time caller. We're studying WSGI and Pylons as a likely environment to which to port existing applications and framework. In our current environment, we often have 2 or more applications running under a single process,