This is C# application which demonstrates Look-Aside caching pattern and leverages Gemfire Native Client with Pivotal Cloud Cache(PCC) and Pivotal MySQL v2 instance.
This is a service that requests customer information from a CloudFoundry hosted Customer Search service and caches them in PCC. You will then see that fetching the same customer information again from cache which will eliminates the expensive call to retrieve customer information from MySQL.
The Customer Search service has the following APIs:
- GET /showcache?count={amount} - get all customer info in PCC
- GET /clearcache - remove all customer info in PCC
- GET /showdb?count={amount} - get all customer info in MySQL
- GET /cleardb - remove all customer info in MySQL
- GET /loaddb?amount={amount} - load {amount} customer info into MySQL
- GET /lookasidesearch?keyword={Name} - get specific customer info by customer name and put entries into PCC
- GET /countdb - get count info from db
- GET /countcache - get count info from PCC
1.PCF2.4+ env:
Pivotal Cloud CacheserviceMySQL for Pivotal Cloud Foundry v2servicePivotal Application Service for Windows(PASW)with windows2016 stack and "binary buildpack or HWC buildpack"
2.Windows OS:
- Visual Studio Professional 2015
- .Net Framework4.6.1
- cf cli (version 6.43.0+815ea2f3d.2019-02-20) https://github.com/cloudfoundry/cli
- Pivotal Gemfire Native Client 10.0.0.2 http://gemfire-native.docs.pivotal.io/100/gemfire-native-client/install-upgrade-native.html
3.This project is using the below packages:
<packages>
<package id="BouncyCastle" version="1.8.3.1" targetFramework="net461" />
<package id="Faker.Net" version="1.1.1" targetFramework="net461" />
<package id="Google.Protobuf" version="3.6.1" targetFramework="net461" />
<package id="JsonPath" version="1.0.5" targetFramework="net461" />
<package id="Microsoft.AspNet.WebApi.Client" version="5.2.7" targetFramework="net461" />
<package id="Microsoft.AspNet.WebApi.Core" version="5.2.7" targetFramework="net461" />
<package id="Microsoft.AspNet.WebApi.Owin" version="5.2.7" targetFramework="net461" />
<package id="Microsoft.AspNet.WebApi.OwinSelfHost" version="5.2.7" targetFramework="net461" />
<package id="Microsoft.Owin" version="4.0.1" targetFramework="net461" />
<package id="Microsoft.Owin.Diagnostics" version="4.0.1" targetFramework="net461" />
<package id="Microsoft.Owin.FileSystems" version="4.0.1" targetFramework="net461" />
<package id="Microsoft.Owin.Host.HttpListener" version="4.0.1" targetFramework="net461" />
<package id="Microsoft.Owin.Hosting" version="4.0.1" targetFramework="net461" />
<package id="Microsoft.Owin.SelfHost" version="4.0.1" targetFramework="net461" />
<package id="Microsoft.Owin.StaticFiles" version="4.0.1" targetFramework="net461" />
<package id="MySql.Data" version="8.0.16" targetFramework="net461" />
<package id="NBuilder" version="6.0.0" targetFramework="net461" />
<package id="Newtonsoft.Json" version="9.0.1" targetFramework="net461" />
<package id="Owin" version="1.0" targetFramework="net461" />
</packages>
4.Gemfire9.X installation where we need to use gfsh to manage PCC cluster.
Step1:
Download this project to a local env and then unzip it into windows env which has installed vistual studio professional 2015 such as [pccpad_path]=C:\work\pcc\pccpad_nativeclient.
Step2:
From pcf app manager
- create a pcc service such as name as
pcc-devand then create a service key such as name aspcc-dev_service_key. - create a mysql service such as name as
MysqlForNCand then create a service key such as name asmysqlservicekey.
Step3:
From Windows OS
- Open pccpad.sln with visual studio professional 2015.
- Add [pivotal-gemfire-native1002_HomePath]\bin\Pivotal.GemFire.dll to project's reference.
- Compile this project by running
build-->build solutionfrom visual studio menu. It will generalte pccpad.exe underpccpad_nativeclient\pccpad\bin\x64\Releasefolder. - Open
[pccpad_path]\manifest.yml, change the name + path + stack + buildpack + services naming accordingly. - Push this application with cf command:
cf push -c "pccpad.exe"from the same folder with manifest.yml.
Since we are using binary buildpack, -c option is necessary to specify the custom start command.
Step4:
Logging into PCC cluster by gfsh with vcap env variable info which is recorded in service key=pcc-dev_service_key.
macuser:gemfire971 macuser$ gfsh
_________________________ __
/ _____/ ______/ ______/ /____/ /
/ / __/ /___ /_____ / _____ /
/ /__/ / ____/ _____/ / / / /
/______/_/ /______/_/ /_/ 9.7.1
Monitor and Manage Pivotal GemFire
gfsh>connect --use-http --skip-ssl-validation --url=https://cloudcache-6b8b9b61-2d39-4928-bb06-cf41598055cb.run.pcfone.io/gemfire/v1 --user=cluster_operator_57Z2ueingjHQrgwIAB389w --password=xxxxxx
key-store:
key-store-password:
key-store-type(default: JKS):
trust-store:
trust-store-password:
trust-store-type(default: JKS):
ssl-ciphers(default: any):
ssl-protocols(default: any):
ssl-enabled-components(default: all):
Successfully connected to: GemFire Manager HTTP service @ https://cloudcache-6b8b9b61-2d39-4928-bb06-cf41598055cb.run.pcfone.io/gemfire/v1
gfsh>create region --name=/customer --type=PARTITION
Member | Status
------------------------------------------------ | -----------------------------
cacheserver-a47426d8-87a9-41c4-95b9-f4291160e41f | Region "/customer" created ..
Step5:
Open this app by cf app pccpad's application URL.