Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

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

Mitomind
Member
Registered: 2012-06-27
Posts: 166

MySQL 5.6 GA releases in a couple of days

Offline

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

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: MySQL 5.6 GA releases in a couple of days

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


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

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

Mitomind
Member
Registered: 2012-06-27
Posts: 166

Re: MySQL 5.6 GA releases in a couple of days

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.

Offline

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

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: MySQL 5.6 GA releases in a couple of days

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 :-)


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

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

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: MySQL 5.6 GA releases in a couple of days

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


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

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

Mitomind
Member
Registered: 2012-06-27
Posts: 166

Re: MySQL 5.6 GA releases in a couple of days

symtab wrote:

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

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)

Offline

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

Mitomind
Member
Registered: 2012-06-27
Posts: 166

Re: MySQL 5.6 GA releases in a couple of days

MySQL 5.6.10 has been released.

Offline

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

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: MySQL 5.6 GA releases in a couple of days

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...).


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

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

Mitomind
Member
Registered: 2012-06-27
Posts: 166

Re: MySQL 5.6 GA releases in a couple of days

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.

Offline

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

Jadmanx
Member
Registered: 2012-05-25
Posts: 128

Re: MySQL 5.6 GA releases in a couple of days

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

Offline

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

Mitomind
Member
Registered: 2012-06-27
Posts: 166

Re: MySQL 5.6 GA releases in a couple of days

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.

Offline

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

rbmoss
Member
Registered: 2012-08-17
Posts: 36

Re: MySQL 5.6 GA releases in a couple of days

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

Offline

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

Mitomind
Member
Registered: 2012-06-27
Posts: 166

Re: MySQL 5.6 GA releases in a couple of days

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.

Offline

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

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: MySQL 5.6 GA releases in a couple of days

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 Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

Board footer

Powered by FluxBB