evolution of couchbase at centeredge: from cache to query – couchbase live new york 2015

Welcome

@ Couchbase Live NYC 2015

Our Evolution with Couchbase

From Cache to Query

Welcome

Dan CutterDirector of Software Development

Brant BurnettSoftware Development Team Lead

The AgendaTodayBrief overview covering our background, our markets, and our key featuresWebstores + Black Friday = need for Amazon and Couchbase CacheMoving Beyond Cache, Shopping Carts as Couchbase DocumentsFrom Toolbox to Platform, our new Enterprise Cloud ArchitectureCouchbase 4.0 Beta Partners, growing into new feature sets togetherGlobalization, fast growth while running at scaleQ & A

Quick FactsCelebrating 10 Year Anniversary

Team of 40 in Roxboro, NC

Sister company is Palace Pointe, a 100k sq. ft. Entertainment Venue for which we were developed as an in-house system

Over 400 users across the US and abroad

FEC’s, Waterparks, Trampoline Parks, Amusement Parks, Skating Rinks, Bowling Centers, Zoos & Museums

Quick Facts Point of Sale

Admissions & Ticketing Party, Group & Event

Bookings Online Sales & Party

Reservations Time Clock & Labor

Management & More!

Quick Facts

At the ParkAdmissionsTicketingSeason

PassesFood &

BeverageGuest

RewardsGift CardsCapacity

ControlConsignmentRentals

Online Sell 24/7

Fully Integrated

Mobile Ticketing

Print at Home

Admissions/Passes

Parties & Events

Convenience Fees

Custom Theme

Securely Hosted

Smart OptionsTime ClockEmployee

SchedulingLiability

WaiversDigital

SignageConstant

ContactAccounting

InterfaceAccess

ControlCashless/

Redemption

Webstores + Black Friday

Started in 2012 using Couchbase 1.8Cache SQL Server query resultsMoving to Amazon EC2 from dedicated servers in data centerNeeded scalability and stability

Webstores + Black Friday

https://github.com/brantburnett/CouchbaseCacheExample

Moving Beyond Cache

Shopping carts in ASP.net Profiles asserialized XML in SQL tables

Discovered major performance bottleneck with serialization and read/writes

Moved to storing as JSON in Couchbase 1.8

Persisted documents for 14 days

Major performance improvement - 1/2 to 1 second page loads to sub 20ms page load times

From Toolbox to Platform

New cloud platform designed from the ground up

Built on 100% NoSQL for scalability and reliability in the cloud

Looked at other NoSQL providers, but with our experience and relationship with CB they won the race

Building with the .NET client

Sync with legacy SQL based on-premise systems

Couchbase 4.0 Beta Partner

Needed ad hoc queries for our operations team and started building utility views

Discoverability of Couchbase Information

Production troubleshooting

Resolutions to deployment issues

Deployment analysis and metrics


Experimenting with N1QL - saw the potential

Operations department already trained on SQL queries for troubleshooting

Indexes are much easier to work with than utility views

Indexes provide more flexibility and reusability than views


N1QL ExampleCREATE INDEX ItemDescriptionON General (type, generalInformation.description)USING GSI

SELECT siteId, gi.description, gi.itemType, gi.itemStatus, gi.categoryId, gi.subCategoryIdFROM GeneralLET gi = generalInformationWHERE type = 'inventoryItem' AND gi.description LIKE '%search%'


Went to Couchbase Connect and met up with Couchbase experts

Since our beta processes were aligned, teamed with Couchbase to go through beta program

* Technical Support

* Document Analysis and Index Creation

* Help with deployment configuration and best practice

* Ongoing technical help, suggestions, and support

Globalization and fast growth

What's next?

N1QL and LINQ integration with code base https://github.com/couchbaselabs/Linq2Couchbase

Rapid growth rapid expansion

Running at global scale

Demo/Screen shots

Thank YouVisit us at

www.centeredgesoftware.com

http://www.centeredgesoftware.com/