Showing entries 1 to 10 of 1056
10 Older Entries »
Displaying posts with tag: Uncategorized (reset)
Oracle’s “Always Free” Cloud Instance – Adding a web server to your free MySQL compute instance with zero monthly charges

In a previous post, I explained how you can take advantage of Oracle’s “Always Free” Cloud instance to obtain a free Oracle Cloud compute instance (virtual machine) and install a copy of MySQL – without having to pay a setup fee and without incurring any monthly charges. And, you can have two free compute instances per account.

This free Cloud option from Oracle is great. I can think of a lot of ways to utilize a free Oracle Cloud compute instance – but the first one that came to …

[Read more]
Installing MySQL on Oracle Cloud’s “Always Free” Compute Instance

At Oracle’s OpenWorld 2019, Oracle announced an Oracle Cloud Free Tier, which includes Oracle Cloud services that will always be free – as long as you use them or keep them active.

Most other hyperscale cloud vendors offer a free 12-month trial before they start charging you, so to see Oracle provide a “truly free” service is really great. And the free services are not just limited to one or two choices – you get a wide variety of free services to choose from. As of this blog post, here is a brief summary of free services (these are subject to change in the future):

Databases – Your choice of Autonomous Transaction Processing …

[Read more]
The Slow Software Movement

Those who build SaaS know that you’re actually providing an experience. You’re building long-term relationships and aiming for recurring revenue. Therefore, your product must be flexible, resilient, and consistent.

Many companies find it hard to take time, acquire the right ingredients, and design truly great software from the bottom-up. This is understandable given how fast the SaaS industry moves.

But firstly, who am I to be talking about this subject? My education was in Economics and Complex Systems, and I’ve been fortunate to gain exposure to various IT trends and tools working almost a decade mostly in Tech. I started interviewing customers at Continuent (majority SaaS) over five years ago, and I have listened to a number of …

[Read more]
MySQL Document Store – a quick-guide to storing JSON documents in MySQL using JavaScript and Python (and even SQL!)

MySQL introduced a JSON data type in version 5.7, and expanded the functionality in version 8.0.

Besides being able to store native JSON in MySQL, you can also use MySQL as a document store (doc store) to store JSON documents. And, you can use NoSQL CRUD (create, read, update and …

[Read more]
NoSQL + SQL = MySQL 8; Keynote OSI2019

NoSQL + SQL = Mysql 8 Open Source India 2019 keynote from Sanjay Manwani

Slides from the keynote presented at Open Source India 2019 at Nimhans convention center Bangalore. As usual lots of interesting folks. Lots of focus on Open Source.

Met people from the SODA foundation who are trying to standardize the IO layer across all cloud implementations. All the best guys.

Also met folks from MOSIP who have an effort ongoing to help countries create their own UID. Seems like they already have some traction.

Also met an interesting person trying to think about Indian design and creativity in software. After Chumbak it does make sense to think about how not only UI but the software development …

[Read more]
Setting up a High Availability for PMM

We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard. PMM has many advantages

  • Easy to deploy (docker based)
  • Flexible
  • Customizable
  • Query Analytics
  • One-stop solution for MySQL,Mongo,ProxySQL & PostgresSQL
  • Orchestrator
  • Rich and Deep metrics stats

Highly recommended for any production deployments its equivalent to Enterprise-grade monitoring and graphing tool.

Recently we have been working for our client on MySQL Consulting to scale peak sale of the year. Wherein we have deployed PMM to view the performance …

[Read more]
MySQL Workbench 8.0.18 has been released

Dear MySQL users,

The MySQL developer tools team announces 8.0.18 as our General Availability
(GA) for MySQL Workbench 8.0.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152

The release is now available in source and binary form for a number of
platforms from our download pages at:

http://dev.mysql.com/downloads/tools/workbench/

Enjoy!

How free is your Open Source software…really?

With growing development and support costs as well as the need to maintain a sustainable business, it became apparent that maintaining the OSS release of Tungsten Replicator (TR) just wasn’t viable. Earlier this year we decided to close it down, instead focusing our efforts on improving and developing its commercial release whilst also growing our flagship commercial product, Tungsten Clustering.

For many businesses, Open Source Software (OSS) is still a very viable solution in many use cases, and I’m sure it will continue to be so for a long time, but I wanted to explore whether an OSS solution really is as free as the $0 price tag suggests.  In this blog I explore just that..

The hidden costs of OSS

Over the last few weeks I stumbled …

[Read more]
Save Space on MySQL data with Column Compression

                                   Recently, One of our client reached our Remote DBA team with a requirement to reduce the size of the table as it is having many text columns with huge number of records. At preliminary check , I have validated the table size and its row format, as it was  in compressed  format already. 

Later I checked on other possibilities to compress the text columns further, At that time, then I came across per-column compression feature in Percona MySQL server (From 5.7.17-11) which features individual column compression and we were using …

[Read more]
Session Variables

In MySQL and Oracle, you set a session variable quite differently. That means you should expect there differences between setting a session variable in Postgres. This blog post lets you see how to set them in all three databases. I’m always curious what people think but I’m willing to bet that MySQL is the simplest approach. Postgres is a bit more complex because you must use a function call, but Oracle is the most complex.

The difference between MySQL and Postgres is an “@” symbol versus a current_setting() function call. Oracle is more complex because it involves the mechanics in Oracle’s sqlplus shell, SQL dialect, and PL/SQL language (required to assign a value to a variable).

MySQL

MySQL lets you declare a session variable in one step and use it one way in a SQL statement or stored procedure.

  1. You set a session variable on a single line with the following …
[Read more]
Showing entries 1 to 10 of 1056
10 Older Entries »