MySQL 5.6 GA releases in a couple of days

Mitomind · 2013-01-25 21:39:24

Bring on InnoDB FTS!!! Yea!

https://blogs.oracle.com/MySQL/entry/mysql_5_6_is_a

symtab · 2013-01-26 07:50:49

To bad MySQL will be replaced soon on Fedora (and probably all other Linux distributions will follow).

Mitomind · 2013-01-26 15:17:37

Yea, I read about that. Many people aren't too happy with the way Oracle is running MySQL. It will be interesting to see what happens.

symtab · 2013-01-26 18:35:45

Well i've read about MariaDB and it has more features, its faster and its open source, so at first look its way better than mysql. And its 100% compatible with mysql. I dont like the name though :-)

symtab · 2013-01-26 18:53:27

BTW...i just read mysql is considered outdated in PHP as of PHP 5.5 We have to move to mysqli which is faster anyway. PDO would be better, but thats one more dependency

Mitomind · 2013-01-27 00:40:06

symtab wrote:

BTW...i just read mysql is considered outdated in PHP as of PHP 5.5 We have to move to mysqli which is faster anyway. PDO would be better, but thats one more dependency

Yea, I've been using PDO for quite some time now in all the script I've written. You can still use mysql in PHP the only thing the PHP team did was add an depreciated error when you use mysql.

As far as the new MySQL they've changed it a lot. The performance is over the top. They've moved a bunch of stuff around... my.cnf is located in the /usr/shared vs. /etc now. They've also streamlined the options for InnoDB. I think it's kind of childish for Fedora not use MySQL anymore just because some of their tests aren't public anymore - truly 'Open Source'. There are plenty of great pieces of software out there which aren't 100% Open Source.

I'm not sold on MariaDB 100% (I don't really like the name either) though everything I've been reading has been good. I honestly think that any change will come from Cpanel. If Cpanel moves to use MariaDB as there choice then everyone will change. So, many novice users use Cpanel to manage their sites.

Honestly, I thought about moving to PostgreSQL for all my projects. There isn't a whole lot of code I would have to change and PostgreSQL is SOLID.

Last edited by Mitomind (2013-01-27 00:41:16)

Mitomind · 2013-02-09 21:10:01

MySQL 5.6.10 has been released.

symtab · 2013-02-10 16:38:41

I'm considering a full change in 1.2 (i have yet to do this, i've implemented parts of 1.2, but not finished, might take longer if i change this), php 5.3 as dependency (i love phar, i hate namespaces...) and some tables will be moved to innodb (probably some small database changes). The option to select mysql, mysqli and pdo (still thinking how to implement this with the current system...).

Mitomind · 2013-02-10 16:46:04

Honestly, I would follow cpanel. I wouldn't release anything related to an upgrade until they do. So many people use cpanel in the world to manage their sites. I haven't even seen a post on the cpanel forum about an upgrade to 5.6 besides the couple of posts asking about testing 5.6. All those posts were about the rc version of 5.6.

Everyone else who is managing their site without a control panel probably will update MySQL themselves.

As far as mysql, mysqli, or pdo - I would totally go pdo. It's really nice to work with pdo. I use it over mysqli.

Jadmanx · 2013-03-18 15:45:38

but we can upgrate to MySQL 5.6? and use Adult Script Pro 1.0.6 with it ?

Mitomind · 2013-03-18 17:21:23

Jadmanx wrote:

but we can upgrate to MySQL 5.6? and use Adult Script Pro 1.0.6 with it ?

Yea, you can upgrade to 5.6 if you want. There isn't any changes in 5.6 which is going to prevent you from using ASP. 5.6 is actually faster.

I would HIGHLY advise you export your database and re-import it after doing the upgrade.

If you are using a custom my.cnf file you will need to change the new my.cnf file to match your settings.

REMEMBER once you upgrade to 5.6 - YOU CAN'T DOWNGRADE. The way 5.6 stores the files isn't compatible with older versions of MYSQL.

rbmoss · 2013-04-22 09:46:39

mysql 5.6 has been released but in future would it be replaced by maria-db

Mitomind · 2013-04-22 11:44:24

rbmoss wrote:

mysql 5.6 has been released but in future would it be replaced by maria-db

I believe it's only going to be replaced in Fedora. You can run any database you want. You just have to install the database you choose.

symtab · 2013-04-23 08:04:34

We had to develop a custom script for a client. The site is currently serving > 5 million videos and with InnoDB it works perfectly :-) and fast. We will switch to InnoDB soon.

Adult Script Pro Community Forums

#1 2013-01-25 21:39:24

MySQL 5.6 GA releases in a couple of days

#2 2013-01-26 07:50:49

Re: MySQL 5.6 GA releases in a couple of days

#3 2013-01-26 15:17:37

Re: MySQL 5.6 GA releases in a couple of days

#4 2013-01-26 18:35:45

Re: MySQL 5.6 GA releases in a couple of days

#5 2013-01-26 18:53:27

Re: MySQL 5.6 GA releases in a couple of days

#6 2013-01-27 00:40:06

Re: MySQL 5.6 GA releases in a couple of days

#7 2013-02-09 21:10:01

Re: MySQL 5.6 GA releases in a couple of days

#8 2013-02-10 16:38:41

Re: MySQL 5.6 GA releases in a couple of days

#9 2013-02-10 16:46:04

Re: MySQL 5.6 GA releases in a couple of days

#10 2013-03-18 15:45:38

Re: MySQL 5.6 GA releases in a couple of days

#11 2013-03-18 17:21:23

Re: MySQL 5.6 GA releases in a couple of days

#12 2013-04-22 09:46:39

Re: MySQL 5.6 GA releases in a couple of days

#13 2013-04-22 11:44:24

Re: MySQL 5.6 GA releases in a couple of days

#14 2013-04-23 08:04:34

Re: MySQL 5.6 GA releases in a couple of days

Board footer