Watch: Lessons from Working with NoSQL in a SQL DB & MySQL JSON Data Type Migration

Wix Engineering
Feb 10 · 2 min read

Wix Engineering’s meetups focus on deep technical insights, whether it’s front-end, back-end, mobile, testing or anything in between. You can join us on Tel-Aviv, Kyiv, Dnipro and Vilnius.

Below you’ll find videos from one of our recent meetups, where our Baruch Assif Osoveksiy and Lior Altarescu, shared their work with NoSQL in a SQL Database, and MySQL JSON Data Type and Migration.


Working with NoSQL in a SQL Database (XDevApi) / Lior Altarescu

The X Dev API is a new protocol for non-blocking, asynchronous calls to MySQL.

In this talk, Lior explores the benefits of working with this protocol and connectors, and the challenges we encountered during the process of adopting X Dev API in Wix Engineering.

He also shares how we are incorporating the protocol in our massive multi dc architecture, and how it helps us, at Wix Engineering, rollout to production faster. Watch:

MySQL JSON Data Type and Migration / Baruch Assif Osoveksiy

At Wix Engineering, we are using JSON in blobs Data Type as far back as MySQL 5.5. In this talk, Baruch shares both our wins and losses, our successes and our challenges, when it came to migrating our blob JSON data to JSON data types, and how we use the new data type to improve search time and reduce IO cost.


For more engineering updates and insights:

Photo by Tobias Fischer on Unsplash

Wix Engineering

Architecture, scaling, mobile and web development, management and more, written by our very own Wix engineers. https://www.wix.engineering/

Wix Engineering

Written by

Wix Engineering. We develop innovative cloud-based web applications that influence our Wix.com 150M+ users worldwide

Wix Engineering

Architecture, scaling, mobile and web development, management and more, written by our very own Wix engineers. https://www.wix.engineering/

More From Medium

More from Wix Engineering

More from Wix Engineering

More from Wix Engineering

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade