PHP Classes
elePHPant
Icontem

PHP MySQL Cluster Connection: Access MySQL clusters using separate connections

Recommend this page to a friend!
     
  Info   View files Example   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2016-01-21 (9 months ago) RSS 2.0 feedStarStarStarStar 69%Total: 296 This week: 1All time: 7,010 This week: 1,047Up
Version License PHP version Categories
mysqli-cluster 1.0GNU General Publi...5.6.16PHP 5, Databases, Performance and opt...
Description Author

This class can access MySQL clusters using separate connections.

It takes an array with parameters to connect to different servers of a MySQL cluster with the distinction of being for read or write query servers.

The class checks the type of query being executed and route them to a read server if it is of the SELECT type or to a write server to INSERT, UPDATE and DELETE queries.

The class can also reconect to another MySQL available server if the current server that it attempted to access is down.

If any errors happen, the class sends an email message to an address configured for the respective cluster server.

Innovation Award
PHP Programming Innovation award nominee
February 2016
Number 9

Prize: SourceGuarding PHP encoder tool		 Database clusters are used to distribute the load of servers when they need to execute many queries at the same time.

Usually there are server machines in the cluster that perform only write operations and others perform only read operations.

This class can connect to different servers of a MySQL database cluster. It sends queries to be executed to the right type of server depending on whether those are read or write queries.

Manuel Lemos
Picture of Mihails Atamanskis
  Performance   Level  
Name: Mihails Atamanskis <contact>
Classes: 1 package by
Country: Latvia Latvia

Level 1 Star

 Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Accessible without login Plain text file example.php Example Simple example
Plain text file mysql.php Class Single server working class
Plain text file mysql_cluster.php Class Cluster server working class

Downloadmysqli-cluster-2016-01-21.zip 3KB
Downloadmysqli-cluster-2016-01-21.tar.gz 3KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:296
This week:1
All time:7,010
This week:1,047Up
User Ratings User Comments (4)
 All time
Utility:100%StarStarStarStarStarStar
Consistency:95%StarStarStarStarStar
Documentation:-
Examples:100%StarStarStarStarStarStar
Tests:-
Videos:-
Overall:69%StarStarStarStar
Rank:369
 
Thats a very good class ;-)
8 months ago (José Filipe Lopes Santos)		70%StarStarStarStar
Thats a very good class ;-)
8 months ago (José Filipe Lopes Santos)		70%StarStarStarStar
Thats a very good class ;-)
8 months ago (José Filipe Lopes Santos)		70%StarStarStarStar
Thats a very good class ;-)
8 months ago (José Filipe Lopes Santos)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.