.. _slb_mysql:

slb mysql
=========

Configure mysql


mysql Specification
-------------------

	===================================== ==================================================
	===================================== ==================================================
	 **Type**                              *Configuration Resource*

	 **Element Name**                      mysql

	 **Element URI**                       /axapi/v3/slb/mysql

	 **Element Attributes**                mysql_attributes

	 **Statistics Data URI**               /axapi/v3/slb/mysql/stats

	 **Schema**                             :download:`mysql schema <slb-mysql/slb-mysql.txt>`
	===================================== ==================================================





	**Operations Allowed:**




.. raw:: html

   <script type="text/javascript">
 function showExample(a,b) { document.getElementById(a+'_div').style.display = 'block'; document.getElementById(a+'_cl').style.display = 'block'; document.getElementById(a+'_eg').style.display = 'none';}
   function closeExample(a,b) { document.getElementById(a+'_div').style.display = 'none'; document.getElementById(a+'_cl').style.display = 'none'; document.getElementById(a+'_eg').style.display = 'block';}
 </script>
   <table width='90%' style='margin-left:5%'>



.. raw:: html

   <tr style='border-bottom: thin solid; border-top: thin solid'><th width=15%>Operation</th><th width=10%>Method</th><th>URI</th><th width=15%>Payload</th><th width=10%></th></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Create Object



.. raw:: html

   </td><td valign = 'top'>


POST



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql



.. raw:: html

   </td><td valign = 'top'>


:ref:`1697_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Get Object



.. raw:: html

   </td><td valign = 'top'>


GET



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql



.. raw:: html

   </td><td valign = 'top'>


:ref:`1697_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Modify Object



.. raw:: html

   </td><td valign = 'top'>


POST



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql



.. raw:: html

   </td><td valign = 'top'>


:ref:`1697_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Replace Object



.. raw:: html

   </td><td valign = 'top'>


PUT



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql



.. raw:: html

   </td><td valign = 'top'>


:ref:`1697_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   <tr  style='border-bottom: thin solid;'><td valign = 'top'>


Delete Object



.. raw:: html

   </td><td valign = 'top'>


DELETE



.. raw:: html

   </td><td valign = 'top'>


/axapi/v3/slb/mysql



.. raw:: html

   </td><td valign = 'top'>


:ref:`1697_mysql_attributes`



.. raw:: html

   </td><td></td></tr>




.. raw:: html

   </table>

.. _1697_mysql_attributes:

mysql attributes
----------------

    **sampling-enable**

        **Type:** List

    **uuid**

        **Description** uuid of the object

        **Type:** string

        **Maximum Length:** 64 characters

        **Maximum Length:** 1 characters

.. _1697_sampling-enable:

sampling-enable
^^^^^^^^^^^^^^^
	=============================== ===================================================
	**Specification**
	=============================== ===================================================
	 **Type**                        *list*

	 **Block object keys**             

	=============================== ===================================================

    **counters1**

        **Description** 'all': all; 'curr_proxy': Curr Proxy Conns; 'total_proxy': Total Proxy Conns; 'curr_be_enc': Curr BE Encryption Conns; 'total_be_enc': Total BE Encryption Conns; 'curr_fe_enc': Curr FE Encryption Conns; 'total_fe_enc': Total FE Encryption Conns; 'client_fin': Client FIN; 'server_fin': Server FIN; 'session_err': Session err; 'queries': DB Queries; 'commands': DB commands reply; 

        **Type:** string

        **Supported Values:** all, curr_proxy, total_proxy, curr_be_enc, total_be_enc, curr_fe_enc, total_fe_enc, client_fin, server_fin, session_err, queries, commands

.. _1697_stats_data:

stats data
----------
.. list-table::
   :widths: 10 20 30 80
   :header-rows: 2
   :stub-columns: 1

   *  - 
      - Counter
      - Size
      - Description

   *  - 
      - 
      - 
      - 

   *  - 
      - server_fin
      - 2
      - Server FIN

   *  - 
      - curr_be_enc
      - 2
      - Curr BE Encryption Conns

   *  - 
      - total_be_enc
      - 2
      - Total BE Encryption Conns

   *  - 
      - total_proxy
      - 2
      - Total Proxy Conns

   *  - 
      - curr_proxy
      - 2
      - Curr Proxy Conns

   *  - 
      - commands
      - 2
      - DB commands reply

   *  - 
      - client_fin
      - 2
      - Client FIN

   *  - 
      - curr_fe_enc
      - 2
      - Curr FE Encryption Conns

   *  - 
      - queries
      - 2
      - DB Queries

   *  - 
      - session_err
      - 2
      - Session err

   *  - 
      - total_fe_enc
      - 2
      - Total FE Encryption Conns