Monitor database issues for OpenCart or Joomla websites
Database issues for websites developed using OpenCart or Joomla can be identified by enabling a Content Match.
With the Content Match configured, Site24x7 will check for the presence of the configured text in all responses. Any response without that text will be reported as "Trouble" or "Down". This will give you a heads up about any corrupt database affecting your website.
- Configure your website response such that a particular text is always present during all success responses and absent during all error responses
- While adding a website monitor, configure the text that will be passed for every success response from your website, by navigating to
Home > Monitors > Click on the (+) icon > Content Match > Keywords to be present
With the Content Match configured, Site24x7 will check for the presence of the configured text in all responses. Any response without that text will be reported as "Trouble" or "Down". This will give you a heads up about any corrupt database affecting your website.
Related Articles
Why is the PostgreSQL individual database monitor shown as down even though that database is up in my instance?
If your PostgreSQL individual database monitor shows as down in Site24x7 but the database is active (up) in your instance, verify that if you have given the necessary permissions for the database user to access that specific database. Refer to our ...I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?
By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials. New ...I am unable to see any data for failed jobs in my database
If you are unable to see data for failed jobs or if there is a mismatch between the failed jobs data in the SQL performance monitor and the SQL insight monitor, check if you have granted the necessary permission. Data in the SQL performance monitor: ...Why is the connection attempted count greater than the maximum connection count of my MySQL database?
The reason for the count of attempted connections being different from the maximum connections is because the Connections Attempted metric is different from the actual successful connections made. Connections Attempted comprises the number of ...My MySQL monitor shows "no data."
Troubleshooting tips when no data is shown in MySQL monitor: Please provide the credentials to the Site24x7 server monitoring agent using the following command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql --add_instance Ensure the ...