Last time I shared a video that is an introduction to Using MySQL without the SQL. This
time I am adding two more videos -- one on Document Collections and another on simple indexes. The MySQL Document Store
is a simple, easy to use way to for developers to store data
without much of the traditional pre-requisite chores needed with
a relational database.
You simple connect to the MySQL instance using the new MySQL Shell to the schema of your choice,
create a document collection, and can start saving data right …
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 …
[Read more]
My post-FOSDEM detox has started - despite preparing by reading some survival guides, I
hadn't really fathomed the variety and quantity (and quality) of
beer that would flow over four days. On reflection however,
the beer flow has been far exceeded by the flow of tech content
and conversation.
On Thursday and Friday I attended the pre-FOSDEM MySQL Days fringe event, where
there were two tracks of talks and tutorials on MySQL including
sessions on :
- MySQL Server simplification
- MySQL replication tooling improvements
- Configuring group replication
- Troubleshooting group replication
- Using DNS for loadbalancing and failover
- Upgrading to MySQL 8.0 …
When I tell people that they can use MySQL without SQL they tend
to be skeptical. But with the MySQL Document Store you can
do just that with a new NoSQL API and in this case there is no
structured query language.pre-FOSDEM MySQL Days (which is sold out
and there is a waiting list) is my tutorial on using the Document
Store. Those in my session will be able to see how to use
the MySQL Shell (mysqlsh) to connect to a MySQL server and save
data without have to do the many things a DBA used to have to do
in the past such as normalize data, setup relations, and several
other tasks. Plus the schema-less Document Store means you
can alter your data needs without having to do an endless series
of ALTER TABLES.
… |
I am writing a tutorial on the MySQL Document Store for the sold
out (sorry) pre-FOSDEM MySQL days. For those who do not
write such exercise they are often a difficult task as you have a
limited time to convey information, need to provide vivid
examples, and create exercises that give a good idea of what the
topic is all about. And my personal preference is to write
once and use the tutorial at other events (please let me know
if you have such an event).
Indexing records is a well know performance step when creating
databases, SQL or NoSQL. And back in June of 2017 I wrote a
blog post on using createIndex() to index documents in the
MySQL Document Store. And as part of creating the tutorial I
referred to that blog post as a reference and was quite surprised
that it was not working.
What happened? Well back in 8.0.11 the function was revised and
it is no longer a series of chained calls but …
The schedule of the preFOSDEM Day is now available !
We had a lot of proposals to deal with. Also this is a MySQL event where we, the MySQL Team has the possibility to show to you, our Community, all what we have working on to improve MySQL but also new stuff. We also invite some of our friends from the MySQL Community to talk about their experience.
I think we did a good selection and propose you new content. We are extremely happy to have Saverio Miroddi from TicketSolve talking about MySQL 8.0, Uber talking about InnoDB Cluster, and Facebook about Binlog.
As you can see, we will have 2 rooms, where one will be dedicated mostly to SQL and Optimizer topics but also tutorials.
You can also see that this year we also want to put some spot lights to MySQL NDB Cluster. You will see what is it, how is it used and what’s new. We will also have 2 community speakers sharing their MySQL NDB knowledge: Giuseppe Maxia, …
[Read more]Mid September, MySQL Community, MySQL Customers and MySQL Engineers will be in San Francisco to share their experience and present the new features of your favorite database !
The event will be held in Moscone South (just Mirko Ortensi‘s Hands-on Lab will be delivered in Moscone West).
During the week, the MySQL Community Team will host the traditional MySQL Reception. We got so great feedback from last year that we decided to renew the experience in the same awesome location, the Samovar Tea Lounge at Yerba Buena Gardens. Don’t forget that you need to register for this reception but no OOW pass is required. Please register here !
Back to the conference, you can find the full schedule for the session in the …
[Read more]Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular? We found all the answers you need at the Percona Live event last month, and broke down the insights into the following free trends reports:
- Top Databases Used: Open Source vs. Commercial
- Cloud Infrastructure Analysis: Public Cloud vs. On-Premise vs. Hybrid Cloud
- Polyglot Persistence Trends: …
The world seems awash in unstructured, NoSQL data, mainly of the
JSON variety. While this has a great many benefits as far
as data mutability and not being locked into a rigid structure
there are some things missing that are common in the structured
world of SQL databases.
What if there was a way to take this unstructured NoSQL JSON data
and cast it, temporarily, into a structured table? Then you
could use all the processing functions and features found in a
relation database on you data. There is a way and it is the
JSON_TABLE function.
JSON_TABLE
You can find the documentation for JSON_TABLE here but there are some examples below
that may make learning this valuable function easier than the
simple RTFM.
I will be using the world_x dataset for the next example
If …
At the end of the month, some engineers of the MySQL Team will be present in Austin, TX !
We will attend the first edition of Percona Live USA in Texas.
During that show, you will have the chance to meet key engineers, product managers, as well as Dave and myself.
Let me present you the Team that will be present during the conference:
The week will start with the MySQL InnoDB Cluster full day tutorial by Kenny and myself. This tutorial is a full hands-on tutorial where we will start by migrating a classical asynchronous master-replicas topology to a new MySQL InnoDB Cluster. We will then experience …
[Read more]