http://digg.com/linux_unix/How_To_Set_Up_Database_Replication_In_MySQL_2
On 10/9/06, Craig Smith <[EMAIL PROTECTED]> wrote:
Hi there,
I'm currently working on a setup and scripts that will give our company a
failover server that we can immediately switch to
in the event of failure without clients ever knowing it was off. I am
planning of putting this in the wiki if people
are interested.
As part of my solution I am using a mysqldump and import, but I've heard
that mysql can replicate the database live.
How do I go about configuring mysql to specifically replicate the vpopmail
database to my backup server so that the backup
server always has an up to date copy of the mysql database?
I can manage without that, but I think it would be more efficient method.
Either way though, with the procedure I'm finalising, should our server A go
down server B will take over it's role
with minimal amount of input. Or with the right script automatically.
Server B will be up to date in terms of A up to the last
minute before failure. This includes uncollected mail etc. Accounts only
have to be created on the main server, the changes will replicate to the
backup server every minute. (or x time frame as scheduled)
So I guess this post is two fold, are people interested in a method for the
above, or are there already loads of solutions out there,
and how does one configure mysql for replication.
Bearing in mind my SQL knowledge is nil. I've only just started getting to
grips with scripting so that's a later project. :-)
Thanks in advance.
Craig
-------------------------------------------------------
Craig Smith - Systems Engineer - Doctor Net
t. 0870 770 4990 - f. 0870 770 4991
Visit www.doc-net.com - let us be your key to success
Visit www.eMailCampaigner.com - close sales cheaper and faster
Visit www.SprintCRM.com - understand your customers better and increase
sales
-------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If you received this in error, please contact the sender and
delete the material.
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
