TransLattice offers details on PostgreSQL

TransLattice addresses the need for always-on, high performance data management tools that place data close to where it is used or where regulations require.

CEO and co-founder Frank Huerta and chief architect, Mason Sharp from geo distributed data management provider TransLattice, reached out to contact me after reading my article on GenieDB - a global, distributed, database as a service . The two offered information on another highly-distributed database, TransLattice Elastic Database (TED), and the TransLattice Application Platform (TAP). They also wanted to discuss TransLattice's newest product, Posgres-XL.

While GenieDB is building upon the foundation of MySQL, TransLattice has focused its attention on PostgreSQL. TransLattice felt that PostgreSQL was a better foundation for distributed, highly scalable, robust, OLTP platforms. They also believed that platform could be made to support multiple tenants and geographically-disbursed datacenters and while still offering the ease-of-use qualities that customers demand.

Who is TransLattice?

Here's what  the company has to say about itself:

TransLattice offers its customers geo-distributed data management solutions that provide unparalleled availability, global visibility and data location control. TransLattice’s award-winning products provide local and geographic scalability that enables data associated with applications to be placed in any location in or out of the cloud, while providing superior reliability and accessibility.

Enterprises use TransLattice’s products to:

  • Provide superior data availability and ensure successful disaster recovery through policy-driven redundancy that does not require bulk replication of data at multiple locations

  • Improve online transaction processing performance, with the data dynamically stored in the location closest to its use

  • Assure regulatory and corporate compliance through easy to use policy settings that automatically ensure that data is placed and maintained in appropriate locations

TransLattice has developed a distributed version of PostgreSQL that supports multiple active notes, all of which are working to support the customer's business operations and provide a robust platform for data analytics.

Snapshot analysis

Applications are collections of separate, distributed services that have been harnessed together rather than monolithic blocks of code that execute on a single computer.  Providing efficient, easy-to-use, easy-to-manage, data management for these services has, in the past, required developers to rely on many separate database instances. This approach, while workable, isn't very efficient. Each database instance must be installed, the database provisioned and procedures developed for moving data around the network as and when needed.

TransLattice and several others have focused on creating a single database engine that can support many distributed datacenters housing many individual database servers. This, they believed, would offer high performance and better reliability, while making it possible to support huge computing environments. The company acquired tools from StormDB that added massively parallel processing (MPP), OLTB scalability and atomic operations, multi-tennant support and, support-clustered computing architectures.

If your organization needs an ACID compliant relational database, one that supports OLTP applications and provides a platform for Big Data analytics, it would be wise to examine TransLattice and Postgres-XL.