General ⇒ DVCS Info (Mercurial/CVS) :: Archives ⇒ 9.1.2.3 introducing database wide ip conversion :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexDVCS Info (Mercurial/CVS)

Archived ⇒ 9.1.2.3 introducing database wide ip conversion


Just few minutes ago 9.1.2.3 have been committed to our CVS repository.
It will convert previously saved IPs to the new binary type.

The upgrade process will take quite a long time for huge databases since it will convert ip by ip, column by column, table by table.

This is a step forward to old install issues and PHP5 with strict mode.

For any related questions or problems feel free to reply.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Good job

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
-


NanoCaiordo,
Clearly this is something that is likely to concern us since we are in the position of possessing a huge database. I'm not sure what size of database you have tested against but our previous experience of collation conversions, etc often shows that this is not a simple process. Would it be useful for us to provide a database that you could use to test with?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.2.4/5.0.37/5.2/9.1.2.1


He already has one lol he can make a copy of df's db

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


Tested on my laptop over a DragonflyCMS's database backup and forums tables were the ...l...o...n...g...e...s...t... to process.

The database used had all kind of IPs types within the same table column and all went good.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Dizfunkshunal wrote
He already has one lol he can make a copy of df's db


No disrespect to DF but there are a number of sites that are much bigger. I don't know what the stats for DF are but we have approx 1.2 million posts and 26,000 users. I'd guess this probably makes our DB somewhere close to 10 times the size of yours? I'm also aware of at least one site that is much bigger than ours.

Previous experience has shown that DF just hasn't been built/tested to cope with these sort of sizes. I was just offering the opportunity for the people who really understand what goes on under the bonnet to test at this scale.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.2.4/5.0.37/5.2/9.1.2.1


Wow that has to be a big database lol

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


BadCO, you can test it on your copy of database. Though ineresting what would be the size of the copy.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
-


BadCo i might be interested to try on you forums posts table only, in that case even a very little optimization will make a big difference on your case.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Nano, Thanks a lot for the suggestion - unfortunately I do not currently have access to our servers (moving house) but will get this setup in the next few days.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.2.4/5.0.37/5.2/9.1.2.1


Eestlane wrote
Though ineresting what would be the size of the copy.


Zipped it is 611 MB - not sure how big it is unzipped .....

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.2.4/5.0.37/5.2/9.1.2.1

All times are UTC