Currently viewing the category:
"SQL"
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 [...]
In my development environment, we have 2 levels of PHPmyAdmin user, the superuser (root) and developer user. Superuser is able to access all features available in PHPmyAdmin and developer user is the database user for database planet_shop which have limitation as stated in MySQL user privilege table.
The current problem is that developer user, which [...]
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 company just launched a new shopping cart web application and currently is under user acceptance phase. Last night, they discovered one bug which cause the payment not synchronize with the sales order data. They thought that it is a fault transaction and proceed to delete the data to synchronize the payment back.
Now they [...]
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
[...]
LVM snapshot is an exact copy of an LVM partition that has all the data from the LVM volume from the time the snapshot was created. The advantages of this is that we can get reliable backup in a small matter of time without suspending the MySQL service. Normal backup using mysqldump or mysqlhotcopy will [...]
Galera cluster replication are now supported in MySQL InnoDB and Percona XtraDB. Even it is new, this technology is having bright future to be developed and is coming into trend to achieve high availability and scalability on database server.
Advantages:
No need to learn new storage engine technology like NDBCluster. Learning new technology will require [...]
Subscribe via Email
Sci/Tech – Google News- Steven Spielberg Working on Live-Action Halo Series for Xbox - Wired 21 May 2013
- Road test: 2009 Honda Civic - Driving.ca - driving.ca 21 May 2013
- The New Flickr Is Pretty, but Is It Social? - New York Times (blog) 21 May 2013
- Eminem's publisher sues Facebook - Irish Independent 21 May 2013
- Next generation gaming: Xbox One launch features first glimpse of Call of Duty ... - Mirror.co.uk 21 May 2013
