[one-users] how to use Haproxy for Frontend load balance

Romany Nageh engromanynageh at gmail.com
Wed Aug 28 06:00:29 PDT 2013


how to use Haproxy for Frontend  load balance

i am using two frontEnd and on database server

After frontend1 insert in the database .Frontend2 find conflict to insert
in the database.

I.e

when front1 create 2user with id (14,15) it inset it correctly. after that
if Front2 try to create  new user give conflict error

if we restart opennebula service on front2 it can work.and after insert one
record front1 will have the same problem

SQL command was: INSERT INTO user_pool (oid, name, body, uid, gid, owner_u,
group_u, other_u) VALUES
(14,'kkkk','<USER><ID>14</ID><GID>1</GID><GNAME>users</GNAME><NAME>kkkk</NAME><PASSWORD>12d860be3734010a62e9b1015e75471d61dbceb5</PASSWORD><AUTH_DRIVER>core</AUTH_DRIVER><ENABLED>1</ENABLED><TEMPLATE><TOKEN_PASSWORD><![CDATA[b97cb083ce53d73d8c2a6be2e51e08cbaa16a392]]></TOKEN_PASSWORD></TEMPLATE><DATASTORE_QUOTA></DATASTORE_QUOTA><NETWORK_QUOTA></NETWORK_QUOTA><VM_QUOTA></VM_QUOTA><IMAGE_QUOTA></IMAGE_QUOTA></USER>',14,1,1,0,0),
error 1062 : Duplicate entry '14' for key 'PRIMARY'


any one know where opennebula save metadata or why he still see id 14 not
16(expected user id)

Please any one can help me?

thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20130828/3171587d/attachment.htm>


More information about the Users mailing list