Sunday, March 30, 2008

SoftLayer, Dedicated Server Web Hosting Firm, Implements SOA


Dallas, Texas - (The Hosting News) - March 17, 2008 - On-demand, dedicated web hosting solutions firm, SoftLayer, has expanded its data warehouse capacity, while improving its backend system performance with service oriented architecture (SOA), by adding an application layer processing cluster.

The data warehouse expansion included the installation of multi-petabyte storage arrays from EqualLogix (now Dell) in its Dallas, Seattle, and, when launched, Washington D.C. facilities to serve as the backend data storage powering all of SoftLayer's on-demand service offerings. Servers from SuperMicro provide the processing power for the new SOA infrastructure. Together, these improvements have been engaged to accelerate deployment of new features and increase performance for all SoftLayer customers (whether they use the SoftLayer Application Programming Interface (API) or the SoftLayer Portal to manage hosted IT infrastructure) and allow the company to maintain its leadership in bringing new products and services to market.

Nathan Day, Chief Technology Officer at SoftLayer noted, ''Delivering world-class services on time, every time, requires an internal infrastructure that, up to now, simply did not exist in the market place. We have created a new model for the industry that combines scalable and flexible data storage with scalable and flexible application processing.''

SoftLayer used industry-standard best-practices to create its SOA to deliver on the architectural style's two fundamental concepts: - Enable a set of simple, ubiquitous, and open communication interfaces - Deliver data using an open schema (e.g. XML) through the interfaces SoftLayer's SOA allows data to be captured, processed, and presented to users in a form chosen by the system administrator, delivering on the company's commitment to give customers total control. The architecture is highly scalable, with the capacity to process millions of transactions per hour across thousands of physical and virtual servers, as well as with any number of related services.

Mr. Day added, ''Our goal is to virtualize all datacenter elements including the hardware, security, network, and embedded services to drive our vision of Serverless IT.''

This new expansion comes on the heels of SoftLayer's recent investment of over $5 million, in the completion of an upgrade of its core networking infrastructure, as well opening a second datacenter facility in Dallas. The new facility features 220 new racks, more than doubling SoftLayer's server capacity in Dallas. It has its own multiple power feeds supported by independent UPS systems and generators for failover, while leveraging the same network operations (NOC) as the existing SoftLayer facility.

As part of this expansion, a major core network backbone upgrade was completed to better serve all customers using the Dallas facilities. The upgrade included: Addition of three new Cisco 7600-S routers utilizing the latest RSP-720 Supervisor Engines; Upgrade of all existing 6500-E switches utilizing the latest Sup720-3CXL Supervisor Engines; DDOS and IDS protection with multiple Cisco Guard and Tipping Point installations; Continued deployment of 40g to the rack (20g public and 20g private) utilizing Cisco 3560-E rack switches.

The upgrade is anticipated to significantly improve performance for all SoftLayer customers as the new Cisco equipment provides increased CPU speed, more memory, and far greater routing capacity than the previous generation of equipment. SoftLayer continues pushing innovation by deploying the latest technologies and increasing its investment in retrofitting the existing environment.

Located in the INFOMART in Dallas, Texas, SoftLayer was formed in June 2005 by a team of industry executives seeking to deliver low cost next generation on-demand hosting services for the small to medium enterprise (SME). Utilizing proprietary software, coupled with the industry's first network-within-a-network topology, the company delivers the power and control to securely manage IT environments while providing comprehensive scalability.

To learn more, please visit: www.softlayer.com.

Two tables, count records and filter by x or y (2 replies)

Hello!

I'm working on a big project but I can't get any help. I would be very happy if someone could help me out.

I have two tables called onkormanyzat and cko. They both have an ID column called ok_id. They also have a telepules (town) and a bemutato_resztv (participated) column which can be 'Igen' or 'Nem'. I would like to get all the telepules (towns) from both cko and onkormanyzat and count the ones which have 'Igen' in participated (bemutato_resztv). But i don't want to have duplicate towns (telepules). It is poosible that only one table has that town with Igen and the other doesnt. So if any of the tables with the selected telepules has 'Igen' it counts.

$query = "SELECT cko.megye,onkormanyzat.ok_id,
COUNT(cko.ok_id) FROM onkormanyzat JOIN cko ON
(onkormanyzat.telepules = cko.telepules)
AND cko.bemutato_resztv='Igen'
GROUP BY cko.megye";

I tried this one, but it only counts the telepules or ok_id (at this time) if both the telepules is in both tables and if cko has bemutato_reszt='Igen'.

COUNT telepules from both tables (cko,onkormanyzat) when any of them has bemutato_resztv='Igen' without duplicate telepules.



Thank You!

Benedek Rakovics
CoreSTAT Consulting Bt.
Skype: corestat.consulting