Always when we talk about MySQL replication we talk about high-availability (HA). Why we choose Mysql Replication and not Mysql Clustering in a high-availability environment? Because Mysql Cluster have some limitations on his NDB storage system and probably we want to use INNODB (ACID compliant storage system) and foreign keys.
What is Replication ? Is a Database syncronization between two (or more) MySQLnodes.
I will start explain you in this step by step tutorial how to do a master slave configuration between 2 nodes.

Share this post

…

In the old versions of Liferay, switching from HSQL to MySQL was easy under Glassfish. Just replace the jdbc connector created for HSQL with one for MySQL and at the next restart of Liferay all was working ok. From version 5.2.1 configuration was changed and all is done from portal.properties. To switch from HSQL just create a portal-ext.properties with the following content:

Share this post

Hide Bookmarks

I will try to exemplify as easy as possible a clustered mysql server under Debian
1. Mysql Servers
For example we have 2 servers what need to be configured in clustered mode. This servers run mysql 4.1.8a (The configuration is still possible to work on other versions). Each cluster server need to have this additional conf in /etc/mysql/my.cnf:

Share this post

Hide Bookmarks