MySQL Archive

SQL Server Alternative

by Jorge R
The main focus of my article is to explain the advantages from moving from SQL Server to MYSQL. The author starts by stating that he worked as a SQL Server DBA, and at the time there was no other program that matched Microsoft’s user friendly interface. As timed progressed he found MYSQL to be a database that could match SQL Server ease of use, reliability and performance. One of the benefits of using MYSQL is the running the program in a multitude of operating systems, with low computer resources and hardrive space. Another advantage of using MSQL is the use of storage engines. This allows the DBA to have a flexibility to have transactional tables, main memory, and compressed data. A point expressed by the article is the companies using MYSQL such as Google, Yahoo, and Facebook. Their performance and scalability is above and beyond their competitors. There are wide arrays of monitoring and tuning tools packed into MYSQL; they are trying to make their products as user friendly to use. The article states that there are multiple ways to transition into MYSQL. A method is to use a program made to convert SQL Server data into MYSQL data.  One of the most attractive features of MYSQL is the low costs. read more...

Not so Sweet for Team Meat

by Kevin Q
 

My article is on an event that took place last December. It involves a Video Game Developer know as Team Meat and their PC version of the game Super Meat Boy. Super Meat Boy is a single player game that tests peoples platforming skills(think Mario Brothers on Crack) and allows users to compete and place on leader boards for best times and earn achievements for completing insanely hard levels. Last December a user reportedly tried to notify Team Meat that their MySQL servers were not secure via Twitter. The users concerns were brushed off by Team Meat saying, “Trust me. It’s fine. I’ve done this stuff for awhile now.” Later that day their game was attacked by the users known as Anonymous. Leader boards became unstable, people couldn’t upload their data to the Team Meat SQL servers, and worst of all levels had their title names changed to write out not so nice sentences to the developer Team Meat. One sentence read across multiple levels reads, “This is why you don’t connect to a remote MySQL Database in your game.” Team Meat still tried to brush this event off as not being a security hole, but the fact that other paying users were strongly affected by this shows bad professionalism on their part. read more...

Joomla + SQL = Fun to say, fun to use

by Brian T
Upon surfing the articles of PC World (mainly in an effort to feel intelligent and savvy), I happened across an article regarding a product known as Joomla. For those of you inquiring as to what Joomla is, it is an open-source style content management system.  Apparently, in their latest release Joomla has added a search engine as well as support for PostGreSQL and Microsoft SQL Server – an expansion from their prior reliance on MySQL. A spokesman for Open Source Matters (Joomla’s supporting organization) explains that valuable time and financial resources may now be retained by expanding Joomla’s capabilities beyond that of a single server. Additionally, it was stated that the Joomla update will allow the execution of multiple common  SQL commands across different types of databases without having to specify or worry about syntax. read more...

All databases used as one.

by George A
My article explains a method of how to allow a user to access information from many databases on the internet using XML as if it were one database.  The purpose is to decrease the workload in obtaining information from the internet. It will also help to increase efficiency and save time. Different database types such as relational databases (RDB), object-oriented databases, and XML databases can all be queried using the method stated in the text. The authors call this method the “virtualization” of many databases into a single one. The authors elaborate by stating that databases on the internet as well as business software databases can all be accessed in the same way and integrated in real time using JDBC/SOAP methods. The author’s developed an, “XML conversion program, XML import/export…” The data from a MySQL server for example is converted using the XML export program code identifying parts such as table names, field names, and constraints. The XML import code is used then to allow a user to access the information as a single virtual database with all the other MySQL, PostgreSQL, or SQLServer2005 servers acting as one to the user. This is just one example for conversion using these types of databases. read more...

MySQL Website Compromised to Inject Malware

by Daniel L
Database management systems are an integral part of many products and services that are offered over the World Wide Web.  MySQL, one of the most common open source database management systems and key component of the LAMP software  stack, caught the attention of hackers on Monday, September 26, 2011.  According to security vendor, Armorize, the  hacker used JavaScript code to inject malicious software onto Windows PC users who visited the MySQL website between the hours of 5 a.m. to 11 a.m. Pacific Time Monday.  Armorize also stated that the particular method that was used to attack website visitors is known as the Black Hole exploit kit; however, there is no indication of what the malware was designed to do.  This is not the first time that the MySQL website has been hacked, they were hit earlier in the year, as well as other open source websites such as Linux.com and Kernel.org.  A hacker on a Russian forum using the alias, sourcec0de, claims to have full permissions and administrative rights to the MySQL servers, and he is even willing to sell root access for $3,000.  Although, it is unclear if the hacker had root access, he posted screenshots which showed that the MySQL web servers were indeed compromised. read more...

Open Source Database for Small Company

by Tuyen H

 

While Eclipse is very successful for Java Development, MySQL and PostgreSQL are very populating open source Databases.We cannot compare with brand name like Oracle, Microsoft, or IBM, but MySQL and PostgreSQL are very reasonable for small business.  If your data is less than a terabyte, both MySQL and PostgreSQL definitely can handle it. However, if your data is really big, you better think of Oracle, DB2, and Microsoft enterprise RDBMSes. Open source database is less secure than brand name database, so you have to keep in mind that “how safe is my data”  (Gravelle, 2011). read more...