MySQL Cluster is different compare to normal MySQL server. It has 3 roles:
management data SQL or API
Data node will required a lot of memory utilization. It is recommended for these nodes to not share any workload with SQL or management nodes as it would end up with resources exhaustion. So we will setup [...]
I have successfully installed and integrate MySQL Cluster with HAproxy and Keepalived to provide scalable MySQL service with cPanel server run on CentOS 6.3 64bit. As you guys know that cPanel has a function called “Setup Remote MySQL server” which we can use to remotely access and control MySQL server from cPanel.
This will bring [...]
I have another set of MySQL Galera Cluster running on Percona XtraDB Cluster which having 2 nodes with 1 arbitrator. In total, I do have 3 votes in the quorum. The expected problem when we have 2 nodes run in cluster is the possibility for this cluster to be split-brain if the arbitrator is down, [...]
In this post I am going to install a MySQL cluster as refer to the architecture as below:
MySQL cluster is consists of 3 types of node:
Data node (mysql-data1 & mysql-data2) Sql daemon node (mysql-mysqld1 & mysql-mysqld2) Management node (mysql-management)
Data node will hold the database and [...]
Piranha is a simple yet powerful tool to manage virtual IP and service with its web-based GUI.
As refer to my previous post on how to install and configure Piranha for HTTP service: http://blog.secaserver.com/2012/07/centos-configure-piranha-load-balancer-direct-routing-method/, in this post we will complete over the Piranha configuration with HTTP and HTTPS load balancing using direct-routing with firewall marks [...]
I am going to integrate Severalnines’s ClusterControl into my existing MySQL Galera cluster which currently being used by our development team. ClusterControl allow us to manage, control and monitor our MySQL cluster from single point.
Actually, you can use their installer script to install a complete MySQL Galera suite as refer to this post.
Some of us might not having much time in installing and configuring several servers which run in a database cluster. As you can refer to my previous posts which related to installation of MySQL Galera and Percona XtraDB Cluster, it always required to spend 1 or 2 hours to do the installation and configuration.
Our new online shopping cart site is run on 3 Apache servers which mount the same document root in all nodes. With a load balancer in front of it to distribute the HTTP/HTTPS connections equally using weigh round-robin algorithm, we are facing big problem in session handling for the site; When user’s session is not exist [...]
I am currently working on a web cluster project using CentOS. In this project, I have 2 web servers running on Apache and mounted the same document root to serve the HTTP content. I also have 2 servers in front of it to become the load balancer and failover to increase high availability of the [...]
Percona has just released XtraDB Cluster stable version which similar to Galera InnoDB patches in MySQL. Percona XtraDB Cluster is a high availability and high scalability solution for MySQL users. XtraDB Cluster integrates Percona Server with the Galera library of high availability solutions in a single product package.
Variables as below:
OS: CentOS 6.2 64bit
To achieve high availability, what we really need is to eliminate single point of failure as many point as possible but, it comes with expensive way to do this. What if we just have 2 servers, and we want to have highest web service availability possible with lowest cost?
Most important part in this high [...]
Cloud storage nowadays has create a trend on storing and accessing data from any where around the world. 2 most popular cloud storage providers are Dropbox and Box.net. In this post, I am going to show you on how to mount Box.net account inside the Linux box. You are required to have a Box.net account, [...]
- Xbox ONE: 'The ultimate all-in-one home entertainment system': Microsoft finally ... - The Independent 22 May 2013
- 67% of Australian tweens on social media: McAfee - Times LIVE 22 May 2013
- Users urged to make best use of smartphones - New Straits Times 22 May 2013
- Yes Launches World's First Samsung 4G Chromebook In Malaysia - Bernama 22 May 2013
- Renault-Nissan showcase - The Sun Daily 22 May 2013