PHP Classes

File: example.php

Recommend this page to a friend!
  Classes of Mihails Atamanskis   PHP MySQL Cluster Connection   example.php   Download  
File: example.php
Role: Example script
Content type: text/plain
Description: Simple example
Class: PHP MySQL Cluster Connection
Access MySQL clusters using separate connections
Author: By
Last change: small fix
Date: 8 years ago
Size: 1,784 bytes
 

Contents

Class file image Download
<?php

$databases
= array();

$i=0;
// Primary database

$databases[$i]['number'] = $i; //server in cluster unique number
$databases[$i]['role'] = 'read'; //server role: read/write
$databases[$i]['db_host'] = '10.0.0.1'; //hostname (ip or domain)
$databases[$i]['db_name'] = 'database'; //database name
$databases[$i]['db_user'] = 'user'; //database user
$databases[$i]['db_pass'] = 'password'; //database password
$databases[$i]['error_email'] = 'my@email.com'; //database error report email

//Second database
$i++;
$databases[$i]['number'] = $i; //server in cluster unique number
$databases[$i]['role'] = 'write'; //server role: read/write . If only one server in cluster then it use for read & write. if
$databases[$i]['db_host'] = '10.0.0.2'; //hostname (ip or domain)
$databases[$i]['db_name'] = 'database'; //database name
$databases[$i]['db_user'] = 'user'; //database user
$databases[$i]['db_pass'] = 'password'; //database password
$databases[$i]['error_email'] = 'my@email.com'; //database error report email

require_once 'mysql_cluster.php';

$db = new db_cluster($databases);

# Uncoment if need test shutdown one of server
//echo "sleep start\n";
//sleep(70); #mysql timeout set to 60 seconds, we must get error and select other mysql server
//echo "sleep stop\n";

//Example 1
$sql_results = $db->query("Select * from users LIMIT 10");
var_dump($db->get_row($sql_results));

//Multy rows example
$sql_results = $db->query("Select * from users LIMIT 10");
if (
$db->num_rows($sql_results) > 0) {
    while (
$row = $db->get_row($sql_results)){
       
//Some your code
   
}
}