Results 1 to 5 of 5

Thread: Replication

  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Unanswered: Replication

    Hey all,

    This is my first post, so go easy on me
    Can anyone offer some good suggestions about how to replicate a mySQL database both locally within the same subnet, and across the net to another server somewhere else? I have read a ton of good stuff about mySQL's built-in replication, but I'm looking for alternatives.

    Also, I'm looking for a good mySQL host ... someone who can provide great uptime and possibly replication as a service.

    Thanks!

  2. #2
    Join Date
    Aug 2003
    Location
    Elsdorf / Germany
    Posts
    3
    Hi,

    try phpmyadmin for this.

    with phpmyadmin you can export the structure and data into a file.
    Then you can use this file (contains all required sql statments) to create and fill the tables within a different database.
    The file will not contain a statment to create the database itself, only the tables but you can add additional statements to the file with an editor.

    gupi

  3. #3
    Join Date
    Aug 2003
    Posts
    3
    Gupi,

    phpmyadmin is good, but that would require a manual process ...
    Replication should take place automatically.
    Besides, mySQL-Front is a much better front end.

  4. #4
    Join Date
    Aug 2003
    Location
    FDR India
    Posts
    24
    Hi

    I'm not sure I understand the question?

    Are you talking about scheduled database back-ups or database mirroring for load balancing?

    I'm no expert, but for the former a cron should do. Can't help with the latter

    regards
    theN
    Last edited by then; 08-10-03 at 07:39.

  5. #5
    Join Date
    Aug 2003
    Posts
    3
    then,

    What I'm really looking to do is mirror a database for redundancy ... if one DB server becomes unreachable for some reason, I would like to have a hot spare.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •