mORMot Open Source

Torbins

Member

Registered: 2015-04-02

Posts: 1

mORMot as MySQL plugin

I have a crazy idea.
What if I setup central MySQL server and then a few replicas, one replica per App instance?
But those replicas will be similar to this: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server. So my App and MySQL server will be in one process, and my App will use mORMot to access InnoDB storage engine directly, bypassing network and SQL parsing layers. Thus local instance of MySQL will become just a cache, which communicates with central server via mysql-replication protocol.
What do you think? Total madness?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,606

Website

Re: mORMot as MySQL plugin

I would even use SQLite3 for replicas, using our new master/slave replication - see http://blog.synopse.info/post/2015/03/3 … eplication
You may be amazed by the resulting speed...

But perhaps the MySQL replication feature is more direct.