ORACLE MYSQL STD ED 1-6 SKT SVR
Mfg.Part: B60942_1 | CDW Part: 3249003
Lease Option ($136.36/month)
Note: Leasing is available to organizations only. Leasing is not available to individuals.
ORACLE MYSQL STD ED 1-6 SKT SVR
ORACLE MYSQL STD ED 1-6 SKT SVR is rated out of 5 by 19.
Rated 4 out of 5 by Lucas Holt from Its strength is in the fast connection, query and insert performance. The weakest link is replication. Primary Use CaseUsed as a data store for RESTful web services and other web applications. Was deployed to store RSS feeds, and for 100 joomla instances.Improvements to My OrganizationMySQL ( /products/mysql ) is widely supported. We were able to integrate it with several different projects using various different programming languages with no issues.Worked with Java, Perl, PHP, C# and C code.Valuable FeaturesMySQL ( /products/mysql )’s strength is in its fast connection, query and insert performance. I’ve benchmarked MySQL against several NoSQL and SQL databases and found it to be faster for getting lots of data inserted quickly.Room for ImprovementThe weakest link is replication. MySQL’s replication is touchy and doesn’t support master-to-master setups.MySQL’s replication was implemented by playing back SQL statements getting executed on the master database node. That means if a slave node gets behind, it has to catch up by running every SQL query that has executed on the master. When the slave gets too far out of date, it is unable to catch up because the replication log is lost.Master to master replication is used to allow writes to either node in the cluster (INSERT, UPDATE, DELETE). Since MySQL does not support this, you can only safely send SELECT queries to slave nodes. If you run an insert, update or delete against the slave node, then it is out of sync with the master and may break if a later replication event comes from the master on the same table.Use of SolutionMore than five years.Stability IssuesI’ve had an issue where an InnoDB database grew too big and got corrupted. I was unable to recover it because there was not enough space on the server either. Be sure to have enough space.Scalability IssuesWe did encounter some scalability issues as it has limited clustering support, it requires scaling up rather than out to some degree. Of course, you can have read replicas. It also has a fall-off on performance with very high workloads, but it takes awhile to get there.Previous SolutionsMySQL has replaced Microsoft SQL Server ( https://www.itcentralstation.com/products/sql-server ) in several cases. MySQL is easier to manage and much more cost-effective.Initial SetupThe security model is different than the other databases.Pricing, Setup Cost and LicensingThere are tuning and monitoring benefits for people who purchase MySQL rather than using the free version.Other Solutions ConsideredLooked at Microsoft SQL Server ( /products/sql-server ) and PostgreSQL ( /products/postgresql ).Other AdviceThe porting code to or from MySQL is not that complicated, but the date type/format and functions are the biggest hurdles. Handling booleans data type is less efficient than the BIT type in the SQL Server ( /products/sql-server ).Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-12-19
Rated 4 out of 5 by Deivid Z Baoti from MySQL ? Sure, but what is the best config and how to optimize for best performance ? We could write books about MySQL ( https://www.itcentralstation.com/products/mysql ) and every book could have a different focus: setup, optimization, backup, etc.So, this review will be about sharing some experience I have had.So, MySQL is probably the most used RDBMS for web applications.The server is really easy to install, literally a straightforward installation.It is very fast and stable and at the same time not resource hungry compared to some other RDBMS products.For smaller projects, you will not even need to do any "after install" tweaks or configurations, just install and you are ready to go.Nevertheless, for some more demanding projects, you will need to investigate and optimize your setup to fit the requirements.What is the best configuration for a MySQL server?There is no single best configuration. There are many of them, depending what is MySQL used for.E.g., it is not the same as having it installed in a shared hosting environment or as a dedicated instance to just one application.Having 1000 of users using a few hundred different databases or having 20 users using one database.Is it gonna be an OLTP or OLAP, do you focus more on writing or reading?I will not dive into this, as there are many other articles covering this in a much better way than this article.But, starting by selecting the adequate storage engine MyISAM or InnoDB, defining the maximal number of connections, all the buffer and caching settings, limit on open files, table caching, etc. is laways a good approach.You will need to sit down and write down all the requirements known to you and then aligned to those, start configuring your server.A very handy tool to investigate your server's setup and performance is the mysqltuner.pl script.It can be used as a starting point to investigate your server setup and increase performance.Sometimes, although your server is configured properly, you might experience a slow performance, especially on a shared hosting server.During my career as a system administrator in a hosting company, we have monitored our MySQL servers and tracked the performance.Often, in such an environment, it might happen that you have a "running away" query, eating up your resources or causing performance issues.In such a case, database optimization is required, rather than server a config.A good example for this is having a well-visited web application with many concurrent users.Often on such an application, there are queries which run more frequently than others.E.g. presenting top 25 products in a web shop by using a query similar to this:SELECT p.name, c.nameFROM product pLEFT JOIN category c ON ( c.id = p.category_id )WHERE p.new_product='1'GROUP BY c.name, p.nameORDER BY p.name ASCLIMIT 25 ;Such queries will run very fast if the database itself is optimized.But otherwise, they can run really slow and cause high CPU utilization or in worse case a bottleneck and slow down the whole server.You don't need to have millions of records, this can happen even if you have only a few hundreds/thousand records in your database.In such case, you need to identify these "slow queries" (you can log slow queries) and then investigate the database they are referencing.Often it's about missing indexes on columns involved in GROUP BY, ORDER BY or WHERE clause.Backup? Of course, you already have the backup in place and it's running, at the end we are talking about the database.There is always a backup policy when a database is involved.Many use mysqlbackup command to schedule a "hot backup" of a server.Although it works in 99% of cases, please consider having a mysqldump running in parallel. Why?It might happen that you have a corrupted InnoDB tables and you are backing them up. By the first server reboot, it might lead that you lose data.When databases are involved, it is always good to have the data backed up in a flat structure if possible, if we are not talking about huge databases and the dump would consume too much time.This gives you the ability to import the data in a new instance, if you face any scenario where you have issues with corrupted storage engine and cannot recover from that.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-08-22
Rated 3 out of 5 by Gaston Nusimovich from Offers a simple DBMS solution with a very low hardware footprint. Only one of the engines supports ACID transaction control. Valuable Features:We design web solutions for customers with PHP (Linux) and ASP.NET ( https://www.itcentralstation.com/products/asp-net ) MVC (Windows). MySQL offers a simple, no frills, but effective DBMS solution with a very low hardware footprint. Since it has no licensing fees, it offers great TCO for our customers.Improvements to My Organization:We do software development for our customers on both Windows and Linux. Since these tools are available for both Windows and Linux, we can leverage the knowledge of these tools for development on both platforms.Room for Improvement:Only one of the engines, InnoDB, supports ACID transaction control. The best performance engine, MyISAM, has no transactional control support.It would make a lot of sense to include one engine that offers both very good overall performance and transactional control support.All versions of MySQL, including the Community Server version include in its design a Pluggable Storage Engine Architecture.This architecture allows for the support of multiple options of Storage Engines, so, a software architect can design a sofware solution with MySQL based on a specific Storage Engine that is capable to cater to a particular type of storage use case requirements, like for instance, web applications with heavy read workloads and moderate write workloads, or intranet desktop applications with heavy write workloads.Depending on the version of Community Server installed is the list of available Storage Engines: all it takes is the execution of the command SHOW ENGINES to retrieve the list of installed Storage Engine plugins.When you create any given table in MySQL, you have the option to select what Storage Engine (among the engines available) will be applied to said table. If this option is no explicitly mentioned at the end of the "CREATE TABLE" command, the current default storage engine will be assumed.For web apps with intensive read workloads and moderate write workloads, the engine that offers a good overall performance is the MyISAM engine, but this does not support ACID transaction control, and it uses a table-level locking mechanism (thus, from a performance standpoint, this is not proper for apps with heavy write workloads).The InnoDB engine uses a record-level locking mechanism, so, it is proper for apps with heavy write workloads. It also supports Isolation Levels, which is important for applications that have many clients doing read and write operations concurrently.The other storage engines offer support for very specific use cases, like for instance, flat file tables (CSV engine) or memory-only tables (Memory engine).Getting back to the InnoDB engine, it offers features that are similar to the database engine in SQL Server, and according to some of benchmarks that we have run, SQL Server Express provides overall better performance than MySQL Community Server with InnoDB tables.My "Room for Improvement" comment is that it would be great if in the future Oracle were to provide with the Community Server edition a version of InnoDB with better overall performance, while still requiring a small hardware footprint.Use of Solution:We have been using MySQL on both Windows and Linux for over six years.Stability Issues:As with any good DBMS, MySQL requires periodic DBA maintenance. If you leave a MySQL database with no supervision of a DBA for enough time, files become too fragmented and they may turn corrupt beyond rescue.Scalability Issues:The version of the product with free licensing does not offer stellar scalability support. We only use these tools for solutions that do not require such a level of scalability.Technical Support:The version of the product with free licensing only offers community forum support. Because it is a very popular product, there are many free resources on the internet to search for solutions to most issues.This kind of "free support" is OK, because we do not use these tools for mission critical solutions.Previous Solutions:For Windows development of non-critical solutions, we previously used SQL Server Express exclusively. However, now we use either SQL Server Express or MySQL, depending on the customer. We have not switched from SQL Server Express to MySQL.Initial Setup:The admin tools offered by MySQL Workbench are very good. For an experienced DBA, it is rather easy to setup a (MySQL) server for development, testing, pre-production, or production environments.Pricing, Setup Cost and Licensing:With no licensing fees, the business opportunity is great for both the customer and an ISV like my company. This is the case, as long as you use these tools for non-critical solutions.Other Solutions Considered:We did evaluate other solutions, mainly PostGre SQL ( https://www.itcentralstation.com/products/postgresql ), which is also a very good product.We run a benchmark comparison first, and then we run a small lab with the development of a small solution with both toolsets (MySQL and PostGre SQL).In this development comparison, we found that the winner is MySQL. MySQL toolset for development offers much more coverage for both PHP and C# development.Other Advice:Most small and medium enterprises require many non-critical solutions. They clearly they do not have large budgets for these kinds of solutions, so it makes a lot of sense to consider MySQL as a good option for this kind of development.The advice is to make sure that it works for your company and for your customers.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-08-01
Rated 4 out of 5 by Antonios Kosmas from The most valuable feature is its graphical interface which allows us to do the database administration. Valuable Features:MySQL is strongly recommended for web applications and LAMP architecture systems. The most valuable feature of this product for me is its graphical interface which allows me to do the database administration easily. Another important feature is its reliability, the decent performance, and the fact that it is an open source product.Improvements to My Organization:It gives us the opportunity to create backups of our databases easily and loop through them with minimum effort.Room for Improvement:I think that the stored procedures and the development tools to write and debug large queries could be improved.Use of Solution:I have used MySQL for about ten years.Stability Issues:There were no issues with stability.Scalability Issues:There was no issue with scalability.Technical Support:We have not used technical support. The community is large enough to find the solution when something comes up.Previous Solutions:We used many SQL database solutions like PostgreSQL and SQLite and NoSQL databases like MongoDB. The choice depends on the project.Initial Setup:The initial setup was straightforward.Pricing, Setup Cost and Licensing:I think that the Open Source product would cover the needs of most projects. In some cases, the advanced features are needed. they could use the enterprise edition which is reasonably priced.Other Solutions Considered:We have evaluated and used different products like SQLite. It depends on the requirements and the needs of the project.Other Advice:I believe that it is the ideal solution for a variety of projects with a small learning curve compared to other solutions. It allows you to be efficient quickly.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-28
Rated 5 out of 5 by Filitsa Chasapi from Improved our internal procedures by providing high performance, ease of use and cost savings. Valuable Features:The most valuable features are:* MySQL Database Servers* MySQL Connectors* MySQL WorkbenchImprovements to My Organization:MySQL has improved our internal procedures by providing high performance, ease of use and cost savings.Room for Improvement:Security in the data files needs manipulation.Use of Solution:I have used this solution for five years.Stability Issues:There were no stability issues.Scalability Issues:There were no scalability issues.Technical Support:Technical support is excellent.Initial Setup:The setup was really straightforward.Pricing, Setup Cost and Licensing:According to the specific business and technical requirements, you can choose your MySQL Edition that you wish by consulting the official site.Other Solutions Considered:We looked at the Microsoft SQL Server.Other Advice:It can benefit any business by a straightforward way of implementing and using it.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-21
Rated 4 out of 5 by SeniorProdEng927 from Simple to use with excellent performance. Valuable Features:To me, MySQL is very flexible, has an excellent performance and it's simple to use.Improvements to My Organization:Once we needed to use a database to distribute a product for my company and we chose MySQL; It was easy to use, it is very small but powerful.Room for Improvement:Maybe the way to build clusters needs to improve, they could improve the installation process.Use of Solution:I been using MySQL for nearly seven years.Stability Issues:There were no stability issues.Scalability Issues:There were some scalability issues.Technical Support:I would give the technical support an 8/10 rating.Previous Solutions:We did upgrade the version by improvements in the product.Initial Setup:The setup was complex in the cluster installation.Pricing, Setup Cost and Licensing:MySQL is one of the best database options, the Community version is great.Other Solutions Considered:We used Oracle and SQL Server but their prices and licensing were so expensive.Other Advice:Using MySQL could be an excellent option.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-20
Rated 4 out of 5 by Massimo Cavallini from Online backup can be implemented by activating a temporary storage and introducing Percona innobackupex. Valuable Features:This product is valuable because it is used in the production environments. Online backup can be implemented by activating a temporary storage similar to the Oracle's flash recovery area and introducing Percona innobackupex. This is possible from version 5.6.Improvements to My Organization:It permits services such as data warehouse and retail.Room for Improvement:The online backup needs to improve.Use of Solution:I have used this solution for 15 years.Stability Issues:We did encounter stability issues.Scalability Issues:There were no scalability issues.Technical Support:Not applicable because we don't purchase commercial support.Previous Solutions:We switched due to the cost saving reasons.Initial Setup:The setup was of medium-level complexity due to the memory parameters.Other Advice:Compared to PostgresSQL, it has an online backup feature only with the extension of Percona innobackupex.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-20
Rated 3 out of 5 by Kalin Dikov from Offers SQL Merge, Replication, and Views. I would like to see additional side management tools and IDEs. Valuable Features:* SQL Merge* Replication* Views* Stored Procedures* Triggers* CursorsThis is just like the enterprise grade Oracle DB. MySQL now supports replication (master-master or master-slave) of our DB to support our company's multiple geo-locations and PoPs.It supports the original Oracle SQL operations such as Merge, as well as the creation of Views to your tables. This brings additional convenience to our organization.Improvements to My Organization:The main benefit for us is that it's totally free, unless you need to pay for support.Room for Improvement:I would like to see additional side management tools and IDEs.Use of Solution:I used this current version for one year. I used previous versions for over ten years.Stability Issues:There were no stability issues.Scalability Issues:There were no scalability issues.Technical Support:We didn't need any technical support. I would guess that Oracle support is top-level.Previous Solutions:We did not use a solution prior to this one.Initial Setup:The initial setup was straightforward, user-friendly, and easy. In most cases, if you use the Linux-based versions, it comes as a standard Linux package. You can get it installed by using AptGet, Aptitude, or Yum.Cost and Licensing Advice:Just pay for any license if you need some enterprise support for your project or any additional support tools that Oracle ships with the enterprise version. During the development stage of your project, you can just use the free community edition.Other Solutions Considered:We evaluated MSSQL, Oracle DB, Informix, and MariaDB.Other Advice:Go with the Linux version. It is more stable and manages the system resources better.Disclaimer: My company has a business relationship with this vendor other than being a customer:We are partners, developing applications together.
Date published: 2017-07-10