Home > Features > Database Dilemmas • Bookmark   • Newsletters   • Register Search Options


Database Dilemmas

Database Dilemmas

July 27, 2006
Text size: 
Get XBIZ News
XBIZ Research
Will virtual reality boost the paysite market?
Yes, it will soon
Yes, but in a few years
Out of 150 votes. Results based on votes submitted by members of XBIZ.net social network.
Robust, reliable and redundant technologies are, or at least should be, the basis of all successful e-commerce operations; yet somewhat surprisingly, many adult companies seem to forego maximum uptime in favor of enhanced interactivity and “bells and whistles.”

A case in point is the widespread use of MySQL databases in mission-critical applications.

The backbone of many staple features of today’s adult Internet, from advanced content management systems to automated gallery post, traffic trading and community message board scripts, the Open Source MySQL database is a favorite among adult webmasters, many of whom have a love/hate relationship with the technology. The reason for this occasional hatred is simple: MySQL crashes catastrophically, and in the process, takes your site down with it.

I watched XBIZ go down for awhile yesterday, the culprit obvious from the many MySQL error messages littering our previously dynamic, content-filled pages. Not just limited to our operations here, I’ve seen similar “doomsday” messages on any number of other websites, from industry-leading forum “GFY” to paysites, free sites, and even my own projects that use this database technology.

Although it’s easy to say “I’ll avoid MySQL” – and indeed, my niche TGP runs on a far more stable CGI-driven flat text database, while my pay site’s member’s area is going back to its previously static, non-database-driven roots in an effort to avoid the downtime, cancellations and chargebacks that MySQL problems can induce; there are applications where using this technology can’t be avoided, such as in my trade script and mainstream community forum.

Still, the point remains that whenever feasible, any “vulnerable” technologies that can be replaced by more robust solutions, should be. Remember, no matter how “cool” your site is, you can only make money when it’s up and running.


Artificial Intelligence Treats Risk Like Cancer

An embarrassing thing happened to me in Amsterdam. I’d just finished dinner with a new partner at a nice restaurant. OK … more expensive than nice, but you know what I mean. I grade food in... More »

8 Tips for Scaling Up Your Ad Campaign

As an advertiser it can take some time for you to get a successful campaign going because many ideas don't always work out. Once you have a great converting campaign it can also quickly die out, so that's... More »

Is the Free Porn Era Starting to Fade Away?

Onlookers might believe that adult entertainment was only a big business prior to free tube sites, or that tube sites started the free porn era online. It’s true that free porn is much more pervasive... More »
Stay informed of the latest industry developments. Get XBIZ newsletters delivered to your inbox. Subscribe today!
Enter email address:

* To manage existing subscriptions click here.

Submit your press release to
multiple news outlets with 1 click.
Subscribe to RSS news feeds or
add free content to your website.
Access XBIZ news and articles
with your mobile device.
Subscribe to XBIZ World magazine, the industry's leading e-commerce trade publication, delivering in-depth coverage of the online, mobile and ancillary digital markets.



Nov 04 - Nov 06
Edison, New Jersey

2016 Inked Awards

Nov 05 - Nov 05
Edison, New Jersey

XBIZ 2017

Jan 09 - Jan 13
Hollywood, CA

XBIZ Awards 2017

Jan 12 - Jan 12
Los Angeles, CA
Everyday thousands of business professionals browse XBIZ's industry directory for quality products and services. Not listed yet? Your company could be losing potential new business. Submit your company today!
Use XBIZ RSS feeds to stay informed of the latest industry developments or as a content syndication tool for your website!