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.
精彩评论