The SQL and NoSQL hybrid database is making progress

The

SQL and NoSQL Hybrid database solution is compatible with many SQL applications while providing NoSQL scalability. Xeround provides such services in the cloud, including a free version. Other programmes include JDBC-driven database.com, NuoDB, http://www.aliyun.com/zixun/aggregation/13932.html ">clustrix and Voltdb."

Xeround provides the database as a service (db-as-a-services), mixing SQL with NoSQL. The front end is the MySQL query engine, facing existing mass MySQL applications, while the stored APIs use the distributed in-memory NoSQL object storage, size up to 50gb.xeround CEO Razi Sharir said to Infoq. The

Xeround provides a "database as a service" for MySQL applications in the cloud. Developers use it to easily run applications in the cloud while automatically scaling up or down, while ensuring failure or database structure changes without impacting availability. It's really 100% native MySQL front-end, not just analog, but we will always use the MySQL front-end, as well as our patented carrier-level storage engine. We use Hadoop as a distributed file system, using a hash table to complete the distributed object storage. We run in memory, so it's natural to have resources on demand in a flexible and linear fashion. At the beginning of the design, we took a virtualization approach, so there was no need to shift from a traditional single storage solution to a virtual and distributed storage solution in the cloud without the pain of a similar transformation. Services in the

Cloud can provide high availability (99.9%) and scalability, which are generally associated with the use of NoSQL data stores. It can be deployed on Amazon EC2 and Rackspace, and can be used as a Heroku plug-in for more than 500MB of databases. Referring to failback, Sharir said:

End users do not need to worry about recovery issues, which is the benefit of the service. We run multiple replicated versions at the bottom and are transparent to end users. We deal with problems with recovery and scalability. There is no need to configure. We are like peer-to-peer networks, all nodes can read and write, for example, we do not care about the primary database recovery or read data from the replicated database?? We can add and remove resources immediately to meet the requirements of expansion and HA, which we now run in a telecom company.

Xeround typicallywill be charged per gigabyte per hour, but they intend to provide a free version for small applications and development use, the database has a 10MB limit, and two new fixed versions, with higher scalability, more support and SLAs: Basic Edition-database upper limit 100MB, 17 USD per month Professional Edition-Database cap 250MB, 33 USD per month. Xeround Free is currently available only in Amazon's U.S. region and is provided as a Heroku plug-in with plans to extend services to other data centers, while basic and Professional editions are available on Amazon, Rackspace and Heroku. There are other similar solutions to

. Database.com services are available through Progress software ODBC and Jdbcconnect drivers connection drivers (currently still beta versions). The

is also a beta nuodb, a nosql database with a SQL front-end that resolves SQL 92 standard statements, supports 99 standard extensions, and can also be accessed through ODBC, JDBC, and ActiveRecord drives. NuoDB can be run in any key-value-to-store, and can be deployed on top of Amazon and Rackspace clouds. The

Clustrix provides hardware solutions and claims that linear scalability can be provided when a node is joined to a database cluster. Hardware is available in 4-or 8-core processors, 24 to 48G of RAM, and 448 to 896GB SSD storage. It also supports MySQL, providing fault-tolerant mechanisms for viewing and managing the entire cluster as you would a single database. The

Voltdb is an in-memory relational database with SQL and ACID transaction support, while integrating Hadoop and OLAP databases, advertising claims: Because of the shared-nothing architecture, it provides excellent scalability. Instead of providing a "database as a service" approach, it is used as a software solution for data centers. It is provided with mirrors of EC2 and VMware, and users can evaluate its performance in the cloud.

(editor: Heritage)