Gabriel Torres Posted July 6, 2014 Share Posted July 6, 2014 Following the advice from GreenLinks, I think I am ready to move from MySQL to Percona. From what I understood, it is a drop-in replacement to MySQL, you just change the binaries, keep the /data directory and it works as MySQL would. Now, my question is on the web server side (we run the webserver on a separate server). Would we need to recompile PHP or PHP's native MySQL drivers are able to communicate directly with Percona? Any other advice or information I should know before proceeding? Another question, does Percona perform better than MySQL for other platforms as well or just with IPB? Thanks, Gabriel. Link to comment Share on other sites More sharing options...
Rhett Posted July 6, 2014 Share Posted July 6, 2014 You shouldn't need to do anything with php, it really is a drop-in replacement. You should see improvement with Percona on all usage, not just IPB. Link to comment Share on other sites More sharing options...
Dmacleo Posted July 6, 2014 Share Posted July 6, 2014 I swapped (on directadmin server and in past on cpanel ) to mariadb with zero issues. only thing not really stated in documents was to fully stop mysql and then installing. I would expect, from what I have read, percona would act the same way. Link to comment Share on other sites More sharing options...
Gabriel Torres Posted July 6, 2014 Author Share Posted July 6, 2014 Thanks. Another question. How does it work in terms of configuration and optimization? I mean, does it use the same /etc/my.cnf file? Link to comment Share on other sites More sharing options...
Dmacleo Posted July 7, 2014 Share Posted July 7, 2014 mariadb does, makes sense as its created by the guy that created mysql. the cnf I had been using worked fine too. not sure on percona but since its a drop in I would expect it to be the same. Link to comment Share on other sites More sharing options...
Rhett Posted July 7, 2014 Share Posted July 7, 2014 Yes it can use the same my.cnf file. Link to comment Share on other sites More sharing options...
AlexJ Posted July 10, 2014 Share Posted July 10, 2014 Just FYI: IPB doesn't support full indexing feature of MySQL 5.6 so if you are going to use that in latest version of Percona stick with MyISAM. Link to comment Share on other sites More sharing options...
Gabriel Torres Posted July 11, 2014 Author Share Posted July 11, 2014 AlexJ, can you elaborate on that? Are you talking about the full search capability that is lost? We use sphinx anyway... Link to comment Share on other sites More sharing options...
Ohio Riders Posted July 15, 2014 Share Posted July 15, 2014 I'm working on a step by step write up on converting from MySQL to MariaDB. Might be useful for you. I'll try to remember to link to it here. Link to comment Share on other sites More sharing options...
AlexJ Posted July 15, 2014 Share Posted July 15, 2014 AlexJ, can you elaborate on that? Are you talking about the full search capability that is lost? We use sphinx anyway... If you use Spinx then it's no issue for you. Basically IPB 3.4 doesn't support full text search of InnoDB on MySQL 5.6. Link to comment Share on other sites More sharing options...
Gabriel Torres Posted July 16, 2014 Author Share Posted July 16, 2014 Thanks, Ohio Riders, that would be much appreciated. I still haven't found the time to play with Percona. Link to comment Share on other sites More sharing options...
Makoto Posted July 16, 2014 Share Posted July 16, 2014 If you use Spinx then it's no issue for you. Basically IPB 3.4 doesn't support full text search of InnoDB on MySQL 5.6. There's not much to "support" really. I've made it work easily, but InnoDB 5.6's FTS implementation still seems a bit incomplete right now. Nonetheless, you can make it work just by enabling full text searching and lying to IP.Board about your engine type. As far as I know, that's literally all the setting is for. A compatibility check for FTS. XtraDB (or even standard InnoDB) is superior to MyISAM in a lot of ways anyways. I pretty much strictly use XtraDB and Memory tables on all of my databases. If you're going to switch to Percona (or MariaDB) I strongly suggest you consider trying out XtraDB as well. Link to comment Share on other sites More sharing options...
Gabriel Torres Posted July 16, 2014 Author Share Posted July 16, 2014 Thanks. I will take a look into that. Link to comment Share on other sites More sharing options...
AlexJ Posted July 16, 2014 Share Posted July 16, 2014 There's not much to "support" really. I've made it work easily, but InnoDB 5.6's FTS implementation still seems a bit incomplete right now. Nonetheless, you can make it work just by enabling full text searching and lying to IP.Board about your engine type. As far as I know, that's literally all the setting is for. A compatibility check for FTS. I would like to know how or more detail steps. IPS Staff asked me in ticket that since it doesn't support FTS they are going to disable full text search on my forums and only option is to convert it to MyISAM. I was using MyISAM anyways but that UTF8 convert messed it up for me. So now I am on InnoDB with not FTS. If you can share how it would be great! Link to comment Share on other sites More sharing options...
Makoto Posted July 16, 2014 Share Posted July 16, 2014 I would like to know how or more detail steps. IPS Staff asked me in ticket that since it doesn't support FTS they are going to disable full text search on my forums and only option is to convert it to MyISAM. I was using MyISAM anyways but that UTF8 convert messed it up for me. So now I am on InnoDB with not FTS. If you can share how it would be great! See my post here: http://community.invisionpower.com/topic/397660-using-fulltext-indexes-with-innodb-56/ You may have to leave $INFO['mysql_tbl_type'] in conf_global.php set to MyISAM as well, even though you're actually using InnoDB. I don't remember honestly, but I'm pretty sure you do. I disabled it after having issues with InnoDB's FTS implementation a while back. Specifically highlighted here; http://community.invisionpower.com/topic/380802-screenshots-on-downloads-search-results/?p=2479739 So proceed with caution. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.