Re: openSUSE MySQL Replication



On 2008-02-25, Michael Soibelman <in-the@xxxxxxxxx> wrote:
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.
<snip>

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.
<snip>
Can it be this simple?

<snip>

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.

Thank you, Michael.
I'll do some reading.

Vahis
Remodeling my site to train new things:
http://waxborg.servepics.com
--
"The only thing more expensive than training is the lack of it"
Henry Ford
.



Relevant Pages

  • Re: write with cURL
    ... execute permissions. ... This is assuming that the PHP script runs ... of potential security risks from other users on the same server. ... web server itself is part of the group. ...
    (alt.php)
  • RE: System.Data.SqlClient "Timeout expired" causing ASP.net web applic
    ... There are many values here that can shutdown the aspnet_wp. ... > update tables on a Web Server running SQL Server 2000. ... > formation(DataSet currentBalances): Timeout expired. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: web service architecture question
    ... To assume that we have all the security we will ever need is a bad one. ... ways to breach a server, and the separatin of the web and app server is one ... You can use remoting or web services. ... The web server will be exposed outside the ...
    (microsoft.public.dotnet.framework.webservices)
  • RE: System.Data.SqlClient "Timeout expired" causing ASP.net web applic
    ... There are many values here that can shutdown the aspnet_wp. ... > update tables on a Web Server running SQL Server 2000. ... > formation(DataSet currentBalances): Timeout expired. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: System.Data.SqlClient "Timeout expired" causing ASP.net web applic
    ... There are many values here that can shutdown the aspnet_wp. ... > update tables on a Web Server running SQL Server 2000. ... > formation(DataSet currentBalances): Timeout expired. ...
    (microsoft.public.dotnet.framework.aspnet)