Re: openSUSE MySQL Replication

Vahis wrote:

I've been practising with MySQL and Php in openSUSE.
All this is new to me and I've come up with the term Replication.

Everything on my site so far (no databases running there yet) is a
synced copy of another machine.

I do all the stuff there and rsync my server directories with that.
That gives me a safe way to edit the site and sync the server only when
everything works as (I think) it should.

Am I right in thinking the following:
I could run this machine as the master MySQL server and my web server
would be a slave. In other words my web server would carry a synced copy
of my master machine where I do all the editing.

So I could keep working the way I'm used to, just the MySQL part would
be added.

In case my 24/7 webserver or slave would be down I would have another one
to throw in to replace it. When it's up again it would just do the syncing
and I'd be back in business.

Can it be this simple?

I'm sure that putting this in practise could be another story though :)

Vahis
Remodeling my site to train new things:
http://waxborg.servepics.com

Here's a couple of links. The first article is a bit long but 'may' offer
insight into remote replication.

http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html?page=4

Here's a little program someone wrote for mirroring a MySQL database:

http://www.cryptonsystems.com/mirrorizer/


You'll have to figure out which, if any, of these will be of use to you.
.

Relevant Pages

  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)
  • Re: KDE is now broken (Fwd: Heads-up: KDE4 hitting testing tonight (UTC) )
    ... don't want to run an akonadi server either, ... KDE 4.0 was available. ... kmail) and I do not have a mysql server installed. ...
    (Debian-User)
  • Re: Using Access for web application?
    ... Any suggestions as to which newsgroup would be more ... The server that the web app will use in this case, ... > which technology you will decide to use as the Web server (Linux or Windows) ... Instead MySQL is being ...
    (microsoft.public.access.dataaccess.pages)
  • [UNIX] phpMyAdmin PHP Code Injection (left.php)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... phpMyAdmin is "web-based MySQL ... does not prevent a malicious user from altering the servers configuration ... server configurations to the list of servers configuration by adding ...
    (Securiteam)
  • Re: KDE is now broken (Fwd: Heads-up: KDE4 hitting testing tonight (UTC) )
    ... don't want to run an akonadi server either, ... doesn't ask if I want to use a mysql server on another host. ... Not if the file format was public. ... There seems to be too much windoze thinking entering Debian: ...
    (Debian-User)