Your best bet for ensuring you have good database backups is to look at setting up replication with master/slave setup. This is done through mysql directly and not with the application.
The only way to do it through the application is to overwrite the save() method within your propel model classes (the non Peer classes) and tell it to save in your alternate database as well. But this will add extraordinary load onto your app, essentially doubling every write transaction. On Thu, Feb 17, 2011 at 9:41 AM, Thor <thorste...@gmail.com> wrote: > Hi all, i have a question about multiple databases: > > supposing that i have the database.yml and everything setup to use two > databases instead of one, with one that serve as a backup , and the > other as the production... > > how can i achieve that with propel? > > i found a simple way to implement the 2 databases , here ( > > http://www.lampjunkie.com/2008/04/using-multiple-databases-in-symfony-with-propel/ > ), what i need to know is: > > 1) is there a way to get records from the backup server ,and with > those , replace the production data ? ( i could work on entire tables > too ,don't know what is simpler ) > 2) how can i eventually save data in both databases at the same time? > > > Thank you in advance > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to symfony-users@googlegroups.com > To unsubscribe from this group, send email to > symfony-users+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > -- Gareth McCumskey http://garethmccumskey.blogspot.com twitter: @garethmcc identi.ca: @garethmcc -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en