Showing entries 1 to 10 of 48
10 Older Entries »
Displaying posts with tag: Developer (reset)
Slow MySQL Start Time in GTID mode? Binary Log File Size May Be The Issue

Have you been experiencing slow MySQL startup times in GTID mode? We recently ran into this issue on one of our MySQL hosting deployments and set out to solve the problem. In this blog, we break down the issue that could be slowing down your MySQL restart times, how to debug for your deployment, and what you can do to decrease your start time and improve your understanding of GTID-based replication.

How We Found The Problem

We were investigating slow MySQL startup times on a low-end, disk-based MySQL 5.7.21 deployment which had GTID mode enabled. The system was part of a master-slave pair and was under a moderate write load. When restarting during a scheduled …

[Read more]
MySQL High Availability Framework Explained – Part I

In this two-part blog series, we will explain the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semisynchronous replication and the Corosync plus Pacemaker stack. In Part I, we’ll walk you through the basics of High Availability, the components of an HA framework, and then introduce you to the HA framework for MySQL.

What is High Availability?

The availability of a computer system is the percentage of time its services are up during a period of time. It’s generally expressed as a series of 9′s. For example, the table below shows availability and the corresponding downtime measured over one year.

Availability %
[Read more]
The Future Of The Application Stack

Containers are eating the world. If you have built and deployed an application in production over the last few years, the odds are that you have deployed your code in containers. You might have created and deployed individual containers (Docker, Linux LXC, etc.) directly in the beginning, but quickly switched over to a container orchestration technology like Kubernetes (K8s) or Swarm when you needed to coordinate multi-node deployments and high availability (HA). In this container-driven world, what will the future of the application stack look like? Let’s start with what we need from this “future” application stack.

What Do We Need From This Future Application Stack?

  1. Cloud Agnostic

    We …

[Read more]
Configuring and Managing SSL On Your MySQL Server

In this blog post, we review some of the important aspects of configuring and managing SSL in MySQL hosting. These would include the default configuration, disabling SSL, and enabling and enforcing SSL on a MySQL server. Our observations are based on the community version of MySQL 5.7.21.

Default SSL Configuration in MySQL

By default, MySQL server always installs and enables SSL configuration. However, it is not enforced that clients connect using SSL. Clients can choose to connect with or without SSL as the server allows both types of connections. Let’s see how to verify this default behavior of MySQL server.

When SSL is installed and enabled on MySQL server by default, we will typically see the following:

  1. Presence of *.pem files in the MySQL data directory. These are the various client and server certificates and keys that are in …
[Read more]
Data Integrity and Performance Considerations in MySQL Semisynchronous Replication

MySQL semisynchronous replication provides improved data integrity because when a commit returns successfully, it’s known that the data exists in at least two places – the master and its slave. In this blog post, we review some of the MySQL hosting configurations that influence the data integrity and performance aspects of semisynchronous replication. We’ll be using InnoDB storage engine and GTID-based replication in a 3-node replica set (master and 2 slaves), which will ensure there is redundancy in the slaves. This means that if there are issues with one slave, we can fall back on the other.

Configurations Applicable to Both Master and Slave Nodes

[Read more]
Career as a Python Programmer Freelancing Jobs in Upwork Linkedin

In this episode, we are going to discuss about some statistics and data about freelancing and jobs based on Python programmer and python developer worldwide. Python is one of the most popular programming language in the market. We will first discuss about Python related jobs in Upwork.com then we will discuss about the jobs in Linkedin.com.



Summary of my discussion:

To start career in Python based work one need to know additional technology besides Python programming language like:

  1. How to Web Scrap
  2. Bash Shell scripting
  3. Elastic Search
  4. Hadoop
  5. Django [ For Web Application ]
  6. JavaScript [ For Web Applicatin]
  7. Data Structure
  8. Git
  9. MySQL or PostgreSQL
  10. Redis [ Server Side Cache ]
  11. Kafka

Recommended Beginner Python Books:

Python Crash Course :

[Read more]
Calculating InnoDB Buffer Pool Size for your MySQL Server

What is an InnoDB Buffer Pool?

InnoDB buffer pool is the memory space that holds many in-memory data structures of InnoDB, buffers, caches, indexes and even row-data. innodb_buffer_pool_size is the MySQL configuration parameter that specifies the amount of memory allocated to the InnoDB buffer pool by MySQL. This is one of the most important settings in the MySQL configuration and should be configured based on the available system RAM.

In this post, we’ll walk you through two approaches of setting your InnoDB buffer pool size value, examine the pros and cons of those practices, and also propose a unique method to arrive at an optimum value based on the size of …

[Read more]
How Cronofy built the Zendesk Calendar Connector

Originally Posted by Adam Bird

There needed to be a better way for agents in Zendesk to track the tasks that had been assigned them. Using the Cronofy calendar API we created an app that keeps those assignments synchronized with the agent’s calendar.

This post shares our learnings from interacting with the Zendesk API, hopefully to help you with your own Zendesk project.

The Ruby source code for our integration is also available.

When a Ticket is a Task

Tickets are the core entity in the Zendesk domain. Tasks are just Tickets of type : ‘task’. This gives them an additional attribute due_at.

We also need to track the status of the ticket to know when it’s …

[Read more]
Save Time and Effort on MySQL With Stored Routines.

Stored routines give you the ability to create a statement in one application (MySQL) that can be used in multiple client applications that use different programming languages or work on different platforms.

Take the MySQL for Developers course to learn more about stored routines and other key topics. This will build your expertise as a MySQL Developer.

You can take this 5-day instructor-led course as a:

  • Live-Virtual Event: Attend a live-event from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.
[Read more]
We’re Hiring! And Looking to Add More 9s to the Severalnines Team!

August 15, 2014 By Severalnines

 

 

We're looking for an energetic and talented web developer to join our small but agile web team. This position is full-time and pay is negotiable. The hours are flexible and work can be done remotely.

 

Severalnines is a self-funded startup with a dozen employees; headquartered in Stockholm, Sweden and with a globally distributed, home-office based team. We provide automation and management software for database clusters. Our ClusterControl product is the leading management application for database clusters and is used by thousands of companies.

 

We were founded in 2010 and launched our product that same year, so you’ll be …

[Read more]
Showing entries 1 to 10 of 48
10 Older Entries »