At MySQL Conference in Santa Clara this April the idea was brought up, now we do it:
a MySQL Proxy hackathon this summer in Sun Office in Hamburg, Germany.
We want bring together everyone who is interested in hacking on MySQL Proxy, sharing ideas how it is used and * how ...
more ...In my rare spare time work on the Binlog Storage Engine: MySQL Proxy Edition and for a few days I was wondering why my index-based JOINs didn't worked. With a index it works, with an index nothing is returned.
I narrowed it down to a simple test-case:
select * from ...We are happy to announce that MySQL Proxy 0.7.1 is available in a source and binary release for many popular platforms.
This release contains a few minor bugfixes and changes in directory layout over the previous 0.7.0 release.
lib/mysql-proxy/pluginsA binlog storage engine was talked about many times already. Being able to JOIN against the binlogs, the just SELECT it, search for entries ... is not possible with current SQL commands in the MySQL Server.
As you have read the previous articles here, I wrote a binlog encoder/decoder for ...
more ...After getting the Druckbetankung stuff working and discussing the idea with the replication team we figured out that my presented approach has a nice hack-value, but otherwise is perhaps a bit too complicated. The same result can be achieved by a more simplified approach:
... or how to misuse RBR to fill a MySQL table in the hopefully fastest way.
In my session yesterday I didn't had time to talk about this. The slide-desk covers it and I still wanted to document the idea at least.
The starting point is "Row Based Replication stores ...
more ...I just pushed the code for my replication changes on launchpad:
$ bzr branch lp:~jan-kneschke/mysql-proxy/replication
The presentation should be available ... soon.
One of the first examples is about filtering binlogs. If you want to remove all ALTER statements from the replication stream (or in this case the binlog ...
The slides are written, uploaded and the code snippets work. I'm ready to present.
One of the topics will be merging binlogs which is what multi-master replication is all about on the low level. A common example is sharding where you have several masters which share the same table-structures ...
... is the title of my session at the MySQL Conf 2009
I'll unveal the full thing at the session at next week Tuesday, but for now let me show you this:
local f = binlog.open("my-binlog", "w")
f:append({
server_id = 1,
type = "INCIDENT_EVENT",
incident = {
incident = 42,
message = "The answer ...