opensymbol - bmw case study
DESCRIPTION
How BMW Uses SugarCRM & Amazon EC2 for Lead Management in ItalyTRANSCRIPT
![Page 1: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/1.jpg)
How BMW Uses SugarCRM & Amazon EC2 for Lead Management in Italy
Enrico Maggi – co founder and CEO of OpenSymbol – Italian SugarCRM Gold Partnerhttp://www.opensymbol.it
![Page 2: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/2.jpg)
Important information
This is not the full presentation
We’re still waiting for BMW approval before publishing the full one
For more information please contact [email protected]
![Page 3: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/3.jpg)
The Italian Market for BMW
Italy is in the top 5 market in the world for BMW - Mini
![Page 4: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/4.jpg)
The Italian Market for BMW
Italy is the second market in the world for BMW Motorrad
![Page 5: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/5.jpg)
BMW Italy Sales Organization
National sales company based in Milan
![Page 6: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/6.jpg)
BMW Italy Sales Organization
Nearly 150 dealers in all over the italian territory (3 brands)
![Page 7: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/7.jpg)
Why SugarCRM
High degree of software customizability
High degree of software integrability
Opensymbol focus on BMW needs: starting from the earlier stages Opensymbol always kept in mind customerneeds
Opensymbol skills on integrating other softwares and on fast customizing SugarCRM
Deployment Flexibility: on demand but with the option toinstall in house if needed
Price Flexibility: the same price per user regardless of the number of users (from 100 to 2000)
![Page 8: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/8.jpg)
How to size the hardware?
How to size the hardware to guarantee the same price per user regardless of the number of users?
![Page 9: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/9.jpg)
Amazon WS: cost effective model
![Page 10: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/10.jpg)
Amazon WS: instances
Instances are similar to Virtual Servers:
STD Small / Medium / Large– Up to 15GB RAM with up to 1,6TB disk space
– Up to 8 EC2 Compute Units 64bit
HIGH MEMORY Extra / Double Extra / Quadruple Extra– Up to 64GB RAM with up to 1,6TB disk space
– Up to 26 EC2 Compute Units 64bit
HIGH CPU Medium / Extra Large– Up to 7GB RAM with up to 1,6TB disk space
– Up to 20 EC2 Compute Units 64bit
![Page 11: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/11.jpg)
Amazon WS: pricing model
“per instance-hour consumed for each instance type, from the time an instance is launched until it is terminated”
![Page 12: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/12.jpg)
The architecture on Amazon Cloud
Database scalability
Dynamic web server scalability
High availability
Disaster Recovery
During working hours there can be as many web servers as needed.
Nightly there are usually only two Amazon Instances up and running.
![Page 13: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/13.jpg)
Database: scalability
No MySQL Proxy (it’s in alpha stage already)
No MySQL Cluster (different table type, too focoused for typical “telco” needs)
So we decided to setup a Single Amazon Instance (currently a “Large instance”) with failover criteria based on Linux Debian
![Page 14: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/14.jpg)
Database: scalability
The database is not strictly “elastic”, but we can easily scale up or down by switching the db server to a larger or smaller instance (in less than one hour) to guarantee very good performances to users
![Page 15: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/15.jpg)
Database: high availability
1 2
3 4
![Page 16: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/16.jpg)
Database: disaster recovery
The database is constantly aligned from Amazon EU region to Amazon US region
![Page 17: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/17.jpg)
Web Server: elastic scalability
Nginx (small linux instance for loadbalancing management)
Apache Web Server based on Linux Debian (e.g. medium instance) scalable up or down as load increases / decreases
![Page 18: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/18.jpg)
Web Server: elastic scalability
Nightly there is only 1 virtual web server up and running
![Page 19: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/19.jpg)
Web Server: elastic scalability
During working hours as load increases / decreases
e.g. at 8 am
e.g. at 11 am
e.g. at 4 pm
![Page 20: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/20.jpg)
Amazon recommends
1. Have a coherent backup and restore strategy for your data and automate it
2. Build process threads that resume on reboot
3. Allow the state of the system to re-sync by reloading messages from queues
4. Keep pre-configured and pre-optimized virtual images to support (2) and (3) on launch/boot
5. Avoid in-memory sessions or stateful user context, move that to data stores.
![Page 21: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/21.jpg)
Ecom website (one of the lead sources)
![Page 22: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/22.jpg)
Dealer Marketing Manager Dashboard
![Page 23: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/23.jpg)
The SugarCRM - facebook project (BETA)
![Page 24: Opensymbol - BMW case study](https://reader033.vdocuments.us/reader033/viewer/2022042700/558570e1d8b42a512c8b4aaa/html5/thumbnails/24.jpg)
Enrico Maggi – co founder and CEO of OpenSymbol – Italian SugarCRM Gold Partnerhttp://www.opensymbol.it