|
Archived MySQL Articles
|
03 Jun 2013
|
MySQL (5th Edition) - By Paul DuBois [31294]
The definitive guide to using, programming and administering MySQL 5.5 and MySQL 5.6
MySQL provides a comprehensive guide to effectively using and administering the MySQL database management system (DBMS).
Author Paul DuBois describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers. The book also includes a comprehensive reference section providing detailed information on MySQLs structure, language, syntax, and APIs.
The fifth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.5, as well as to add new coverage of features introduced with MySQL 5.6.
MySQL is an open source relational database management system (DBMS) that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications. MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it.
(Get More Information . .)
|
|
18 May 2013
|
Circular Replication in MySQL [31005]
Replication is a hot topic in MySQL 5.6
Jeremy Smyth writes, "Replication is a hot topic in MySQL 5.6, and for good reason: There are many excellent features that make it a strong well-supported feature, from the new Global Transaction Identifiers (GTIDs), to simplified replication configuration and automated failover using MySQL Utilities (now available in alpha as a separate download).
The simplest topology consists of a master server that accepts changes, and slaves that replicate those changes from the master. A common requirement is for a network to have multiple servers that accept changes and replicate to each other. This is possible by means of circular replication, where each master is also the slave of another master, in a circular fashion. However, this configuration is prone to certain problems..."
(Get More Information . .)
|
|
10 May 2013
|
NetMotion Wireless Migrates Product from Microsoft SQL Server to MySQL [30910]
Reduces Costs and Increases Flexibility
NetMotion Wireless develops software to manage and secure wireless data deployments for organizations with mobile field workers. Founded in 2001, NetMotion Wireless is one of the fastest growing wireless and technology companies and the recipient of over 25 awards for outstanding technology. NetMotion Wireless has over 2,500 customers, including Advocate Healthcare, Comcast, and Unilever.
NetMotion Wireless had used Microsoft SQL Server with Mobility Analytics, their mobile VPN products analytics module, but found it was too costly and lacked the platform and language flexibility to be a good [embedded] database. As a result, when the NetMotion Wireless product team was developing Locality, a cellular network management product, they decided to find an alternative database to use with it and with Mobility Analytics. The team compared MySQL with Microsoft SQL Server on a number of key criteria and, after finding nothing in the 'con column', decided to use MySQL...
(Get More Information . .)
|
|
30 Apr 2013
|
Big Fish Selects MySQL Cluster to Serve Real-Time Web Recommendations [30810]
World's Largest Producer of Casual Games Uses Worlds Most Popular Open Source Database to Power Improved User Experience
With more than 2 billion games distributed to date, Big Fish, the world's largest producer of casual games, needed a solution that would enable it to maintain its leadership in the casual game sector. Using business intelligence and predictive analytics Big Fish can segment customers based on a range of demographic and behavioural indicators.
To deliver an increasingly personalized customer experience based on its intelligence and analytics, Big Fish selected MySQL Cluster Carrier Grade Edition (CGE) to power its Marketing Management Service platform.
Big Fish's Marketing Management Service platform is used across all of the company's customer management systems, including customer support and the company's "Game Manager", to provide a unique customer experience to each of its millions of monthly users whenever they come in contact with Big Fish.
(Get More Information . .)
|
|
22 Apr 2013
|
MySQL for Excel 1.1.1 [30724]
Version 1.1.1 is a maintenance release that contains the may bug fixes
The MySQL Windows Experience Team has announced the release of MySQL for Excel version 1.1.1 GA, the latest addition to the MySQL Installer for Windows.
MySQL for Excel enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:
- Importing MySQL Data into Excel
- Exporting Excel data directly into MySQL to a new or existing table
- Editing MySQL data directly within Excel
You can download it from the official Downloads page
(Get More Information . .)
|
|
22 Apr 2013
|
Driving MySQL Innovation [30730]
Keynote Speach by MySQL Engineering Tomas Ulin
Oracle's VP of MySQL Engineering Tomas Ulin delivered on Tuesday a keynote entitled "Driving MySQL Innovation for Next Generation Applications" at the Percona Live Conference.
If you haven't seen it yet, watch it here.
Tomas covers:
- Oracle's Investment in MySQL
- MySQL 5.6
- Trends and Product Directions
He makes it very clear that Oracle:
- Invests in MySQL like Never Before
- Drives MySQL Innovation
- Makes MySQL Better for Next Generation Web, Cloud and Big Data Applications
Enjoy the keynote!
(Get More Information . .)
|
|
|
|
|
