?

Log in

No account? Create an account

Drizzle, Look at the last row...

« previous entry | next entry »
Feb. 19th, 2010 | 11:44 am

drizzle> select * from plugins WHERE PLUGIN_TYPE="storageengine";
+--------------------+---------------+-----------+-------------+
| PLUGIN_NAME        | PLUGIN_TYPE   | IS_ACTIVE | MODULE_NAME |
+--------------------+---------------+-----------+-------------+
| ARCHIVE            | StorageEngine | TRUE      |             |
| BLACKHOLE          | StorageEngine | TRUE      |             |
| CSV                | StorageEngine | TRUE      |             |
| FunctionEngine     | StorageEngine | TRUE      |             |
| INFORMATION_ENGINE | StorageEngine | TRUE      |             |
| InnoDB             | StorageEngine | TRUE      |             |
| MEMORY             | StorageEngine | TRUE      |             |
| MyISAM             | StorageEngine | TRUE      |             |
| schema             | StorageEngine | TRUE      |             |
+--------------------+---------------+-----------+-------------+
9 rows in set (0 sec)



The payoff for making Drizzle a plugin based architecture? Development goes much faster.

Link | Leave a comment |

Comments {4}

What does it mean?

from: xaprb
date: Feb. 19th, 2010 09:46 pm (UTC)
Link

I'm not sure I understand. Say more? What does this plugin DO?

Reply | Thread

Brian "Krow" Aker

Re: What does it mean?

from: krow
date: Feb. 19th, 2010 10:44 pm (UTC)
Link

Yesterday, or today in MySQL, schemas are just directories. In Drizzle they are a part of the owned objects that can be controlled via plugins.

A network engine can provide schemas that are not located on the localhost, and something like Innodb can own a schema and then rollback the changes (so yes... in theory you could rollback an entire drop of a schema/databases).

Reply | Parent | Thread

Re: What does it mean?

from: xaprb
date: Feb. 19th, 2010 11:23 pm (UTC)
Link

OK, so the summary is "Drizzle will have real schemas" -- this is great.

Reply | Parent | Thread

Brian "Krow" Aker

Re: What does it mean?

from: krow
date: Feb. 19th, 2010 11:31 pm (UTC)
Link

Yep!

Reply | Parent | Thread