File: Env.customer.container.example.md

Recommend this page to a friend!

Packages of Ramesh Narayan Jangid (Sharma)

Env.customer.container.example.md

File:	`Env.customer.container.example.md`
Role:	Auxiliary data
Content type:	`text/markdown`
Description:	Auxiliary data
Class:	Open Swoole Microservices Implement microservices using Open Swoole
Author:	By Ramesh Narayan Jangid (Sharma)
Last change:	refactor refactor
Date:	14 days ago
Size:	`5,473 bytes`

Download

Container

In this package the Container are Database / Caching tools used for maintaining dynamic data.

Server configuration Example

Global Cache Server configuration (Redis)

; Cache Server configuration
gCacheServerType='Redis'
gCacheServerHostname='127.0.0.1'
gCacheServerPort=6379
gCacheServerUsername=''
gCacheServerPassword=''
gCacheServerDatabase=0

Global Database Server configuration - global.sql

; Database Server configuration
gDbServerType='MySql'
gDbServerHostname='127.0.0.1'
gDbServerPort=3306
gDbServerUsername='username'
gDbServerPassword='password'
gDbServerDatabase='<global>'

; Tables in <global> database on the server
groupTable='group'
customerTable='customer'

Setting Cache / Database Server configuration in customer table for working

These Global Cache Server configuration (Redis) and Global Database Server configuration config key's should be set in customer table in below columns respectively for each customer.

`customer`.`master_db_server_type` varchar(255) NOT NULL,
`customer`.`master_db_server_hostname` varchar(255) NOT NULL,
`customer`.`master_db_server_port` varchar(255) NOT NULL,
`customer`.`master_db_server_username` varchar(255) NOT NULL,
`customer`.`master_db_server_password` varchar(255) NOT NULL,
`customer`.`master_db_server_db` varchar(255) NOT NULL,
`customer`.`master_db_server_query_placeholder` varchar(255) NOT NULL,
`customer`.`slave_db_server_type` varchar(255) NOT NULL,
`customer`.`slave_db_server_hostname` varchar(255) NOT NULL,
`customer`.`slave_db_server_port` varchar(255) NOT NULL,
`customer`.`slave_db_server_username` varchar(255) NOT NULL,
`customer`.`slave_db_server_password` varchar(255) NOT NULL,
`customer`.`slave_db_server_db` varchar(255) NOT NULL,
`customer`.`slave_db_server_query_placeholder` varchar(255) NOT NULL,
`customer`.`cache_server_type` varchar(255) NOT NULL,
`customer`.`cache_server_hostname` varchar(255) NOT NULL,
`customer`.`cache_server_port` varchar(255) NOT NULL,
`customer`.`cache_server_username` varchar(255) NOT NULL,
`customer`.`cache_server_password` varchar(255) NOT NULL,
`customer`.`cache_server_db` varchar(255) NOT NULL,
`customer`.`cache_server_table` varchar(255) NOT NULL,

Note: Only the Key detail in the environment file are to be set in columns of respective record. Eg. for column master_db_server_hostname the value to be set is 'gDbServerType' and not '127.0.0.1'. The configured values for the Key are picked from the env files.

The slave detail can take same values as master if presently your system doesn't have such implementation.

Setting Cache / Database Server configuration in customer table for working

Different database on Database server

If there is a requirement from customer X to have a dedicated database like <database-x> on the database server one can do this.

Make a new config variable as below and set this Key in the above table for customer X record in customer table.

cDatabaseServerDatabase='<database-x>'

Dedicated Database Server

If the same customer X in future prefer to have a dedicated database server one can do this as well.

Make a new config variables as below and set this Key in the above table for customer X record in customer table.

Customer Cache

; Supported Container - Redis / Memcached / MongoDb
cCacheServerType001='Redis'
cCacheServerHostname001='127.0.0.1'
cCacheServerPort001=6379
cCacheServerUsername001='kartik'
cCacheServerPassword001='shames11'
cCacheServerDatabase001=0
cCacheServerTable001='customer_001'      ; For MongoDb

Dedicated Database

; Supported Container - MySql / PostgreSql
cDbServerType001='MySql'
cDbServerHostname001='127.0.0.1'
cDbServerPort001=3306
cDbServerUsername001='username'
cDbServerPassword001='password'
cDbServerDatabase001='customer_001'
cDbServerQueryPlaceholder001='Named'; Named(:param) / Unnamed(?)

Going forward

One can on similar lines can configure slaves server detail or a dedicated master / slave cache servers.

The query_placeholder column

These column contains key's containing detail about the way the queries are build to use data provided for SQL's'

`customer`.`master_db_server_query_placeholder` varchar(255) NOT NULL,
`customer`.`slave_db_server_query_placeholder` varchar(255) NOT NULL,

Named(:param)

-- Named(:param)
INSERT INTO `user` SET `firstname` = :firstname;

Unnamed(?)

-- Unnamed(?)
INSERT INTO `user` SET `firstname` = ?;

Global Cache hit configurations can be set as below.

Below settings are not to be configured in any table. They are used as it is. Only need to make required config value changes in below.

; Supported Container - Redis / Memcached / MongoDb
queryCacheServerType='Redis'
queryCacheServerHostname='127.0.0.1'
queryCacheServerPort=6379
queryCacheServerUsername='username'
queryCacheServerPassword='password'
queryCacheServerDatabase=0
queryCacheServerTable='api_cache' ; For MongoDb