Who uses MySQL triggers for Application Refactoring ?

Here's a technical question which we have been asked by Panthermedia.net a Sun Startup Essentials member:

Panthermedia is currently refactoring the entire application including the database and it's schema. Panthermedia needs some time to do this. Panthermedia decided to do a step by step mgration for all modules. They decided to follow an innovative approach:

  • They created the new database tables in parallel to the existing ones
  • The old tables got update triggers which maintain the correct state in the new tables for every "old" query going to the old tables
  • The new tables got update triggers which maintain the correct state in the old tables. "New" queries use the new tables
  • The application is now getting re factored in a step by step approach. More and more new components use the new tables
  • Panthermedia is currently using MySQL 5.0.68 including master/master replication plus replication for backup purposes.

The current approach works like a charm. The questions is however if other members used this approach before. What are the up- and downsides?

Please let us know and start a discussion through the comment function!

Before I forget!:

Panthermedia.net is an online marketplace for royalty-free photography. Buyers and sellers of royalty-free images meet on one common platform. This platform is divided in a photo community for photographers and a stock agency for art buyers.

The photo community serves as the creative heart of the marketplace. Semi-professional and hobby photographers from all over the world can submit images to our site, communicate and interact with other members of the community, share their knowledge and experiences, and sell their images. The goal is to provide an environment where photographers can develop their artistic potential.


The founders Robert Walters (l.) und Peter Ammel

The editors at Panthermedia.net select images for our archive. The licenses for using these images for editorial or commercial purposes are offered in the stock agency. The primary target group are small and medium-sized agencies, publishers and companies working with a limited budget. Our team of sales representatives support customers in their search and selection of images. We have created an easy and affordable pricing structure that is significantly below regular prices for professional royalty free images.

Panthermedia.net is an enterprise of PantherMedia GmbH, located in Munich, Germany. The company was founded in October of 2004.

Welcome to PantherMedia - the online marketplace for digital photography

Comments:

Post a Comment:
Comments are closed for this entry.
About

Connecting the Startup Essentials community with all the events, information and resources required for them to grow and scale.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today