Thank You, We could actually handle the double load for writie queries, since that would actually happens not quite often. The problem i can't think on how to handle is how to copy data among the databases.
i have no idea on how to do a query like insert into db1.table values (select * from db2.table ) (also ... i actually don't know if this thing would work or not..) On Feb 17, 11:46 am, Gareth McCumskey <[email protected]> wrote: > 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 <[email protected]> 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... > > ), 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 [email protected] > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > >http://groups.google.com/group/symfony-users?hl=en > > -- > Gareth McCumskeyhttp://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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
