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 (7 months ago) RSS 2.0 feedStarStarStarStar 69%Total: 289 This week: 1All time: 7,040 This week: 954Up
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
Age: 32
All time rank: 358410 in Latvia Latvia
Week rank: 811 Up2 in Latvia Latvia Up
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

 Version Control Unique User Downloads Download Rankings  
 0%
Total:289
This week:1
All time:7,040
This week:954Up
User Ratings User Comments (4)
 All time
Utility:100%StarStarStarStarStarStar
Consistency:95%StarStarStarStarStar
Documentation:-
Examples:100%StarStarStarStarStarStar
Tests:-
Videos:-
Overall:69%StarStarStarStar
Rank:321
 
Thats a very good class ;-)
6 months ago (Josť Filipe Lopes Santos)
70%StarStarStarStar
Thats a very good class ;-)
6 months ago (Josť Filipe Lopes Santos)
70%StarStarStarStar
Thats a very good class ;-)
6 months ago (Josť Filipe Lopes Santos)
70%StarStarStarStar
Thats a very good class ;-)
6 months ago (Josť Filipe Lopes Santos)
70%StarStarStarStar