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

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)

Docker Log Management & Enrichment

Over the last several months we’ve made all kinds of improvements to Sematext Docker Agent (SDA).  If you’re not familiar with SDA yet, here it is in a nutshell Sematext Docker Agent is a modern, open-source, Docker-native monitoring and log collection agent. It runs as a tiny container on each Docker host and provides automatic collection and processing of Docker Metrics, Events and Logs for all cluster nodes and all auto-discovered containers. It works with Kubernetes, Mesos, Docker Swarm, Docker Datacenter, Docker Cloud, as well as Amazon EC2, RancherOS, and CoreOS. By default SDA collects all logs from all containers, but we’ve recently added LOGSENE_ENABLED_DEFAULT, a new flat that lets you control if log collection should be enabled by default or not. When set to false,  SDA will collect logs only from containers labelled with a LOGSENE_TOKEN=more)

Set up custom process groups for monitoring

Within large, dynamic environments, the number of processes running on your hosts can become overwhelming. For this reason, Dynatrace only monitors process group types that are considered to be important. Valuable process group types that Dynatrace reports on by default include: Java application server (for example, Tomcat, WebSphere, WebLogic, Glassfish, and JBoss) All other Java applications All .NET applications Databases (for example, MS SQL, Oracle, MySQL, and Cassandra) Additional technologies (for example, Node.js and PHP) Web servers (for example, Apache and IIS) Processes that have an open TCP listening port or for which CPU/memory usage or network traffic exceeds 5% within 3 samples taken within 5 minutes Monitor custom process groups To monitor a process group that doesn’t meet any of the criteria above, you can define a custom process group to be monitore... (more)

Improve IT alert management

Reduce IT alert noise and improve productivity In IT Ops, monitors send alerts when thresholds are passed. Unfortunately, these thresholds are responsible for much of the excessive noise. In fact, organizations waste an average of $1.27 million every year responding to the noise of false alerts. Today, it’s no longer enough to simply get alerts. Ops teams get far too many of them already. In fact, the steady stream of alerts is training Ops to ignore them. Ops teams need to learn better Incident alert management. The goal of this blog is to highlight ways to eliminate noise from monitoring and as a result, enhance the effectiveness of your alerting. By following these practices, you will ensure that you effectively manage your critical events. Use Analytics to Learn Normal Behavior Effective alerting means effective monitoring. It means you are alerting on the righ... (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)

Data Platforms as a Service | @CloudExpo @Pythian #SQL #Azure #AWS #AI

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)

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)

Oracle+MySQL Opponents Take to the Barricades

MySQL Journal on Ulitzer Monty Widenius, the creator of the MySQL open source database – which is apparently all that stands between Oracle and its acquisition of Sun – thinks that Oracle shouldn’t have his baby and that the European Commission – whose investigation into MySQL has put the Oracle-Sun merger in limbo – should force Oracle to spit it out to another company. Oracle CEO Larry Ellison, a guy with a collector’s temperament not given to letting things that belong to him go, has said he wants to keep MySQL and has claimed to be watching Sun’s revenue plunge by $100 million a month while he waits for the EC to finish its probe, a exercise that could take well into January. MySQL isn’t supposed to be why Larry shocked everybody and offered $7.4 billion for poor down-on-its-heels Sun back on April 20. Sticking it to IBM was probably something he relished and wi... (more)

Amazon Scales MySQL for Heavy Traffic

Amazon Web Services (AWS) has added Read Replicas to its Relational Database Service (RDS) to make it easier to scale MySQL deployments to meet the performance demands of high-traffic web applications. Read Replicas lets users create one or more copies of a MySQL Database Instance and an application serve read traffic from the multiple replicas. They can create or delete replicas in minutes using the point-and-click interface of the AWS Management Console. Amazon says Read Replicas can be made to another Availability Zone as a disaster-ready failover measure under its Multi-AZ deployments program. Once a Read Replica is created, any subsequent updates to the source will automatically be replicated in the Read Replica. And Read Replicas can be elastically added to any RDS database deployment to keep query response times fast, even as request volumes scale. Amazon fi... (more)

Sun To Cut 3,000 Jobs, Blames EC

Mergers & Acquisitions on Ulitzer Sun said late Tuesday that it will be forced to cut 3,000 jobs worldwide over the next 12 months because of “the delay in the closing of the acquisition of the company,” laying the blame squarely at the doorstep of the European Commission and its prolonged investigation into whether Oracle should be allowed to acquire the Sun-owned MySQL open source database. It could be playing hardball with the EC, which some think has an interim deadline this week to decide how much longer its investigation is going to take. It could take until we’re deep into January. In an SEC filing Sun said its board had approved the plan “to better align the company’s resources with its strategic business objectives.” Sun expects to incur total charges of $75 - 125 million over the next several quarters, most likely the December and March quarters, in connectio... (more)

Using Ext JS, Servlets, JSON, MySQL and Tomcat on Fedora

Java Developer Magazine on Ulitzer These days the popularity of Ext JS (a JavaScript library) is gaining momentum. One of the most popular widgets within Ext JS is the DataGrid. The reason - displaying data from a database is one of the most common tasks of a web application. "Out of the box" the DataGrid has functionality (for instance, ascending or descending sorting and reordering of columns by dragging it) that otherwise would require some effort from developers. Another attractive feature of the DataGrid is that it can use JSON (JavaScript Object Notation), which allows you to reduce traffic in comparison with full Swing HTML or XML formatting on the server. Examples from Ext JS site [1] and Ext JS books such as Learning Ext JS.Packt Publishing [2] are focused on PHP in conjunction with Ext JS. However, what if your organization already uses servlets for web a... (more)