MySQL Archive

SkySQL’s New Database Tool

by Andrew S
The article talks about how a company named SkySQL released a configuration tool that deploys databases to a cloud environment.  SkySQL offers its services to database administrators that lack the technical skills to transfer databases to a cloud environment.  The new company will offer its services on Amazon Web Services(AWS).  Through this new configuration, it allows its users to manage instances, isolate and reconfigure individual nodes, and backup and restore.  The article informs the reader about the compatibility of the new service and how it is compliant with the three most used MySQL distributions.  MySQL is a growing trend that allows companies to seek the latest performance optimization technologies.  SkySQL provides a lucrative service that received funding from a number of investors that hope to see the company grow and evolve. read more...

Applications of Database Development to Gene Ontology

by Michael V
The Gene Ontology database is essentially a tool that those involved in the field of molecular and cellular biology utilize in order to both obtain information as well as share it amongst peers in an open community. The database located at http://www.geneontology.org/ contains an organized structure of genetic vocabulary, classifications, and information for those involved with genetic research to access. Not only does the database contain the information in a well organized manner, it is easily customized for an individuals needs through searches and multiple display formats for ease of the user. It also supports changes and additions to the database easily, as the members of the Gene Ontology Consortium continuously expand and update the genetic vocabulary. In essence the Gene Ontology projects represents the best efforts of people around the world to merge their collective information about genetic vocabulary with a well structured database that will standardize the formats that the data is shared in. The database itself is made from MySQL database that allows it to be easily worked with by programmers from everywhere in the world. read more...

Amazon Relational Database Services (Amazon RDS)

by Miguel V
The article I chose, Amazon Web Services Announces New Managed Services for Windows Developers Worldwide, talks about Amazon annoucing a new managed services for windows developers with the launch Amazon RDS for Microsoft SQL Server and ASP.NET called AWS Elastic Beanstalk. Business can use “Amazon RDS to offload the operational responsibilities of their MySQL and Oracle database.” The article also talks about AWS Elastic Beanstalk which gives developers “an even easier way to quickly deploy and manage their Java, PHP and ASP.NET applications in the AWS Cloud.” AWS works by having the user upload their application and it will automatically handle the deployment details of capacity provisioning, load balancing, auto-scaling, and application health monitoring. read more...

MySQL gets an upgrade from Oracle

by Ermie C
The one thing that has become in a business is the importance of databases. We understand how everything is and how it flows, however, the ease to make the SQL statements can get kind of hairy. For Oracle, they have launched this new version MySQL Cluster. This new feature is actually going to be open source and is a lot easier to use. The two new features that are provided are combing the best of both worlds of NoSQL and SQL databases. ” It can rival the fast key value operations of NoSQL, while still offering the ability to do complex queries of a regular SQL databases” is how they they described it. With the open source, it can prove to be a advantage in the sense that anything is possible for this type of SQL, however, this upgrade can prove fatal for potential hackers who can get the code of how databases are filled. The main feature that is going to be great is the Memcached API. This is because this will make searches and performances go faster and as mentioned Facebook uses this software. This will make the input of data a lot easier. read more...

The Future of MySQL

by Miguel V
The article I chose to talk about this week was “eWEEK Labs Ponders MySQL’s Fate Under Oracle.” In this article the author Jeff Cogswell gives his ideas on the future of MySQL, by factoring in sound business sense as well as history, now that Oracle has bought it for $1 Billion. With 11 million installations, MySQL has proven to demonstrate just how valuable the software can be proving that it is not just some “small, run-of-the-mill Open-source Package.” MySQL has become a serious competitor to Oracle’s database products especially even more now “in the down economy, with cash-strapped businesses increasingly looking to free and open-source software.” The article then looks at the history of Oracle’s pasted acquisition deals, for example, “in early 2007, Oracle acquired Hyperion, a maker of business intelligence products.” Jeff noticed that Hyperion software was integrated into Oracle’s overall product set while remaining largely intact. In general Oracle’s “acquired companies’ products did not go away but were integrated into Oracle’s existing product lines.” He wraps up the article by saying that “It’s very possible that the name will change, but, based on previous Oracle acquisitions, it’s doubtful that MySQL will disappear.” read more...

Anonymous Hacks Apple Server

by Jonathan N
This Article talks about how one of Apples servers were hacked into by a group named Anonymous. The group Anonymous broke into one of Apples less important servers which is used to process technical support follow-up surveys. The hack ended up revealing only 27 customer Apple User name and Passwords. Apple has made it clear that no personal customer data has been retrieved from the attack. Anonymous posted on their twitter account that they should not need to worry because they are busy hacking elsewhere. However, Apple immediately took the affected server offline just incase of any more risk. Lulzec, which is a former hacker group used a similar style of hack with the user name and password dump of the mysql database on the Apple machine. Lulzsec used SQL injections to pilfer information from Sony Pictures  and PBS, as well as the website of the Mosman Council in Sydney, Australia. Lulzec has made former claims that it has broken into Apples ICloud server by claiming, “After mapping their internal network and thoroughly pillaging all of their servers, we grabbed all their source code and database passwords, which we proceeded to shift silently back to our storage deck.” Apple has yet to make a comment on either attacks. read more...

Tips in using MySQL in AWS

by Jim J
The next generation of storing data is in cloud computing. Amazon cloud offers these kinds of services few things can be done to overcome most of the performance issues. Amazon uses elastic book storage (EBS) which appropriates network resources to its users and which has performance that varies depending on availability; this is their greatest weakness. Ways to mitigate this is taking advantage of the cache in browsers, objects, queries, and data. Many MySQL settings can be tuned for performance benefits such as increasing buffer sizes and even things like using a high-performance file system like XFS. In addition to performance benefits, DBA’s need to ensure data redundancy taking use of multiple data centers spread across the globe so as to have options for when a server goes down; recovery is equally important where DBA’s need to automate getting their servers back up and running. Some companies like Netflix even run programs that randomly take out servers during the day so as to test out their ability to stay on-line. read more...

MySQL Will Have Two Conferences In 2012

by David A
Oracle has announced on Thursday that the open-source database management system MySQL will have user-focused event conference Sept. 29 and 30 in San Francisco. In addition Percona will also hold an event next Tuesday in Santa Clara known as the Percona Live MySQL Conference. This is great news for users and developers of the application, because O’Reilly which hosted the last two annual events had decided not to host anymore. Percona’s event will be jam packed with technical presentations, review of user case studies and will have Marten Mickos the CEO of MySQL as the key note speaker. Oracle’s event will provide technology road maps and a chance to talk with Oracle engineers working on MySQL. Both conferences are going to be great, but many believe that most companies will pay to send their administrators to only one, so it would be nice to have Oracle and Percona combine and provide a joint event in the future. Yet, it is nice to see that MySQL is getting so much attention. read more...

Oracle, Keeping MySQL Users Happy

by Jongwoo Y
In 2010, Oracle went through with the buyout of Sun Microsystems, a company that was very popular for their open source applications such as MySQL and OpenOffice, for 7.3 billion dollars. During that time, MySQL users were outraged at the fact that Oracle would now have control over their open source products, especially since at the time, Oracle seemed to be hostile towards the idea of OpenSource technology (Pallato, 2011). However, contrary to popular belief, Oracle has actually treated their newly acquired product as a completely different line and have continuously updated their newly obtained OpenSource database management tool just as diligently as their own Oracle Database Management system. The biggest news that has come out recently is that Oracle has released an update for MySQL 5.5 that gives users of that program the same access to the 24/7 online technical support environment as the Oracle database (Pallato, 2012). This is huge because users of the free database software are able to receive the same professional support that many fortune 500 companies receive from Oracle. Oracle has taken a huge step forward with this new development in their customer service area due to the fact that thousands of users of MySQL are thrilled with the decision that Oracle has made. Though many people did not like the fact that Oracle had taken over their open source database application, Oracle is slowly, but surely showing these users that it was a step in the right direction. read more...

Joomla incorporates MySQL

by Ermie C
This article is about how the new edition of Joomla has now made it possible to use Microsoft SQL Server, PostGreSQL, and MySQL.  This multi-database support has become a great plus for business owners that use Joomla for their websites.  There won’t be as much hassle by being limited to just one database structure.  This is because the creators have only made previous Joomla versions to only incorporate MySQL.  However, with the new integration of multi-database functions, the use of PHP could allow Joomla to connect with the new database tools.  There’s a couple of new things they added also; the ability to incorporate a search engine function and something called stemming where it assumes the word that is being searched.   Then there is also auto completion.  In a nutshell, they have made the interface for Joomla, a lot more user friendly and this is what will attract new customers and keep the long lasting consumers of 1.6 million websites. read more...