To proxmox team: what about sqlite

[cesarpk]

Hi Pormox team

To start I am amazed by the excellent work done by the team of PVE. I love PVE.

But about of SQlite, I understand that SQlite is mono-user and for use in only one computer, then not allow connections concurrent, therefore obviously to my understand in a cluster with multi-administrators and multi-computers may lose consistency the data base by itself.

As PVE team said that is possible delegate administrative functions to others users, I have doubts about the disadvantages of this data base (for example, what happend if two administrators users modify the same object at same time or modify different objects at same time and from different PVE nodes?)... MySQL Cluster may be the better option for this???

Therefore I would like to consult about the disadvantages or limitations that this data base entails into of a cluster PVE.

Please do not go to be interpreted as a complaint, just want to know about this.

And finally I say again that PVE is a fantastic product, and finely I study step by step all improvements and congratulate to Proxmox team for the excelent work accomplished!!!

Best regards
Cesar

 

[dietmar]

As PVE team said that is possible delegate administrative functions to others users, I have doubts about the disadvantages of this data base (for example, what happend if two administrators users modify the same object at same time or modify different objects at same time and from different PVE nodes?)... MySQL Cluster may be the better option for this???

PVE implements a distributed, redundant configuration storage on top of SQList, including a locking system.

http://pve.proxmox.com/wiki/Proxmox_Cluster_file_system_(pmxcfs)

SQLite is perfect for our use case, and works quite well (there is no disadvantage).

 

[cesarpk]

PVE implements a distributed, redundant configuration storage on top of SQList, including a locking system.

http://pve.proxmox.com/wiki/Proxmox_Cluster_file_system_(pmxcfs)

SQLite is perfect for our use case, and works quite well (there is no disadvantage).

Hi Dietmar

Thanks for your prompt response. after see your answer, this link...:
http://stackoverflow.com/questions/5102027/can-sqlite-support-multiple-user

...and introductory this link:
http://www.sqlite.org/atomiccommit.html

.. I understand the limitations... is very dificult that PVE have lots of concurrent writes, and if this happens > not will damage the data base and will not change the data base, as I understand it, this is the only limitation
(please consider that I'm not a programmer)

And as always, I want to share my admiration for the excellent work of PVE team , many congratulations for all!!!

Best regards
Cesar

 

[dietmar]

.. I understand the limitations... is very dificult that PVE have lots of concurrent writes, and if this happens > not will damage the data base and will not change the data base, as I understand it, this is the only limitation
(please consider that I'm not a programmer)

Again, there is no such limitation! The database is not exposed to the user at all.