2016/08/19
by admin
Comments Off on Fooling around with MySQL JSON full-text indexing
MySQL 5.7/8.0 does not allow creating a full-text index on a JSON column. Although a full-text index would be useful – unstructured data deserves unstructured search. I am unaware o any workaround of this limitation that does not require storing … Continue reading
2016/08/17
by admin
Comments Off on MySQL Document Store: unstructured data, unstructured search
Storing documents is convenient: no need to define a schema up-front, no downtime for schema changes, no normalization, no slow joins – true or not, you name it. But what about search if you do not know how your data … Continue reading
2016/08/12
by admin
Comments Off on Use the index, JSON! Aggregation performance (Elastic, MySQL, MongoDB)
Use the index, Luke!? No: use the index, JSON! When hunting features the X DevAPI should consider I got shocked by some JSON query execution times. Sometimes the MySQL Document Store runs head-on-head with MongoDB, sometimes not. Sometimes the difference … Continue reading
2016/08/11
by admin
Comments Off on Aggregation features, Elasticsearch vs. MySQL (vs. MongoDB)
To make the MySQL Document Store primary programming interface, the X DevAPI, a success we should provide building blocks to solve common web development tasks, for example, faceted search. But is there any chance a relational database bend towards a … Continue reading
2016/07/29
by admin
Comments Off on Faceted search, why the DevAPI could matter one day
Faceted search or faceted navigation is a highly praised and widely use search pattern. And, it is a great reply to an off the records sales engineering question. MySQL finally has some document store features built-in. A bit of a … Continue reading
2014/10/30
by admin
Comments Off on PECL/mysqlnd_ms needs updates for MySQL Group Replication
‘Synchronous’, multi-master, auto-everything – that’s the new MySQL Group Replication (IPC14 talk/slides) in simple words. After torturing PHP developers for decades with MySQL Replication there is now a new replication option which does not require read-write splitting. A system that … Continue reading
2014/10/02
by admin
1 Comment
The HTTP Plugin for MySQL offers three APIs: REST-like CRUD, REST-like JSON DOCUMENT and SQL. The SQL API lets you run any SQL you want. Including, for example, DROP mysql.users if you mess up your setup. Insecure? It depends on … Continue reading
2014/09/27
by admin
10 Comments
It is official: MySQL listens to HTTP and speaks JSON. MySQL got a new plugin that lets HTTP clients and JavaScript users connect to MySQL using HTTP. The development preview brings three APIs: key-document for nested JSON documents, CRUD for … Continue reading
2014/08/07
by admin
Comments Off on PECL/mysqlnd_ms: summer time, (connection) pool time – Fabric support internals
The MySQL replication and load balancing plugin for PHP, PECL/mysqlnd_ms, aims to make using a cluster of MySQL servers instead of a single server as transparent as possible. Should you ever want to migrate your PHP app from a single … Continue reading
2014/07/29
by admin
Comments Off on PECL/mysqlnd_ms: how failed XA transactions get fixed
XA transactions are an open standard for distributed transactions. A distributed or global transaction can spawn multiple databases. XA transactions come handy, for example, when data sets are sharded over multiple servers and a business transaction affects multiple shards. The … Continue reading