Nov
20
2018
--

Our 3 favorite startups from Morgan Stanley’s 2nd Multicultural Innovation Lab Demo Day 

The Morgan Stanley Multicultural Innovation LabMorgan Stanley’s in-house accelerator focused on companies founded by multicultural and female entrepreneurs, hosted its second Annual Showcase and Demo Day. The event also featured companies from accelerators HearstLab, Newark Venture Partner Labs and PS27 Ventures. (Note: I was formerly employed by Morgan Stanley and have no financial ties.)

The showcase represented the culmination of the program’s second year, which followed an initial five-company class that has already seen two acquisitions. Through the six-month program, Morgan Stanley provides early-stage companies with a wide range of benefits, including an equity investment from Morgan Stanley, office space at Morgan Stanley headquarters, access to Morgan Stanley’s extensive network and others. Applications are now open for its third cohort of companies, with the application window closing on January 4th, 2019.

The 16 presenting startups, all led by a female or multicultural founder, offered solutions to structural inefficiencies across a wide array of categories, including fintech, developer tools and health. Though all of the companies offered impressive presentations and strong value propositions, here are three of the companies that stood out to us.

Hatch Apps

In hopes of democratizing software and app development, Hatch Apps provides a platform that allows users and companies to build iOS, Android and web applications without any code through pre-built templates and custom plug-and-play functions. In essence, Hatch Apps provides a solution for application building similar to what Squarespace or Wix provide for websites.

In the modern economy, every company is in one way or another a tech or tech-enabled company. Now the demand for strong engineers has made the fight for talent increasingly competitive and has made engineering quite costly, even when only needed for simple tasks. 

For an implementation and subscription fee, Hatch Apps allows companies with less sophisticated engineering DNA to reduce entering costs by launching native apps on their own, across platforms and often on faster timelines than those seen through third-party developers. Once an app is launched, Hatch Apps provides customers with detailed analytics and allows them to send targeted push notifications, export data and make in-app changes that can automatically go live in app stores.

The company initially took a bootstrapping approach to financing and raised funds by selling a 2016 election-themed “Cards Against Humanity”-style game created on the platform. Since then, Hatch Apps has already received funding from the Y Combinator Fellowship, Morgan Stanley and a number of other investors.

FreeWill

While estate planning is a topic many don’t like to think about, it’s a critical issue for managing cross-generational wealth. But will drafting can often be very complex, time-consuming and costly, requiring hours of legal consultation and coordination between various parties.

Founded by two former classmates at Stanford Business School, FreeWill looks to simplify the estate-planning process by providing a free online platform that automates will drafting, in a similar function to what TurboTax does for taxes. Using FreeWill, users can quickly set allocations for their estate and select personal recipients, charitable donations, executor specifications and other ancillary requests. The platform then creates a finalized legal document that is legally valid in all 50 states, to which users can also quickly make changes and replace without incurring expensive legal costs.

FreeWill is able to provide the platform to consumers for free due to the proceeds it receives from its nonprofit customers, who pay to be featured on the platform as a partner organization. FreeWill offers a compelling value proposition for partnering companies. By acting as a channel to funnel user donations to listed organizations, FreeWill has been able to drive a 600 percent increase in charitable giving to partner organizations on average. FreeWill also provides partner organizations with backing analytics that allow nonprofits to track bequests and donors through monthly reports. 

FreeWill currently boasts an impressive roster of 75 paying nonprofit partners that include American Red Cross, Amnesty International and many others. In the long-run it hopes to be the go-to solution for financial and legal end-of-life planning for investment advisors, life insurance and employee benefits providers.

Shoobs

Shoobs is looking to be the go-to platform for local “urban” events, which the company defined as events centered on local nightlife, comedy and concerts in the hip-hop, R&B and reggae genres to name a few. But unlike the genre-agnostic, transaction-focused event management platforms that can make the space seem pretty crowded, Shoobs focused on providing genre-specific even discovery. Shoobs matches urban event goers with artists of their choice and related smaller-scale events that can be harder to discover, acting as a form of curation, quality control and discovery.

For event organizers, Shoobs helps provide digital ticketing and promotion services, with event recommendation capabilities that target the most promising potential customers. Through its offering to event organizers, Shoobs is able to monetize its services through ticket sale commission, advertising and brand partnerships.

Since its initial launch in London, Shoobs notes it has become one of the top urban events platforms in the city, with an extensive base of recurring registered users and event organizers. After previously working with AEG for its London launch, Shoobs is looking to expand stateside with the help of organizers like Live Nation. Shoobs joins a long list of promising Y Combinator alumni companies with YC also acting as one of Shoobs’ initial investors.

Other presenting companies included:

Morgan Stanley Multicultural Innovation Lab

  • BeautyLynk “is an on-demand hair and makeup service provider, specializing in customizable services for women.”
  • Broadway Roulette “is an events marketplace that pairs consumers with surprise cultural events, beginning with Broadway theater.”
  • CariClub “is an enterprise software platform to connect young professionals with nonprofit opportunities.”
  • COI Energy Services “is an integrated platform for electric utilities and business users to optimize and manage energy usage.”
  • CoSign “is an API and application that allows anyone to create, distribute and monetize visual content.”
  • Goalsetter “is a goals-based gifting, savings and investing platform designed for children.”
  • myLAB Box “offers customizable at-home health-test kits and relevant telemedicine consultations / prescription services.”

HearstLab

  • Priori “is a global legal marketplace changing the way in-house teams find, hire and manage outside counsel.”
  • TRENCH “is an online fashion marketplace that makes use of the unworn items in every woman’s closet.”

Newark Venture Partners Labs

  • Floss Bar “is a new type of preventive brand for oral health care. The company offers high-quality, routine dental care across flexible locations at thoughtful prices.”
  • Upsider “is a software solution allowing recruiters to leverage AI technology to identify a comprehensive set of candidates who align with their business and role requirements, resulting in a more strategic understanding of the best possible talent for the job.”

PS27 Ventures

  • BlueWave Technologies “is a cleantech company and the creators of the BlueWave™ Cleaning System — a water-free, detergent-free and chemical-free plasma device that cleans items that are extremely hard or impossible to clean with a washer and dryer.”
  • OnPay Solutions “focuses exclusively on business-to-business payments. They create payment software and offer payment web services to enhance efficiency and productivity for Accounts Payable and Accounts Receivable.”

Oct
08
2018
--

WeWork taps Lemonade to offer insurance to WeLive members

WeWork has partnered with Lemonade to provide renters insurance to WeLive members.

WeLive is the residential offering from WeWork, offering members a fully-furnished apartment, complete with amenities like housekeeping, mailroom, and on-site laundry, on a flexible rental schedule. In other words, bicoastal workers or generally nomadic individuals can rent a short-term living space without worrying about all the extras.

As part of that package, WeLive is now referring new and existing WeLive members to Lemonade for renters insurance.

WeLive currently has two locations — one in New York and one in D.C. — collectively representing more than 400 units. WeWork says that both units are nearly at capacity. The company has plans to open a third location in Seattle Washington by Spring 2020.

Lemonade, meanwhile, is an up-and-coming insurance startup that is rethinking the centuries-old industry. The company’s first big innovation was the digitization of getting insurance. The company uses a chatbot to lead prospective customers through the process in under a minute.

The second piece of Lemoande’s strategy is rooted in the business model. Unlike incumbent insurance providers, Lemonade takes its profit up-front, raking away a percentage of customers’ monthly payments. The rest, however, is set aside to fulfill claims. Whatever goes unclaimed at the end of the year is donated to the charity of each customer’s choice.

To date, Lemonade has raised a total of $180 million. WeWork, on the other hand, has raised just over $9 billion, with a reported valuation as high as $35 billion.

Of course, part of the reason for that lofty valuation is the fact that WeWork is a real estate behemoth, with Re/Code reporting that the company is Manhattan’s second biggest private office tenant. But beyond sheer square footage, WeWork has spent the past few years filling its arsenal with various service providers for its services store.

With 175,000 members (as of end of 2017, so that number is likely much higher now), WeWork has a considerable userbase with which it can negotiate deals with service providers, from enterprise software makers to… well, insurance providers.

Lemonade is likely just the beginning of WeWork’s stretch into developing a suite of services and partnerships for its residential members.

Sep
14
2018
--

PostgreSQL Webinar Wed Oct 10th – Enterprise-Grade PostgreSQL: Built on Open Source Tools

Enterprise PostgreSQL built with open source tools

PostgreSQL® logoPlease join Percona’s PostgreSQL Support Technical Lead,  Avinash Vallarapu; Senior Support Engineer, Fernando Laudares; and Senior Support Engineer, Jobin Augustine, on Wednesday, October 10th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4), as they demonstrate an enterprise-grade PostgreSQL® environment built using a combination of open source tools and extensions.

“We built our application on top of PostgreSQL. It works great but only now that we took it to the market and it became a hit we realize how much it relies on the database. How can we “harden” PostgreSQL? How can we make the solution we built around PostgreSQL enterprise-grade?”

“I migrated from a proprietary database software to PostgreSQL. I am curious to know whether I can get the same features I used to have in the proprietary database software.”

You’ll find the answer to these questions and more in a series of blog posts we will be publishing on this topic, which will be followed by a live demo we planned for our webinar on October 10th, 2018.

The market coined the term “enterprise grade” or “enterprise ready” to differentiate products and service offerings for licensed database software. For example: there may be a standard database software or an entry-level package that delivers the core functionality and basic features. Likewise, there may be an enterprise version, a more advanced package which goes beyond the essentials to include features and tools indispensable for running critical solutions in production. With such a differentiation found in commercial software, we may wonder whether a solution built on top of an open source database like PostgreSQL can satisfy all the enterprise requirements.

It starts with building a secured PostgreSQL environment, tuning the database for the production workload, building a high availability strategy that avoids single-point-of-failures, scaling PostgreSQL using connection poolers to avoid excessive usage of server resources, and finally load balancing the reads between master and all the available standby servers aka replicas to effectively use the computing power of all the database servers.

The operational aspect of maintaining an enterprise grade PostgreSQL database also includes the methods to configure a backup strategy that helps us achieve point-in-time-recovery as needed, detailed logging and monitoring PostgreSQL along with a real-time analysis of the database performance and finally maintaining the database health with optimal performance, such as making sure vacuuming is working as it should and at the right times.

“Can we build such an enterprise grade solution that satisfies all the above requirements around PostgreSQL with open source softwares only?”

Yes, we can. During the 20+ years PostgreSQL has been around, the open source community has created all sorts of complementary extensions and tools that can be used to build an enterprise grade solution with postgres.

We’ll be following this post with a series of posts covering each piece of such solution, culminating with a webinar that will take place on October 10th. During the webinar we’ll showcase the full project. Here’s the list of topics we are going to consider while building our enterprise grade PostgreSQL server.

  1. Securing your PostgreSQL database cluster
  2. High Availability
  3. Preparing a Backup strategy and the tools available to achieve it
  4. Scaling PostgreSQL using connection poolers and load balancers
  5. Tools/extensions available for your daily DBA life and detailed logging in PostgreSQL.
  6. Monitoring your PostgreSQL and real-time analysis.

Join us to see it in action!

The post PostgreSQL Webinar Wed Oct 10th – Enterprise-Grade PostgreSQL: Built on Open Source Tools appeared first on Percona Database Performance Blog.

Aug
28
2018
--

Webinar Wed 8/29: Databases in the Hosted Cloud

databases-in-the-cloud

databases-in-the-cloudPlease join Percona’s Chief Evangelist, Colin Charles on Wednesday, August 29th, 2018, as he presents Databases in the Hosted Cloud at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4).

 

Nearly everyone today uses some form of database in the hosted cloud. You can use hosted MySQL, MariaDB, Percona Server, and PostgreSQL in several cloud providers as a database as a service (DBaaS).

In this webinar, Colin Charles explores how to efficiently deploy a cloud database configured for optimal performance, with a particular focus on MySQL.

You’ll learn the differences between the various public cloud offerings for Amazon RDS including Aurora, Google Cloud SQL, Rackspace OpenStack DBaaS, Microsoft Azure, and Alibaba Cloud, as well as the access methods and the level of control you have. Hosting in the cloud can be a challenge but after today’s webinar, we’ll make sure you walk away with a better understanding of how you can leverage the cloud for your business needs.

Topics include:

  • Backup strategies
  • Planning multiple data centers for availability
  • Where to host your application
  • How to get the most performance out of the solution
  • Cost
  • Monitoring
  • Moving from one DBaaS to another
  • Moving from a DBaaS to your own hosted platform

Register Now.

The post Webinar Wed 8/29: Databases in the Hosted Cloud appeared first on Percona Database Performance Blog.

Aug
14
2018
--

Open Source Database Community Blog: The Story So Far

open source database community blog

open source database community blogRecently, we initiated a new project, the Open Source Database Community Blog. One way to think of this is as an online, year round version of the Percona Live conferences. If you have a story to tell, an experience to share, or a lesson to be learned send it along. As long as it’s related to open source database software, their management and application. That’s right. Not just Percona software. Any open source database software of all formats.

Unlike Percona Live, though, we are not limited by time or space. All submissions are welcome as long as they follow some simple guidelines.

We have already had some excellent posts, and in case this is news to you, here’s a recap:

You can also read Jean-François’s personal blog (unsolicited, but greatly appreciated) on how the process of getting his post up and running went.

About the posts … and what’s in it for you

All of the writers are giving freely of their time and knowledge. So .. if you would just like to read some alternative independent viewpoints, try the blog. If you want to support the writers with constructive exchanges and comments, that would be great.

If you would like to go a little further and provide some feedback about what you’d like to see via our blog poll, that would be awesome. As a community blog, we want to make sure it hits community interests.

You can also drop me a line if there are things that I’ve missed from the poll.

Also, you should know I have the English covered but I am not a technical expert. We don’t want—not would I get—Percona techs to edit or review these blog posts. That’s not the point of the blog!

So, would you consider being a technical editor maybe? Not for all posts, since many of the writers will want to ‘own’ their content. But there could be some new writers who’d appreciate some back up from a senior tech before going ‘live’ with their posts. Might that tech buddy be you?

There’s some more ideas and I have written more about our vision for the blog here.

If you are tempted to write for this, please get in touch, I would love to hear from you. You do not have to be an expert! Content suitable for all levels of experience is welcome.

The post Open Source Database Community Blog: The Story So Far appeared first on Percona Database Performance Blog.

Jul
18
2018
--

Webinar Wed 7/18: MariaDB 10.3 vs. MySQL 8.0

MariaDB 10.3 vs MySQL 8.0

MariaDB 10.3 vs MySQL 8.0Please join Percona’s Chief Evangelist, Colin Charles as he presents as he presents MariaDB 10.3 vs. MySQL 8.0 on Wednesday, July 18th, 2018, at 9:00 AM PDT (UTC-7) / 12:00 PM EDT (UTC-4).

 

Technical considerations

Are they syntactically similar? Where do these two databases differ? Why would I use one over the other?

MariaDB 10.3 is on the path of gradually diverging from MySQL 8.0. One obvious example is the internal data dictionary currently under development for MySQL 8.0. This is a major change to the way metadata is stored and used within the server, and MariaDB doesn’t have an equivalent feature. Implementing this feature could mark the end of datafile-level compatibility between MySQL and MariaDB.

Non-technical considerations

There are also non-technical differences between MySQL 8.0 and MariaDB 10.3, including:

Licensing: MySQL offers their code as open-source under the GPL, and provides the option of non-GPL commercial distribution in the form of MySQL Enterprise. MariaDB can only use the GPL, because their work is derived from the MySQL source code under the terms of that license.

Support services: Oracle provides technical support, training, certification and consulting for MySQL, while MariaDB has their own support services. Some people will prefer working with smaller companies, as traditionally it affords them more leverage as a customer.

Community contributions: MariaDB touts the fact that they accept more community contributions than Oracle. Part of the reason for this disparity is that developers like to contribute features, bug fixes and other code without a lot of paperwork overhead (and they complain about the Oracle Contributor Agreement). However, MariaDB has its own MariaDB Contributor Agreement — which more or less serves the same purpose.

Colin will take a look at some of the differences between MariaDB 10.3 and MySQL 8.0 and help answer some of the common questions our Database Performance Experts get about the two databases.

Register Now

The post Webinar Wed 7/18: MariaDB 10.3 vs. MySQL 8.0 appeared first on Percona Database Performance Blog.

May
23
2018
--

Meet the speakers at The Europas, and get your ticket free (July 3, London)

Excited to announce that this year’s The Europas Unconference & Awards is shaping up! Our half day Unconference kicks off on 3 July, 2018 at The Brewery in the heart of London’s “Tech City” area, followed by our startup awards dinner and fantastic party and celebration of European startups!

The event is run in partnership with TechCrunch, the official media partner. Attendees, nominees and winners will get deep discounts to TechCrunch Disrupt in Berlin, later this year.
The Europas Awards are based on voting by expert judges and the industry itself. But key to the daytime is all the speakers and invited guests. There’s no “off-limits speaker room” at The Europas, so attendees can mingle easily with VIPs and speakers.

What exactly is an Unconference? We’re dispensing with the lectures and going straight to the deep-dives, where you’ll get a front row seat with Europe’s leading investors, founders and thought leaders to discuss and debate the most urgent issues, challenges and opportunities. Up close and personal! And, crucially, a few feet away from handing over a business card. The Unconference is focused into zones including AI, Fintech, Mobility, Startups, Society, and Enterprise and Crypto / Blockchain.

We’ve confirmed 10 new speakers including:


Eileen Burbidge, Passion Capital


Carlos Eduardo Espinal, Seedcamp


Richard Muirhead, Fabric Ventures


Sitar Teli, Connect Ventures


Nancy Fechnay, Blockchain Technologist + Angel


George McDonaugh, KR1


Candice Lo, Blossom Capital


Scott Sage, Crane Venture Partners


Andrei Brasoveanu, Accel


Tina Baker, Jag Shaw Baker

How To Get Your Ticket For FREE

We’d love for you to ask your friends to join us at The Europas – and we’ve got a special way to thank you for sharing.

Your friend will enjoy a 15% discount off the price of their ticket with your code, and you’ll get 15% off the price of YOUR ticket.

That’s right, we will refund you 15% off the cost of your ticket automatically when your friend purchases a Europas ticket.

So you can grab tickets here.

Vote for your Favourite Startups

Public Voting is still humming along. Please remember to vote for your favourite startups!

Awards by category:

Hottest Media/Entertainment Startup

Hottest E-commerce/Retail Startup

Hottest Education Startup

Hottest Startup Accelerator

Hottest Marketing/AdTech Startup

Hottest Games Startup

Hottest Mobile Startup

Hottest FinTech Startup

Hottest Enterprise, SaaS or B2B Startup

Hottest Hardware Startup

Hottest Platform Economy / Marketplace

Hottest Health Startup

Hottest Cyber Security Startup

Hottest Travel Startup

Hottest Internet of Things Startup

Hottest Technology Innovation

Hottest FashionTech Startup

Hottest Tech For Good

Hottest A.I. Startup

Fastest Rising Startup Of The Year

Hottest GreenTech Startup of The Year

Hottest Startup Founders

Hottest CEO of the Year

Best Angel/Seed Investor of the Year

Hottest VC Investor of the Year

Hottest Blockchain/Crypto Startup Founder(s)

Hottest Blockchain Protocol Project

Hottest Blockchain DApp

Hottest Corporate Blockchain Project

Hottest Blockchain Investor

Hottest Blockchain ICO (Europe)

Hottest Financial Crypto Project

Hottest Blockchain for Good Project

Hottest Blockchain Identity Project

Hall Of Fame Award – Awarded to a long-term player in Europe

The Europas Grand Prix Award (to be decided from winners)

The Awards celebrates the most forward thinking and innovative tech & blockchain startups across over some 30+ categories.

Startups can apply for an award or be nominated by anyone, including our judges. It is free to enter or be nominated.

What is The Europas?

Instead of thousands and thousands of people, think of a great summer event with 1,000 of the most interesting and useful people in the industry, including key investors and leading entrepreneurs.

• No secret VIP rooms, which means you get to interact with the Speakers

• Key Founders and investors speaking; featured attendees invited to just network

• Expert speeches, discussions, and Q&A directly from the main stage

• Intimate “breakout” sessions with key players on vertical topics

• The opportunity to meet almost everyone in those small groups, super-charging your networking

• Journalists from major tech titles, newspapers and business broadcasters

• A parallel Founders-only track geared towards fund-raising and hyper-networking

• A stunning awards dinner and party which honors both the hottest startups and the leading lights in the European startup scene

• All on one day to maximise your time in London. And it’s PROBABLY sunny!

europas8

That’s just the beginning. There’s more to come…

europas13

Interested in sponsoring the Europas or hosting a table at the awards? Or purchasing a table for 10 or 12 guest or a half table for 5 guests? Get in touch with:
Petra Johansson
Petra@theeuropas.com
Phone: +44 (0) 20 3239 9325

May
08
2018
--

BotChain wants to put bot-to-bot communication on the blockchain

Increasingly we are going to be having bots conducting business on a company’s behalf. As that happens, it is going to require a trust mechanism to ensure that bot-to-bot communication is legitimate. BotChain, a new startup out of Boston wants to be the blockchain for registering bots.

The new blockchain, which is built on Ethereum, is designed to register and identify bots and provide a way for companies to collaborate between bots with auditing capabilities built in. BotChain has the potential to become a standard way of sharing data between bots in a trusted way.

The idea is to have an official and sanctioned place for companies to register their bots securely. As the organization describes it, “BotChain offers bot developers, enterprises, software companies, and system integrators the critical systems, standards, and means to validate, certify, and manage the millions of bots and billions of transactions powered by AI.

Photo: allanswart

The company was created by the team at Talla, a bot startup in Cambridge, but the goal is to open this up to much larger community of partners and expand. In fact, early partners include Gupshup, a platform for developers and Howdy.ai, B2B enterprise bot developers along with Polly, CareerLark, Disco (formerly Growbot), Zoom.ai, and Botkeeper.

BotChain is the brainchild of Rob May, who is CEO at Talla. He was formerly co-founder and CEO at Backupify, which was sold to Datto in 2014. He recognized that as bot usage increases, there needed to be a system in place to help companies using bots to exchange information, and eventually even digital currencies to complete transactions in a fully digital context.

May believes that blockchain is the best solution to build this trust mechanism because of the ledger’s nature as an immutable and irrefutable record. If the entities on the blockchain agree to work with one another, and the other members allow it, there should be an element of confidence inherent in that.

He points to other advantages such as being decentralized so that no single company can control the data on the blockchain, and of course nobody can erase a record once it’s been written to the chain. It also provides a way for bots to identify one another in an official way and for participating companies to track transactions between bots.

Talla opened this up to a community of users because it wants BotChain to be a standard way for bots to exchange information. Whether that happens or not remains to be seen, but these types of projects could be important building blocks as companies look for ways to conduct business confidently, even when there are no humans involved.

BotChain has raised $5 million USD in a private token sale to institutional investors such as Galaxy Digital, Pillar, Glasswing and Avalon, according to the company.

In addition, they will be conducting another token pre-sale starting this Friday to raise additional funds from community stakeholders. “This token sale is a way to give [our community] access. Purchasing these tokens allows users to start registering their assets and create chains of immutable records of what their machines have done,” May explained. He said the company expects to sell about $20 million worth of tokens this year.

You can learn more about Botchain from this video:

Oct
24
2017
--

Community Matters

Community Matters

Community MattersBuilding on community

Percona is very committed to open source database software. We think of ourselves as unbiased champions of open source database solutions. With that, we also carry a responsibility to the open source database community – whether MySQL®, MongoDB®, ProxySQL or other open source database technology. We’ve seen that, and taken action by hiring a Community Manager.

That’s me. Which is great… For me!

And my job, in a nutshell, is to help to make our community great for you. By building on the good stuff that’s been done in the past and finding ways to do more.

The common thread tying the community together is the sharing of information, experience, and knowledge. Hundreds of you have taken part in Percona Live or Percona Live Europe — thank you for that! Props if you’ve done both. If you’ve proposed a paper (selected or not), presented a session, given a tutorial, staffed a booth or sponsored the event – kudos!

Maybe you’ve benefited from or run sessions at a Percona University (the next one is in Kiev in November and it’s FREE). Or caught up with Percona staff at one of the many tech conferences we attend during the year.

You might have used our code, added to our code, spotted and logged bugs, given feedback or requested new features. Helped out other users in forums, written to question-and-answer sites like Stack Overflow. Maybe you’ve blogged about using Percona software on your own blog, or looked for help on the Percona Database Performance Blog. You might have recommended our software to your company, or a colleague, or a client or a friend. Or even a stranger. Mentioned us in passing in conversation. Read our e-books, watched our webinars, shared a link or reached out to Percona via social media.

All excellent, valuable and much-appreciated contributions to the community.

Ways you can join in

Have a think about these opportunities to shine, share and make the Percona community best-in-class.

  • Take part in our forum: we really try to keep up, but there are always more questions than we can address. It’s easy to think of the forums as a support queue but honestly, we are MORE than delighted when we have help from you.
  • You have a passion for a particular subject, or maybe an interesting project to share. How about proposing a webinar or blog post? Contact me if you are interested.
  • If you haven’t yet done it, make 2018 the year you attend Percona Live. If you’ve done it before, do it again – network with old friends and make some new ones. Get a new t-Shirt. Enjoy the company. The warmth of the welcome and the generosity of the knowledge shared made a big impression on me in Dublin, I’m convinced you’ll find the same.
  • In-depth knowledge or hardcore learning on-the-job? Don’t forget that the call for papers for Percona Live is opening soon and that speakers get free attendance at the conference. It’s a competitive call, but you’re up for that right? Right! 
  • Don’t want to “do stuff” on the Percona site? Maybe contributing to code or working on the question-and-answer sites is more for you. Or maybe you have a blog already and write about our software and how to use it. If so – thanks again, and please let me have the link!
  • If you haven’t already, don’t forget to subscribe to our newsletters to get early warning of upcoming webinars, and the latest tech and community news

Have you thought about joining Percona? We’re hiring! Don’t forget, too, that all the contributions you make to online communities – Percona or not – really pay off when you want to demonstrate your knowledge and commitment to future employers or clients. A link is worth a thousand words.

What do you think?

Interested? Ideas or comments? Things you think we should do better? Things that you think are great? Things we used to do that were great and you miss? Things that others do and you wished we did? Things that … well, you get the idea!

Get in touch, or just get stuck in. You might find it rewarding*…

free to email me or message me on Skype.

*I have keys to the swag box … ?

Mar
30
2016
--

Docker MySQL Replication 101

Docker

Precona Server DockerIn this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent years as a lightweight alternative to virtualization. It is ideal for building virtual development and testing environments. The solution is flexible and seamlessly integrates with popular CI tools.

 

This post walks through the setup of MySQL replication with Docker using Percona Server 5.6 images. To keep things simple we’ll configure a pair of instances and override only the most important variables for replication. You can add whatever other variables you want to override in the configuration files for each instance.

Note: the configuration described here is suitable for development or testing. We’ve also used the operating system repository packages; for the latest version use the official Docker images. The steps described can be used to setup more slaves if required, as long as each slave has a different server-id.

First, install Docker and pull the Percona images (this will take some time and is only executed once):

# Docker install for Debian / Ubuntu
apt-get install docker.io
# Docker install for Red Hat / CentOS (requires EPEL repo)
yum install epel-release # If not installed already
yum install docker-io
# Pull docker repos
docker pull percona

Now create locally persisted directories for the:

  1. Instance configuration
  2. Data files
# Create local data directories
mkdir -p /opt/Docker/masterdb/data /opt/Docker/slavedb/data
# Create local my.cnf directories
mkdir -p /opt/Docker/masterdb/cnf /opt/Docker/slavedb/cnf
### Create configuration files for master and slave
vi /opt/Docker/masterdb/cnf/config-file.cnf
# Config Settings:
[mysqld]
server-id=1
binlog_format=ROW
log-bin
vi /opt/Docker/slavedb/cnf/config-file.cnf
# Config Settings:
[mysqld]
server-id=2

Great, now we’re ready start our instances and configure replication. Launch the master node, configure the replication user and get the initial replication co-ordinates:

# Launch master instance
docker run --name masterdb -v /opt/Docker/masterdb/cnf:/etc/mysql/conf.d -v /opt/Docker/masterdb/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=mysecretpass -d percona:5.6
00a0231fb689d27afad2753e4350192bebc19ab4ff733c07da9c20ca4169759e
# Create replication user
docker exec -ti masterdb 'mysql' -uroot -pmysecretpass -vvv -e"GRANT REPLICATION SLAVE ON *.* TO repl@'%' IDENTIFIED BY 'slavepass'G"
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
GRANT REPLICATION SLAVE ON *.* TO repl@"%"
--------------
Query OK, 0 rows affected (0.02 sec)
Bye
### Get master status
docker exec -ti masterdb 'mysql' -uroot -pmysecretpass -e"SHOW MASTER STATUSG"
mysql: [Warning] Using a password on the command line interface can be insecure.
*************************** 1. row ***************************
             File: mysqld-bin.000004
         Position: 310
     Binlog_Do_DB:
 Binlog_Ignore_DB:
Executed_Gtid_Set:

If you look carefully at the “docker run” command for masterdb, you’ll notice we’ve defined two paths to share from local storage:

/opt/Docker/masterdb/data:/var/lib/mysql

  • This maps the local “/opt/Docker/masterdb/data” to the masterdb’s container’s “/var/lib/mysql path”
  • All files within the datadir “/var/lib/mysql” persist locally on the host running docker rather than in the container
/opt/Docker/masterdb/cnf:/etc/mysql/conf.d

  • This maps the local “/opt/Docker/masterdb/cnf” directory to the container’s “/etc/mysql/conf.d” path
  • The configuration files for the masterdb instance persist locally as well
  • Remember these files augment or override the file in “/etc/mysql/my.cnf” within the container (i.e., defaults will be used for all other variables)

We’re done setting up the master, so let’s continue with the slave instance. For this instance the “docker run” command also includes the “–link masterdb:mysql” command, which links the slave instance to the master instance for replication.

After starting the instance, set the replication co-ordinates captured in the previous step:

docker run --name slavedb -d -v /opt/Docker/slavedb/cnf:/etc/mysql/conf.d -v /opt/Docker/slavedb/data:/var/lib/mysql --link masterdb:mysql -e MYSQL_ROOT_PASSWORD=mysecretpass -d percona:5.6
eb7141121300c104ccee0b2df018e33d4f7f10bf5d98445ed4a54e1316f41891
docker exec -ti slavedb 'mysql' -uroot -pmysecretpass -e'change master to master_host="mysql",master_user="repl",master_password="slavepass",master_log_file="mysqld-bin.000004",master_log_pos=310;"' -vvv
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
change master to master_host="mysql",master_user="repl",master_password="slavepass",master_log_file="mysqld-bin.000004",master_log_pos=310
--------------
Query OK, 0 rows affected, 2 warnings (0.23 sec)
Bye

Almost ready to go! The last step is to start replication and verify that replication running:

# Start replication
docker exec -ti slavedb 'mysql' -uroot -pmysecretpass -e"START SLAVE;" -vvv
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
START SLAVE
--------------
Query OK, 0 rows affected, 1 warning (0.00 sec)
Bye
# Verify replication is running OK
docker exec -ti slavedb 'mysql' -uroot -pmysecretpass -e"SHOW SLAVE STATUSG" -vvv
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
SHOW SLAVE STATUS
--------------
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: mysql
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysqld-bin.000004
          Read_Master_Log_Pos: 310
               Relay_Log_File: mysqld-relay-bin.000002
                Relay_Log_Pos: 284
        Relay_Master_Log_File: mysqld-bin.000004
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 310
              Relay_Log_Space: 458
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: 230d005a-f1a6-11e5-b546-0242ac110004
             Master_Info_File: /var/lib/mysql/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
1 row in set (0.00 sec)
Bye

Finally, we have a pair of dockerized Percona Server 5.6 master-slave servers replicating!

As mentioned before, this is suitable for a development or testing environment. Before going into production with this configuration, think carefully about the tuning of the “my.cnf” variables and the choice of disks used for the data/binlog directories. It is important to remember that newer versions of Docker recommend using “networks” rather than “linking” for communication between containers.

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com