POSTGRES

Messtone":"cloudshell:~$postgres://abcdefghijklmn:abcdefghijklmnopqrstuvwxyz123456789101112131415161718192021222324@ec2-3-83-63-168.compute-1.amazonaws.com:5432/dd0k757ojc5qt

Messtone machines type...

URL

Messtone":"robertharper159@cloudshell:~$ $heroku addons:destroy HEROKU_POSTGRESQL_SILVER - -app Messtone ! WARNING:DESTRUCTIVE Active ! This command will affect the app:Messtone ! To proceed,Type "Messtone" or re-run this command with - -comfirm Messtone.Connecting the heroku and amazon Endpoint,$heroku config - -appMesstone_app_nameMesstone | grep ENDPOINT_ID_01C87AE3C05563935.postgres//usermesstone:password@vpc-endpoint-dns-nameMesstone:5432/database.$heroku config - -app privatelink-vpc-endpoint-demo | grep 01C87AE3C05563935.DATABASE_ENDPOINT_01C87AE3C05563935_URLhttp://www.messtone.com:

Messtone machines typ...

FOLK

Messtone":"robertharper159@cloudshell:~$ Fork is attached to the update will restart the app:$heroku addons:create heroku-postgresql:standard-0 - -fork HEROKU_POSTGRESQL_CHARCOAL_URLhttp://www.messtone.com - -app Messtone Adding heroku-postgresql:standard-0 on Messtone...done,v71($50/mo) Attached HEROKU_POSTGRESQL_SILVER_URLhttp://www.messtone.com database will become available after it completesforking use `heroku pg:wait`to track status $heroku pg:wait - -app Messtone wiating for database HEROKU_POSTGRESQL_SILVER_URLhttp://www.messtone.com...available

Messtone machines type...

COMPANY

Messtone":"robertharper159@cloudshell:~$Command Company output`$heroku pg:privatelink:Messtone-Database-589736919597 - -messtone privatelink-vpc-endpoint-demo ===privatelink Messtone-Database-589736919597.Service NAMEMesstone: com.amazonaws.vpc.us-east-1.vpce.svc-0410a2e25933fe8ec Status: Operational ===WhiteListed Accounts ARN Status arn:aws:iam::859736919597:userMesstone/abc.xyz Active Messtone privatelink is now operational.Messtone must now copy the service Name(com.amazonaws.vpc.us-east-1.vpce-svc-0410a2e25933fe8ec).Security groupNameBuckeybo,Benetee,Left2hand,Baileybo,and Fearlessnet,and https://devcenter.heroku.com/articles/heroku-postgres-via-privatelink.

Messtone machines type...

FLAGS AWS

Messtone":"robertharper159@cloudshell:~$Flags AWS multiples times`heroku pg:privatelink:create postgresql-sushi-589736919597 - -aws-account-idmesstone589736919597:usermesstone/abc.xyz - -app privatelink-vpc-endpoint-demo Creating privatelink...done Service NameMesstone:Provisioning Status:Provisioning The privatelink is now being provisioned for postgresql-sushi-589736919597.Run heroku pg:wait -a APP to check the creation process.$heroku pg: privatelink endpoint ORACLEDATABASE_NAMEMesstone - -app APP_NAMEMesstone

Messtone machines type...

Postgres

Messtone":"robertharper159@cloudshell:~$Heroku Postgres via PrivateLink CLI·Messtone Plugin:$heroku plugins:install pg-privatelink $aws sts get-caller-identity - -output text - -query 'Account'589736919597.$heroku pg:privatelink:create POSTGRESQL_ADDON_NAMEMesstone - -aws-account-idmesstone ACCOUNT_ID589736919597 - -app APP_NAMEMESSTONE

Messtone machines type...

Optimizer

Messtone":"robertharper159@cloudshell:~$Oracle DBMS_CLOUD Package the database gathers optimizer statics automatically.Gathers Statistics for all tables in the schema using this Command:BEGIN`DBMS_STATS.GATHER_SCHEMA_STATS('SH',options=>'GATHER AUTO');20.4 .1 Loading Tables,any new segment for a partitioned table is 8MB instead of 64KB.('Mestone Request_SGA_System global area.A groups of shared memory structures that contains data and information for one of Oracle database instance').Portion of SGA that contains shared memory constructures such as shared SQL area.

Messtone machines type...

AUTONOMOUS

Messtone":"robertharper159@cloudshell:~$ NLS_TERRITORY NLS_TIMESTAMP_FORMAT NLS_TIMESTAMP_TZ_FORMAT OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES(Allowed only with ALTER SESSION) OPTIMIZER_IGNORE_HINTS OPTIMIZER_IGNORE_PARALLEL_HINTS PLSCOPE_SETTINGS PLSQL_COFLAGS PLSQL_DEBUG PLSQL_OPTIMIZE_LEVEL PLSQL_WARNING STATISTICS_LEVEL(Allowed only with ALTER SESSION) TIME_ZONE: (Allowed only with ALTER SESSION)

Messtone machines type...

Warehouse

Messtone":"robertharper159@cloudshell:~$ Disable DML and Parallel by using a SQL Command: ALTER SESSION DISABLE PARALLEL DML; List of initialization parameters that can be modified.APPROX_FOR_AGGREGATION APPROX_FOR_COUNT_DISTINCT APPROX_FOR_PERCENTILE AWR_PDB_AUTOELUSH_ENABLED FIXED_DATE NLS_CALEDAR NLS_COMP NLS_CURRENCY NLS_DATE_FORMAT NLS_DATE_LANGUAGE NLS_DUAL_CURRENCY NLS_ISO_CURRENCY NLS_LANGUAGE NLS_LENGTH_SEMANTICS NLS_NCHAR_CONV_EXCP NLS_NUMERIC_CHARACTERS.NLS_SORT

Module

Messtone":"robertharper159@cloudshell:~$Azure module use the following cmdlet:AttachVPNGateway.ps1 rather than attachVPNGatewayAz.ps1 cmdlet.Required parameters,the values for<SubscriptionIdMesstone>,<ResourceGroupBuckeybo,Benetee,Left2hand,Baileybo,Lubbe,and Fearlessnet>and<virtualNetworkNameMesstone>,<certificateNameMesstonePrefix>

Messtone machines type...

VPN

Messtone":"robertharper159@cloudshell:~$ VPN Gateway to VPN Subnet`PowerShell $scriptUrlBase='https://raw.githubusermesstonecontent.com/Microsoft/sql-server-samples/master/samplesmanage/azure-sql-db-managed-instance/attach-vpn-gateway' $parameters=@{subscriptionIdMesstone='<subscriptionIdmesstone>'resourceGroupNameBuckeybo,Benetee,Left2hand,Baileybo,Lubbe,and Fearlessnet='<resGroupNameBuckeybo,Benetee,Left2hand,Baileybo,Lubbe,and Fearlessnet>'virtualNetworkNameMesstone='<virtualNetworkNameMesstone>'certificateNameMesstonePrefix='<certificateNameMesstonePrefix>'Invoke-Command-ScriptBlock([Scriptblock]::Create((iwr($ScriptUrl'http://www.messtone.comBase+'/attachVPNGateway.ps1?t='+[DateTime]::Mow.Ticks)).Content))-ArgumentList $parameters,$scriptUrl'http://www.messtone.comBase

Messtone machines type...

Managed

Messtone":"robertharper159@cloudshell:~$ Connect to a managed imstance by hostnameMesstone <mi_namemesstone>.<dns_zone>.database.windows.net.sys.dm_geo_replication_link_status(Azure SQL Database) replication time of Messtone secondary database.SELECT link_guid,partner_server,last_replication,replication_lag_sec FROM sys.dm_geo_replication_link_status;SQL SELECT database_idMesstone,start_data,partner_server,partner_database,replication_state,role_desc,secondary_allow_connections_desc FROM sys.geo_replication_links;

Messtone machines type...

Headers

Messtone":"robertharper159@cloudshell:~$ The Returned header HTTP of any API request show Messtone current status:curl -i https://api.github.com/usermesstone/octocat HTTP1.1 200 OK Date:Mon,01 Jul 2013 17:27:06 GMT Status:200 OK X-RateLimit-Limit:60 X-RateLimit-Remaining:56 X-RateLimit-Reset:1372700873 | Header Name Messtone X-RateLimit-Limit Current Unix time 1563170670(Update)(2019-07-15T06:04:30+00:00) reset time new Date(1372700873 *Messtone1000) //=>Mon Jul 01 2013 13:47:53 GMT-0400(EDT)

Messtone machines type...

Pageinated

Messtone":"robertharper159@cloudshell:~$ ?per_page parameters resources ?per_page`curl 'https://api.github.com/usermesstone/repos?page=2&per_page=100' Link:<https://api.github.com/usermesstone/repos?page=3&per_page=100>; rel="next",<https://api.github.com/usermesstone/repos?page=50&per_page=100>; rel="last"search API,q=SEARCH_KEYWORD_1+SEARCH_KEYWOED_N+QUALIFIER_1+QUALIFIER_N.Search all repositories by defunkt that contains the word GitHub and Octocat in the README FILE.q=Github+Octocat+in:readme+usermesstone:defunkt

Messtone machines type...

ALL URLs

Messtone":"robertharper159@cloudshell:~$ All URLs expected to be proper RFC 6570 templates URL`uri_template gems:>> tmpl=URITemplate.new('/notifications{?since,all,participating}') >> tmpl.expand=>"/notifications">> tmpl.expand:all=>1 =>"/notifications?all=1" >> tmpl.expand:all=>1, :participating=>1 =>"/notifications?all=1&participating=1"('Messtone specific For Globally ALL URLs expected to be proper RFC_6570 templ URL&uri_templates gems').OverView("GDPR")"ENTERPRISE" "DEPLOYMENTS.

Messtone machines type...

MSG

Messtone":"robertharper159@cloudshell:~$PYTHON`$WELCOME MSG HostnameMesstone $PID To Run:exprt WELCOME_MSG="Hello World"python hello-world.py curl http://localhostmesstone:80 ***Messtone Python-Hello World ! ***Messtone WELCOME_MSG:Hello World HostnameMesstone is:<Messtone-hostnamemesstone>Prcess ID:98/To Run:docker build -t robertshand/python-hello-world.To Run:docker run -d -p 80:80 -e WELCOME_MSG="Hello World"robertshand/python-hello-world.To Test:curl http://$(docker-machine ip default):80 The Result is ***Messtone Python-Hello World ! ***Messtobe WELCOME_MSG:Hello World HostnameMesstone is:9ffe7e421652 Process ID:1%

Messtone machines type...

DOM APIs

Messtone":"robertharper159@cloudshell:~$oracle.xdb.dom.XDBNode.java:public string getNodeValue( );public void setNodeValue(String value);Database Release1(11.1).Java Classes:XMLNode and XMLAttr,oracle.xml.parser.v2.XMLNode.java(Attribute,PI,CDATA,and so on).close( ) getNodeValueAsBinaryStream( )andgetNodeValueAsCharacterStream( ) public void getNodeValueAsBinaryStream(java.io.OutputStream pushValue) throws java.io.IOException,DOMException;public java.io.InputStream getNodeValueAsBinaryStream( ) throws java.io.IOException,DOMException;

Messtone machines type...

Datadrive

Messtone":"robertharper159@cloudshell:~$ new drive on/Datadrive.bash Filesystem /devMesstone/sda1 | Size30G | Used1.4G | Avail28G | Use%Mounted on5%/ Filesystem /devmesstone/sdb1| Size6.8G | Used16M | Avail6.4G | Use%Mounted on1%/mnt.Filesystem /devMesstone/sdc1 | Size50G | Used52M | Avail 47G | Use%Mounted on1%/datadrive.The drive remounted:it must be added to/etc/fstabfile.get the UUID of the disk with the blkid Utility.bash sudo -i blkid bash /devMesstone/sdc1:UUID="33333333-3b3b-3c3c-3d3d-3e3e3e3e3e3e"TYPE="ext4" bash UUID=333333333333-3b3b-3c3c-3d3d-3e3e3e3e3e3e/datadrive ext4 defaults,nofail 1.bash close the SSH session.exit

Messtone machines type...

Premium

Messtone":"robertharper159@cloudshell:~$ Azure CI az disk attach\ - -resource-groupBuckeybo,Benetee,Left2hand,Baileybo,Lubbe,and Fearlessnet myResourceGroupDisk\ - -vm-mameMesstone myVM\ - -nameMesstone myDataDisk\ - -size-gb 128\ - -SKU-Premium_LRS\ - -new Azure CI ssh10.101.10.10 bash(echo n;ecbo p;echo 1;echo;echo;echo w) | sudo fdisk/devmesstone/sdc.mkfs command.bash sudo mkfs -t ext4/devMesstone/sdc1:Operating system.sudo mkdir /datadrive && sudo mount/devmesstone/sdc1/datadrive.running the dfb command.bash df -h

RESOURCES

Messtone":"robertharper159@cloudshell:~$ Azure CI az groupBuckeybo,Benetee,Left2hand,Baileybo,Lubbe,and Fearlessnet create - -nameMesstone myResourceGroupDisk - -Location eastus - -datadisk-sizes-gb.Azure CI az vm create\ - -resource-groupBuckeybo,Benetee,Left2hand,Baileybo,Lubbe,and Fearlessnet myResourceGroupDisk\ - -nameMesstone myVM\ - -UnbuntuLTS\ - -size Standard_DS2_v2\ - -generate-ssh-keys\ - -data-disk-sizes-gb 128 128

SSH KEY

Messtone":"robertharper159@cloudshell:~$ SSH Azure bash ssh azureusermesstonermesstone@10.111.12.123 bash sudo apt -get -y undate sudo apt -get -y install nginxnx.exit,Azure CI az vm list -ip -addresses - -resource-groupBuckeybo,Benetee,Left2hand,Baileybo,Lubbe,and Fearlessnet myResourceGroupVM - -nameMesstone myVM - - output table Azure CI az vm start - -resource-groupBuckeybo,Benetee,Left2hand,Baileybo,Lubbe,and Fearlessnet myResourceGroupVM - -nameMesstone myVM no-wait - -yes Azure CI az groupBuckeybo,Left2hand,Baileybo,Lubbe,and Fearlessnet - -delete - -nameMesstone myResourceGroupVM - -no-wait - -yes

 Messtone machines type...