Sriram, Zoho Creator’s Lead Architect has given an interesting interview (well I shouldn’t say… go check it out for yourself) and a nice peek into Zoho Creator’s Infrastructure, Security and more…
Here are some interesting tidbits from the interview:
ZohoCreator is completely based on relational model and Deluge was a natural fit. Gradually when we integrated Deluge, ZohoCreator transformed from a simple Form Builder to a complete Online Database Application creator.
Migrating ZohoCreator to the Grid Environment was a huge effort. Some part of the data model for the ZohoCreator had to be modified. Especially with regards to sharing. With a standalone service, there is only one database and all the users data resides in one database. Whereas in a database cluster the user information is distributed across the clusters.
The performance aspect of ZohoCreator is bit unique among all other Zoho services. ZohoCreator hits the database more than any other application. There are more write operations compared to other services and hence the database is heavily loaded. These database queries are very dynamic in nature.
We are preparing to host and replicate the data in multiple data centers across the world, so that our customers are not affected by any catastrophic database failures or prolonged network outage. This way even if one of the data center is affected, the others would work fine.
We have developed both REST API’s and XML-RPC/CSV-RPC. So stay tuned for the API release
Here is full length interview of Sriram by Pete Thomas at Land of ZC.
Charles Zoho Creator’s Chief Engineer will be interviewed next by Pete. Watch out this space for an announcement soon.
Previous Interview at Land of ZC: Suganya about Deluge Script