Podcasts Learning

In this episode we discuss our timeless podcasts. For those who are new and listening for the first time - welcome! This podcast is a great jumping off point to learn about specific topics we've covered. If you have been with us for some or all of the time, thank you for being with us, and we hope this trip down memory lane brings you nostalgia - it did for us.

I thought it was worth a moment to reiterate on the new Performance Schema related defaults that MySQL 5.7.7 brings to the table, for various reasons.

For one, most of you might have noticed that profiling was marked as deprecated in MySQL 5.6.7. So it is expected that you invest into learning more about Performance Schema (and Mark’s sys schema!).

Second, there are lots of virtual environments and appliances out there running Community Edition MySQL where Performance Schema can be a useful tool for analyzing performance. Thus, expect to see more articles about using PERFORMANCE_SCHEMA and SYS_SCHEMA from us!

Third, we have more and more junior readers who might benefit from light reads such as this.

The new defaults that I wanted to highlight are mentioned in the …

A few months ago I updated my profile on LinkedIN, and adjusted my position as CTO and founder of Athoa Ltd, a British company currently active for translation services and events that in the past hosted a couple of interesting open source projects. I simply forgot to disable the email notification to my connections, set by default, and in 2-3 hours I received tens of messages from friends and ex-colleagues who were curious to hear about my new adventure.

Today, I changed my profile on LinkedIN again and have left the email notification set on purpose.

As of today, I join the team at ScaleDB. My role is to define the product and the strategy for the company, working closely with CEO Tom Arthur, CTO …

Providing a suitable High Availability (HA) solution for each database system is one of the challenging tasks for a DBA and here we have to answer some questions like the following ones:

1. What is the cost for that HA solution?
2. Is it required to change the system structure or the DB design to use that HA solution?
3. Is it complicate to understand, use or maintain ?

Choosing the suitable HA solution for each system will depend on the answers of such questions …
In this post, I’m going to write about MySQL Master High Availability MHA as a nice tool which provides HA for MySQL by performing automatic fail-over or fast online master switching with almost no downtime!

Before going through more details about MHA, let’s first answer the previous questions:

1. MHA is a free opensource tool, no cost to …

All of our services (external REST APIs and internal services) are written in Go. Like others, we wanted to factor out repeated code, but found it hard to do without making things messy or hiding the flexibility of the built-in net/http interfaces. After evaluating many “REST frameworks” for Go, we found some that seemed to have good ideas, but nothing that met our needs well enough. Using these as inspiration and drawing on experience with other languages and their frameworks, we created Siesta. We believe it improves on other projects with similar goals, and is worth trying.

Siesta is our third “REST framework;” the others are ugly internal-only failures we will never open source. Siesta is designed to accomplish the following:

• Handle common tasks such as defining and validating inputs, which can be in the URL or query string. These are strongly typed and flexible.
• More sophisticated routing than …

We are excited to announce that VividCortex now supports MongoDB, a flexible and scalable NoSQL database. After announcing PostgreSQL support in January and Redis in April, our brainiacs continue to create a unified solution for diverse systems.

During the beta period, VividCortex’s MongoDB customers were impressed, as Chris Clarke, DevOps engineer at Parse.ly states: “VividCortex’s highly granular data, including detailed information about each query made against our MongoDB clusters, is invaluable. Installation was a breeze, and the system immediately spotted two problematic queries that had evaded all our other monitoring systems.”

Read the …

Performance Schema (PS) has been the subject of many, many recent discussions, presentations, and articles.  After its release in MySQL 5.7, PS has become the main actor for people who want to take the further steps in MySQL monitoring. At the same time, it has become clear that Oracle intends to make PS powerful with so many features and new instrumentation that old-style monitoring will begin to look like obsolete tools from the Stone Age.

This article will explain PS and provide guidance on what needs to be done in order to use it effectively.

What I am not going to do is to dig into specific performance issues or address polemics about what PS is and what, in a Utopian vision, it should be. I have seen too many presentations, articles and comments like this and they are not productive, nor are they in line with my target which is: keep people informed on how to do things EASILY.

For the scope of this …

recheck module path under rediusd.conf or may be it’s an issue with permission or
version mismatch for modules .so files

We’ve added a fullscreen (kiosk) mode to VividCortex, perfect for livestreaming a dashboard to a big monitor on your wall. Fullscreen mode uses native browser functionality to request fullscreen access, so there’s no need to try to hide your tab bar. Simply click the little icon in the top right corner of any screen:

The app will not only go into fullscreen mode but will hide all the “chrome” used for navigation. You will see a minimalistic header that just shows the time interval you’ve selected.

Naturally, you’ll want to start livestreaming before you fullscreen, so your monitor will refresh with updated data continually.

Enjoy!

And remember, VividCortex makes you look smart …

This Log Buffer edition sheds light on the ongoing innovations and updates in the SQL Server, MySQL and Oracle realms.

Oracle:

• Warning: standby redo logs not configured for thread – BUG
• SLOB 2.3 is soon to be released. This version has a lot of new, important features but also a significant amount of tuning in the data loading kit.
• Even in the highly volatile world of JavaScript frameworks, AngularJS is still very clearly leading the pack.
• Are you …