Hello List,
Does mysql support raw device? In this case, two or more mysql servers
could share the same raw device as the backend storage.
On Wed, 3 Apr 2002 17:35:41 +1000
"Paul" <[EMAIL PROTECTED]> wrote:
> Scott,
>
> Try the following perl script to copy the contents of one mysql table from a
> mysql database and insert it's contents into another mysql database on a
> different host/server/computer under the same table name. Essentially a
> mirrored copy. Can be useful in a cron or a shedule as it wont output any
> information or anything. Fill in your database details and let it run.
> Ensure both mysql's are running on each of the hosts and all the accounts
> and permissions for each database work etc and try it out :)
>
> #!/usr/bin/perl
>
> $localuser = "mysql";
> $localpass = "mysqlpassword";
> $localdatabase = "mydatabase";
> $localtable = "products";
>
> $remoteuser = "mysql";
> $remotepass = "mysql";
> $remotehost = "192.168.1.200";
> $remotedatabase = "mirrordatabase";
>
> system ("/usr/local/bin/mysqldump -u
> $localuser --password=$localpass --add-drop-table $localdatabase $localtable
> | /usr/local/bin/mysql5:32 PM
> 4/3/2002--user=$remoteuser --password=$remotepass --host=$remotehost
> $remotedatabase");
>
>
> ----- Original Message -----
> From: Scott Broderick
> To: [EMAIL PROTECTED]
> Sent: Wednesday, April 03, 2002 5:07 PM
> Subject: How to mirror MySQL database on two servers?
>
>
> Does anyone know of a good place to start looking at how to mirror a MySQL
> database on two different computers?
>
> Any help would be great, Thanks
>
> Scott
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Patrick Hsieh <[EMAIL PROTECTED]>
GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php