ClickHouse Consulting and Support from MinervaDB
What is ClickHouse ?
ClickHouse (https://clickhouse.yandex) is an open source columnar database management system built for web-scale, real-time streaming data analytics using SQL queries, developed by Russian internet company Yandex (https://www.yandex.com) . ClickHouse is capable for delivering optimal, horizontally scalable, fault tolerant and highly available data analytics solutions for planet-scale internet / mobile properties and Internet of Things (IoT) . Modern hardware efficient ClickHouse columnar storage format allows fitting more hot data in RAM, which leads to a shorter response times. MinervaDB provides ClickHouse Consulting and Support (24*7) to deliver optimal, scalable and highly available web-scale data analytics platforms. You can download ClickHouse Consulting and Support flyer PDF and also available on SlideShare
☛ Quick facts on ClickHouse
- Open source columnar database system from Yandex.
- Built for Massively Parallel Processing Systems , Large / complex queries can be run in parallel with minimal or no effort, The modern hardware infrastructure ready !
- Data compression – ClickHouse support data compression and this improves query performance.
- Horizontally scalable columnar database system – ClickHouse is built for web-scale data analytics, Data can be replicated across several ClickHouse Shards. ClickHouse is distributed database analytics ready columnar database system.
- In ClickHouse, data is not just stored by columns, but is also processed by vectors to achieve high CPU performance.
- Web-Scale data analytics ready – Primary keys are allowed, The data extraction for specific clients through Metrica counter over a specific time range makes low latency query analytics possible.
- Flexible aggregation – Aggregate functions for partial data with approximated calculation (minimal data retrieval option). Random keys aggregation instead of all keys for higher accuracy using minimal resources.
- Maximum availability and self healing – Asynchronous multi-master replication with auto failover capabilities.
- SQL based – ClickHouse supports SQL, JOINS, subqueries including FROM, IN, JOIN clauses; and scalar subqueries are allowed . Correlated subqueries are not allowed.
☛ ClickHouse repositories and downloads
Github:
- https://github.com/Yandex/ClickHouse
- https://github.com/Yandex/clickhouse-jdbc
- https://github.com/Yandex/clickhouse-odbc
Server Packages:
- Debian/Ubuntu: http://repo.yandex.ru/clickhouse/
- RPMs: https://packagecloud.io/altinity/clickhouse
- Docker: https://hub.docker.com/r/yandex/clickhouse-server/
Client Packages:
- https://hub.docker.com/r/yandex/clickhouse-client/
- JDBC: https://mvnrepository.com/artifact/ru.yandex.clickhouse/clickhouse-jdbc
- ODBC: https://github.com/yandex/clickhouse-odbc/releases
☛ How MinervaDB can help you in building an web-scale real-time streaming data analytics using ClickHouse ?
- Consulting – We are experts in building optimal, scalable (horizontally and vertically), highly available and fault tolerant ClickHouse powered streaming data analytics platforms for planet-scale internet / mobile properties and Internet of Things (IoT) . Our elite-class consultants work very closely with your business and technology teams to build custom columnar database analytics solutions using ClickHouse.
- Database Architect services – We architect, engineer and deploy data analytics platform for you. We will take care of your data analytics ecosystem so that you can focus on business.
- ClickHouse Enterprise Support – We have 24*7 enterprise-class support available for ClickHouse, Our support team will review and deliver guidance for your data analytics platforms architecture, SQL engineering, performance optimization, scalability, high availability and reliability.
- ClickHouse Training.
- Pay only for hours we have worked for you, This makes us affordable for startups and large corporations equally.
☛ ClickHouse Consulting Plans (we do both on-site and remote ClickHouse consulting)
If you are building an web-scale columnar database systems analytics and your business demands on-site ClickHouse consultants, We are available on short notice. We work very closely with your team on-site guiding them both strategically and technically on building optimal, scalable and highly available ClickHouse database infrastructure operations.
| On-Site ClickHouse Consulting | Rate ( plus GST / Goods and Services Tax where relevant ) |
|---|---|
| Per-Diem | US $350 / hour |
We can do almost everything remote on ClickHouse, This include performance, scalability and high availability . Our technical account manager will be working very closely with your team to understand the goals and build short / long-term deliverables managing MinervaDB ClickHouse Consultants.
| Remote ClickHouse Consulting | Rate ( plus GST / Goods and Services Tax where relevant ) |
|---|---|
| Per Diem | US $250 / hour |
If you are a startup, We have flexible consulting options available:
| Avg. Hours / Month | Quarterly ( plus GST / Goods and Services Tax where relevant ) | Six-Monthly ( plus GST / Goods and Services Tax where relevant ) | Annually ( plus GST / Goods and Services Tax where relevant ) |
|---|---|---|---|
| 4 | US $2,100.00 | US $4,200.00 | US $8,400.00 |
| 8 | US $3,360.00 | US $6,720.00 | US $13,440.00 |
| 12 | US $3,780.00 | US $7,560.00 | US $15,120.00 |
| 16 | US $4,200.00 | US $8,400.00 | US $16,800.00 |
| 20 | US $4,900.00 | US $9,800.00 | US $19,600.00 |
| 24 | US $7,000.00 | US $14,000.00 | US $24,500.00 |
| 28 | US $9,100.00 | US $18,200.00 | US $28,000.00 |
| 32 | US $10,500.00 | US $21,000.00 | US $31,500.00 |
| 36 | US $14,000.00 | US $28,000.00 | US $42,000.00 |
| 40 | US $17,500.00 | US $34,500.00 | US $49,000.00 |
☛ ClickHouse Enterprise Support (24*7)
You get access to our seasoned ClickHouse support team 24*7 for an fraction of cost to hiring a full-time Sr. level ClickHouse consultant . We will help you in building an planet-scale data analytics platform using ClickHouse which is optimal, scalable and highly available.
- Enterprise-Class ClickHouse Support
- Technical Account Manager to clearly understand your business goals and orchestrate our support operations.
- 30 Minute Response Time on Severity 1 (Urgent) Issues.
- 10 Named Customer Contacts.
- Support channels – Phone, Email, Slack, Skype, Google Hangouts and Phone.
- Technical support — 30 minute response time (S1)
- Support -levels – We have very well defined support infrastructure operations function:
- Severity 1– Immediate attention needed, The customer’s business is severely impacted and database infrastructure is unavailable.
- Response time (SLA) – 30 minutes.
- Severity 2– Customer database infrastructure is available (up and running) but performance / scalability issues are directly impacting business.
- Response time (SLA) – 12 hours.
- Severity 3– Low impact situation, Customer business and production infrastructure is functioning normally, but the problem is impacting the development ecosystems, also causing delay in production deployment.
- Response time (SLA) – 24 hours.
- Severity 4– Low to no impact situation, It is more about knowing the features and capability of components before considering the adoption.
- Response time (SLA) – 48 hours.
- Severity 1– Immediate attention needed, The customer’s business is severely impacted and database infrastructure is unavailable.
- Support -levels – We have very well defined support infrastructure operations function:
- MinervaDB Support Email (Only for MinervaDB Support Customers) – support@minervadb.zohodesk.com
- Submit your tickets online here
- DBA Support
- Recommendations for database architecture and design.
- Recommendations for optimal SQL engineering.
- Recommendations for ClickHouse Performance optimization and tuning.
- Recommendation for index design, optimization and usage.
- Recommendations for ClickHouse backup and disaster recovery.
- Recommendations for ClickHouse high availability and auto failover.
- Recommendations for ClickHouse data archiving and partitioning.
- Recommendations for ClickHouse maintenance operations.
| MinervaDB ClickHouse Enterprise Support | Rate ( plus GST / Goods and Services Tax where relevant ) |
|---|---|
| Unlimited ClickHouse Instances | US $25,000 / Year |
☛ Rates, We expect prompt payment from customers to deliver elite-class consulting and support services
- The default payment term for every invoice from MinervaDB is on or before 30 days, although other terms can be arranged for in our contract. You will pay invoices promptly, or we may choose to not do further business with you. Yes, we do that, as happy and healthy business relationships are important to us.
- MinervaDB Flexible Consulting plans, Remote DBA packages and Enterprise-Class 24*7 support subscriptions are payable in advance, this so we can make sure we have the resources available to assist you. In return for this commitment, you pay a lower hourly rate.
☛ Discounts
Discounts are applicable only for multi-year contracts / long-term engagements, We don’t hire low-quality and cheap rookie consultants to manage your mission-critical Database Systems Infrastructure Operations and so our consultants are expensive. Being a virtual corporation (no offices anywhere in the world), whatever you pay go directly to our consultant’s fee. It’s impossible for us to offer you low-cost consulting, support and remote DBA services with elite-class team, Thanks for understanding and doing business with MinervaDB.
☛ Partial list of customers – What we did for them ?
- Garmin – ClickHouse Consulting and Enterprise-Class Support
- ClassPlus – ClickHouse Enterprise-Class Support
- Morgan Stanley – ClickHouse Enterprise-Class Support
- Blue Dart – ClickHouse Consulting / Professional Services and Enterprise-Class Consultative Support
- Carlsberg – ClickHouse Enterprise-Class Support
- PRADA – ClickHouse Consulting and Managed Database Services
- Netflix – ClickHouse Enterprise-Class Support
- MPL – ClickHouse Enterprise-Class Support
- Burberry – ClickHouse Enterprise-Class Support
- Edward Jones – ClickHouse Consulting and Enterprise-Class Support
- Cambridge Investment Research – ClickHouse Consulting and Enterprise-Class Support
- National Geographic – ClickHouse Consulting and Enterprise-Class Support
- American Express Travel – ClickHouse Consulting and Enterprise-Class Support
- Sony – ClickHouse Consultative Support and Managed Services
- Nintendo – ClickHouse Consultative Support and Managed Services
- Unilever – ClickHouse Consultative Support
- VISA – ClickHouse Consultative Support and Database Architect Services for Big Data Analytics
☛ MinervaDB Inc. Bank Account Details – Silicon Valley Bank
For the customers based out of U.S.
Instruct the paying financial institution or the payor to route all domestic wire transfers via FEDWIRE to the following ABA number:
| Bank Details | MinervaDB Inc. Bank Account Details for U.S. Customers |
|---|---|
| To | SIL VLY BK SJ 3003 TASMAN DRIVE, SANTA CLARA, CA 95054 |
| ROUTING & TRANSIT # | 121140399 |
| FOR CREDIT OF {Account Name} | MinervaDB Inc. |
| CREDIT ACCOUNT # | 3303503907 |
| BY ORDER OF | NAME OF THE SENDER |
For the international customers ( non U.S. based customers )
Instruct the paying financial institution to advise their U.S. correspondent to pay as follows:
| Bank Details | MinervaDB Inc. Bank Account Details for International Customers ( outside U.S.) |
|---|---|
| PAY TO | SILICON VALLEY BANK 3003 TASMAN DRIVE, SANTA CLARA, CA 95054, USA |
| ROUTING & TRANSIT # | 121140399 |
| FOR CREDIT OF {ACCOUNT NAME} | MinervaDB Inc. |
FINAL CREDIT ACCOUNT # | 3303503907 |
| BY ORDER OF | NAME OF THE SENDER |
IMPORTANT: Wire instructions MUST designate your FULL TEN-DIGIT ACCOUNT NUMBER. Wires received by Silicon Valley Bank with INCOMPLETE or INVALID ACCOUNT NUMBERS may be delayed and could possibly require return to the sending bank due to new regulations.
☛ MinervaDB Inc. Bank Account Details – Mercury Bank
For the customers based out of U.S.
| Bank Details | MinervaDB Inc. Bank Account Details for U.S. Customers |
|---|---|
| Bank name | Evolve Bank & Trust |
| Beneficiary Name | MinervaDB |
| Type of Account | Checking |
| Account Number | 9800891942 |
| ABA Routing Number | 084106768 |
| Bank Address | 6070 Poplar Ave, Suite 200 Memphis, TN 38119 |
For the international customers ( non U.S. based customers )
| Bank Details | MinervaDB Inc. Bank Account Details for International Customers ( outside U.S.) |
|---|---|
| Receiving Bank Details ( SWIFT / BIC code ) Remove the trailing XXX if you are asked for an 8-digit code | FRNAUS44XXX |
| Bank Name | First National Bankers Bank |
| Bank Address | 7813 Office Park Blvd Baton Rouge, LA, 70809 USA |
| Beneficiary ( IBAN / Account number ) | 084106768 |
| Beneficiary Name | Evolve Bank & Trust |
| Beneficiary Address | 6070 Poplar Ave, Suite 200 Memphis, TN 38119 USA |
| Important! Include this memo in the field for originator to beneficiary information (OBI) / further credit / special instructions: | For: MinervaDB account 9800891942 at Evolve Bank & Trust |
☛ MinervaDB contacts – Sales & General Inquiries
| Business Function | Contact |
|---|---|
| ☎ CONTACT GLOBAL SALES (24*7) | 📞 (844) 588-7287 (USA) 📞 (415) 212-6625 (USA) 📞 (778) 770-5251 (Canada) |
| ☎ TOLL FREE PHONE (24*7) | 📞 (844) 588-7287 |
| 🚩 MINERVADB FAX | +1 (209) 314-2364 |
| 📨 MinervaDB Email - General / Sales / Consulting | contact@minervadb.com |
| 📨 MinervaDB Email - Support | support@minervadb.com |
| 📨 MinervaDB Email -Remote DBA | remotedba@minervadb.com |
| 📨 Shiv Iyer Email - Founder and Principal | shiv@minervadb.com |
| 🏠 CORPORATE ADDRESS: CALIFORNIA | MinervaDB Inc., 340 S LEMON AVE #9718 WALNUT 91789 CA, US |
| 🏠 CORPORATE ADDRESS: DELAWARE | MinervaDB Inc., PO Box 2093 PHILADELPHIA PIKE #3339 CLAYMONT, DE 19703 |
| 🏠 CORPORATE ADDRESS: HOUSTON | MinervaDB Inc., 1321 Upland Dr. PMB 19322, Houston, TX, 77043, US |
To engage MinervaDB for ClickHouse consulting, support and training, please book for an appointment here or send email to contact@minervadb.com
P.S. If you are a MinervaDB 24*7 Enterprise-Class Support Customer, You can submit support tickets by sending email to support@minervadb.zohodesk.com or submit tickets online – https://minervadb.com/index.php/clickhouse-consulting-and-support-by-minervadb/ticketing-system-for-clickhouse-support/
