pecl:mysqlnd_poc_plugins

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
pecl:mysqlnd_poc_plugins [2012/04/27 14:31]
uw created
pecl:mysqlnd_poc_plugins [2012/04/27 14:38] (current)
uw markup
Line 1: Line 1:
-= Proof-of-concept mysqlnd plugins =+====== Proof-of-concept mysqlnd plugins ​======
  
-A wide range of mysqlnd plugins, providing additional features are available from [[PECL|http://​pecl.php.net]]. Mature, stable and ready-to-use plugins are documented in the php.net reference manual. Those include:+ 
 +A wide range of mysqlnd plugins, providing additional features are available from [http://​pecl.php.net]. Mature, stable and ready-to-use plugins are documented in the php.net reference manual. Those include:
  
 * Replication and Load Balancing plugin - PECL/​mysqlnd_ms * Replication and Load Balancing plugin - PECL/​mysqlnd_ms
-** R/W Splitting, Failover, Load Balancing +  ​* R/W Splitting, Failover, Load Balancing 
-** Connection Service Levels, Lazy Connections+  * Connection Service Levels, Lazy Connections
 * Query Cache plugin - PECL/​mysqlnd_qc * Query Cache plugin - PECL/​mysqlnd_qc
-** TTL and user-defined invalidation strategy +  ​* TTL and user-defined invalidation strategy 
-** Flexible storage: MEM, APC, process memory, user-defined+  * Flexible storage: MEM, APC, process memory, user-defined
 * User Handler plugin - PECL/​mysqlnd_uh * User Handler plugin - PECL/​mysqlnd_uh
-** Write plugins in PHP not C +  ​* Write plugins in PHP not C 
-** Basic monitoring, auditing, ...+  * Basic monitoring, auditing ​and more
  
 Additional, proof-of-concept plugins exist. The proof-of-concept plugins are not aimed at developers to showcase the possibilities of the mysqlnd plugin concept. They may or may not build, they may or may not be further developed. The replication and load balancing plugin is an example of a plugin that was available as a proof-of-concept long before it became of real value for end users and was released as stable. Additional, proof-of-concept plugins exist. The proof-of-concept plugins are not aimed at developers to showcase the possibilities of the mysqlnd plugin concept. They may or may not build, they may or may not be further developed. The replication and load balancing plugin is an example of a plugin that was available as a proof-of-concept long before it became of real value for end users and was released as stable.
Line 17: Line 18:
 Due to their early stage and uncertain future none of the proof-of-concept plugins is mentioned in the reference manual. Due to their early stage and uncertain future none of the proof-of-concept plugins is mentioned in the reference manual.
  
-== Multi Connect plugin - PECL/​mysqlnd_mc ==+===== Multi Connect plugin - PECL/​mysqlnd_mc ===== 
  
 **Theme: sharding, performance** **Theme: sharding, performance**
Line 25: Line 27:
 Instead, the proof-of-concept takes a SELECT statement and adds a LIMIT clause to create subtasks. This is unlikely to result in better performance. However, from a plugin implementors point of view it makes no difference over the possibly more appealing sharding use case example. Instead, the proof-of-concept takes a SELECT statement and adds a LIMIT clause to create subtasks. This is unlikely to result in better performance. However, from a plugin implementors point of view it makes no difference over the possibly more appealing sharding use case example.
  
-== Prepared Statement Handle Cache plugin - PECL/​mysqlnd_pscache ==+===== Prepared Statement Handle Cache plugin - PECL/​mysqlnd_pscache ===== 
  
 **Theme: performance** **Theme: performance**
Line 31: Line 34:
 The creation of a prepared statement handle is a relatively expensive operation. It may not be as heavy weight as opening a connection but still. Tests in other environments but PHP have shown significant performance gains when pooling or caching prepared statement handles. The creation of a prepared statement handle is a relatively expensive operation. It may not be as heavy weight as opening a connection but still. Tests in other environments but PHP have shown significant performance gains when pooling or caching prepared statement handles.
  
-== SQL injection protection plugin - PECL/​mysqlnd_sip ==+===== SQL injection protection plugin - PECL/​mysqlnd_sip ===== 
  
 **Theme: security** **Theme: security**
  
 The SQL injection protection plugin attempts to detect and block malicious SQL statements. It has two operational modes. In the learning mode it records all SQL statements and remembers them. The recorded statements are considered safe. Recoding shall be done in a safe environment,​ for example, in a test environment. In the operational mode the plugins verifies that all SQL statements match the lift of safe statements. All SQL statements that match are executed. The other ones are rejects. Execution is prevented. The SQL injection protection plugin attempts to detect and block malicious SQL statements. It has two operational modes. In the learning mode it records all SQL statements and remembers them. The recorded statements are considered safe. Recoding shall be done in a safe environment,​ for example, in a test environment. In the operational mode the plugins verifies that all SQL statements match the lift of safe statements. All SQL statements that match are executed. The other ones are rejects. Execution is prevented.
pecl/mysqlnd_poc_plugins.1335529919.txt.gz · Last modified: 2012/04/27 14:31 by uw