In the old days, when we wanted to strengthen our skills the only option was to buy a good book. Nowadays one can find a lot of resources on the Internet, however quality is often poor. Fortunately there are still some great people who are brave enough to write new books that will help a new generation of women and men to build modern applications with MySQL the world's most popular open source database. Let me introduce you 3 MySQL books : Introducing the MySQL 8 Document Store / MySQL and JSON: A Practical Programming Guide / Pro MySQL NDB Cluster
10 Older Entries »
As you know, one of the great new feature in MySQL 8.0 is the Document Store. Now with MySQL you can store your JSON documents in collections and manage them using CRUD operations. NoSQL is now part of MySQL ! Instead of a mix of MongoDB and MySQL, now you can eliminate MongoDB and consolidate with MySQL !
This is a historical meeting of NoSQL and SQL in the same database server!
To use MySQL 8.0 as Document Store, you need to have the X plugin installed (by default since 8.0.11). This plugin enables the X DevAPI that offers a modern programming interface. Clients that communicate with a …[Read more]
Next week I will be speaking at DataOps in Barcelona about MySQL 8.0 Document Store. If you don’t know it yet, I really invite you to join this talk, you will be very surprised about all MysQL can do in the NoSQL world !
There will be also a lot other MySQL related sessions by many good speakers of the MySQL Community.
As I will be in Barcelona, the Barcelona MySQL Meetup invited me to give a session about MySQL InnoDB Cluster and Group Replication and I will also share the stage with my friend and colleague …[Read more]
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Some big news out from Microsoft about their acquisition of GitHub for $7.5 billion. GitHub hosts many projects, including from the MySQL ecosystem, but maybe more interesting is that their DBA team is awesome, give great talks, and are generally prolific writers. Some of the cool tools the MySQL world has gotten thanks to the excellent team include (but are not limited to): ccql, gh-ost for triggerless online schema migrations, and Orchestrator which is a GUI-based High Availability and …[Read more]
From June 16th to 17th, the MySQL Team will be attending and speaking at the Hong Kong Open Source Conference 2018.
Unfortunately I won’t be present but some of my great colleagues will be speaking about MySQL.
If you are planning to attend HKOSCon2018, don’t miss their talks:[Read more]
Today the call for participation for Oracle Open World 2018 has started.
The 2018’s edition will take place in San Francisco as usual, from October 22nd to 25th.
As every year, MySQL will be present and if you want to participate, we encourage you to submit a session. We encourage the submission on the following topics:
- case studies / user stories of your use of MySQL
- lessons learned in running web scale MySQL
- Production DBA/DevOps perspectives into Architecture, Performance, Replication, InnoDB, Security, etc
The call for paper is open until March 22nd, don’t miss the chance to be part …[Read more]
MySQL 8.0 RC2 has just been released with a lot of new features compared to MySQL 5.7. In this blog post, I will list the top 10 new features that should excite developers.
These functionalities are presented in descending order of preference of our MySQL Community.
- MySQL Document Store
- Default to utf8mb4
- JSON enhancements
- Window Functions
- Descending Indexes
- Better Optimizer Cost Model
- MySQL Server Components
- Improvement in GIS
- InnoDB NO WAIT & SKIP LOCKED
MySQL Document Store
This is the most expected and liked feature in MySQL 8.0 … and …[Read more]
From September 25th to 27th 2017, the MySQL engineers and community team will be speaking at Percona Live Europe in Dublin.
MySQL is also part of the contributing sponsors.
For the conference, we tried to bring new faces to the Community. Usually, it’s always the same famous team leaders speaking at the conferences, this time, it’s not. A lot of key developers will present their own work. We have so much talented people in MySQL we want to present to our community.
Of course, once again we will focus our talks on MySQL 8.0. This is the list of sessions the MySQL Team will deliver:
Monday, Sep 25th
On Monday, I will deliver a tutorial with my friend …[Read more]
Embedding Structured Query Language (SQL) within PHP, or other programming languages, has been problematic for some. Mixing two programming languages together is just plainly not aesthetically pleasing. Especially when you have a declarative language (SQL) mixed with a procedural-object oriented language. But now, with the MySQL XDevAPI PECL extension, PHP developers can now stop mixing the two languages together together. MySQL Document StoreThe MySQL Document Store eliminates the heavy burden for SQL skills. It is designed to be a high speed, schema-less data store and is based on the MySQL JSON data type. This gives you roughly a gigabyte of store in a document format to do with as needed. So you do not need to architect you data before hand when you have no idea how it will evolve. No need to normalize your data. Now behind the scenes …[Read more]
I am starting a series of videos on the MySQL Document Store. The Document Store allows those who do not know Structured Query Language (SQL) to use a database without having to know the basics of relational databases, set theory, or data normalization. The goal is to have sort 2-3 minute episodes on the various facets of the Document Store including the basics, using various programming languages (Node.JS, PHP, Python), and materializing free form schemaless, NoSQL data into columns for use with SQL.
The first Episode, Introduction, can be found here.
Please provide feedback and let me know if there are subjects you would want covered in the near future.
10 Older Entries »