Home | Contact Us | Log In | Help
  ASP.Net & C#
  Perl and PHP
  Java Scripts
  C and C++
  Ajax Tutorials
  J2ee, J2Me, Java
  Python & Ruby Rail
  Crystal Report
  Cold Fusion & CFML
  Photoshop/Web Designing
  Tools & Utilities
  Sql Server
  Domain Name Registration
  Remotely Hosting
  Web/Server Application
  Hotel Marketing
  Internet and Law
   Search Engine Optimization/SEO
Interview Questions
MySQL – is this database fit for the Enterprise?

MySQL has recently appeared as an Enterprise edition. We have already looked at whether MySQL (the company) is enterprise ready, but we can also ask whether the product itself is suitable for enterprise use. MySQL has a list that is long and distinguished, which is fine, but you have to bear in mind that it is just a list of the enterprises that use MySQL somewhere. It is not a list of the enterprises that use MySQL exclusively. It is certainly not a list of large enterprises that formerly used Oracle, took a look at MySQL, found it was great, threw Oracle out the door, replaced all of their Oracle installations with MySQL, saved quadrillions of dollars per year, and lived happily ever after.

Using MySQL from PHP
In database-driven applications, three different players produce the final output of the web page you view with your client: the web server, the scripting language (PHP), and the database back end (MySQL). When the client browser requests a page from your web site, the following steps occur...We will focus on steps three and four in our discussions here. Looking at those steps in more detail, we can summarize the process of accessing and working with a database connection from within a PHP script in the following steps.
Defining Mysql
MySQL is a relational database management system (RDBMS).MySQL runs on virtually all platforms, including Linux, Unix, and Windows. It is fully multi-threaded using kernel threads, and provides application program interfaces (APIs) for many programming languages, including C, C++, Eiffel, Java, Perl, PHP, Python, and Tcl. MySQL is used in a wide range of applications, including data warehousing, e-commerce, Web databases, logging applications and distributed applications.

MySQL Cookbook
The bulk of MySQL-related code in use today, was created not just to be accessed within a database client program, such as mysql, but instead from interpreted programming languages — especially those used heavily on Web sites. This is one area where MySQL Cookbook really shines, because it contains a large amount of sample code in Perl, PHP, Python, Java, and even Ruby. For developers using the MySQL database system, the gold standard of such books is MySQL Cookbook, by Paul DuBois."
MySQL Optimization
• You can do more with less. – MySQL on “normal” hardware scales well .– A little time can save thousands in hardware – The classic story goes…• As you data grows, you’ll need to – Performance will degrade over time – Performance will degrade over time • It is easier than re-coding you apps • Your users will notice if you don’t!

Previous < 3 4 5 6 7 8 9 10 11 > Next

  Copyright 2000-2006 © SoloScript.com, All rights reserved.