Optimize database infrastructure with NetScaler DataStream technology

NetScaler improves the scalability, performance, availability and security of Microsoft SQL Server and Oracle MySQL while lowering overall costs. Placed in the data tier, NetScaler DataStream technology provides native SQL protocol support to deliver intelligent traffic and connection management and high availability, and optimize the efficiency and performance of database infrastructure.

Scale and consolidate database infrastructure

As application demands increase, so do the requirements placed on databases. In response, administrators often look to scale up their database infrastructure by buying a high-end SMP (symmetric multiprocessing) server, an approach which quickly becomes expensive. NetScaler DataStream technology offers a highly cost-effective means of scaling up while simultaneously consolidating database infrastructure resources. By combining hundreds of requests into a few long-lived SQL connections and offloading SQL servers from connection management tasks, NetScaler DataStream technology maximizes database infrastructure efficiency and ROI. By overcoming limitations on concurrent connections, more databases can be hosted on a server to achieve consolidation and reduce complexity.

Optimize database scale-out

NetScaler DataStream technology can optimally route SQL requests to the most available servers based on extensive health monitoring capabilities. A SQL-aware content switching policy engine is able to perform the read/write split between the read and write server pools. SQL connection offload with SQL load balancing enables high performance for OLTP (online transaction processing), allowing the customer to keep adding more servers and expand website capacity easily, with no increase in latency.

Improve database availability

Business continuity depends on the guaranteed availability of database servers. IT administrators have typically achieved this through clustering, an approach which requires expensive software, SMP hardware and often a storage area network (SAN). NetScaler DataStream provides a quicker, simpler and less expensive solution with SQL health monitoring and automated failover. If a database server fails, NetScaler automatically and transparently reroutes outstanding SQL requests to another server.

Simplify database security

NetScaler DataStream technology enables SQL-aware policies and enforces user access control. By implementing NetScaler in their database infrastructure, companies can easily generate aggregate transaction logs for all data accesses, aiding compliance and regulatory needs. Since there are no monitoring agents on the database servers, query performance is not reduced and database security is simplified.

Continue reading

< Advanced load balancing |  Global server load balancing >