开发者

Switching to MariaDB with Zend Framework

I've been developing a site on

MySQL client version: 5.1.41
Server version: 5.1.41

And I've been considering the deployment onto the production server could be the best time t开发者_开发百科o migrate to maria db (Ubuntu Lucid Lynx)

What settings do I need to change in my application config

resources.multidb.front_db.adapter  = "pdo_mysql"
resources.multidb.front_db.charset  = "utf8"
resources.multidb.front_db.host     = localhost
resources.multidb.front_db.username = root
resources.multidb.front_db.password = ****
resources.multidb.front_db.dbname   = ****
resources.multidb.front_db.default  = true

Would I just need to replace pdo_mysql with pdo_mariadb? (is there such an adapter?)

Can I create the dump of my database(mainly innoDB,a few MyISAM and a some views) in mysql and import then import it into mariadb?

Anything else I should lookout for?


MariaDB is a binary drop in replacement for MySQL (source)

There is no pdo adapter for mariadb, you use pdo_mysql and as far as PHP knows, that's what it is.

As far as data conversion goes, I would probably just use mysqldump (or phpMyAdmin) to move the data, and manually convert which ever tables you want to convert by hand to mariadb's alternate storage engine(s).

Good luck! I haven't had the opportunity to use mariadb in production, but I'm dying for an excuse to.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜