Database Abstraction Layer for PHP https://www.adodb.org/dokuwiki/ 2026-05-17T02:43:42+00:00 https://www.adodb.org/dokuwiki/ https://www.adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2017-04-29T02:01:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:loadbalancer:mysql_replication:automatic_control&rev=1493431270&do=diff Creating Connections ADOdb Loadbalancer Debugging Automatic Control Of Statement Execution Once we have assigned the primary write server, we can assign readonly servers. These servers are used to delegate readonly SQL operations, thereby reducing the load on the primary server. The Load balancer class can automatically determine which SQL statements can be delegated onto secondary nodes. There is no limit to the number of secondary servers that can be created. text/html 2017-04-28T00:09:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:loadbalancer:mysql_replication:creating_connections&rev=1493338149&do=diff Introduction ADOdb Loadbalancer Automatic Control Of Connections Creating A Connection Pool Each of the connections in the connection pool are defined in the exact same way as a normal ADOdb connection, which makes it simple to add the functionality of existing code. This is shown below: Existing ADOdb Connection text/html 2017-04-29T02:03:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:loadbalancer:mysql_replication:debugging&rev=1493431381&do=diff Automatic Control ADOdb Loadbalancer Manual Configuration Debugging Connections Using the ADOdb debugging feature differs slightly from the normal database connection, because the load balancer class is instantiated before any database connections are made. There is, therefore, a period during which no debugging information is available. text/html 2016-06-05T15:31:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:loadbalancer:mysql_replication:introduction&rev=1465140716&do=diff IntroductionADOdb Loadbalancer Creating A Connection Pool Introduction This tutorial uses as it's basis a MySQL replication system in the simplest configuration possible. The reader should be familiar with the implementation and management of such a configuration. All of the databases in the replication group must be configured to allow incoming connections from the machine running as the PHP client. text/html 2017-04-29T02:19:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:loadbalancer:mysql_replication:manual_configuration&rev=1493432373&do=diff <- v5:loadbalancer:mysql_replication:debugging|Debugging ^ v5:loadbalancer:index|ADOdb Loadbalancer ^ Manual Configurations The Load Balancer provides a small number of configuration options. ClusterExecute This option allows a command to be processed synchronously across all the defined nodes. It is especially useful for setting commands