Project Deliverable 3 - Infrastructure Design PDF

Preview

Summary

PROJECT DELIVERABLE 3: INFRASTRUCTURE DESIGN 1Theresa Weirbach Information Tech. Capstone CIS498003VA016-1222- Project Deliverable 3: Infrastructure Design February 12, 2022Overview The demanding environment of e-commerce brings challenges and opportunities for enterprises. The ones that will surviv...

Description

PROJECT DELIVERABLE 3: INFRASTRUCTURE DESIGN

1

Theresa Weirbach Information Tech. Capstone CIS498003VA016-1222-001 Project Deliverable 3: Infrastructure Design February 12, 2022

INFRASTRUCTURE DESIGN

2 Overview

The demanding environment of e-commerce brings challenges and opportunities for enterprises. The ones that will survive will need to innovate and invent new ways of creating value continuously. (1, 306) The company’s infrastructure is integral, and its capabilities are vital for the business to succeed in the rapidly changing environment in which we need to compete for our business. (1, 308) This document serves as the design layout for the infrastructure of Dusty Ducklings Farm and Homestead. It is with great honor that the proposed infrastructure of the company is built to stand the tests of time in this very competitive environment and assist in Dusty Duckling’s ability to achieve greatness. The most important aspect of this planning is to understand the requirements and expectations of the company. According to INTL, a comprehensive guide for IT service management, “IT infrastructure is defined as a combined set of hardware, software, networks, facilities, etc. (including all the information technology-related equipment) used to develop, test, deliver, monitor, control, or support IT services. Associated people, processes, and documentation are not part of IT Infrastructure.” (2) This document will detail the specifics of this infrastructure. A. Major Software and Hardware Components The infrastructure of Dusty Ducklings will allow us to deliver our products to customers. It is fundamentally important because it will affect the quality of service regarding the speed and responsiveness that we will provide to our customers. It links our company to our customers, suppliers, and vendors alike. This section offers a view of the system and its functionality. Dusty Ducklings will operate mainly as cloud-based infrastructure, utilizing Amazon Relational Database Service (RDS) to save space and cost. Amazon RDS will allow us to set up, use quickly, and scale a relational database in the cloud. It has a resizable capacity and automates

INFRASTRUCTURE DESIGN

3

time-consuming tasks like hardware provisioning, database setup, patching, and backups. We will only pay for what we use. Amazon RDS provides us with a choice of various instance types. We will be using T Type Instances, specifically T3. T Type allows for Burstable Performance. Since we will require a stable baseline performance with occasional peaks in demand, this will work best for us. (4) We also are given three storage options. We will be going with Provisioned SSD Storage. It does cost more. However, it provides more consistent performance than the other two options, which is essential for e-commerce. (4) Amazon RDS also gives us six database engine types to choose from. We have chosen to use MySQL, which is more customizable, accessible, and open source. We don’t want to rely on the cloud for our database at our core. We will utilize a physical onsite backup server and Amazon’s cloud-based server environment. This is also known as a hybrid cloud model. The cloud database will be responsible for organizing, managing, and processing all our data related to inventory, customers, and vendors. This information will be backed up on the cloud and a backup server, hosted in the networking room, in case of any failures or intrusions. Also in the networking room will be a Cisco switch and router. Network cabling is one of the most critical aspects of the design. This needs to be reliable so as not to cause system outages. Cat 6A cables will be used throughout the building, both in the office and warehouse areas. Cat 6A runs on a standard frequency of 500 MHz and speeds of 10 Gbps for up to 100 meters. They also allow for Wireless Access Points which will be necessary, especially in the warehouse where the router competes with thick concrete and steel. (5) We will have three wireless access points. There will be two in the warehouse (one at either end) and one in the office.

INFRASTRUCTURE DESIGN

4

There will be overhead monitors that live stream orders directly from the cloud database server in the warehouse. Orders will also be fed through industrial Bluetooth headsets to the order pickers. There will be three desktop computer stations and three laser printers to print packing slips and shipping labels. These computers will also directly interface with FedEx. The office will consist of six computer stations. This will later be expanded based on company needs. Each office employee will have a laptop, a pluggable docking station that connects to the laptop, internet, monitors, keyboard, and mouse. There will be one laser printer in the office. Avaya VoIP will be utilized for the phone system. Microsoft Office 365, including MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, and MS Outlook, will be installed on each laptop and desktop throughout the company. Google workspace will be our provider for our internal domain. This allows for domainspecific company emails, virtual conference rooms, interoperative office files, calendars, storage, and group-based policy controls. Public network components, i.e., UI Client, will consist of a scalable website on both desktop and mobile platforms and an application for Android and iOS. The website or application will send orders and customer information to the database and the warehouse. The customer will pay for their order right on the application or website, and encrypted payment info will be sent to the payment gateway/processor. We will be funded the following business day. Security is also a significant factor. Each laptop will also have a VPN installed that will send a code to the office employee’s cell phone to be input into the computer to connect to the network. This will be mandatory to access the network when not hardwired, such as when an employee is working from home. Each building entrance will be equipped with a digital keypad. The networking room will also have digital key card access. Security cameras will be placed

INFRASTRUCTURE DESIGN

5

throughout the interior and exterior of the building. All computers will utilize Windows Firewall for internal and external traffic. Specific rules will be in place to eliminate threats. 2. Hardware and Software Design The last section outlined the components of our infrastructure. This section will detail the specifics of the hardware and software design. I.

Software Design: a. MySQL: This will be downloaded from http://dev.mysql.com/downloads/installer/ using the online installation version (MySQL-installer-web-community-.exe). We will be utilizing version 8 for Windows (x86, 32-bit), MSI Installer. (6) Once installed, the database administrator will set up the database(s). There will be five main components: Customer database, Product database, Sales database, Transaction database, and Employee database. The database and backup with be stored in the cloud and a secondary backup on the mainframe server located in the on-site server room. b. Amazon RDS for MySQL: We have chosen this since it is easy to set up, operate, and scale. It also handles backups, software patching, monitoring, scaling, and replication. Amazon RDS is preconfigured with the parameters and settings needed for MySQL and provides granular control and fine-tuning. To begin with, we will have 2 TB of space available and an additional 30 GB for backup storage. As our storage requirements grow, we can provide additional storage with zero downtime. Since we operate using OLTP (online transaction processing) applications, the IOPS (input/output operations per second) will consistently deliver 40,000 IOs per second. Amazon RDS will store User-initiated database

INFRASTRUCTURE DESIGN

6

backups until we choose to delete them. Enhanced monitoring will access 50 CPU, memory, file system, and disc I/O metrics. The management console shows us compute, memory, storage capacity utilization, I/O activity, and instance connections. Amazon RDS also provides high-level security via network isolation using Amazon Virtual Private Cloud (VPC) and encryption that we will create and control through AWS Key Management Service (KMS). All data being transmitted with also be encrypted using SSL. (7) The cost estimate for Amazon RDS is as follows: Amazon RDS for MySQL estimate o RDS MySQL cost (monthly) = 5,112.92 USD o Storage pricing for 2 TB (monthly) = 471.04 USD (2,048 GB * 0.23 USD * 1 instance) o Additional 30 GB backup storage cost (monthly) = 2.85 USD (30 GB * 0.095 USD)  Total monthly cost: 5,586.81 USD c. Website/Application: We will be utilizing Shift4’s e-commerce solution, Shift4Shop, which includes website design, social media, email marketing, SEO tools, and product and order management. It also features an online shopping cart that links directly to the credit card processing gateway. The solution is entirely free; however, we must use Shift4’s payment gateway and processing, which will be explained in more detail later. We will have an application available for both Android and iOS. Even though Java is not the preferred language for iOS, both applications will be written using this language due to its flexibility and

INFRASTRUCTURE DESIGN

7

popularity. The following details the methodology needed for the applications which will reciprocate with the database: i. CList – method will be an ArrayList containing all customer objects. 1. Customer class will allow the customer object containing the following methods to be built. a. CAdd – Add a new customer to the database b. CMod – Modification of customer object c. CDel – Deletes a customer from the database d. getC – Retrieves customer information e. printC – Prints a report based on customer data 2. Customer properties – a. fName – Customer’s first name b. lName – Customer’s last name c. phNum – Customer’s phone number d. eMail – Customer’s email address ii. IList – method will be an ArrayList containing all Inventory objects 1. Inventory class will allow the inventory object containing the following methods to be built. a. IAdd – Add a new inventory item to the database b. IMod – Modification of inventory object c. IDel – Deletes an inventory item from the database d. getI – Retrieves inventory data e. printI – Prints a report based on inventory data

INFRASTRUCTURE DESIGN

8

2. Inventory properties – a. IName – Name of the item in inventory b. ICost – Amount company bought item for c. IPrice – Customer’s price d. IQuantity – the amount of inventory item in stock iii. OList – method will be an ArrayList containing all order items 1. Order class will allow the order containing the following methods to be built. a. OAdd – Add an inventory item to the order b. OMod – Modification of order item c. ODel – Deletes an inventory item from the order d. GetO – Retrieves individual order information e. printO – Prints a report with open orders in OList 2. Order properties – a. ONum – Order number b. OPrice – Total cost of the order c. ProfiT – Total profit from the order We will be using a RESTful API interface to connect the components (i.e., website/application => database => warehouse/office => supply chain). According to Gillis, “REST API (aka RESTful API) is an architectural style for an application program interface (API) that uses HTTP requests to access and use data.” APIs allow different software programs to integrate or communicate with each other. REST APIs use less bandwidth, making them more suitable for ecommerce. Resources are sent in a JSON file between the server and the applications. (9)

INFRASTRUCTURE DESIGN

9

d. Customer Relationship Management (CRM): Salesforce will be our provider for managing relationships with customers, both current and potential. Even though Shift4Shop does provide CRM, we also want a more streamlined way of connecting all aspects of the business, not just the website platform. This will help us in marketing and sales by prioritizing opportunities. It is also cloud-based, so our office personnel from anywhere can access it. e. Payment Processing: As stated before, since we will be utilizing Shift4’s ecommerce solution, we will also be using Shift4’s PCI-compliant secure payment gateway and processing platform. Rates still need to be negotiated; however, we can securely accept our customers' credit, debit, and EBT payments. Once the payment information is entered on the website or application, it is encrypted as P2PE and sent via the gateway. We will receive a response in a matter of seconds if the payment is approved. Since we are an e-commerce business, we will also set up fraud controls such as AVS verification. For example, if the credit card address or zip code does not match the shipping address, the payment will be automatically declined to prevent fraudulent charges. We will have access to a real-time payment database known as Lighthouse Transaction Manager and their business portal, Lighthouse Business Manager. Credit card transactions will be automatically batched and sent for processing one hour after the close of business, and we will be funded the next day. Batch reporting will be available in real-time and sent via email to the Office Manager to be synced with QuickBooks. The payment processing setup also gives us the ability to later expand to adding a POS system and credit card terminals if we so choose.

INFRASTRUCTURE DESIGN

10

f. Enterprise Resource Planning (ERP): Oracle Cloud ERP will be utilized for this aspect of the business. This SaaS will give us access to financial reporting and analysis to help us make better decisions for the business. It will allow us to keep track of payables and receivables, risk management, project management, and automate procurement by finding the best suppliers and managing supplier risk while controlling costs. Oracle Cloud ERP also blends finance and human resources. “A recent MIT Technology Review study revealed 35% of the businesses surveyed are creating a shared Finance and HR function. Uniting the back office, bringing Finance and HR together, and moving it on one system to the cloud can reduce costs, improve employee engagement, and create the right foundation for growth,” according to Oracle. (12) g. Financials and Human Resources: We will also be utilizing QuickBooks for income and expense tracking, receipt organization, invoicing, and tracking of sales and sales tax. ADP will be utilized for HR and payroll-related activities. ADP’s SmartCompliance suite integrates with Oracle Cloud ERP. It will allow us to handle employment verification, health compliance, wage payments, employment tax, wage garnishments, tax credits, W-2 management, and unemployment claims. (13) Banking will be handled through Capital One Business Banking. Their Unlimited Checking offers us unlimited digital transactions with no fees, Online Bill Pay, free Overdraft Coverage Protection, no fee cash deposits, free Domestic Wire service for all incoming wires, and the first five outgoing wires. If our balance averages $25,000 or more, there is no monthly

INFRASTRUCTURE DESIGN

11

service fee. If our balance falls below this amount for any reason, we will be charged a $35 monthly service fee. (14) II.

Hardware Design: a. Internet: Since most of our business will be run by cloud computing, we need a fast, secure, and reliable solution for our internet. Astound Business Solutions offers Dedicated Internet Access (DIA) via a pure fiber IP network. This will guarantee that our private network with dedicated static IPs will guarantee the symmetrical speed and bandwidth up to 940 Mbps. b. Network Bandwidth: Although also measured in Mbps, bandwidth differs from network speed. Latency, the delay packets experience moving through a network, puts strain on the network. According to Madden, “Many factors contribute to latency, including the distance between two systems (such as over a wide area network), the number of hops (bridge, router, or gateway points) along the way, large packet sizes (video files or encrypted data), jitter (the variance in the time delay between packets) or network congestion (too many bits in the pipe). These scenarios can cause data packets to be dropped and then retransmitted, resulting in more latency. As an increasing number of data packets are retransmitted over long distances, they consume greater amounts of available bandwidth, thus degrading network performance.” The proximity between data points helps reduce latency, which increases available bandwidth. (23) Even though Astound guarantees symmetrical speed and bandwidth up to 940 Mbps, we must consider the latency the network will experience within our network. We will be consulting

INFRASTRUCTURE DESIGN

12

with a networking professional to assist in designing the networking infrastructure to achieve low latency and higher bandwidth. c. Server Room: The server room will be located on the bottom floor away from the warehouse and refrigeration areas and not on an exterior wall to avoid any issues with leaks or moisture. (16) It will be 50 watts/square range. i. Cooling: We will have a computer room Air Conditioner (CRAC) which will include cooling humidity regulators. ii. AisleContainment: Cool Shield describes Aisle Containment as “a cooling system that completely separates the cold supply airflow from the hot equipment exhaust air.” (18). We will be utilizing a cold air containment system (CAC). This works because the CAC isolates the cooling air supply from the CRAC units and prevents hot exhaust air from encountering the server intake. (18) We will be contracting with a thirdparty HVAC contractor familiar with IT infrastructure to install this. iii. UPS (Uninterruptible Power Supply): A UPS is a backup power system that supplies power long enough for equipment to shut down properly. It helps prevent data loss and minimizes the stress a hard shutdown can cause on our equipment. Common power problems include surges, blackouts, brownouts, voltage sags, over-voltage, frequency noise and variation, and harmonic distortion. (19) We will be implementing CyberPower’s Smart App Online OL10KRT. This 6U rack doubleconversion UPS provides sine wave output to critical aspects of our IT infrastructure. It delivers consistent 200-240 V power with zero-transfer

INFRASTRUCTURE DESIGN

13

time and includes automatic bypass in the event of an overload or internal fault. The full specs can be viewed at https://www.cyberpowersystems.com/product/ups/smart-apponline/ol10krt/. iv. Power Distribution: We will use a Switched Rack PDU which will allow us to remotely turn on/off or reboot each outlet to power cycle unresponsive equipment, monitor critical power usage data, receive alerts when the power goes beyond the thresholds we set, and set power sequence time delays to avoid circuit overload. (17) The model we will be using is Vertiv VP5100, a 15A, 120V 1U horizontal with input power monitoring and outlet level switching. It has 6 NEMA 5-15R receptacles and a NEMA 5-15P, providing 1.4kW of power capacity. v. Cable Management: We will use a server rack cable management system in the form of a Vertical Cable Manager. For this, we will be consulting a professional cabling contractor to determine the routes for power and data cables. Vertical cable managers ensure proper airflow and will be perfect for the later expansion of our network. We will also implement a Fiber Optic Patch Panel for our networking needs. (21) vi. Server and Switch: 1. Our server will be a Cisco UCS X-Series Modular System. It provides the functionality of blade and rack servers. It consists of two components. The first is the Cisco UCS X9508 Chassis with a 7RU form factor, eight front-facing flexible slots for computing

INFRASTRUCTURE DESIGN

14

nodes and future upgrades, two UCS 9108 IFMs ...