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

Wix Engineering
Wix Engineering
Published in
2 min readFeb 10, 2020

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
Wix Engineering

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