Archive for the ‘Google’ Category

Google Cloud WordPress : You can install WordPress in Google app engine via some simple method. When you install WordPress in Google App Engine your page speed optimized and increase. You can check it through page speed optimization tools and better page speed means better SEO rank. How to Install WordPress in Google App Engine ? If you want to install and run WordPress in Google App Engine, then you have to follow the following method.

Prerequisites of Installation WordPress in Google App Engine

For install WordPress in Google App Engine, Python takes very important role to install it properly. Python is an Official language of Google.Python is also the key language of Google even with others language such as C++ and Java.It is used in Google App Engine, You Tube, and others places.So you have to Download and Install Python locally to Install WordPress in Google App Engine. You will get details download and Installation process from above mention link.

Before you install any simple application or WordPress in Google app engine at first you have to download and install python and PHP SDK locally for Google App Engine.Why you should install Python ? For running PHP SDK application, Python help to run PHP SDK application to deploy WordPress in Google App Engine. When you install WordPress in cPanel you need to install Filezilla or CuteFTP to upload WordPress or anything in your server but here is nothing like that. Here, PHP SDK application deploy everything that you want to install in Google App Engine. For details Download and Installation process for this application click on above mention link.

MySQL database is a web hosting database.It is used to store website data like blog posts or others user information. Today MySQL database is the best linking database server. A MySQL database is capable for storing any type of data that need to crate a website. It also to rapidly store and retrieve data from the database.So you have to download and  install it locally for Install WordPress in Google App Engine. If you want to know the downloading and installation process of MySQL then Click on above mention link.

After download and install all above mentioned package you have to Sign up Google Cloud platform project then set up a Cloud SQL instance.Here you have to be enabled billing on the project. I mention here some steps which help you to install WordPress in Google App Engine

Install WordPress in Google App Engine


How to register and Create Cloud Console Project for Google Cloud WordPress

Google Cloud WordPress : At first you need to register in Google Could Platform and then create Cloud console project.When you will sign in your Google Cloud Consol you will find CREATE PROJECT option. Click here to create new project for Google App Engine in WordPress Google Apps platform.When you will click that option you might be asked to put your Project name and Project ID.

Step: 1

Set Up Local application for Google App Engine.

To run WordPress in Google App Engine application you have to create an empty folder for setup application (the name of the application folder should be same of your actual Project ID) in your local computer .Then you need to add app.yaml file, php.ini file, cron.vaml file in this folder.

The following text code you have to put in app.yaml file through notepad. Here you have to change your Project ID name which you have been created before.

application: YOUR_PROJECT_ID
version: wp
runtime: php
api_version: 1

- url: /(.*.(htm|html|css|js))$
  static_files: wordpress/1
  upload: wordpress/.*.(htm|html|css|js)$
  application_readable: true

- url: /wp-content/(.*.(ico|jpg|png|gif))$
  static_files: wordpress/wp-content/1
  upload: wordpress/wp-content/.*.(ico|jpg|png|gif)$
  application_readable: true

- url: /(.*.(ico|jpg|png|gif))$
  static_files: wordpress/1
  upload: wordpress/.*.(ico|jpg|png|gif)$

- url: /wp-admin/(.+)
  script: wordpress/wp-admin/1
  secure: always

- url: /wp-admin/
  script: wordpress/wp-admin/index.php
  secure: always

- url: /wp-login.php
  script: wordpress/wp-login.php
  secure: always

- url: /wp-cron.php
  script: wordpress/wp-cron.php
  login: admin

- url: /xmlrpc.php
  script: wordpress/xmlrpc.php

- url: /wp-(.+).php
  script: wordpress/wp-1.php

- url: /(.+)?/?
  script: wordpress/index.php

The following text code you have to put in php.ini file through notepad

google_app_engine.enable_functions = "php_sapi_name, gc_enabled"

The following text code you have to put in cron.vaml file through notepad

- description: wordpress cron tasks
url: /wp-cron.php
schedule: every 2 hours

Step: 2

Download WordPress from

You have to download latest version WordPress from the website for Google App Engine.It will be downloaded as zip file in your local computer. Then it should be extracted in your created folder.

Step: 3

Create Database for your local MySQL server

After create database in your local MySQL server you have to allow to connect WordPress database and later to Connect Cloud SQL. When your local MySQL server will be running you have to run the following code.

Step: 4

Create wp-config.php file

Go to your created folder where you have been installed WordPress. In this WordPress you will get a file name wp-config-sample.php. You need to edit text code of this file.Change the name of the database as ‘wordpress_db’ Change the MySQL database user name as ‘wp_user’ and change the MySQL database password as ‘wp_password’ at last you have to save this wp-config-sample.php file as wp-config.php

The details changeable code are mention below. This code will be edited by Notepad. 

/** The name of the database for WordPress */
define('DB_NAME', 'wordpress_db');

/** MySQL database username */
define('DB_USER', 'wp_user');

/** MySQL database password */
define('DB_PASSWORD', 'wp_password');

Step: 5

Run your WordPress locally On Google App Engine

Add application by Google App Engine Launcher

Here you have to open Google App Engine launcher. Go to file menu and Click on Add existing application. Here you need to add that file which you created before (see Step: 1).When you will add this application the application path, Port and Admin port will be added here and then click on ok button. After that you have to click on Browse option of Google App Engine Launcher.Here you will see a window will be appear. Mention your Website tile, Username, password, email address here and click on Install WordPress Option. Log in it by using your user,password and theme for

Step: 6

Set up Cloud SQL instance

In this step you have to go your Cloud console project. There you will need to store your hosted WordPress database.If you want to set this then need to enabled billing and create a New Cloud SQL instance

Step: 7

Edit wp-config.php file to connect it in your Cloud SQL instance

Go to your wp-config.php file. of WordPress that reads define(‘DB_HOST’, ‘localhost’);and edit it with following code with notepad.

if(isset($_SERVER['SERVER_SOFTWARE']) && strpos($_SERVER['SERVER_SOFTWARE'],'Google App Engine') !== false) {
  define('DB_HOST', ':/cloudsql/YOUR_PROJECT_ID:wordpress');
  define('DB_HOST', 'localhost');

Here you have to put your Cloud SQL Instance ID name.After change the code save it.

Step: 8

Deploy WordPress installation to Google App Engine.

Go to your Google App Engine Launcher. Click on Deploy option. Then put your E-mali and password for Deploy application to Google.

Step: 9

Install Google App Engine Plugins for WordPress

Before run your WordPress in Google App Engine you need to install Google App Engine Plugin in your local computer.  When installation will be complete you need to deploy WordPress by Google App engine. After deployed WordPress when you will log in it by using User ID and Password you will see that Google App Engine Plugin has been inactivated there. You have to activate this plugin to run WordPress in Google App Engine  then Add a sweet able theme for WordPress in Google App Engine.

See Also

Feature and Utility for new WordPress themes

What is Google Chrome Browser: Google Chrome Browser is an open source programme and it has launched in 2008 with different updated features. Google Chrome Browser is available for Windows, Linux, Mac OS X, iOS and Android operating system.

Google Chrome is most useful Web browser.There are many features in Google Chrome.But some times we properly can not utilize it. If we use it properly then it will work faster with better performance.Google Chrome has huge number of keyboard short cut to do your work quickly. So if you already not install this browser then install it to get its benefits. In this Article Some interesting tips about Google Chrome features we have share.

Some Google Chrome Features for Better Your Performance

Any Web Page save as PDF File

You can save any web page as PDF file by this Google Chrome Browser. To save any file as pdf, just open any web page then Press Ctrl+P button on Windows and select save as PDF at the time of printing from the printers list and download the page as a PDF file.(In this case no extensions will be required)

Compose Your Email from Address Bar

You can compose your email from address bar just go to the address bar of chrome browser and type the following command

mailto:[email protected] This Command will open the Gmail compose window and next it auto-fill the address in the To field.

Chrome Browser Reveal Your all Hidden Passwords

When we put any password Google Chrome can remember and auto-fill password but this password hidden with asterisks. You can reveal your hidden password using developer tools. It can change your imputing asterisk password as a text. Otherwise you can reveal your saved password using chrome://settings/passwords.

Select All history to Delete it Quickly

We can not delete all the web history in Google Chromes because here (in Chromes) does not have “Select All” button. If we want to delete more than one page at a time then We have to select each chekboxes.

Some Google Chrome Features for Better Your Performance

In this case we can select more page at a time using some tricks. At first click on 1st Check box, then hold shift key, after that select last check box.

Use Google Chrome as Text Editor

You can use Chrome as text editor.It works like notepad to your browser. To use Google chrome as text editor just open a new tab and the following link into your address bar.
data:text/html,<html contenteditable>
Next you can start your typing anywhere into your tab.

Set more than one bookmarks in toolbar

To set more than one bookmarks in toolbar of Google Chrome, just right click on any bookmark and select Edit option, then delete everything in the name filed. After save it Google Chrome will show only the sites fivicon to your toolbar. Thus you can set more tnan one bookmarks in same space.

Google Chrome as Media Player

Using Google Chrome browser you can view video, image, even PDF file from your desktop to Chrome video. To open any  video need not require any viewer application, just drag your image, text file, audio and video from desktop into chrome video.

Install Alternative version of Flash Player in Google Chrome

  • Download and install the appropriate system plug-in. 
  • Next type “about:plugins” (without quotation marks) into the address bar at the top of a Chrome browser window.
  • Click “Details” at the upper-right corner of the page.
  • Find the “Flash” (or “Shockwave Flash”) listing for the integrated plug-in on the page and click the corresponding “Disable” button. To identify the integrated plug-in, see the table of plug-in file names above.
  • Find the “Flash” (or “Shockwave Flash”) listing for the system plug-in on the page and click the corresponding“Enable” button. To identify the system plug-in, see the table of plug-in file names above.
  • Close all Chrome windows and restart the browser.
See Also

When we create any website, One thing we should know about the optimization of our blog or websites images. If our site not optimize properly by Google Search Engine then it will not grab traffic. So for better optimization or rank in Google search engine Optimization images, we need to optimize our blog as well as its images.If your image optimize properly then you will get more traffic by using image search.We know 90% of blogger use either blogger platform or WordPress and they must need to optimize their images for better performance of their website.

We know that many blogger gets traffic for there images form Google Image Search. When we use images, sometimes we cannot utilize it properly and we loss traffic for less image optimization. Even it effect on our website Bounce rate.<Read more how to Reduce Website Bounce Rate>

I think if you optimize your image properly then you will get good rank by Google Search Engine and your traffic also will be high then before.Here I mention some useful tips which will help you to increase your image optimization properly and your SEO will be better than previous.

image optimization

Some tips for image Optimization

Here are some tips for fast image optimization for your website. When Some blogger upload any images in their blog or post, they forget to format image properly. Most of the time they doesn’t compress there images for their post. We know that if we not compress our images then it takes lot of space and images would not be optimized properly.It will take more time to download image when any visitor visit your site and as a result, your site page speed optimization also very low then before which is very impotent factor for SEO. I have discussed below, how to increase and optimized image for your post.

Use Best Format for Optimize image

When we save any image to insert in blog post, We see different types of image format like JPG, GIF, PNG and many others.But after create blog every blogger should use better image format.I think the best image format is JPG. Because if you use this image format then it takes less size memory than others file format and Even it will help you to reduce website loading time.

Use WP Plugin for WordPress

If your site made you blog with WordPress, Before uploading your image into you blog or website, One things you should mind that Compressed image will help you to loading your website fast and if you not compress it properly then it takes more time to loading. You can use WP plugin for compress your images. This plugin compresses any image and then reduce their size.If you install This plugin for WordPress site then you will get best optimized feature from this plugin.

After download and install this plugin it automatically reduced your file size .when you upload any image into your blog this plugin will reduce image size without any lose of image quality.

Some features of WP plugin

  • It optimize JPEG file format
  • This plugin convert GIF file format to PNG file format
  • This plugin remove useless data from images.

<Read more How to Compress images by WP plugin>

<How to use WordPress SEO friendly images plugin>

Use keyword rich image name

If we download images from Google image or any others sources then we download it very easy method.But it should not download to your blog site directly.It requires something change before downloading image to your site. By default image format are looks like image234.jpg. You need to rename it with your post keyword name. Example: you can change image234.jpg into image-optimizations.Thus if you use keyword rich image name then it will come first in image search and your site optimized in search Engine.

Use Alt Text

In case of image optimization Alt text is too much important factor for your site or blog. By using alt tag search engine will get real concept about image.If you use alt tag in your image then Search Engine crawl your image quickly and your SEO rank will be better. So, we should use alt tag into our images before publish a post.You can know more information about how to add ALT tag  for image optimization.

Use Hyphen in Image name

One thing you should keep in mind when you rename your keyword rich image name, you need to separate your name by using hyphen. Do not separate your keyword rich image name with blank space or underscore. If you separate your image name by using blank space or underscore then Google Search engine does not crawl your image properly and your site rank also be down.

Re-size and crop your Image

Faststone tool

Best Image Optimization Tools: Before uploading image it is important to re-size and crop your image.You can use Photoshop to compress and re-size your image. Moreover You can use photo re-size tool to re-size your image.I think Faststone tool is a Best Image Optimization Tool. There are many features you will get in Faststone photo Re-sizer tool.<Download Faststone for image optimization>

Best Image Optimization Tools

Moreover you can use another image optimization tool that is MS paint by which you can re-size your image

Some features of this tool

  • This tool support different types of images like JPEG, PNG, GIF, BMP etc.
  • This tool can change color of the image.
  • It can re-size the images.
  • It can crop your images.
What is keyword density ratio? Keyword or keyword phrase is the most important factor for any blog or site.When you will create a website and want to better page optimization you should use keyword or keyword density ratio for SEO because the best keyword for blog will help you to increase page rank.
You have to use this keyword or Keyword Density Ratio with special Technic. When our keyword density will be  2% to 3% then it will be good for SEO. Suppose you used in your blog post near about 600 word and your total keyword in respect for this content is 18 times then it would be equal to 3%. This keyword density ratio will help us for Search Engine optimization as well as your page rank.

But using of more keyword not good for blog or site. When we will use more keyword in our blog then it will be treated as spam by Google. I mean if you use keyword 60 times out of 600 word then your keyword density ratio will be 10% which will affect on your site. Over density will  down your page and you will not get Google rank properly.So when you will use any keyword or keyword phrase, always try to  maintain proper keyword , Keyword density and proper place of keyword for better keyword optimization.

keyword density ratio

What is the best Keyword for Blog?

The best keyword for blog: If you want to search the best keyword for blog then you can get it from Google Suggest for the best keyword for blog .If you search something related to your topic then it will show you some suggestions and you need to follow this suggestions. if you follow this suggestion then it will help you to grab more traffic and page views. Now Google suggest inbuilt with Google Search engine.

Where You should use keyword

If you create blog in WordPress then you can use plugins for blog post to add keyword or keyword phrases. Otherwise we can use it manually. This tutorial will help you for where you should use  keyword for optimization.

Use blog keyword in Page title

Page title appears at the top of  our blog. We should mention our keyword at least one in our page title. If you can place proper keyword in  your page title then visitors attracted by it. When any visitors search any topic using any keyword which you have been mentioned into your page title then it will be effective to your keyword optimization and your page title will be appear in search rank with keyword.

Use blog keyword in Permalink

Permalink is the important part of your blog or site.You must be mentioned your  keyword in URL. When you will use keyword or keyword phrase, you should separate it by hyphen not separate it by using underscore.

Google Search Engine crawl your keyword from Permalink structure so you need to use keyword or keyword phrase into your permalink structure.

Always try to target useful keyword in your permalink structure and should avoid the keyword which is not so important.<The Best WordPress Permalink structure Guide>

Use blog keyword in Headline

Our Headline is another important for using keyword. You need to use  proper keyword in all heading such as headline1, headline2, headline3. By using this keyword in your heading tag you will be  able to discuss about the topic to your headline.

Visitors will get the information by this headline tag. So you need to use blog keyword in all the H1, H2 and H3 tag so that article reader interested by it and Google Search engine get proper information by it.

Use blog keyword in Body content

It is important point to use blog keyword into your body content. We can use our keyword in the first paragraph of  the article and last paragraph of the article for better SEO rank. When you will use keyword into your article always maintain its keyword density.

keyword density ratio

In previous I mention the proper  keyword density ratio for your article. If  we use over keyword density ratio, Hidden keyword, Irrelevant keyword then our website might be banned.

Use keyword in images and image alt attributes

Where You should use keyword in case of image ? You should use blog keyword at least on time to in image and image alt attributes. If you use this keyword properly then it will be better not only page optimization but also your image optimization. When visitors search any image they can go to inside your blog through images. So always use keyword in your image and images alt tag option.

the best keyword for blog

Use keyword in External link

I think use of keyword in external link is a good idea. Try to use your keyword at least one time in your External link. If we use keyword in outbound link then it will help us to your optimization page quickly and it will be the best keyword for blog.

<Read more what is External or Outbound link>

Use keyword in Meta description/Tags

Meta description is an important part of any blog site.When visitors search somethings and the searching keyword match with visitors keyword then it appear in search result.It will show the visitors in snippet of  search result.

By using keyword in meta description we can get more befits for Search Engine optimization. You can also use the best keyword in your meta tags for better optimization of your site.<Add meta tag plugin for best page optimization>

Note: We have to use keyword in proper way so that it looks natural for blog reader and Search engine. So always use the best keyword for your blog or website.

Google Adsense is an advertising program that permits publisher or anybody who want to put ads on their sites to insert HTML into their site and when it inserted then the ads appear into the targeted place with relevant content of your website

After create website or blog everyone want to get money from their blog. If you are a new blogger, You may required money by using your blog. For this, at first needs an Adsense account and then If your blog made with WordPress, then to insert ads you need Google publisher plugin for your blog. There are many WordPress plugin for AdSense ads and they work in many different way. I think the best is Google Publisher WordPress Plugin as its official plugin for Google Adsense for WordPress.

Official plugin of Google Adsense : Google has launched this new plugin which is call Google publisher plugin.Here, I will share you how to configure this plugin and how you use Google publisher plugin for your blog posts.I hope you will get great advantage by using this plugin for your website.Although, Google publisher plugin currently is in beta but the plugin makes it easier to use Google AdSense ads and Webmaster Tools with WordPress

How to Setup AdSense Google Publisher Plugin for WordPress

What is Best plugin for AdSense ? Google publisher plugin. If you want to use this plugin then at first you need an AdSense account.Now you need to install Google publisher plugin in your WordPress platform. After install it you need to activate it.After installation and activation Google publisher plugin, you need to do below step to place ads in your site.
Go to the Settings option of  the WordPress and if you successfully install Google publisher plugin, then you will find an option “Google publisher plugin” in the settings menu.Then to this Google publisher plugin > link it to your Google Adsense account.

AdSense Google Publisher Plugin

When you will set up this plugin you will get an another feature where you need to verified your site under Google Webmaster tool. If you not verified your site then you might be asked to verify your site in Google Webmaster tool.

verified your site

When your blog will be verified successfully, You will get the AdSense option. You need to click on Use my AdSense Account button for integration your AdSense Account.

After integration you will see Manage Ads button.If you click on this button your plugin will start analyzing your blog for Ads Placement.Then you will see the the places where AdSense ads can be inserted as per your suggest plus sine.

Google Publisher Plugin

This plugin will show you with Red colour + marks as above mentioned screen shot.You need to click on + marks option for insert Adsense code inside it as this plugin will help you add the code directly from the plugins area.You can able to preview your ads in your plugins panel to set best match ads.You also able to change text only or image only ads unit in every ads settings.You can place Google ads choice and placement also to place ads in your site without place ads manually.

Advantage of the Best plugin for AdSense Google publisher plugin in WordPress

Best Plugin for AdSense Google Publisher : In before when you add any ads in your blog post you should edit HTML and play with the code but here you need not to edit HTML or play code for insert any AdSense ads.If you click on any pin point then your ads will be added automatically.

This plugin will not allow to add any text-link ads but may be Google add it latter this features.As its official plugin of Google Adsense its has lot of opportunity to update latter.When you will select any ad placement you need to save and activate it.

In WordPress you will find different type of Ads based plugin but this plugin one of the best plugin by which any non technical blogger or technical also utilize it in their blog.It is easy for work.Moreover, It will help the all AdSense publisher to optimize their ads placement for better improvement.Google publisher plugin now in beta stage but it will help you more than before any plugins for your website or blog and you may also placing your ads using custom AdSense size with this.

When you create a blog or any website you may need to Embed PDF files in WordPress many times to provide more information to your blog readers.But many reader face problem as they can’t read the information of the PDF file without adobe reader.

You can embed this files in your  blog posts so that your readers can read it very easily.You can embed it very easily by using a WordPress Plugin.The plugin which is help you to embed your PDF files in website is ‘Google Doc Embedder’.

Embed PDF files in WordPress Blog Post

Before Embed PDF files in WordPress you have to download and install Google Doc Embedder plugin.By this plugin you can embed different types of file such as PDF, XLS,PSD, DOC, PPT,TIF.Dont Embed Google Docs because Google Docs API is to display locally hosted files in the blog not embedding from the Google Docs itself.

How to Download and Install Google Doc Embedder Plugin to Embed PDF files in WordPress Blog Post

Embed PDF files in WordPress

If you want to download this plugin you have to go your add Plugins option of your Dashboard. Here you will find a search box. Just put the Google Doc Embedder in search box and then search.Then you need to install it.After complete your installation click on Active option to active this plugin. When it will be activate you will see a GDE option in your Dashboard Settings.

Note: When you will use it don’t need to have a Google Doc account.

How to Embed PDF files in WordPress Blog Post

After installation and Activation Google Doc Embedder you have to go GDE settings to configure some basic settings. You may go to GDE settings through Settings option of your Settings tab. There are many option you will find in General settings option such as Viewer Mode, Default Language,Default size, File Base URL, Download link, Link Text, Link
Position, Link Behavior etc. You can select and change this option.

Embed PDF files in WordPress

You can change viewer mode section. If you select Enhanced viewer then you will find different option in toolbar such as page number, previous/ Next page, zoom in/out, full screen/New window.You can select any option by check mark.Moreover you can change the page area background color and page border color.

You can select your document width and height in Default size settings.In Download link section if you want to downloaded link visible to everyone than you have to select All Users by default or you can select just logged in users.

In Advance tab Option you can set how the plugin integrated in visual editor, you can also set maximum file size and set Error handling.You can Export and import file for backup and migration purpose.

How can you Embed PDF files in WordPress Blog Post page or post ?

After complete your installation you will get a g mark button which has added in your Visual editor.

Embed PDF files in WordPress

When you will click on this button a Google Doc Embedder window will be open.Put your PDF url in this URL or file name filed. Select width or height of document.You will find here a short code preview which will be generate automatically.

Google Doc Embedder window

Click on insert button to Embed PDF files in WordPress.Your blog readers read it without any Adobe Browser now.

After download and  install MySQL locally, you need to enable Google App Engine SQL in your Google App Engine Account. After creating Google App Engine Cloud SQL you need to deploy your local apps or WordPress in Google App Engine. For Creating Cloud SQL you need to enable billing system, it asks you your credit/debit card details but don’t worry Google deduct your balance as per your uses so there is nothing to worry about billing.

Before create Google Apps SQL in Google App Engine you need to register on Google Cloud Platform and give the name of your Cloud console project.When you will create Cloud console project you have to log on Google Cloud Platform and put your specific project name after that you need to follow some step to create MySQL database in Google App Engine.


Create MySQL Database in Google App Engine.

To create MySQL Database in Google App Engine you need to follow following steps.


In this step you have to go on your created project Name which you have been created in before. You have to Click on your project ID to enter it.


Here you will find different type option such as Overview, Permissions, Settings, Support. Click on Settings option of your project.


In settings option you will see different type of section like Billing, Delete project, Rename Project.In Billing section you need to click on Enable billing option to access the full set of service and increase usage limits.

Create MySQL Database in Google App Engine


When you click on Enable Billing option ‘Setup Your Billing Profile’ will be open.In billing profile section you have to mention Country or territory where your billing address is located.Then choose your language preference and what is your tax status.At last you have to fill up address form and credit/debit card details.

How to create new Cloud SQL instance


After complete your billing one things you need to create that is New Cloud SQL instance. Go to your Cloud console dashboard and click on your project. Here you will find Cloud SQL option.Click on it to create new Cloud SQL.


When you will create a new Cloud SQL instance you will be put your Instance ID, Region, Tier option, Billing Plan
(as Per Use use you need to set it)

How to import file into your new Cloud SQL instance.

In Cloud SQL dashboard you need to select Import option to import file into your new cloud SQL instance. When you click on import tab a new window will be appear to import detabase.In case of WordPress installation in Google App Engine There you should be mentioned Cloud Storage path (gs://appengine- php/setup.sql) and then click ok button.

Before you download and Setup MySQL for Google App Engine first I discuss about MySQL . A MySQL database is a web hosting database that is utilized to store site data like blog posts or user information. A MySQL database is the best linking database on the web today.A MySQL database is capable for storing any type of data that need to crate a website. It will give you a chance to rapidly store and retrieve data from the database. Different site visitor can utilize it at the same time simultaneously whenever they want to access your website. Here is some simple step you need to follow for download and setup MySQL  in your local computer before deploying in Google App Engine.In previous I have discuss about how to download and install Python and PHP SDK for Google App Engine now after install phython and PHP SDK you need to install mysql locally to deploy any type of php application like WordPress.

After install MySQL for Google App Engine locally , you also need to enable cloud SQL in your Google App Engine Account.After creating Google App Engine Cloud SQL you need to deploy your local apps or WordPress in Google App Engine. For Creating Cloud SQL you need to enable billing system and it asks about your credit/debit card details. Don’t worry, Google deduct your balance as per your uses so there is nothing to worry about high amount of deduction or its may be that its not deduct balance if your uses within free uses. You can pay as per uses in hour or daily plan.See the pricing section of Google App Engine  for more details about billing.

How to download and setup Mysql Locally


At first you have to go download section you will see MySQL Community Server.

Setup MySQL for Google App Engine


When you click on MySQL community Server, you will find download option for MySQL Installer MSI for Google App Engine SQL

Setup MySQL for Google App Engine


In MySQL-installer-community section you will find another download option and click on it.



Next click on just start my download option. Now MySQL will start  download in your local computer.

How to Install MySQL locally

How to Install MySQL locally


Before install Google Apps Database locally , you have to Download and install .NET Framework to run this MySQL.When install MySQL you will see different option such as Install Products, About MySQL and Resources. You have to click on Install MySQL Product option.Then check mark the I accept the license terms and click Next button.


Then you have to select Connect to Internet and Fetch Update information. Click Next option and click again Next option


Here you will see different selected option such as python, Microsoft.NET Framework, Microsoft Visual C++ which will be installed before the installed MySQL server


In this step you will see different product which will be installed except one product.


In this step you will see MySQL Server Configuration. Here put your MySQL Root Password and then click on Next option


In this step you will see MySQL Configuration Overview. You have to click on Next Option.At last you have to click on Finish Option.

Before you install WordPress or any simple application in Google app engine, in this tutorial I show you how you download and install python and PHP SDK for Google App Engine. Here is some simple steps you need to follow to install python and PHP SDK. Now you think , why I need to install python and PHP SDK  for running Google App Engine ?

Before installing  Google App Engine you need to download Python and App Engine PHP SDK application. After download python and PHP SDK application you need to install it to your local computer. First, you need to install Python and then PHP SDK application as Python help to run PHP SDK application to deploy anything in Google App Engine. In case of cPanel you may be aware that you need to install Filezilla or CuteFTP to upload anything in your server but here is nothing like that. Here, PHP SDK application deploy everything that you need to install in Google App Engine.

Use of Python in Google :

Python for running Google App Engine : Python is an Official language of Google.It is also the key language of Google alongside with others language such as C++ and Java.It runs many Google internal systems and show up many Google APIs.It is used in many places of Google such as Google App Engine, You Tube,, Open source libraries, Google Data python Client Libray, Google API Client Library etc.In case of Google App engine Python was the language which originally designed for it.Python allows building web applications with Python programming language, using its rich collection of libraries, tools and frameworks.To install python for running Google App Engine below tutorial help you.

How to download and install python


In this Google App Engine Tutorial At first you have to download python in your local computer from Python website


In download option you will see different types of formats for download python. Select any one format option which your want to download. Then click for download

Download php SDK


After download python , you have to  install python application set up wizard in your local computer.

python setup wizard
python setup wizard

When python will be installed completely then you have to download and install App Engine PHP SDK in your local computer which are mention below.

What is App Engine PHP SDK

PHP SDK for running Google App Engine : App Engine PHP SDK application deploy everything that you need to install in Google App Engine.  Before install App Engine PHP SDK you have to install Python as Python help to run PHP SDK application.

How to Download and Install PHP SDK for Google App Engine


At first you have to download PHP SDK for Google App Engine. Click for Download the latest PHP SDK for App Engine.


Next you will see that Google App engine msi will be download in your computer.

app engine install


When download will complete you have to go its set up option in your computer.


Google App engine

When you will Install Google App engine, you find this Setup Wizard then Click on next button and Select check mark (I accept terms and condition) Please Note: If you install Python before install Google app engine then you will find this massage in setup wizard that “Python found” otherwise you will find a massage that “makes sure that you install python” .If you do not  install python and google app engine same version then its can be also makes trouble to install properly.

Google App engine_step_2

after install Google app engine you have to finish the wizard.

Google App engine_step_7

After download both python and App Engine PHP SDK in your local computer you need to download and setup MySQL in your local computer for Google App Engine.

How Does Google Search Work ? When you create a website or blog, your site crawled by Google bot or Google Crawler and indexed your page in Google search engine.After indexing, Search engine rank your content and it will come in to the Google search result.You have to maintain your blog content for fast crawling and indexing. If  your blog content fast crawl and index then content will be fast in Google search result. otherwise, if the content is not not crawl and indexed, then your page content also will not come in to the Google search result.

If your site will come fast in your search result then It will be good for your SEO rank.In previous we have discussed how to increase your SEO rank and how to Google index website quickly. Here I discussed why Google Crawler Not Crawling/indexing webpage for your website or blog site.

What is Google Bot or Google Crawler ?

Google Bots is a spider which crawl your page content that you publish in your website or your blog. Google sent this Google bot to your site for crawling your content.

google bots

How Google Crawlers Work ? What is Crawling ?

How Web Crawlers Work ?Google Crawler or Google bots (spider) will crawl your site when you post something in your site. Google does not have any worker for crawling your site, They use an auto program software for this Purpose. Its think about the Page Rank, Back Links before crawling. You can get faster crawling with sitemaps. But, there is no guarantee that Google will crawl anything that you put in your sitemap. Sitemap will simply let the Google know about your site content.

What is indexing?

How Does Google Search Works in case of indexingA lots of people now depend on Google. They just search everything through Google Search engine that they don’t know. How we get all the information which we want to search? When any blogger post any blog then Google sent their Google bots or Google Crawler for crawling then index it. After indexing this page it comes in Google search engine according to rank and people get their search result. When Google sent bots then their spiders start for crawling. When the bots get new content or edited content then they send information back to Google. After that Google stored this information in Google rank and indexed.But if you have internal and external duplicate content in your page then you may face problem in indexing.

Not update properly:

If your content of webpage is too old but you do not update this content then you have to face late indexing of your page. It may take many days. If your site is new then sometimes it takes more time to indexing page.So you have to update your page properly for indexing by Google bot or to take more time for Google Crawler.

Use Proper URL

Some URL are restricted for indexing to avoid duplicate content for your website. If your content cover with duplicate content than it create many problem for indexing.

XML sitemap:

This site map will help you to crawling  page of your website for Google Crawler .When you create XML sitemap and submit it in your Google Webmaster Tools it help to crawling your page fast. If you do not submit your XML sitemap then Google bot or Google Crawler not indexing properly.

Internal Link Structure:

When you will create a website Ensure that all of your pages are interlinked with each other. Especially if your site’s home page has been indexed make sure all the other pages are inter connected with it so they will be indexed too, but make sure there are not huge number of links on any given page.

Google plus Profile:

If you Create a Google+ profile and add a link to your site in the About section then it will be better for your site indexing and to stay Google Crawler take more time on your site . You must have to Add posts to Google plus containing links to your site. Google+ is a Google product the Google bot or Google Crawler will pay attention to these links. You will also get benefit from other popular social media profiles for your website.

Fetch as Google:

You have to go into Google Webmaster tools. Then you will see a section which is called Fetch as Google.It will help you to crawl new pages and pages with updated content.Here you will find text box where type your URL path and click on FETCH option.If your fetch status update with Successfully then click on Submit to index.

google bots

Here you can submit individual URLs or URLs containing links to all the updated content of your website.