‘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 does not know about slave lags and
reading stale data. In theory, MySQL Group Replication is just
about the perfect approach to run a standard PHP application
(WordPress, Drupal, …) on a small cluster (3-7 nodes) in LAN
settings. In theory, MySQL Group Replication …

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 your viewpoint.

It’s more than just another protocol…

On the first look HTTP is just another network protocol for
sending requests to MySQL. HTTP is the protocol of the web.
Whether you need to integrate MySQL in a larger setup and use web
services for data exchange or you want to access MySQL from a
JavaScript client …

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 JSON mapped SQL
tables and plain SQL with JSON replies. More so: MySQL 5.7.4 has
SQL functions for modifying JSON, for searching documents and new
indexing methods! The download and documentation (also here) is on http://labs.mysql.com/, the slides
are below:

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 MySQL server to any kind of MySQL cluster, install PECL/mysqlnd_ms
and see how much breaks. A simple app, might need no code changes
at all. Your APIs connect call remains unchanged, your query
execution calls remain the same: one connection handle
transparently …

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 free MySQL Fabric tools help to setup and manage a
sharded MySQL cluster. The development version of …

The development version of PECL/mysqlnd_ms now has an very early version
of distributed (2PC/XA)
transaction support tailored for use with clusters of MySQL
servers. XA transactions can span multiple servers in a
cluster to ensure transaction guarantees among them. In real
life, there is always, at some point, a sequence of work on your
data for …

A legend is born: PHP Unconference Europe, Majorca. Nearly one
hundred witnesses exist. The #phpuceu combines the proven concept of an
unconference with the beauty of the island of majorca. Within a
day after the end of the event, one third had bought a ticket for next years issue (May 9-10, 2015)! We
all knew for years, unconferences work. We finally have one at a
place that is easy to get and is just about perfect for any …

Majorca! May 2014 – 17./18! Could there be a better place and
time on earth for the PHP EU Unconference: sun, fun, plenty of cheap
flights, affordable accommodation? The PHP EU Unconference
(tickets) is the international version of the
national unconference. The national one frequently
sells out quickly (>350 tickets) not only because it matches
other conferences despite the ticket price of ~40 Euro only.
Traditionally the international one, is more cosy with about 100
…

What happens when you take a well known receipt for
unconferences, a group of young motivated and talented chefs,
some 300 attendees is in the photos below. Some call it, the
JavaScript
Unconference Hamburg (JS Unconf). Some say, they had seasons
in the sun. All I know is, I’ve been there and will come again!

The menu delivered by the chefs is as tasty and sophisticated as
that of a commercial conference but it does not cost you a
fortune. For some 40,– Euro you get two days packed with talks,
intensive discussions and nice fellows. It is the people that
drive an unconference and that becomes obvious the very …

Inspired by Antony, Andrey has implemented a memory optimization
for the PHP mysqlnd library. Depending on your usage pattern
and the actual query, memory used for result sets is less and
free’d earlier to be reused by the PHP engine. In other cases,
the optimization will consume about the same or even more memory.
The additional choice is currently available with mysqli only.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.