The moment I upgraded to PHP 5.4, my Wordpress sites and servers were flooded with error messages. Thankfully, the crew at Atomicorp are maintaining a legacy PHP 5.3 repository that you can use to easily downgrade your PHP installation. This guide will show you how to use the Nucleus repository to safely and easily downgrade your PHP version back to 5.3.
Guide to setup and install a new CentOS 6.x server with VirtualMin Control Panel, Apache, NGINX and PHP-FPM support.
A default SNMP v3 community string will mean a high vulnerability during a scan. Here is a guide to modify your SNMP settings for Centos & Linux systems.
Quick and dirty code to harden the spam policy on Postfix systems to use RBL (Remote Black List) features.
This guide will help walk you through some of the steps necessary to install Postfix, Amavisd-new, ClamAV, and Spamassassin on Plesk based linux servers.
Here is a quick and dirty guide to mounting an Amazon S3 drive to your EC2 instance on Centos 6 / RHEL linux systems.
The correct tool for creating users is snmpusm. To get the snmp v3 encrypted goodness going run,
Guide to setting up Swap Space on an EBS volume of a Centos/Ubuntu Linux Amazon EC2 web server.
A good guide and refresher on how to create or delete partitions on Linux (Red Hat or Centos). This is especially handy for those new Cloud installations and EBS volumes.
A brief Overview on MySQL
While connecting to MySQL server you may get many errors this means that your other available connections are being used by other clients.
With the help of max_connections system variable you can control number of permitted connections. But 100 is its default value. And if you want to increase number of connections, you can set high value for this system variable.
Requirements
To start this procedure you must have below mentioned decencies:
For root or a sudo user you must have SSH access
• Connecting via SSH to user server
• How do I enable root access?
• How do I disable SSH login for root user?
Instructions:
To increase the number of maximum connections of MySQL, edit the file /etc/my.cnf. And connect to server as root or sudo user via SSH, and type
|
1 |
vi /etc/my.cnf |
Then you will see a section like this or may be somewhat different:
|
1 2 3 4 5 |
[mysqld] safe-show-database innodb_data_file_path=ibdata1:10M:autoextend datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock |
Under [mysqld] add following line:
|
1 |
max_connections=250 |
Resulting configure file must resemble this:
|
1 2 3 4 5 6 |
[mysqld] safe-show-database innodb_data_file_path=ibdata1:10M:autoextend datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock max_connections=250 |
To restart mysqld save the changes and type:
|
1 |
/etc/init.d/mysqld restart |
Result will appear as-
|
1 2 3 |
Output: Stopping mysql: [ OK ] Starting mysql: [ OK ] |
If stopping FAILS, there will be some mistake, recheck all settings and make sure you have correctly entered new settings.
Important:
If you want to check settings whether it was applied successfully or not, use any of the below mentioned methods:
1. See mysql> prompt by Log into MySQL
|
1 |
mysql -uadmin -p`cat /etc/psa/.psa.shadow` |
2. Run Command
|
1 |
show variables like 'max_connections'; |
Remember to add semi column to the end.To exit Mysql, apply the quit command.
A script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. Features – Backup mutiple databases – Single backup file or to a seperate file for each DB – Compress backup files – Backup remote servers – E-mail logs –
I spent some time trying to figure out how to fix the Suexec Policy Violation error under Plesk in Centos.
