Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

MySql Database as a service:

  1. Amazon
  2. Xeround

Another eg. PostgreSQL Database-as-a-Service. You can get the list of similar products here.

Does anyone have details on their performance, reliability, and scalability of these DbaaS? Reading literature on these products make them sound too good to be true. And my inner cynical sense tells me to question the claims.

share|improve this question
3  
See also: SQL Azure –  Nick Chammas Jan 2 '12 at 22:50
add comment

1 Answer 1

up vote 5 down vote accepted

The only thing I would like to comment on is Xeround

I tried out the XEROUND MySQL Instance

I found out that it only has three(3) Stroage Engines

mysql show engines;
+---------+---------+-----------------------------------------------------------+--------------+------+------------+
| Engine  | Support | Comment                                                   | Transactions | XA   | Savepoints |
+---------+---------+-----------------------------------------------------------+--------------+------+------------+
| Xeround | DEFAULT | Xeround MySQL storage engine                              | YES          | NO   | NO         |
| MyISAM  | YES     | Default engine as of MySQL 3.23 with great performance    | NO           | NO   | NO         |
| MEMORY  | YES     | Hash based, stored in memory, useful for temporary tables | NO           | NO   | NO         |
+---------+---------+-----------------------------------------------------------+--------------+------+------------+
3 rows in set (0.01 sec)

If you want ACID-compliant transactions, you have to use XEROUND Storage Engine. Most users are familiar with InnoDB since it has been with MySQL long before Oracle and Sun became involved. There are about 50 variables to tune and monitor.

Here is everything for XEROUND

mysql show variables like 'x%';
+----------------------------------+--------------------------------------------------------+
| Variable_name                    | Value                                                  |
+----------------------------------+--------------------------------------------------------+
| xeround_transaction_memory_limit | 128                                                    |
| xeround_transactional_ddl        | OFF                                                    |
| xeround_xdapc_socket             | /opt/xeround/sys_819/v3.0.1.43/xdrm/mysql/xdapc_socket |
+----------------------------------+--------------------------------------------------------+
3 rows in set (0.01 sec)

Not much you can tune there.

You are at XEROUND's mercy for tuning the transactional behavior

Questions

  • Can you disable the ACID compliance of XEROUND ?
  • Does XEROUND have multiple levels of Transaction Isolation to support MVCC ?
  • Are there shared or separate tablespaces per table or per user ?
  • Any limitations on the row length or the number of columns ?
  • How does XEROUND do crash recovery ?

Hey, one could only guess at these things right now.

I am sure that reading literature on the XEROUND Storage Engine turns up nothing you can do that a DBA would be expected to do for configuration, optimization, and overall tuning.

IMHO I would not use the XEROUND Storage Engine from any transactions until an adequate Whitepaper comes out on how to use it, tune it, and configure it. In addition, some internals you can understand would be nice as well. Otherwise, the XEROUND Storage Engine is just as mysterious to the public as is the Storage Engine of PostgreSQL, SQL Server, and Oracle.

As long as users only use the MyISAM Storage Engine and are not performing any ACID-compliant transactions, you should be fine.

As a good rule of thumb, stick to DB Services that will support MyISAM and InnoDB.

share|improve this answer
2  
Hey, I thought Postgres was Open Source –  ypercube Jan 3 '12 at 7:46
    
@ypercube I am sorry, PostgreSQL is open source. I was referring to storage engine internals. –  RolandoMySQLDBA Jan 3 '12 at 11:07
    
Hi Ronaldo: Thank you for your response. Would you mind looking at this question: dba.stackexchange.com/questions/12688/… –  startup007 Feb 11 '12 at 22:35
    
What is mysterious about PostgreSQL? Source code is free available and of good quality, what makes it readable and understandable. No mystery imho. –  Frank Heikens May 24 '12 at 16:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.