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

The Porticor Agent enables you to encrypt disks on your server, using Porticor’s highly secure key management technology. The Agent connects to a key management appliance – a Porticor virtual machine deployed in your cloud account, which is responsible to safeguard your master key so that you do not have to trust anybody else with your keys, not even Porticor. The Agent is provisioned with an API key, which allows it to access its own managed crypto keys, but not the master key. All disk encryption takes place locally on the server that runs the Agent, and the disk-encryption keys are split between the key management appliance and the Porticor Virtual Key Management (PVKM) service. Installing the Agent Download the agent from this link (for Debian/Ubuntu) or this link (for RHEL, CentOS or Amazon Linux). Install the package on your application server: On Ubuntu, run ... (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)

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)

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)

Will Sun Microsystems Survive until 2018?

Normal 0 false false false MicrosoftInternetExplorer4 st1\:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:"טבלה רגילה"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} I will start my post by quoting Garner Group's Magic Quadrant for Application Infrastructure for Back-End Application Integration Projects 2Q07 first Caution on Sun Microsystems: "Sun's sales force was ill-prepared for the SeeBeyond acquisition, which significantly hurt SeeBeyond's momentum. The sales force has been trained, but Sun must rebuild momentum in a market where ... (more)

Data Platforms as a Service | @CloudExpo @Pythian #API #Azure #BigData

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)

RocksDB from Facebook By @JnanDash | @ThingsExpo #IoT

I attended a HIVE-sponsored Meetup yesterday evening titled, “Rocking the database world with RocksDB”. Since I had never heard of RocksDB, I was curious to learn how it is rocking the database world. Facebook built this key value store storage layer originally to use for MySQL (instead of InnoDB), as MySQL is used heavily at Facebook. They claim that was not the only motivation. Then in 2013, they decided to open source RocksDB. Last evening’s speaker in an earlier post on November, 2013 had said, “Storing and accessing hundreds of petabytes of data is a huge challenge, and we’re constantly improving and overhauling our tools to make this as fast and efficient as possible. Today, we are open-sourcing RocksDB, an embeddable, persistent key-value store for fast storage that we built and use here at Facebook.” RocksDB is also ideal for SSD (Flash store) and claims fas... (more)

Five Big Data Features in SQL Server

Traditional RDBMS & New Data Processing Over the past two decades relational databases have been most successful in serving large scale OLTP and OLAP applications across enterprises. However, in the past couple of years with the advent of Big Data processing, especially for processing unstructured data coupled with the need for processing massive quantities of data, made the industry to look into Non RDBMS solutions. This has lead into the popularity of NOSQL databases as well as massively parallel processing frameworks. However the traditional RDBMS were quick to react and added several Big Data features as part of their offering so that the enterprises with a heavy investment of traditional RDBMS can have the best of both worlds by properly leveraging these new features. The following sections provide ideas about Big Data features in the popular SQL Server databa... (more)

The 451 Group Reports on Open Source Activity

Open source software is driving "a number of interesting deals," according to analyst company The 451 Group in its Q1 2006 look at mergers and acquisitions in the technology industry. The firm, based in New York with offices in Boston, San Francisco, and London, said that M&A activity rose 67 percent overall comparable to Q1 2005, with the telco sector accounting for more than three quarters of all activity. Yet open source stood out as well, with deals by Cisco, Oracle, Yahoo, and Google drawing the most attention. The report also outlined some so-called "cradle robbing" by Yahoo and Google, which made deals of very young companies such as Flickr. The 451 Group's report includes the enormous, $67 billion purchase SBC/AT&T's BellSouth purchase. But back on planet Earth, it also pointed to Oracle's acquisition of SleepyCat (which 451 valued at $60 million). The report ... (more)

Limits of Open Source SOA Testing Tools

In this article, we will discuss the limits of adopting an Open Source SOA testing tool for SOA and Web Services projects. Open Source has become an essential and popular resources for many tools and platforms used in SOA deployments. From operating systems such as Linux, to databases such as MySQL, and browsers such as Firefox, Open Source has a proven track record for cost-effective Jason Macynoreply@blogger.com2 ... (more)

Is MySQL Doomed to Extinction?

MySQL on Ulitzer What if all that tap dancing, posturing, bargaining and political in-fighting Oracle had to do to get clearance to pick up MySQL along with Sun Microsystems was an utter waste of time and money. What if MySQL was suddenly shown to be one of Mr. Darwin's fabled evolutionary dead ends. Clustrix, a 30-man San Francisco start-up that just broke cover, thinks it was born and bred to replace MySQL with a more viable, genetically superior built-from-the-ground-up product that can do what MySQL's not very good at and that's scale into the billions of the entries. There's no MySQL DNA in the Clustrix product, only MySQL emulation. But, in a move that could impede MySQL's longevity with the checkbook set, it interoperates with the MySQL protocol so applications don't have to be ported. The widgetry is cast as the first clustered database system for Internet-... (more)