| Mailing List | | Home | | MySQL General - General MySQL discussion | | MaxDB - Everything about MaxDB, formerly known as SAP DB | | MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP | | MySQL++ - Programming with the C++ API to MySQL | | ODBC - ODBC with the MySQL Connector/ODBC driver | | Java Help - Mostly related to the MySQL Connector/J driver | | Perl - Perl support for MySQL with DBI and DBD::mysql | | GUI - MySQL GUI Tools | | Announcement |
|
|
 | | Re: What solution on RedHat Enterprise 3 Linux can give me a
mirrored log volu | Re: What solution on RedHat Enterprise 3 Linux can give me a
mirrored log volu 2004-05-10 - By Filip Sergeys
Back
Hi,
We use heartbeat and drbd in a similar setup. It works good,but there
are some considerations to take into account:
Drbd is only able to write to a volume on another server, you cannot
read that volume at the same time on that other server.
The consequences of this limitation:
a) you cannot use maxdb hotstandby, because that requires write and read
access at the same time. You can use maxdb "normal" standby
b) we experienced that logbackup recovery is instable on maxdb version
prior to 7.5.0 build 9. When you have recovered the database completely
and terminated with a util_release, the server crashes. Thus be sure to
use the latest build
c) Failing over to the backup server requires some steps to go through.
- Stop the drbd on both nodes
- umount the drbd device on the backupserver
- mount the underlaying partition that drbd used to write the maxdblogs
to
Have a look at:
http://dev.mysql.com/doc/maxdb/en/cd/0bbc023569f4428f571bae780e3ebc/content.htm
for the commands of a standby database recovery.
It is better to use a separated direct connection between the two
servers for drbd (it consumes quite some bandwidth).
Cheers,
Filip Sergeys
On Sun, 2004-05-09 at 13:43, Jim Sanders wrote:
> What solution on RedHat Enterprise 3 Linux can give me a mirrored log
> volume configuration?
>
> I cannot afford the HA/Cluster solution you have said exists for MaxDB.
>
> I want to set up the following scenario:
>
> s1 is production server. It has a mirrored log volume. The mirrored log
> volume is installed on server s2 as its log volume. The data on s2 will
> be the latest full backup from s1.
>
> Both s1 and s2 are RH E3 Linux completely seperate servers with only
> TCP/IP connections.
>
> What software solution do you know of that can mirror volumes on 2
> separate servers reliably in this way?
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe: http://lists.mysql.com/maxdb?unsub=filip.sergeys
@(protected)
>
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be *
* Oostkaai 23 B-2170 Merksem *
* 03/6416673 - 0477/340942 *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
|