maria-developers team mailing list archive

[Daniel Bartholomew <dbart@xxxxxxxxxxx>]

The following question has been posted to the AskMonty Knowledgebase:

https://kb.askmonty.org/en/storage-engine-plugin-that-proxies-another-engine/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Storage engine plugin that "proxies" another engine?

I would like to write a plugin that adds transparent versioning support
for table rows.

The idea is one would create a table and specify something like
"Engine=Versioned", which would create two regular tables in
InnoDB/MyISAM. One table to hold the current data, and one to hold a
couple of previous versions.

Then, when running UPDATE/DELETE statements, the "versioned" engine
would first copy the current data to the "history" table and then
forward the statement to the underlying storage engine.

Is this possible to do in a nice way using the plugin architecture?

Thanks

Thomas
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -


Thanks.

-- 
Daniel Bartholomew
  Google+ - http://gplus.to/dbart
  Twitter - http://twitter.com/daniel_bart

MariaDB: An Enhanced Drop-in Replacement for MySQL
        Website - http://mariadb.org
        Twitter - http://twitter.com/mariadb
        Google+ - http://google.com/+mariadb
       Facebook - http://fb.com/MariaDB.dbms
  Knowledgebase - http://kb.askmonty.org
  Monty Program - http://montyprogram.com