11 million installations can't be wrong

MySQL Journal

Subscribe to MySQL Journal: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get MySQL Journal: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories

Download Slide Deck: ▸ Here Download Slide Deck: ▸ Here A Tour of Data Platforms as a Service With the proliferation of both SQL and NoSQL databases, organizations can now target specific fit-for-purpose database tools for their different application needs regarding scalability, ease of use, ACID support, etc. Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations. Download Slide Deck: ▸ Here In his session at 18th Cloud Expo,Christo Kutrovsky , Principal Consultant at Pythian, compared the NoSQL and SQL offerings from AWS, Microsoft Azure and Google Cloud, their similarities, differences and use ca... (more)

Migrating Your Database to the Cloud? | @CloudExpo #API #Cloud

Migrating Your Database to the Cloud? Look Beyond MySQL Companies are migrating infrastructure to the cloud in order to achieve advantages and agility that they need to remain competitive. However, they may have difficulty achieving one extremely important benefit of cloud computing as they attempt to run their MySQL databases in the cloud - scalability in true utility fashion. Similar to the power utilities we are all familiar with, this entails the ability to get what you need, when you need it and pay for only what you use, even during peak demand. Why switch to the cloud if databases like MySQL limit scalability and performance? It's very simple: the advantages of shedding the headaches of managing one's own machines and reducing operating and capital expenditures are still too great to ignore. However, organizations are in many cases shortchanging themselves by... (more)

The i-Technology Right Stuff

Related Links: Wanted: 19 More of the Top Software People in the World Sung and Unsung i-Technology Heroes Who's Missing from SYS-CON's i-Technology Top Twenty?" Our search for the Twenty Top Software People in the World is nearing completion. In the SYS-CON tradition of empowering readers, we are leaving the final "cut" to you, so here are the top 40 nominations in alphabetical order. Our aim this time round is to whittle this 40 down to our final twenty, not (yet) to arrange those twenty in any order of preference. All you need to do to vote is to go to the Further Details page of any nominee you'd like to see end up in the top half of the poll when we close voting on Christmas Eve, December 24, and cast your vote or votes. To access the Further Details of each nominee just click on their name. Happy voting!   In alphabetical order the nominees are:   Tim Berner... (more)

Book Review: Expert T-SQL Window Functions in SQL Server | @CloudExpo #API #Cloud #TSQL #SQLServer

There is an old saying that good things come in small packages. This saying definitely applies to this book, which focuses in on a set of functions that most people are not aware of that are available in SQL Server. To start off with we need to answer the following question: What are T-SQL Window functions? These functions have nothing to do with the Microsoft Windows API. They are in essence a way to create a window into your data as you process each line in a query. Their strength lies in the ease with which you can solve tricky queries. The authors also point out that these functions don't add any new functionality per se as you could create the queries the old way; however, in general the functions are much more efficient. One very neat capability of these functions is to allow you to include non-aggregated columns in an aggregated query, which is a big limitatio... (more)

This Is How Amazon’s Servers Rarely Go Down [Infographic]

Amazon Web Services (AWS), Amazon’s best-in-class cloud services offering, had downtime of only 2.5 hours in 2015. You may think their uptime of 99.9997 percent had something to do with an engineering team of hundreds, a budget of billions, or dozens of data centers across the globe—but you’d be wrong. Amazon’s website, video, and music offerings, and even AWS itself, all leverage multiple AWS products to get five nines of availability, and those are the same products we get to use as consumers. With some clever engineering and good service decisions, anyone can get uptime numbers close to Amazon’s for only a fraction of the cost. But before we discuss specific techniques to keep your site constantly available, we need to accept a difficult reality: Downtime is inevitable. Even Google was offline in 2015, and if the single largest website can’t get 100 percent upti... (more)

Deploying at Scale: Chef, Puppet, Ansible, Fabric and SaltStack

The manageability, reliability and powerful technology of remote servers — cloud computing — allows IT managers to deploy hundreds, even thousands of machines. At the same time, the cloud creates a new challenge for sys admins and ops teams: how to maintain and configure all these machines. How do you apply patches, maintain updates and fix security gaps? The answer is to use powerful tools like Chef, Puppet, Ansible, Fabric or SaltStack for managing Infrastructure As Code (IaC) automation. IaC means deploying and managing infrastructure for computing, including virtual servers and bare-metal servers. Definition files are used instead of physical hardware management. Here is a bit of the history, background, advantages and disadvantages for each of these infrastructure configuration management tools currently on the market. Puppet Puppet was founded in 2005 by Luke ... (more)

Apple Shares ‘Home’ App Ad on Refreshed ‘Home’ Webpage

Apple  debuted an ad for its Home app on the Home app webpage on its site, showing off what users can with the HomeKit ecosystem. The ad is not yet on Apple’s YouTube page, and is only available on Apple’s website. (adsbygoogle = window.adsbygoogle || []).push({}); The ad depicts a woman who uses the Home app to get through the day. When she wakes up, she tells Siri good morning, prompting Siri to tell the woman that her home is ready for the day, turning on the lights and opening the window shades. She then opens the Home app and clicks on the “Breakfast Time” scene, which turns on her coffee maker via an iHome SmartPlug and adjusts the temperature via a Honeywell smart thermostat. Once she’s ready for the day, she leaves home and clicks the “Lock Up” scene in the Home app, which turns everything in her house off and locks the door. Hours later, she returns home and... (more)

Dynatrace makes life easy for OpenStack admins (EAP starting)

We’re thrilled to announce the Early Access Program for Dynatrace OpenStack integration! This blog post is the first in a two-part series that explores how Dynatrace supports the monitoring of OpenStack environments. OpenStack has become quite popular in recent years. Organizations are increasingly opting to build public and private OpenStack cloud environments for their employees and customers. One reason for the rapid adoption of OpenStack is its vibrant user community, which has fueled OpenStack’s growth and spirit of innovation. By joining the OpenStack community you can contribute your ideas related to requirements definition as well as development. This gives you the power to actively shape the features of the next OpenStack release. OpenStack is indeed powerful, but it’s also complex. As an OpenStack admin, you know perfectly well that there’s no such thing a... (more)

QuickBooks & Microsoft Dynamics CRM now on AppSource

Excited to announce that we are live on Microsoft AppSource for Microsoft Dynamics CRM & QuickBooks. Check us out at Microsoft AppSource DBSync – QuickBooks and Microsoft Dynamics CRM Also do checkout our supported integrations for Microsoft Dynamics with many other applications like Dynamics GP, NAV, Sage and popular Databases like SQL Server, Oracle, mySQL, Azure ... (more)

Cogito Graph Database Solution Takes SOA Approach to Java-Based and .NET Environments

Cogito has announced the availability of its graph database and data analysis solution that allows organizations to quickly query and view massive amounts of data and associated relationships improving data analysis, situation intelligence and process understanding. The Cogito Knowledge Center has at its core a graph database that, by storing information as graphical nodes and their respective relationships as arcs, provides a powerful way for organizations to overcome the challenges of recursive queries, long wait times and complicated SQL programming required to analyze data with more traditional database technology. By seamlessly interfacing to Oracle, DB2, SQL Server and MySQL, the Cogito Knowledge Center provides a complement to existing data management strategies and offers intelligence and security organizations, life sciences companies, manufacturing plants an... (more)

More stupid PHP tricks

(LinuxWorld) -- If you follow the latest security bulletins, you noticed someone discovered a huge security hole in the PHP-based weblog software PHP-Nuke. I mention this because I've been learning PHP the hard way by modifying the PHP-Nuke source code, since my two non-profit sites VarLinux.org and Petreley.org are based on PHP-Nuke. I used the 4.4.1a version of the source code, but it looks to me like the security hole may still exist in the latest version. The problem exists in the admin.php file. This part of the program authenticates you as an administrator before it lets you run most privileged functions. There's a snippet of code outside of the security check that lets you upload a file. If you're clever enough to form the proper URL, you can trick PHP-Nuke into uploading its own PHP-Nuke configuration file as a text file. Then you can view the text file to... (more)