How to Troubleshoot FakeDb Errors – Sitecore 8.2
A NuGet package, Sitecore.FakeDb helps us to test functions that use Sitecore API. It is a mock memory database where you can remove the dependencies and isolate the code. When you create a brand-new test project, setting up FakeDb can be tricky. Installing FakeDb and adding the usual two Sitecore …
Configuring Multiple Sites with Sitecore
Sitecore has the out-of-box capability to host multiple sites from a single installation. Enabling multi sites is relatively straight forward. Sitecore decides the site context based on the incoming URL and three site attributes, hostName, virtualFolder and physicalFolder. A unique site in Sitecore is defined by hostName and those folder …
How to Prevent Blocked Host Connection from Many Connection Errors in MySQL
MySQL has a parameter called max_connect_errors to prevent user from connecting to the database if they make too many connection errors (e.g. from wrong password) for security reason. The default for this value is 10. In case of AWS RDS, I don’t think the value is set. Therefore, when you …
Top 10 Configuration Parameters to Tune PostgreSQL for Better Performance
The conventional wisdom is that, if you do not know what you are doing, you’re better off using the default configuration. Databases usually perform well with the default parameter values and premature performance optimisation often results in worse performance. On the other hand, Postgres is a different story. Postgres default …