How to configure mysql clustering in centos.

queries on Database configuration in Linux
Forum rules
queries on Database configuration in Linux

How to configure mysql clustering in centos.

Postby admin » Tue Sep 30, 2014 3:36 pm

admin
Site Admin
 
Posts: 0
Joined: Wed May 07, 2014 3:49 pm

Re: How to configure mysql clustering in centos.

Postby Vipin » Wed Nov 26, 2014 10:36 am

Hi,

What does Clustering mean?

Clustering, in the context of databases, refers to the ability of several servers or instances to connect to a single database. An instance is the collection of memory and processes that interacts with a database, which is the set of physical files that actually store data.

Clustering offers two major advantages, especially in high-volume database environments:

Fault tolerance: Because there is more than one server or instance for users to connect to, clustering offers an alternative, in the event of individual server failure.
Load balancing: The clustering feature is usually set up to allow users to be automatically allocated to the server with the least load.

Clustering takes different forms, depending on how the data is stored and allocated resources. The first type is known as the shared-nothing architecture. In this clustering mode, each node/server is fully independent, so there is no single point of contention. An example of this would be when a company has multiple data centers for a single website. With many servers across the globe, no single server is a “master.” Shared-nothing is also known as “database sharding.”

Contrast this with shared-disk architecture, in which all data is stored centrally and then accessed via instances stored on different servers or nodes.

The distinction between the two types has become blurred recently with the introduction of grid computing or distributed caching. In this setup, data is still centrally managed but controlled by a powerful “virtual server” that is comprised of many servers that work together as one.

For configuring MySql cluster in Centos, please refer to these links

http://skillachie.com/2014/06/30/mysql- ... tcentos-6/
http://blog.secaserver.com/2012/11/cent ... imple-way/

Methods in these articles are very simple to implement in Centos.

Hope it helped someone :D .
Vipin
 
Posts: 0
Joined: Tue Nov 25, 2014 11:50 am
Location: Trivandrum

my comment

Postby DennisSi » Mon Dec 29, 2014 12:25 am

Informative article
wish to
publish it on your resource.
You do not mind ?

[url].[/url]
DennisSi
 
Posts: 0
Joined: Thu Dec 25, 2014 12:57 pm

How to configure mysql clustering in centos

Postby coiche » Fri Sep 29, 2017 6:06 pm

i also need to solve this.
or is there posibility to catch this error and print my own error dialog
like "Database server error, please call your administrator"?

can somebody help?

Очень интересный и красивый сайт
http://voltservice.cn.ua
coiche
 
Posts: 0
Joined: Sat Dec 19, 2015 1:16 pm
Location: Anitioncuck


Return to Database configuration in Linux

Login  •  Register