businesses of all sizes are now have to deal with an explosive growth in data. This growth will be used by broader trends such as the rise of social networks, video and Web, along with the growing number of mobile and consumer devices driven workplace. Providing visibility and business intelligence into this data is placing increasing demands on traditional databases, cloud storage models and unstructured file systems like Hadoop. Together, these trends have created an increasing need for solutions that can be effectively scaled, secure and optimize data infrastructures.
The NetScaler DataStream ™ feature an intelligent mechanism for request switching provides the database layer by queries based on the SQL query of the distribution will be sent. If provided before database servers, NetScaler ensures optimal distribution of traffic of the application servers and Web servers. Administrators can segment traffic according to information in the SQL query and on the basis of database name, user name, fonts and package size. You can either configure load requests on load balancing algorithms based change compensation or the switching criteria elaborate by the configuration contents of a decision on an SQL query parameters change make based. You can configure additional monitors, that the state of the database server to keep track of
technology advantages .:
Native SQL Fluency
With its powerful new DataStream Technology , NetScaler now verified traffic data in real time with native SQL fluency and protocol aware policies for Microsoft SQL Server and MySQL database server. natively for Microsoft SQL Server, NetScaler parses the Tabular Data Stream (TDS) protocol for integrated policy and control with Microsoft System Center. For MySQL performs NetScaler SQL Intelligent Load Balancing, policy control and comprehensive health monitoring enable secure, large-scale online transaction processing (OLTP) implementations.
database server offload
NetScaler with DataStream now offers SQL connection multiplexing, significantly the number of SQL connections to back-end database servers to reduce and optimize database infrastructure by database server allows to effectively host the scale-up more databases. The ability of NetScaler SQL connection management outsourcing provides a cost effective way of database server consolidation and virtualization.
Cost scale-out
The addition of native SQL protocol support, NetScaler with DataStream technology now advanced Load allows balancing and health monitoring policies the best performance, efficiency and to ensure reliability. By routing all database traffic to the optimal server company can also custom policies established to guide how to read to a read-only database server pool all requirements. This capability also enables cost-effective high availability through advanced SQL health monitoring application of these SQL connections are routed only to backend database server, to ensure that a correct power. When combined with a comprehensive set of load balancing policies, including global server load balancing (GSLB), increase the active monitoring of database servers availability and offers companies an attractive alternative to expensive database clustering solutions.
Data Security and Threat Control
The new DataStream technology, policies can be applied at the user level to control access, database servers to back-end. This allows NetScaler to inspect all SQL transactions and perform SQL protocol validation and data access control. Data access events can also be tested and documented to meet compliance requirements. As a result, NetScaler now provides a holistic view of the Web, App and data planes comprehensive security and risk management of data on an entire data center or in the cloud environment allow.
Add Datastream is the NetScaler placed in- line between the application and / or web server and the database server. On the NetScaler appliance the database server by the service sector.
A typical Datastream application consists of the units described in the following figure.
As shown in this figure, can Datastream configuration of an optional content consist switching virtual server (CS), a setup load balancing, consisting of load virtual servers (LB1 and LB2) and services (SVC1, SVC2, Svc3 and Svc4) and content switching policies (optional) ,
The client (application or web server) Balancing Please send requests to the IP address of a virtual content server (CS) configured on the NetScaler appliance into operation. The NetScaler then the client authenticates the database user credentials on the NetScaler appliance can be configured. The Content Switching Virtual Server (CS) uses the associated content policy is switched to the requests. After the policy evaluation distributes the content virtual server (CS) forwards the requests to the appropriate load balancing virtual server (LB1 or LB2) which, then switch to the requests to the appropriate database server (represented by services on the NetScaler) on based on the load balancing algorithm. The NetScaler uses the same database credentials to authenticate users to connect to the database server.
When a content virtual server placement is not configured on the NetScaler, the client (application or web server) to send their requests to the IP address of a load virtual server on the NetScaler appliance configured compensation. The NetScaler authenticates the client by using the database user credentials on the NetScaler appliance configured, and then use the same credentials to authenticate the connection to the database server. The load balancing virtual server distributes the requests to the database servers to the load balancing algorithm. The effective load balancing algorithm for database switch is the least connection method.
Datastream connection multiplexing used to activate to be made on the same server-side connection several client-side requirements. The following connection properties are taken into account:
- username
- database_name
- packet size
- character set
NetScaler addresses the demand for optimal database performance
consequences: @NetScaler @bhavinsodha
0 Komentar