MySQL master/slave help or ideas

B

bjseiler

Verified User
Joined
Jun 19, 2003
Messages
182
I have a two server setup for a client that I have questions on. The web server has DA installed on it and the other server will only be for MySQL. There is only one domain on the DA server and this is not a shared environment in any way.

If possible, does anyone know where I can look for a howto on setting up a master/slave relationship for MySQL and is this easy or a pain (considering future updates to MySQL, etc.)?

What I would like is the dedicated db machine to be the Master and then the mysql on the DA machine to be the slave. My main goal would be ease of use for backups as I would just be able to use the DA nightly backup system to backup site files and databases and then I would not have to script any db backups, ftp, etc., on the dedicated database machine.

Maybe there is an easier way to do this and I am just being forgetful. Any help would be appreciated.
 
I don't know if there's any such thing as a MySQL "slave".

Perhaps you're thinking about replication?

We're experimenting with MySQL replication now and will probably be able to post a How-To soon.

However it requires a third system as a management server.

Jeff
 
It is not a very nice term, but in "replication" the standard terms are Master and Slave but I should have mentioned replication because yes, that is what I mean.

Can you give a little more information about what you are working on and what you mean by the "third system"?
 
I'm following (and tweaking) a how-to I found on the 'net.

I don't have time to look for it now, but I believe I've posted it previously; you might want to search these forums for "mysql replication" without the quotes.

Jeff
 
Necropost

Sorry for the necro post but I thought I had a stroke of genius and it seems I'm not the first to think of this so I wanted to run it by you guys...I too have a multi-server setup and I want to add a third just to help with database transactions. I'd like to make the third non-directadmin just a replication slave that works with the da server as master. This would allow me to keep the typical da setup for the webserver and just use the mysql slave server for database reads. Will this configuration work with DA?
 
You're on own to use Master/Slave replication, as directadmin does not have any special tools to do that. So you'd better find a ready How-To on the subject, or read documents and manuals on MySQL.Com site.

As for me, I have some experience in creating Master/Slave replication with MySQL. And nothing special is needed, so you should do that as if no directadmin was installed on the box, and directadmin doesn't really care about how are you using MySQL, until it has all grants to create/modify/delete databases and users, etc.
 
You must log in or register to reply here.
Back
Top