2013/10/17
by admin
2 Comments
When you design a distributed database you are faced with a variety of choices each having its well known pro’s and con’s. MySQL Fabric made an intial decision for one design. Let me try to put in context of NoSQL … Continue reading
2013/10/09
by admin
7 Comments
For decades MySQL has considered BLOB a sink for data junk that didn’t fit the strictly typed SQL bill. As the outside world began voting for JavaScript, JSON and key-value/key-document stores, TEXT/BLOB was rediscovered as the only way to store … Continue reading
2013/09/26
by admin
Comments Off on Mir unbekannte Welten: DOAG SIG Development/Tools
Beim gestrigen Event DB-Programmierung: Oracle 12c für Entwickler der Deutsche ORACLE-Anwendergruppe (DOAG) SIG Development/Tools erfolgte ein Blick über den Tellerrand für Referent und Teilnehmer. Ich durfte über die verschiedenen Cluster Optionen für MySQL sprechen und die Sicht des PHP-Entwicklers andeuten. … Continue reading
2013/09/23
by admin
Comments Off on PHP Unconference Hamburg 2013: hungry for more
A day before the 7th edition of the PHP Unconference Hamburg the caretake of the venue called the organizers to inform them that their event cannot take place. The space would be needed as a polling station for the german … Continue reading
2013/09/23
by admin
6 Comments
MySQL 5.7 has sharding built-in through MySQL Fabric (Lab Release). And, MySQL has scaled the marketing team to handle 500.000 customer requests/s – or, was it MySQL 5.7 query throughput? Whatever. MySQL Fabric frees you from implementing sharding yourself. MySQL … Continue reading
2013/08/08
by admin
7 Comments
Modern NoSQL solutions make good, old MySQL Replication appear weak on High Availability (HA). Basically, MySQL users have three choices for MySQL Replication HA: give up on HA, believe that doubling single points of failures means HA, or go for … Continue reading
2013/06/24
by admin
Comments Off on Connecting MySQL and the Dojo Toolkit: MySQL data store
Based on my own limited experience with the Dojo Toolkit, you either love or hate it. First, I disliked the steep learning curve. After a few days, I began to enjoy it, for example, because of the Dijit interface vodoo: … Continue reading
2013/06/21
by admin
2 Comments
Over the years JavaScript has become an integral part in every web developers life. The Dojo Toolkit is one of many JavaScript frameworks offering language goodies and interface voodo. It may not be the most used framework but it is … Continue reading
2013/06/12
by admin
Comments Off on PHP: PECL/mysqlnd_ms 1.6 – automatic retry loop for transient errors
PECL/mysqlnd_ms is client-side load balancing driver plugin for PHP MySQL that aims to increase distribution transparency when using any MySQL based cluster: failover, read-write splitting, abstraction on consistency (e.g. read-your-writes), partitioning/sharding support, … it’s all there. Until a few minutes … Continue reading
2013/06/05
by admin
Comments Off on (Slides) DIY – A distributed database cluster, or: MySQL Cluster
Ever wondered how a database cluster ticks? Here’s how! During my talk at the International PHP Conference (#ipc13) I tried to build a cluster. I brought a soldering iron, sold, pink, orange and brown cables with me. Then, I tried … Continue reading