Hi Heikki, The basic problem is that I have committed the transaction and then replicated to another DB. Now I want to rollback the committed transaction. Is there a way to rollback to a particular point. This requirement is very similar to rolling back using save points. I guess an option would be to backup database before changes and restore it if the user is not satisfied with the changes he has made. One transaction in my application would affect 6-8 tables with at least 50 - 100 records getting inserted/updated or deleted.
Please advice Karthikeyan B ----- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 23, 2003 12:36 AM Subject: Re: Replication Rollback > > Karthikeyan, > > replication poses no problem here. MySQL does not write to the binlog > transactions which are rolled back. Thus, a replication slave will never > perform the steps in a transaction which is rolled back in the master. > > Best regards, > > Heikki Tuuri > Innobase Oy > http://www.innodb.com > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > tables > > Order MySQL technical support from https://order.mysql.com/ > > ----- Original Message ----- > From: ""karthikeyan.balasubramanian"" > <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, December 22, 2003 7:37 PM > Subject: Replication Rollback > > > > Hello everybody. > > > > I have a clarification/solution to request. I am currently in the > > process of designing a web application with JBoss 3.2.2 and MySQL 4.0.16. > > The application is a data centric application with huge list of products > > (tens of thousands). Sets of products are grouped into Categories. These > > categories are maintained in a hierarchical fashion in the database. There > > is no restriction on the number of levels that this categories can go to . > > The requirements are to help an admin user manage product categories and > > also to be able to bifurcate a category. To cite an example, let us take a > > category of Toys which has 100 products beneath it. The admin user wants > to > > split the Toys category based on age group. he can split the category into > > any sub categories ( 3 Yrs - 8 Yrs, 9 Yrs - 15 Yrs, 16+). The admin user > > will now have to split the 100 products into these categories. He cannot > > leave any products in the Toys category. There are two risks associated > with > > this: > > > > a.. The user doesn't finish the multistep process. (handled by the use > of > > session variables) > > b.. The admin user needs to test the application (data changes) on a > > staging environment before he can confirm the changes to production. > > c.. The admin user needs to be able to roll back changes if he is not > > satisfied with the changes made. > > > > I was planning to use replication. This is described in detail at the > > url document(http://www.aspiresys.com/karthik/procs.pdf). The process > works > > fine as long as the data is correct. given the approach I would like to > know > > how I can roll the old transaction back. Also I want to know the best > method > > to achieve this. This is pretty important and any help would be highly > > appreciated. > > > > > > Thanks > > Karthikeyan B > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]