[ZODB-Dev] RelStorage: Which tables to replicate?

[Stefan H. Holek]

Let me rephrase this. Would it be ok to change *all* tables to use the  
InnoDB engine (except new_oid)?

Stefan

On 19.05.2008, at 10:55, Stefan H. Holek wrote:

> I am playing with database replication (MySQL) and have found the  
> following caveats:
>
> 	- don't mix engine types (MyISAM, InnoDB)
> 	- don't use temporary tables
>
> Now, RelStorage does both and so I was wondering how to proceed with  
> replication. Would it be prudent to assume that all I ever need to  
> replicate are the InnoDB tables "transaction", "object_state", and  
> "current_object"? All other tables don't seem to be used across  
> transaction boundaries, but I may be missing something here.

--
Stefan H. Holek
stefan at epy.co.at