achieve new levels of performance for magento e-commerce sites
TRANSCRIPT
![Page 1: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/1.jpg)
© 2015 CLUSTRIX
The First Scale-out SQL Database Engineered for Today’s Cloud
Achieve new levels of performance for Magento e-commerce sites. Kevin Bortnick Magento Certified Developer @kbortnick
@clustrix
![Page 2: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/2.jpg)
Common Problems with High-Transaction Magento Sites
2
Significant effort to deal with unexpected traffic
Issues with check-out during indexing
Delaying catalog updates to avoid reindexing
Site-slowdowns during peak selling seasons
High support costs Pages take too long to load!
Replication lag
Poor disaster recovery options
@clustrix
![Page 3: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/3.jpg)
Clustrix Benefits on the Magento Platform
3
High Transaction Magento Sites
24x7x365
Large Catalogs and frequent updates
No Check-out downtime
@clustrix
![Page 4: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/4.jpg)
Next-Generation Backend for Magento
4
ClustrixDB for Magento
ClustrixDB Clustrix Shadow (re)Indexer
@clustrix
![Page 5: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/5.jpg)
ClustrixDB: Scale-out, Fault-tolerant, MySQL-Compatible
ClustrixDB Overview 5
ClustrixDB
ACID Compliant
Transactions & Joins
Optimized for OLTP
Built-In Fault Tolerance
Flex-Up and Flex-Down
Minimal DB Admin
Built to run in the Cloud or
Datacenter
The only Magento-approved alternative database to MySQL that scales performance up/down as your add or subtract commodity nodes.
![Page 6: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/6.jpg)
Scale-Up far beyond MySQL: ✓ # of Connections ✓ # of Concurrent Transactions ✓ Scale-Up writes (and reads)
ClustrixDB 3 Key Values
ClustrixDB Overview 6
Keep the database On-line: ✓ Survive server crashes ✓ Add capacity on-line
Don’t re-write the App: ✓ Applications see MySQL ✓ No sharding needed ✓ No Read/Write partitioning
ClustrixDB
@clustrix
![Page 7: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/7.jpg)
Flex Licensing = Business Agility
• ClustrixDB has: – Technical capability to grow & shrink cluster while online – Licensing model that aligns with a seasonal business
or temporary workloads
• Flex Licensing – Annual license covers base cluster size
• e.g. 3-nodes year round – Monthly Flex license covers seasonal demand
• e.g. 2 extra nodes for Nov & Dec • And drop to 1 extra node in Jan
PROPRIETARY AND CONFIDENTIAL 7
ClustrixDB
@clustrix
![Page 8: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/8.jpg)
Easy to Administer
@clustrix
![Page 9: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/9.jpg)
What is the ClustrixDB Shadow (re)Indexer?
• Updates to the Magento Indexer and Magento EAV Systems
• Removes frustrations and downtime stemming from catalog updates
• No impact on site performance
9 @clustrix
![Page 10: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/10.jpg)
About ClustrixDB Shadow (re)Indexer
Re-write of two modules of the Magento Platform • Clustrix EAV
– Dramatically improves data store retrieval from primary data tables – Removes need for flat tables
• Reindex faster and less often
• Clustrix (re)Indexer – Tunes indexes to run better on ClustrixDB – Improves processing behavior
10 @clustrix
![Page 11: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/11.jpg)
Magento Imagine Benchmark
11
![Page 12: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/12.jpg)
Benchmark: Configuration
Software
12 @clustrix
• ClustrixDB 7.5 • Gatling Stress Tool • Magento CE 1.9.2
– Apache 2.2 – Varnish 4.0
Hardware (8 core nodes)
• 4 Drivers (Gatling Stress) • 12 Magento web servers • 6 ClustrixDB servers
![Page 13: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/13.jpg)
Benchmark: Results
13 @clustrix
Duration 50 hours
Transaction per second 14.6
Orders Processed 2,600,000
Indexing every 12 minutes
Page Views 816/second
Average Response Time 267 ms
Average CPU Load on Database Servers 35%
![Page 14: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/14.jpg)
Magento Site Response Times, 3 x 8 core
14
#ConcurrentUsers(over1min)
Avg.ResponseTime(milliseconds)
ErrorRate(%)
With
ClustrixWithoutClustrix
WithClustrix
WithoutClustrix
500 1956 3826 0 0.11000 2050 3868 0 02000 1896 16168 0 1.23000 5030 20767 5.2 51.4
![Page 15: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/15.jpg)
Clustrix Scales
15
![Page 16: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/16.jpg)
Live Demo
16
![Page 17: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/17.jpg)
Live demo: Configuration
Software
17 @clustrix
• ClustrixDB 7.5 • Gatling Stress Tool • Magento CE 1.9.2
– Apache 2.2 – Varnish 4.0
Hardware (8 core nodes)
• 2 Drivers (Gatling Stress) • 6 Magento web servers • 3 ClustrixDB servers
![Page 18: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/18.jpg)
Benchmark: Workload
• Workload – 120 concurrent users – 450 requests per second – 6 checkouts per second
• Catalog Size – 15,500
• Reindex/Catalog Updates – Reindexing continuously
18 @clustrix
![Page 19: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/19.jpg)
Demo: Madison Island Homepage
19 @clustrix
![Page 20: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/20.jpg)
Demo: Madison Category
20 @clustrix
![Page 21: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/21.jpg)
Demo: Madison Catalog page, Filtered
21 @clustrix
![Page 22: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/22.jpg)
Demo: Madison Catalog page, Search
22 @clustrix
![Page 23: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/23.jpg)
Demo: Madison Product Page
23 @clustrix
![Page 24: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/24.jpg)
Demo: Madison, Add to Cart
24 @clustrix
![Page 25: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/25.jpg)
Demo: Madison, Checkout
25 @clustrix
![Page 26: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/26.jpg)
Demo: Madison, Checkout Success
26 @clustrix
![Page 27: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/27.jpg)
Demo: NewRelic
27 @clustrix
![Page 28: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/28.jpg)
Demo: Magento, Orders
28 @clustrix
![Page 29: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/29.jpg)
Demo: Magento, Order Admin
29 @clustrix
![Page 30: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/30.jpg)
Demo: Magento, Product Edit
30 @clustrix
![Page 31: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/31.jpg)
Demo: ClustrixDB New GUI
31 @clustrix
![Page 32: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/32.jpg)
Solved Problems with High-Transaction Magento Sites
32
✅ Indexing doesn’t overwhelm hardware
✅ No extended downtimes
✅ Add, modify or delete catalog entries anytime
✅ Terrific Site Performance even during Peak Selling Season
✅ Low Support Costs. Predictable Performance
✅ Fast Page Load Times ✅ No need for data replication
@clustrix
![Page 33: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/33.jpg)
Q&A
ClustrixDB Overview 33
![Page 34: Achieve new levels of performance for Magento e-commerce sites](https://reader031.vdocuments.us/reader031/viewer/2022030300/588195851a28ab0d358b6701/html5/thumbnails/34.jpg)
Thank You
facebook.com/clustrix
www.clustrix.com
@clustrix
linkedin.com/clustrix
ClustrixDB Overview 34