how are data s shared
Hello all :)
Im new to activgrid and I want to try out the opensource version and have some questions.
When I have to servers running with apache, mysql on different locations and I have an application with a mysql database in background and users are selling, buying, creating accounts... How are the mysql data's shared when one machine goes down? How is this done that the machines are always actuell with same data?
Can I do distributed clustering?
I was not able to find any information about this.
can someone help?
tia
stefan
Hi Stefan- Welcome to
Hi Stefan-
Welcome to the community! Happy to answer all of your questions.
From Studio -> Help ActiveGrid Documentation, open Installation and Deployment -> Install and Configure AG Server -> Session Persistence and Replication on Apache.
The session data can be stored on the primary server, and a backup server. The client stores it in a cookie. If the server you reach doesnt contain the session, it will pull it from the server which has it, based on the cookie, and continue the session.
geremy
Hello
Hello :)
hmm..., this is not what I mean. When I create a website with an mysql backend, how are this mysql-servers and databases gridet?
Is it possible to grid mysql?
tia
stefan
Im not able to find any
Im not able to find any information about mysql grid/ cluster and activegrid.
Can somone point me to some sites? Or explain how "mysql grid" is working or not working?
tia
stefan
I'm not sure if any of our
I'm not sure if any of our users are running ActiveGrid against a MySQL cluster, but I am very confident that many of them are running ActiveGrid against standalone MySQL instances. If anyone has experience running ActiveGrid, or any framework/language against a MySQL cluster, now is your chance to speak up ;)
Hi Stefan- The
Hi Stefan-
The clustering, as described above, is the extent of ActiveGrid's session replication features. That is, ActiveGrid supports session persistence across multiple servers, whether running in LAMP mode, or Java mode.
If you wish to run MySQL in a cluster, or grid, we dont document how to do that -- you may wish to research further on the Internet how that is possible, or perhaps somebody else from the community can add some details . . .
geremy
Hi Stefan, Information on
Hi Stefan,
Information on clustering in MySQL:
http://dev.mysql.com/doc/refman/4.1/en/mysql-cluster-overview.html
Information on replication in MySQL:
http://dev.mysql.com/doc/refman/4.1/en/replication.html
Hope this points you to the proper resources.
Eljakim