Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Ankit Agarwal
Liferay + MySQL Cluster / Master+Master Replication
March 17, 2012 10:37 PM
Answer

Ankit Agarwal

Rank: New Member

Posts: 6

Join Date: June 22, 2011

Recent Posts

Hi All,

We are developing our corporate website to be on Amazon Cloud with Liferay EE Cluster and MySQL.


We have successfully tested Liferay working with MySQL Cluster and MySQL Mater+Mater Replication however we are not sure what architecture of MySQLL would be suitable for our environment.
Hitoshi Ozawa
RE: Liferay + MySQL Cluster / Master+Master Replication
March 18, 2012 3:33 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7952

Join Date: March 23, 2010

Recent Posts

We have successfully tested Liferay working with MySQL Cluster and MySQL Mater+Mater Replication however we are not sure what architecture of MySQLL would be suitable for our environment.


I'm not sure what you'r asking. Are you asking if MySQL Cluster or MySQL Master-Master is better on Amazon Cloud?
Ankit Agarwal
RE: Liferay + MySQL Cluster / Master+Master Replication
March 18, 2012 3:38 AM
Answer

Ankit Agarwal

Rank: New Member

Posts: 6

Join Date: June 22, 2011

Recent Posts

Yes.
Hitoshi Ozawa
RE: Liferay + MySQL Cluster / Master+Master Replication
March 18, 2012 3:42 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7952

Join Date: March 23, 2010

Recent Posts

If you got MySQL Cluster working on Amazon Cloud with Liferay, that would be better because Master - Master replication has very large number of restrictions on how to setup and use tables.
Ankit Agarwal
RE: Liferay + MySQL Cluster / Master+Master Replication
March 18, 2012 3:43 AM
Answer

Ankit Agarwal

Rank: New Member

Posts: 6

Join Date: June 22, 2011

Recent Posts

Ankit Agarwal:
Yes.


Also wanted to understand if the below entry would be fine for MySQL Cluster / Master + Master model.

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql:loadbalance://<IP Address 1>:3306,<IP Address 2>:3306/<db name>?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
loadBalanceBlacklistTimeout=5000
jdbc.default.username=xxxx
jdbc.default.password=xxxx


In case of MySQL Cluster

database.mysql.engine=ndb
Ankit Agarwal
RE: Liferay + MySQL Cluster / Master+Master Replication
March 18, 2012 3:48 AM
Answer

Ankit Agarwal

Rank: New Member

Posts: 6

Join Date: June 22, 2011

Recent Posts

Hitoshi Ozawa:
If you got MySQL Cluster working on Amazon Cloud with Liferay, that would be better because Master - Master replication has very large number of restrictions on how to setup and use tables.



We got some strange behavior when we demoted one of the SQL Server in MySQL Cluster setup.

Liferay was able to connect to the available node but was unable to restart and without throwing any exceptions went into hung state. Could this be a problem with the Liferay jdbc drivers settings being loadbalanced or could be an OS Level issue.
Hitoshi Ozawa
RE: Liferay + MySQL Cluster / Master+Master Replication
March 18, 2012 3:53 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7952

Join Date: March 23, 2010

Recent Posts

In case of MySQL Cluster
database.mysql.engine=ndb


If you got Liferay to work, then that's probably the correct setting.