MulticastReplication
[edit] Multicast Replication
[edit] Introduction
This project aims to create a mysql plugin to make data replication through multicast. The idea is to develop a plugin or a external independent application to do this. A multicast capability for replication is usefull if you have a large number of databases and don't wan't to have a huge traffic on your network. The multicast funcionality will be supporte by the SpreadAPI.
[edit] System architecture
Actually, there a lot of doubts on it. Here is a description of what the application should do:
The idea is to create a application that connects to a MySQL master as common slave asking for binary logs. This application will also connect to a spread daemon running on the server and then join a multicast group. That each log event would be replicated through multicast. On the other hand, another application should connect to spread daemon and join a group. Each log event received on that group should be replicated on the database.
How the application do this is what is needed to be defined here. The first idea is to create the application as a MySQL plugin. Although documentation don't tell it, it seems to be possible to do such application as a plugin. My next step is to define if this can be made as a plugin or not. Any help on this would be appreciated...