Jump to content

KVS main server load balancing


leonrak
 Share

Recommended Posts

  • 1 month later...

No, this will not work correctly as far as we understand. For example when user uploads a video, it should be inserted into primary database, so that conversion engine took it and started converting. If the video will be randomly inserted into 1st, or 2nd, or 3rd database instance, it will be a mess in the data and will result in data inconsistency. This is something that we will have supported after migrating KVS frontend to a nextgen architecture.

Link to comment
Share on other sites

  • 11 months later...
On 8/29/2021 at 3:25 PM, Tech Support said:

No, this will not work correctly as far as we understand. For example when user uploads a video, it should be inserted into primary database, so that conversion engine took it and started converting. If the video will be randomly inserted into 1st, or 2nd, or 3rd database instance, it will be a mess in the data and will result in data inconsistency. This is something that we will have supported after migrating KVS frontend to a nextgen architecture.

These 3 instances are replicated from the master, so the information on all will be identical.

Link to comment
Share on other sites

1 hour ago, Scumtron said:

There is no point in doing this. Yes you then have a replica but thats all it is. Nothing will be read from this server. You cant simply do a round robin either using dns because this will cause data mismatching in the databases.

best bet is to get atleast 3 MySQL (3 is minimum for galera) activate-galera (comes preinstalled with the latest mariadb). Make only 1 of the servers writeable this is easily done use proxySQL and then use proxySQL as the main SQL connection to do the loadbalancing. 

Setup like this can easily be googled on how to do it.

 

FYI: this does require to set your database engine to INNODB. kvs uses MyISAM by default.

Edited by hbarnetworks
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...