VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
eguadamuz at gmail.com
Guest
|
 Posted: Tue Mar 25, 2008 8:43 pm Post subject: [asterisk-users] Realtime replication!!!!! |
 |
|
I am trying DB replication with MySQL. I have two nodes, and Linux-HA
running on both of them. The first idea is simply have the master
database in one server, where both nodes send the SQL queries and in
the other node a second DB replicated from the first one. In the case
of the master database fails, Linux-HA should promote the second
database to the master state.
On Tue, Mar 25, 2008 at 6:33 PM, Cheikhou DIAW <deuteryon at gmail.com> wrote:
| Quote: |
Hi list
what do you think is the best way to replicate an asterisk mysql realtime
database ,
i'm setting up a cluster , and i obviously need to ensure the database high
availability
i've been reading about DRBD and the internal replication functionality of
mysql , but i dont really know if its the proper solution, i'm looking for
advices on how to replicate the mysql realtime database
so then when the main server is down , the second replace it .
any help would be gr8
Best regards
--
Cheikhou DIAW
+225 02175082
+225 22414039
msn: deuteryon at hotmail.com
e-mail:deuteryon at gmail.com
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
|
|
|
| Back to top |
|
 |
tilghman at mail.jeffa...
Guest
|
| Posted: Tue Mar 25, 2008 9:03 pm Post subject: [asterisk-users] Realtime replication!!!!! |
|
|
On Tuesday 25 March 2008 20:43:49 Edgar Guadamuz wrote:
| Quote: | I am trying DB replication with MySQL. I have two nodes, and Linux-HA
running on both of them. The first idea is simply have the master
database in one server, where both nodes send the SQL queries and in
the other node a second DB replicated from the first one. In the case
of the master database fails, Linux-HA should promote the second
database to the master state.
|
Actually, MySQL supports dual-master replication, so both machines may be
both the master, slaving queries from the other, which keeps them both
balanced, and it won't matter which one goes down. For more on that, I invite
you to read MySQL documentation, as this really isn't on-topic for this list.
--
Tilghman |
|
| Back to top |
|
|
YEHAVI at VMS.HUJI.AC.IL
Guest
|
| Posted: Wed Mar 26, 2008 12:02 am Post subject: [asterisk-users] Realtime replication!!!!! |
|
|
| Quote: | what do you think is the best way to replicate an asterisk mysql realtime
database ,
i'm setting up a cluster , and i obviously need to ensure the database high
availability
i've been reading about DRBD and the internal replication functionality of
mysql , but i dont really know if its the proper solution, i'm looking for
advices on how to replicate the mysql realtime database
so then when the main server is down , the second replace it .
|
I won't call it "best way" but I am using two-way master-slave repliaction of
MySQL.
__Yehavi: |
|
| Back to top |
|
|
bwentdg at pipeline.com
Guest
|
| Posted: Wed Mar 26, 2008 5:45 am Post subject: [asterisk-users] Realtime replication!!!!! |
|
|
Could you point a link to the DUAL MASTER Replication.
I swear i have been all over the docs and have NOT found this,
thx
Tilghman Lesher wrote:
| Quote: | On Tuesday 25 March 2008 20:43:49 Edgar Guadamuz wrote:
| Quote: | I am trying DB replication with MySQL. I have two nodes, and Linux-HA
running on both of them. The first idea is simply have the master
database in one server, where both nodes send the SQL queries and in
the other node a second DB replicated from the first one. In the case
of the master database fails, Linux-HA should promote the second
database to the master state.
|
Actually, MySQL supports dual-master replication, so both machines may be
both the master, slaving queries from the other, which keeps them both
balanced, and it won't matter which one goes down. For more on that, I invite
you to read MySQL documentation, as this really isn't on-topic for this list.
|
|
|
| Back to top |
|
|
rjcarvalho at gmail.com
Guest
|
|
| Back to top |
|
|
tilghman at mail.jeffa...
Guest
|
| Posted: Wed Mar 26, 2008 9:01 am Post subject: [asterisk-users] Realtime replication!!!!! |
|
|
On Wednesday 26 March 2008 05:45:19 Al Baker wrote:
| Quote: | Could you point a link to the DUAL MASTER Replication.
I swear i have been all over the docs and have NOT found this,
thx
|
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html
See Figure 7-3.
--
Tilghman |
|
| Back to top |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Search
