Web Technology Experts Notes

Showing posts with label Wamp Server. Show all posts

Wednesday, 28 December 2016

How to install redis on wamp server?

Question: What is Redis?
it is an open source advanced key-value database storage system like NoSQL.

Question: Why Redis is used?
Redis is used for caching to speed up application.

Question: How redis helpful in Optimization?
Redis operations can be executed on the server side and reduce the client's workload.

Question: What type of data can be stored in Redis server?
Redis store complex data structures like strings, hashes, lists, sets, sorted sets, bitmaps and hyperlogs as its key values.

Question: Why redis is fast?
Redis is inherently fast as it stores data in memory.

Question: How to install redis in wampserver?

Download the redis
A) Download Redis setup For 32 Bit System and Install
B) Download Redis Setup for 64 Bit system and follow below steps.
1. Extract the zip file
2. Place the unzip file in c:\redis
3. Run redis-server.exe from c:\redis
4. then Run redis-cli.exe from c:\redis
Check out your php version and know whether thread safety is enabled or not(by using phpinfo()).
Now we need to download the php_redis.dll. Download the php_redis.dll from PECL.
Download as per PHP Version and thread based.
Extract the zip file.
Copy the php_redis.dll and paste to following folder in Wamp Server.
```
wamp\bin\php\php5.x.xx\ext\
```
Add the following line in your php.ini
```
extension=php_redis.dll
```
Re-start the wamp Server.
Do phpinfo() and search redis. It will start displaying which means its Redis is installed
Learn and Work with redis.

Question: How to check redis is installed Or Not?

try {
    $redis = new Redis();
    $redis->connect('localhost', 6379);
    $redis->set('name', 'Redis is Installed');
    echo $glueStatus = $redis->get('name');
    
} catch (Exception $ex) {
    echo $ex->getMessage();
}

Tuesday, 2 August 2016

How to install Laravel 5 on wamp server

We are going to install Laravel5.0 on wamp server in windows.

Question: What are system requirement for laravel5.0?
Following are system requirements:

PHP >= 5.4, PHP < 7
Mcrypt PHP Extension
OpenSSL PHP Extension
Mbstring PHP Extension
Tokenizer PHP Extension

Question: How to install Laravel5.0?

You must have composer. If not install composer.
Create a folder where you want to install the laravel. Supppose
```
E:\wamp\www\laravel
```
Login to Command Prompt and go the "E:\wamp\www\laravel" using cd command.

Execute following command

composer create-project laravel/laravel laravel "5.0.*" --prefer-dist

Set the document_path to "E:\wamp\www\laravel\public" OR You can use virtual host for this. In any ways file must point to public folder first.

Friday, 6 February 2015

How to delete MySQL Binary logs Files in Wamp Server?

Sometime we find our Wamp Server is talking too much space like 10GB whereas it must take less than the current size. It may be your mysql binary log files are taking too much space in data.
Binary files look like below:
mysql-bin.000001,
mysql-bin.000002,
................,
mysql-bin.000221

Before we delete the mysql binary log files permanently, we should know about these binary log files like what type of files are these and how effect our server.

Question: What is Mysql Binary logs file?
MySQL binary logs are the text file, created by mysql automatically. Default files name are "mysql-bin.000001" which located in data folder of mysqlx.x.

Question: What is purpose of Binary logs file?
It has two purpose
Data Recovery: It is used for data recovery operations.
High availability / replication: It is used on master replication servers as a record of the statements to be sent to slave servers.

Question: What is default location of binary log file?

E:\wamp\bin\mysql\mysql.x.x\data

Question: How can change the Binary log file name?
Open my.ini file under mysql.x.x folder.
In my window system:
E:\wamp\bin\mysql\mysql.x.x\my.ini

Question: Update the following "mysql-bin" name

log-bin=mysql-bin

Question: How to disable the automatic creating binary log files?
Open my.ini file under mysql.x.x folder.
In my window system: E:\wamp\bin\mysql\mysql.x.x\my.ini
Search

log-bin=mysql-bin

and replace with following

#log-bin=mysql-bin

Question: What is dis-advantage of mysql binary log files?
Its takes too much space, some times it take upto 10MB or more space.

Question: How to delete mysql bin files permanently?
It have 3 steps and are following.

Step 1: Disable automatic creating file.
open my.ini file under mysql.x.x folder.
Search

log-bin=mysql-bin

and Replace with following

#log-bin=mysql-bin

Step 2:
Restart Wamp Server

Step3 :
Now you can delete all files start with "mysql-bin.0000xx"

Never delete mysql bin files directly you must follow Step 1