Can someone suggest a solution to dealing with having Gravity Forms on a WordPress site that is deployed on multiple instances behind a load balancer?
Because Gravity Forms saves data on the local MySQL database of a WordPress site, it's preventing us from deploying our site on multiple instances since a user may be directed at random to one of three instances behind our load balancer. As a result, the different versions of the local MySQL database would have different set of user submitted Gravity Forms data.
PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.
Gravity Forms on multiple instances of single WP site
-
Posted 12 years ago on Friday November 18, 2011 | Permalink
-
Anytime you are dealing with load balancing a database like this you need to deal with data consistency. How are you tackling this issue with comments on the site, or are you not using comments? Is Gravity Forms the only "user submitted" data that will be on the site?
Posted 12 years ago on Friday November 18, 2011 | Permalink -
Yes Gravity Forms is the only user submitted data.
Posted 12 years ago on Friday November 18, 2011 | Permalink -
You would run into this same issue with comments, etc. This isn't a Gravity Forms issue, it's a network setup issue. You need to configure your MySQL databases so that they stay in synch. Or you need to configure them so that they use a single MySQL database.
If the site is load balanced across multiple MySQL databases how are you handling propagating changes when a new post or page is added to whatever the master database is?
Posted 12 years ago on Friday November 18, 2011 | Permalink -
We handle the WP page content locally on a development environment and then when testing is approved, we have a push process that deploys the entire WP site along with the MySQL database to our live site. No WP administration actually happens on the live site.
The Gravity Forms user submitted data was the only thing that really updated the underlying MySQL database in production.
But I understand that the problem we're trying to solve is not a GF issue per say. I think that's the answer I needed to take away from this thread. Thanks!
Posted 12 years ago on Friday November 18, 2011 | Permalink -
Thank you. Good luck.
Posted 12 years ago on Saturday November 19, 2011 | Permalink
This topic has been resolved and has been closed to new replies.