category:
How to Configure MySQL Master Slave Replication in CentOS 7
Updated on: 12 Oct 2023
MySQL Master Slave Replication for database load balancing MySQL replication is a method of storing data on many systems, and this data is automatically copied from one database (Master) to another database (Slave). If one server goes down, the data can still be accessed from the other servers (Slave) database. In this article, we’ll look […]category:
How to Check MySQL version in Windows? 5 Instructive methods
Updated on: 12 Oct 2023
How to check MySQL version in Windows can be a bit of a task. This is so because there is a substantial difference between Linux and Windows installation of MySQL server. Moreover most of the MySQL tutorials and guides are focused on the Linux installation of MySQL version. Check the MySQL daemon for version The […]category:
PHP performance benchmarking and optimisation
Updated on: 18 Oct 2023
PHP performance optimisation is a growing concern with web developers who are obsessed with shaving milliseconds from their php code execution and there is a need to benchmark php performance so that you can compare the performance of your PHP Recently, we had a client wanting to host their sites on our VM hosting platform […]category:
Tips to optimise MySQL server performance
Updated on: 20 Oct 2023
Here are a couple of tweaks which can improve your mysql server performance significantly. We implemented this on our hosted servers and the php/mysql queries for dynamic DB driven applications improved by over 50%. The following are the relevant commands which can be inserted in the mysql conf file, which is normally located at /etc/my.cnf. […]category:
Setting up and getting DOMpdf to work in XAMPP on Windows
Updated on: 19 Aug 2023
Setting up the Dompdf (a pdf generation package in php) in XAMPP in windows environment can sometimes be an issue. After we have set up the package in the htdocs and go for testing the examples in the packages , error is encountered which is as follows- A PHP Error was encountered Severity: Warning Message: […]category:
Improve Security using php.ini
Updated on: 25 Oct 2023
PHP has some vulnerable functions which can be used to break into your server if your scripts are not coded securely. You can setup a list of functions in php.ini using disable_functions directive. This directive allows you to disable certain functions for security reasons. It takes on a comma-delimited list of function names. This disable_functions […]category:
Creating image thumbnails in php
Updated on: 25 Oct 2023
Thumbnail are used by graphic designers and photographers for a small image representation of a larger image. The main advantage of creating thumbnails is that it generates the new image with the proportional dimension of the large image and hence the image resolution and quality remain intact. As the thumbnails are smaller in size they […]