For program developers, the most popular background database is currently mysql and sql server. The most basic similarities between these are data storage and belongs to the query system. You can use SQL to access data of these two databases because they all support ANSI-SQL. Also, both database systems support binary keywords and key indexes, which greatly accelerates query speed. At the same time, both provide various formats that support XML.
In addition to the distinctive differences in the significant software price, is there any obvious difference? How do you choose between these two? Let us see the main differences between these two products, including issuance, performance, and their security.
Fundamental differences are the basic principles they follow
The basic principles followed are the main differences: open VS conservative. The narrow, conservative storage engine with the SQL server is extensible to the mysql server, and the open storage engine is not different. Although you can use the SQL server's Sybase engine, MySQL can provide more options such as Myisam, Heap, InnoDB, and Berkeley DB. MySQL does not fully support unfamiliar keywords, so it is less related than SQL servers. At the same time, MySQL also lacks the functionality of some storage programs, such as the Myisam engine supports the switching.
Distribution cost: mysql is free, but it is very cheap
When referring to the fees issued, these two products adopt two kinds of different decisions. For SQL servers, get a free development fee is the most common way to buy Microsoft's Office or Visual Studio's fees. However, if you want to use the development of commercial products, you have to buy SQL Server Standard Edition. School or non-profitable companies may not consider this additional cost.
Performance: Advanced MySQL
In terms of performance, MySQL is quite well because it contains a default desktop format Myisam. Myisam databases are very compatible with disk and do not occupy too much CPU and memory. MySQL can run in a Windows system without conflicting, running on UNIX or similar UNIX systems. You can also get additional performance by using a 64-bit processor. Because MySQL uses 64-bit integer processing many times in the interior. Yahoo! Business website uses mysql as a background database.
When referring to the performance of the software, the stability of the SQL server is much stronger than its competitors. However, these features must also be deserved. For example, you must add additional complex operation, disk storage, memory loss, and so on. If your hardware and software can't fully support SQL servers, I suggest you choose to choose another DBMS database because you will get better results.
security function
MySQL has a binary log for changing data. Because it is binary, this log can quickly copy data from the host to the client. Even if the server crashes, this binary log will remain complete, and the part of the replication will not be damaged.
In the SQL server, you can also record the relevant queries of SQL, but this requires a high price.
safety
These two products have their own complete safety mechanisms. As long as you follow these security mechanisms, there will be no problems with general procedures. Both use the default IP port, but sometimes unfortunately, these IPs will be broken into some hackers. Of course, you can also set these IP ports themselves.
Restore: Advanced SQL Server
Restoreability is also a feature of MySQL, which is primarily manifested in myISAM configuration. This approach has its own lack of lack, if you accidentally damage the database, the result may result in all data loss. However, it is very stable for the SQL server. SQL servers can always monitor data exchange points and save the process of damage to the database.
Decide your choice for these two databases as needed, if you don't want to say which one is more excellent, maybe I will let you down. With my point of view, any database that is helpful to your work is a very good database, no database is absolute, and no database is absolute. I want to tell you what you should start from your own needs, what kind of task you want to do? Do not simply start from software.
If you want to build a .NET server system, this system can access data from multiple different platforms, participate in the management of the database, then you can use the SQL server. If you want to build a third-party site, this site can read data from some clients, then MySQL will be the best choice.
Both the database can run normal in .NET or J2EE, the same, the same, it can take RAID