Web Hosting Blog

• 13Nov

  General difference between Clustered and Shared Web Hosting.

  Database Hosting, Dedicated Server Hosting, Domain Name, Email Hosting, Linux Hosting, Linux VPS, Linux web hosting, Micfo Web Hosting, MySQL Hosting Issues., Plesk Hosting, Search Engine Marketing, Web Hosting, Windows Web Hosting, cPanel Hosting, cpanel No Comments

  Clustered web hosting is designed to eliminate the problems inherited from the typical shared web hosting technology. This type of hosting provides customers with a clustered handling of security, load balancing and necessary resources.

  Human interference is not required in clustered hosting as the clustered hosting platform is data driven. The resources are virtualized beyond the limits of a single physical server which removes the limitation of the website to be present on a single server. The processing power and application resources are shared in Cluster web hosting. Incase of any changes done to a customer’s account then it gets propagated to each server present in the cluster. Whereas in shared web hosting changes to a configuration file takes effect after the server is re-booted. In clustered hosting multiple layers of security are integrated into the platform whereas in other types of web hosting the security layers are not integrated in the platform. The Clustered hosting network layer protection require intelligent routing, built in firewalls and proxy technology. It comprises of redundant switching fabric.

  Shared web hosting service refers to the hosting service in which many websites are hosted on a single server. Each website is assigned a particular limited space (Depends on the Shared Hosting Package) in which the web server resources are shared between many web-sites hosted on the same server. Shared web hosting is the most economical type of web hosting service available. Shared web hosting requires web based control panel such as cPanel, Plesk, Direct Admin etc. The servers might have Windows or Linux operating systems installed on them. Both have similar interfaces and functionality with only difference in the operating system. As the resources offered by a single server are used by each website optimum performance cannot be expected which is not the case with dedicated web hosting service. The secure websites are not properly supported in shared web hosting platforms. All the websites share the same IP address and the same domain name. Improper configuration of file permissions with shared files might lend access of file to other users present on the same server.

  Tags: Clustered web hosting, cpanel, dedicated web hosting service, Linux Hosting, plesk, Shared Hosting Package, Shared Web Hosting, shared web hosting technology, Virtualisation, WebServer security, windows hosting

• 26Oct

  Phpmyadmin errors on newly setup cpanel server or vps.

  MySQL Hosting Issues., cPanel Hosting No Comments

  1) 2002 - The server is not responding (or the local MySQL server’s socket is not correctly configured).

  Ans :-

  Built in mysql.sock file path is /var/lib/mysql/ phpmyadmin search it in /tmp. To solve error just create symlink of mysql.sock under /tmp. Please use following command to create symlink.

  ln –s /var/lib/mysql/mysql.sock mysql.sock

  2 Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

  Ans:-

  We receive above error while accessing phpmyadmin due to wrong session file path or wrong session handler type mentioned in file “/usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini” . Please find following and change it as per below.

  Search for

  session.save_handler = sqlite

  session.save_path =/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb

  Replace to

  session.save_handler = files

  session.save_path = /tmp

  3 Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this.

  Ans:-

  Please check you have set root password of mysql. You can do it from whm >> sql services >> mysql root password.

  Please check password is correctly saved under

  /root/.my.cnf

  Tags: Add new tag, cpanel server, cpanel vps, error, mysql.sock, php.ini, phpmyadmin, Phpmyadmin errors on newly setup server, Server, session, setup

• 15Oct

  SEM is the leading trend of SEO.

  General, Linux Hosting, Linux web hosting, Micfo Web Hosting, MySQL Hosting Issues., Search Engine Marketing, Web Hosting, Windows Web Hosting, cPanel Hosting No Comments

  Search Engine Marketing (SEM) has become a leading trend in the Search Engine Optimization (SEO) process.

  

  Nowadays every web hosting company should realize the change in the trend of SEO process. Now only focusing on optimization is not enough, marketing too has become an essential factor because of the increased importance of search engines. Till recent times SEO was the process used to increase traffic to a particular website. Nowadays the main priority is given to prioritize on the traffic that you are already receiving.

  

  Search Engine Marketing (SEM) includes :

  • Building Links
  • Analyzing Keywords
  • PPC and advertising
    

    Different Search Engines

  • Organic Traffic
  • Targeted traffic
  • Social Networking
  • Conversion Rate Optimization
  • Search Engine Optimization
  • Web Design
  • Precise Web Page content

  To summarize SEM, the basics are :

  1. Content
  2. Credibility
  3. Usability
  4. Conversion.

  Tags: advantages of a dedicated server, Search Engine Marketing, search engine optimization, SEO, Web Hosting

• 04Jul

  High Availability-Failover Clustering

  Dedicated Server Hosting, MySQL Hosting Issues., Server Security 1 Comment

  The High availability clusters are computer clusters which are implemented mainly for the purpose of improving the availability of the services. The high availability clustering detect hardware/software faults, and instantly restart the application on another system without requiring administrative intercession, this process is commonly known as a Failover process. It has functionality that provides failover from one node to another if the current node becomes unavailable, a failover cluster appears on the network as a normal application, but it has additional functionality that increases its availability in case one server fail.

    –>

  The clustering software may configure the node before starting the application on it. To run the system smoothly it require appropriate filesystems to be imported and mounted and  to set-up cluster rules that enable a common set of configurations also network hardware may have to be configured, and some supporting applications may need to be running as well.Diagram: HA Cluster network (2 node)

  

  The purpose of HA clusters to utilize all available techniques to make the individual systems/shared infrastructure as reliable as possible. The high availability clustering should include the following;

  * Build redundancy into a cluster.

  * Redundant network connections so that a switchover or network interface failures do not result in network outages.

  * Disk mirroring to avoid system crashes in case of failure of internal disks.

  * SAN data connections.

  * Redundant electrical power inputs.

  The high availability clusters generally use a critical clustering in private network connection and monitor the status of each node in the cluster. Such clustering are often required for critical databases, business applications, file sharing on a network and customer services such as e-commerce websites.

• 12Oct

  Change MYSQL Root Password

  MySQL Hosting Issues., Web Hosting Articles, cPanel Hosting No Comments

  Forgot the MySQL root password :

  First you will have to stop the MySQL service on the server.

  # service mysqld stop

  Start MySQL as

  # /usr/bin/safe_mysqld –skip-grant-tables &

  Or

  # /usr/bin/mysqld_safe –skip-grant-tables &

  safe_mysqld is a script that starts mysqld and traps any forceful terminationof the MYSQL server and it privents any database corruption.

  Change the password for root user as

  # mysql -u root mysql
  mysql> UPDATE user SET Password=PASSWORD(’new_password’) WHERE user=’root’
  mysql> FLUSH PRIVILEGES;
  mysql> exit;

  Start the MySQL service:

  # service mysqld start

• 21Sep

  How to move mysql Database from ensim to cpanel (manually)

  Ensim Hosting, Linux Hosting, MySQL Hosting Issues., Web Hosting Articles, cPanel Hosting No Comments

  Hello Friends,

  Following are the steps to move database from ensim server to cpanel server.

  Create a file with all the mysql databases from one domain (type in
  each full file name based on the files in the

  /var/lib/mysql directory). If there is just one domain then you’ll only
  have one domain_com_-_xx entry, if there are several,

  then just keep adding the databases.

  mysqldump -Q –databases domain_com_-_xx domain_com_-_yy domain_com_-_zz -u root -p –add-drop-table > dump.sql

  Step 2: Create the priviliges file

  mysqldump mysql > mysql.sql -u root -p

  cat mysql.sql | grep domain > mysql2.sql

  Step 3: Make the Tar of Files

  tar -czvf dump.tar.gz dump.sql mysql2.sql

  Step 4: Transfer the files

  ftp new.cpanelserver

  put dump.tar.gz

  At cpanel server you need to do the following steps
  Login to cpanel server.

  step 1:Start in the directory in /home/admin
  cd /home/admin

  tar -zvxf dump.tar.gz

  Step 2: Run the vi editor to do a search/replace on database name

  vi dump.sql

  :%s/ecclestoned_com_-/ecclestoned/g

  Step 3: Run the vi editor to do a search/replace on the permissions to fix
  some version issues.

  vi mysql2.sql

  :%s/ecclestoned\\\\_com\\\\_-\\\\/ecclestoned/

  :%s/);/,’Y',’Y');

  Step 4: Run mysql hosting to import the databases

  mysql mysql -u root -f

• 19Sep

  How to set the mysql database backup cronjob ?

  Dedicated Server Hosting, Hosting Support, Linux Hosting, Micfo Web Hosting, MySQL Hosting Issues., cPanel Hosting 1 Comment

  CRON
  Cron is a linux utility that schedules a command (or commands) to be executed periodically at certain times. They can perform user-defined tasks such as backing up databases, scheduling mailing lists, clearing old records, etc etc.

  To set up a CRON Job, you need to know two things.

  1. The command that is to be executed (often a user written script or a UNIX command)
  2. How often the command is to be executed (what days, months, dates, hours etc etc)

  There are following different format to get the backup of mysql database using cron job

  1) Simple cron job syntax to take database backup
  * * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword > /path of database store.sql

  2) Compress the database backup in gz format
  * * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword|gzip > /path of database store.gz

  3) Compress the database backup in bz2 format
  * * * * * /usr/bin/mysqldump -u datbaseusername databasename -pdatbasepassword|bzip2 -c > /path of database store.bz2

• 16Sep

  PhpMyAdmin Installation Step by Step

  Dedicated Server Hosting, Hosting Support, Hsphere Hosting, Linux Hosting, Micfo Web Hosting, MySQL Hosting Issues., cPanel Hosting No Comments

  If you are like me on a shared/reseller/dedicated hosting server chances are your web hosting account has cPanel or some other administration panel through which you can create/delete MySQL databases (DBs)/DB users. But you will not be able to:

  a. Take selective backup. i.e., backup of only some tables in a DB in different format ( .sql , .gz ,.zip etc)

  b. Execute queries. You might have seen that some scripts give you a .sql file that needs to be ‘executed’ in your DB so the tables in it get created/populated.

  Enter phpMyAdmin to the rescue. It is a nice web interface to control your MySQL DB. Most hosts already provide phpMyAdmin but it’s usually out-dated.

  This is a step-by-step tutorial for installation of phpMyAdmin on your shared/reseller/dedicated hosting space using FTP access or shell access.

  1.ftp::Download the latest version from http://www.phpmyadmin.net/home_page/downloads.php.

  The latest version is at the top. You can download the .zip file.

  Shell::wget
  http://mesh.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.9.0-rc1.tar.gz

  2. ftp ::Extract the contents of the .zip file using a program like winrar.

  shell:: tar -zxvf phpMyAdmin-2.9.0-rc1.tar.gz

  3. [Optional] You may want to delete unneeded language files. This saves time while uploading. Go into ‘lang’ folder and delete all files except a) all the .sh files and b) the three .php files having names starting w/ ‘english’.

  4. In this tutorial scope, we are going to have phpMyAdmin access and control all the tables in a single database that you are going to create.

  a. Create a DB using cPanel

  b. Create MySQL username and a password for this user

  c. Assign all privileges to this user to access the DB

  5. Edit the config.inc.php file.

  a. Usually it is ‘localhost’.

  $cfg[’Servers’][$i][’host’] = ‘localhost’; // MySQL hostname or IP address

  b. Enter MySQL user you created in step 4 b.

  $cfg[’Servers’][$i][’controluser’] = ‘MySQL_user’; // MySQL control user

  settings

  c. Enter MySQL user’s password that you created in step 4 b.

  $cfg[’Servers’][$i][’controlpass’] = ‘MySQL_pass’; // access to the

  “mysql/user”

  d. Save the file and close it.

  6. ftp::Log into your web space using a FTP client and create a directory, say phpmyadmin under public_html. Upload all the content into the directory created.

  Shell:: For the convient move the phpMyAdmin fodler to phpmyadmin using following command under your public_html folder

  mv phpMyAdmin-2.9.0-rc1 phpmyadmin

  7. Installation is complete. Simply point your browser to the directory where you installed phpMyAdmin and you should be able to start using it.

  8. Important: Password protect the directory where you installed phpMyAdmin or else anyone will be able to access it! You can do that using the admin panel that your host provides.

• 26Aug

  > Mysql root issues, cannot log into the database as root

  MySQL Hosting Issues. No Comments

  Hello,

  If you face such error —–>

  ERROR 1045: Access denied for user: ‘root@localhost’ (using password: NO).

  Solution :

  You have set a password on the root account. This is a good thing. Start mysql by:

  mysql -p

  and it will prompt for the password.

  If you don’t know the password, you can re-run the /scripts/mysql_install_db script to rebuild the mysql database. You might need to delete the /data/mysql directory to do this, but I’m not positive.

  Since you’ve just installed the server this shouldn’t disrupt any existing user/database relationships.

  And if there’s no default password- just running “mysql” when logged into the server as root should get you in.

  The method to change the password is (as root):
  “update mysql.user set password=password(’newpass’) where user=’root’;”

  Then try

  ” mysqladmin -u root -p password ” or ” mysqladmin -u user -ppassword “

  If you’re logged into the server as “root”, then the “-u root” is optional. Mysql will use the currently-logged-in userid unless told otherwise.

• 26Aug

  MySql sample my.cnf file

  MySQL Hosting Issues. No Comments

  [client]
  port=3306
  socket=/var/lib/mysql/mysql.sock

  [mysqld]
  port=3306
  datadir=/var/lib/mysql
  socket=/var/lib/mysql/mysql.sock

  skip-locking
  skip-innodb
  query_cache_limit=1M
  query_cache_size=32M
  query_cache_type=1
  max_connections=500
  interactive_timeout=100
  wait_timeout=14400
  connect_timeout=10
  thread_cache_size=128
  key_buffer=150M
  join_buffer=1M
  max_allowed_packet=16M
  table_cache=1500
  record_buffer=1M
  sort_buffer_size=1M
  read_buffer_size=1M
  read_rnd_buffer_size=768K
  max_connect_errors=10
  thread_concurrency=4
  myisam_sort_buffer_size=64M
  log-bin
  server-id=1

  [mysql.server]
  user=mysql
  basedir=/var/lib

  [safe_mysqld]
  err-log=/var/log/mysqld.log
  pid-file=/var/lib/mysql/********.pid [NOTE : here it should be server hostname]
  open_files_limit=8192

  [mysqldump]
  quick
  max_allowed_packet=16M

  [mysql]
  no-auto-rehash

  [isamchk]
  key_buffer=64M
  sort_buffer=64M
  read_buffer=16M
  write_buffer=16M

  [myisamchk]
  key_buffer=64M
  sort_buffer=64M
  read_buffer=16M
  write_buffer=16M

  [mysqlhotcopy]
  interactive-timeout

« Previous Entries