|
|
Sponsored Content
Special Forums
UNIX and Linux Applications
What Database engine would you recommend?
Post 302168898 by olenkline on Tuesday 19th of February 2008 05:12:26 PM
02-19-2008
Which DB Engine?
Greetings and salutation,
market research is it? I've been an Oracle DBA on unix for a long time, like it just fine, can handle the small workload you're talking about without issues, can run on many platforms / OS's. Terabyte to petabyte not an issue - to the database anyway
The real issues are supportability over the long run, any of the commercially available rdbms engines will do what you want, if it's storing data and being able to retrieve it. I've got friends running DB2, Informix, Sybase and Oracle in the same shop. MySql is very popular because of the cost and it's features compare favoriably with any of the commercially available RDBMS's I've been told.
If Sarbanes-Oxley compliance is a requirement make sure you research how much work it would be to meet that requirement with the features available. It used to be easier to pick an RDBMS, you looked at what would run on your OS(s), then features, then price. By the time you got done with that you had only one or two choices. Now the products are so close, it's very difficult.
As stated up front, I'm an Oracle DBA, so I would recommend that, however, that could be from lack of current knowledge of the product offerings from the other vendors. I've managed databases in the terabyte range and with Oracle it was easy, not saying it wouldn't have been just as easy with another product, just it's more a matter of familiarity. It used to be Oracle DBA's were very expensive, now with the availability of remote on demand administration and monitoring, the costs have come down. Take as much time as you can to research and find out what best fits your needs, because, while picking a rdbms is difficult, migrating from one rdbms to another is much more difficult and time consuming.
Hope this is of some help. If you have questions ask.
market research is it? I've been an Oracle DBA on unix for a long time, like it just fine, can handle the small workload you're talking about without issues, can run on many platforms / OS's. Terabyte to petabyte not an issue - to the database anyway
The real issues are supportability over the long run, any of the commercially available rdbms engines will do what you want, if it's storing data and being able to retrieve it. I've got friends running DB2, Informix, Sybase and Oracle in the same shop. MySql is very popular because of the cost and it's features compare favoriably with any of the commercially available RDBMS's I've been told.
If Sarbanes-Oxley compliance is a requirement make sure you research how much work it would be to meet that requirement with the features available. It used to be easier to pick an RDBMS, you looked at what would run on your OS(s), then features, then price. By the time you got done with that you had only one or two choices. Now the products are so close, it's very difficult.
As stated up front, I'm an Oracle DBA, so I would recommend that, however, that could be from lack of current knowledge of the product offerings from the other vendors. I've managed databases in the terabyte range and with Oracle it was easy, not saying it wouldn't have been just as easy with another product, just it's more a matter of familiarity. It used to be Oracle DBA's were very expensive, now with the availability of remote on demand administration and monitoring, the costs have come down. Take as much time as you can to research and find out what best fits your needs, because, while picking a rdbms is difficult, migrating from one rdbms to another is much more difficult and time consuming.
Hope this is of some help. If you have questions ask.
|
|
LEARN ABOUT PHP
mysql_get_proto_info
MYSQL_GET_PROTO_INFO(3) 1 MYSQL_GET_PROTO_INFO(3) mysql_get_proto_info - Get MySQL protocol info SYNOPSIS
Warning This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include: omysqli_get_proto_info(3) int mysql_get_proto_info ([resource $link_identifier = NULL]) DESCRIPTION
Retrieves the MySQL protocol. o $ link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection is found or established, an E_WARNING level error is generated. Returns the MySQL protocol on success or FALSE on failure. Example #1 mysql_get_proto_info(3) example <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } printf("MySQL protocol version: %s ", mysql_get_proto_info()); ?> The above example will output something similar to: MySQL protocol version: 10 mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_server_info(3). PHP Documentation Group MYSQL_GET_PROTO_INFO(3)