MySQL vs. WordPress

MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.

Incentivized

Wordpress is a great solution for a website of nearly any type. It may not be as suitable if a fully custom solution or app is needed, and it does have some limitations when it comes to connecting it to external products (especially if the product doesn't have any support from a native system), and it does require a lot of testing. Multiple plugins in one install are common but also increase the risk of conflicts, and when those do occur, it can be exceptionally time-consuming and tedious to identify what is causing the issue. As third parties create many plugins, you're also at risk with each potential security breach, which needs to be kept in mind. I would be cautious to use WordPress to store any sort of sensitive PPI. That said, it's a wonderful, easily customizable solution for many, many different types of websites and can allow even inexperienced client users with low-tech knowledge to update basics.

Incentivized

• Stable - it just runs, with minimal downtime or errors
• Fast - well-structured data is quickly written and read
• Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
• Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL

Incentivized

• Easy to use User Interface
• Coding / Plugin Implementation is awesome
• There's always a solution available for the platform
• Security is easy to use and robust
• Implementation with 3rd party platforms, such as Google's variety of tools
• Can download and host on your own server or use their hosted servers

Incentivized

• Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
• Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.

Incentivized

• WordPress breaks often so you need to have someone who understands how to troubleshoot, which can take time and money.
• Some plugins are easier to customize than others, for example, some don't require any coding knowledge while others do. This can limit your project if you are not a coder.
• WordPress can be easily hacked, so you also need someone who can ensure your sites are secure.

Incentivized

For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.

Incentivized

The complications we have and the lack of support. Every plugin has a differente team of support in charge and make one plugin work with the other one always affects the website performance. It's a thousand times better to have only one provider with all functionalities included unless you are an expert web developer or have a team dedicated to it

Incentivized

I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.

Extremely easy to use and train users. It took very little time to get everyone trained and onboarded to start using WordPress. Anytime we had any issues, we were able to find an article or video to help out or we were able to contact support. The menu options are well laid out so it is easy to find what you are looking for.

Incentivized

Anyone can visit WordPress.org and download a fully functional copy of WordPress free of charge. Additionally, WordPress is offered to users as open-source software, which means that anyone can customize the code to create new applications and make these available to other WordPress users.

Mostly, any performance issues have to do with using too many plugins and these can sometimes slow down the overall performance of your site. It is very tempting to start adding lots of plugins to your WordPress site, however, as there are thousands of great plugins to choose from and so many of them help you do amazing things on your site. If you begin to notice performance issues with your WordPress site (e.g. pages being slow to load), there are ways to optimize the performance of your site, but this requires learning the process. WordPress users can learn how to optimize their WordPress sites by downloading the WPTrainMe WordPress training plugin (WPTrainMe.com) and going through the detailed step-by-step WordPress optimization tutorials.

We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.

Incentivized

I give this rating, which I believe to be a great rating for a community based support system that's surrounding it. Most platforms and products have their own, and as WordPress does have their own team that help here and there, a lot of it's handled by community involvement with dedicated users who are experts with the system who love to help people.

Varies by the person providing training. High marks as it's incredibly easy to find experienced individuals in your community to provide training on any aspect of WordPress from content marketing, SEO, plugin development, theme design, etc. Less than 10 though as the training is community based and expectations for a session you find may fall short.

It is very easy to find online resources to learn how to do just about anything with WordPress.

1. Estimate your data size. 2. Test, test, and test.

Incentivized

WordPress is not a great solution if you have: 1) A larger site with performance / availability requirements. 2) Multiple types of content you want to share - each with its own underlying data structure. 3) Multiple sites you need to manage. For very small sites where these needs are not paramount, WordPress is a decent solution

MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.

Incentivized

WordPress isn't as pretty or easy to use as certain competitors like Jimdo, Squarespace or HubSpot, but it makes up for it with its affordability, familiarity and the ability to find quality outside help easily. The same can't be said for certain competitors, as you might need to find an expert and it could get costly.

Incentivized

WordPress is completely scalable. You can get started immediately with a very simple "out-of-the box" WordPress installation and then add whatever functionality you need as and when you need it, and continue expanding. Often we will create various WordPress sites on the same domain to handle different aspects of our strategy (e.g. one site for the sales pages, product information and/or a marketing blog, another for delivering products securely through a private membership site, and another for running an affiliate program or other application), and then ties all of these sites together using a common theme and links on each of the site's menus. Additionally, WordPress offers a multisite function that allows organizations and institutions to manage networks of sites managed by separate individual site owners, but centrally administered by the parent organization. You can also expand WordPress into a social networking or community site, forums, etc. The same scalability applies to web design. You can start with a simple design and then scale things up to display sites with amazing visual features, including animations and video effects, sliding images and animated product image galleries, elements that appear and fade from visitor browsers, etc. The scaling possibilities of WordPress are truly endless.

• As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
• The acquisition by Oracle makes you need to contract support for the enterprise version
• If you have knowledge about oracle databases, you can get more out of the enterprise version

Incentivized

• Allowed us to being all websites under a single umbrella, saving costs on similar products.
• It's increased our website turn time and made us faster and more efficient at launching websites.
• Edits and tweaks happen much faster as we have a customized environment.

Incentivized