Watch: Lessons from Working with NoSQL in a SQL DB & MySQL JSON Data Type Migration
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.