June 28, 2013 By Severalnines
This article describes how to setup replication between a regular MySQL server and a Galera Cluster. The regular MySQL Server is the MASTER , and one of the Galera nodes will be the SLAVE:
In this example we have the following hosts:
June 17, 2013 By Severalnines
Magento is an open-source e-commerce platform built on Zend PHP and MySQL. It is widely adopted by online retailers with some 150,000 sites known to use it. Single server setups are easy to set up, but if your store is a huge success, then you probably need to think about clustering your environment with multiple servers. Clustering is done at the web, database and file-system level, as all web nodes need access to catalog images.
This post is similar to our previous posts on scaling Drupal and WordPress performance, and focuses on how to scale Magento on multiple servers. The software used is Magento version 1.7.0.2 , nginx, HAProxy, MySQL Galera …
[Read more]June 11, 2013 By Severalnines
Over the years, WordPress has evolved from a simple blogging platform to a CMS. Over seven million sites use it today, including the likes of CNN, Forbes, The New York Times and eBay. So, how do you scale Wordpress on multiple servers for high performance?
This post is similar to our previous post on Drupal, Scaling Drupal on Multiple Servers with Galera Cluster for MySQL but we will focus on Wordpress, Percona XtraDB Cluster and GlusterFS using Debian Squeeze 64bit.
April 26, 2013 By Severalnines
This post shows you how to move from a single instance Drupal/MySQL to a multi-server environment. A well designed multi-server deployment not only allows Drupal to scale, but will also enhance redundancy by removing single points of failure. Components used are Apache, PHP, csync2, lsyncd, Keepalived, HAproxy, MySQL Galera Cluster and ClusterControl.
I'm pleased to announce the release of Spider storage engine
version 2.22(beta), Vertical Partitioning storage engine version
0.11(beta) and BKA-for-ha_partition version 0.3.
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
Vertical Partitioning is a Storage Engine for vertical
partitioning for a table.
http://launchpad.net/vpformysql
BKA-for-ha_partition is a patch file of supporting "Batched Key
Access" for table partitioning feature.
http://launchpad.net/partitionmrrformysql
The main changes in this version are following.
Spider
- MS Windows support.
- Add UDF "spider_copy_tables".
Spider HA feature is now available!
…
Solaris Cluster is a multi-system, multi-site high availability
and disaster recovery solution that manages the availability of
applications services and data across local, regional and
geographically dispersed data centers. The Solaris Cluster
environment extends the Solaris Operating System into a cluster
operating system.
If you are following the Solaris Cluster product and features,
you would have noticed extreme innovation by Sun in the high
availability and disaster recovery space since the time we
released our first HA product many years ago. For well over a
decade, Solaris Cluster has been a market leader for providing
business continuity and disaster recovery solutions to all
mission critical business applications, spanning all the major
industry segments.
Continuing with our tradition of innovation, we are pleased to
announce another release - "Solaris Cluster 3.2 11/09" - an
update to the Solaris Cluster 3.2 …
Solaris Cluster is a multi-system, multi-site high availability
and disaster recovery solution that manages the availability of
applications services and data across local, regional and
geographically dispersed data centers. The Solaris Cluster
environment extends the Solaris Operating System into a cluster
operating system.
If you are following the Solaris Cluster product and features,
you would have noticed extreme innovation by Sun in the high
availability and disaster recovery space since the time we
released our first HA product many years ago. For well over a
decade, Solaris Cluster has been a market leader for providing
business continuity and disaster recovery solutions to all
mission critical business applications, spanning all the major
industry segments.
Continuing with our tradition of innovation, we are pleased to
announce another release - "Solaris Cluster 3.2 11/09" - an
update to the Solaris Cluster 3.2 …
Solaris Cluster is a multi-system, multi-site high availability
and disaster recovery solution that manages the availability of
applications services and data across local, regional and
geographically dispersed data centers. The Solaris Cluster
environment extends the Solaris Operating System into a cluster
operating system.
If you are following the Solaris Cluster product and features,
you would have noticed extreme innovation by Sun in the high
availability and disaster recovery space since the time we
released our first HA product many years ago. For well over a
decade, Solaris Cluster has been a market leader for providing
business continuity and disaster recovery solutions to all
mission critical business applications, spanning all the major
industry segments.
Continuing with our tradition of innovation, we are pleased to
announce another release - "Solaris Cluster 3.2 11/09" - an
update to the Solaris Cluster 3.2 …
I'm pleased to announce the release of Condition Pushdown for
ha_partition version 0.1.
http://launchpad.net/partitionconditionpushdownformysql
This release is a patch file for MySQL's table partitioning
feature. (ndb is excluded)
This patch file works to add methods("cond_push" and "cond_pop")
to ha_partition. As a result, every storage engine's table that
use table partitioning can get condition-pushdown through
ha_partition.
There was no problem because only ndb supported
engine-condition-pushdown up to now.
This patch was needed because the Spider storage engine supported
engine-condition-pushdown recently.
Enjoy!
For the past few months, I’ve been helping my friend develop and
market Philtro
.
We’ve gone through various iterations of the elevator pitch for
it, and the one that seems to be kinda working, is: “It’s
like a spam filter for your Twitter account.”
At SXSW, I got the opportunity to talk to Guy Kawasaki about this tool, and he said “There is no spam on twitter, if you don’t like it, don’t follow them”.
While that’s an easy way to handle spam, I also realized that the word Spam means different things to different people.
On Twitter, nothing is UCE. It’s easy to block the profiles with …
[Read more]