mysql_master_slave mod

[mtu1380]

YaBBSE can support MySQL replication if it can be configured to use a master mysql server for writes only and a slave mysql server for reads.  This way we can speed up YaBBSE even more.

Why need this?  Even if we had multpile virtual servers running YaBBSE, they all have to connect to one mysql server (the master server in a mysql replication) because YaBBSE uses the same server for writes as well as reads.  So now the bottleneck is in the mysql queries.

Anybody up to this mod?  I'm quite interested in this mod.  Maybe it won't make much of a difference to most people. But lets say that it is cool to have this feature.

[[Unknown]]

This would be a lot easier for SMF, actually. (when it's released.)

-[Unknown]

[Anguz]

This would be a lot easier for SMF, actually. (when it's released.)

-[Unknown]

what would be the advantage of something like this?
can it be done with a regular webhost? or do you need a special kind?

[[Unknown]]

Well, the basic idea is that it's easier and faster to read than to write.

The slave servers would store data, but only be able to read.  They would be able to select data from the database at a good speed.... and only have to figure out how to optimize select queries.

The master would deal with write queries. (update, alter, delete, replace, etc.)  It would take care of the implications of a query (as in which rows it affects and how..) and then communicate this information to the other servers. (this is known as replication.)

There are a few problems with this.  First off, replication is currently sorta buggy even in the latest release of MySQL 4.  They are fixing more bugs with it every release, so I expect it will be stable soon... but it's not yet imho.

Second, all queries have to be sent to the proper server.  This means SELECT/SHOW queries should be sent to the slave, and others should be sent to master.

This would greatly optimize things, however, since you could have more than one slave to take up the load of SELECTs. (which are the most common type of query usually anyway...)

-[Unknown]

[Anguz]

ah ok... thank you for the explanation... let's hope it happens soon then

when you're talking about the master/slave servers, are they physical or just different copies of the program running?

[[Unknown]]

Physically different servers...

-[Unknown]

[Anguz]

thanks