High availability and shared memory

[Raul Andres Guzman]

Hello, i am trying to improve a system with a high availability solution like prm on mysql 5.0, this system count with a database and others resources like apache and one php program who use a shared memory on fedora core 9 and the same time full the database. my question is what can i do with the shared memory is the master server go down? sorry about my bad english. thanks a lot for help.

[Yves Trudeau]

Hi Raul,

   the MySQL part is easy but the shared memory part is difficult to make HA. I don't know any solution that does that.  Maybe DRBD could be used over /dev/shm but you would need to map a file.

Regards,

Yves

2014/1/22 Raul Andres Guzman <raul.a...@gmail.com>

Hello, i am trying to improve a system with a high availability solution like prm on mysql 5.0, this system count with a database and others resources like apache and one php program who use a shared memory on fedora core 9 and the same time full the database. my question is what can i do with the shared memory is the master server go down? sorry about my bad english. thanks a lot for help.

--
You received this message because you are subscribed to the Google Groups "PRM-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prm-discuss...@googlegroups.com.
To post to this group, send email to prm-d...@googlegroups.com.
Visit this group at http://groups.google.com/group/prm-discuss.
For more options, visit https://groups.google.com/groups/opt_out.

[Raul Andres Guzman]

I was thinking in to make a copy of the shared memory or a replication to the other node. because the app who used the shared memory can be initialized with a script so i can to add like a resourse in pacemaker and when this app init, needs the database and the shared memory i suppose. So my problem is that in the other server( the slave) i have the shared memory to but it is outdate because the admins only writes in the master. Help me please the high avaiability is a new concept for me because i am a student. and i need this solution for used in a industry where i am a intern. thanks you from venezuela.

2014/1/23 Yves Trudeau <trud...@gmail.com>

--
You received this message because you are subscribed to a topic in the Google Groups "PRM-discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/prm-discuss/jSVIMaVk0GY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to prm-discuss...@googlegroups.com.

[Raul Andres Guzman]

Another Question. I do not even configured corosync and pacemaker. the only thing I have is the simple replication of 

a master to a slave. this is the correct configuration before configuring the cluster? or to use Percona resource manager 

requires the master master replication? I say to promote the new master. The management of failover. 

And return the system to its original state. how to configure my mysql replication? thanks friend.

2014/1/24 Raul Andres Guzman <raul.a...@gmail.com>

[Yves Trudeau]

Hi,

   yes, you do need a working replication setup before you start with the clustering.

Regards,

Yves