youtube/vitess

General discussion about Vitess

Sugu Sougoumarane

@sougou

@klausenbusk Vitess allows you to plug in your custom sharding rules. There are a couple of users that have gone that route. Can you message me your email addres? I can send you a slack invite, which is where all the action is.

Kristian Klausen

@klausenbusk

@sougou I'm just reading on stuff for fun right now, currently we are using Galera which I think can handle the load for at least a decent amount of time. I just wanted to hear, so I have this in mind when it hopeful get relevant :)

Sugu Sougoumarane

@sougou

@klausenbusk sounds good

michi-covalent

@michi-covalent

hello. is there a maven repo for 2.0 client? i couldn't find it here: https://github.com/youtube/mvn-repo/tree/master/snapshots/com/youtube/vitess

Sugu Sougoumarane

@sougou

@michi-covalent We're in the process of cleaning up the java client. We plan to publish one soon after that. Until then, you'll have to build your own.

michi-covalent

@michi-covalent

sounds good. thank you for your quick reply!

Fabián Carvajal

@FCA_IMCL_twitter

Hello!! Who's it going? good? ok, I've started with vitess but I've not could have a correct installation :-( Some of you could help me?

Sugu Sougoumarane

@sougou

Hi there, the vitess community uses a slack channel. Can you PM me your email? I can send you an invite.

Fabián Carvajal

@FCA_IMCL_twitter

sure. My personal email is fabiancarvajalacolt@gmail.com thanks

Sugu Sougoumarane

@sougou

invite sent

Fabián Carvajal

@FCA_IMCL_twitter

excelent

valamorgon

@valamorgon

Using vites in the beginning of an app considered a bad move? Should I start with just mysql and then switch to vitess if I need to scale?

Sugu Sougoumarane

@sougou

@valamorgon Using vitess at the beginning would be the best way. Then you don't have to migrate.

If you PM me your email, I can send you a slack invite, which is where all the action is.

RaunoVV

@RaunoVV

Hey, a question: is there any progress with integration with mesos? Asking cause we use mees atm and looking to ways how to scale mysql containers..

Sugu Sougoumarane

@sougou

@RaunoVV BetterCloud runs vitess on Mesos. So, I believe it should work for you also. They are on the slack channel. Let me know if you need an invite.

RaunoVV

@RaunoVV

Okay cool, invite would be nice. Probably need to ask further information

@sougou

Sugu Sougoumarane

@sougou

Can you PM me your email address?

RaunoVV

@RaunoVV

Sure

Ricardo Maraschini

@ricardomaraschini

hi guys! i have followed the howto and got vitess to work on kubernetes. i also successfully sharded the database and now i have two slices -80 and 80-, looking great. my problem is, when i try to connect to the vtgate using golang i am receiving the following message: paramsSelectScatter: No partition found for tabletType unknown in keyspace test_keyspace. the code i am using is here: https://pastebin.com/dBFFMTq5

btw, i have also tried @master as tabletType, that is not the issue

harshit-gangal

@harshit-gangal

@ricardomaraschini Have you applied vschema for that keyspace using vtctl command?

Ricardo Maraschini

@ricardomaraschini

Let me double check

harshit-gangal

@harshit-gangal

you can check on vtgate ui

/debug/vschema

Ricardo Maraschini

@ricardomaraschini

Cool, I will check that and return here in 30

Thanks for the hint

Ricardo Maraschini

@ricardomaraschini

as far as i could see it appears to be correct, no?

{
 "test_keyspace": {
  "sharded": true,
  "tables": {
   "messages": {
    "name": "messages",
    "column_vindexes": [
     {
      "column": "page",
      "type": "hash",
      "name": "hash",
      "vindex": {}
     }
    ],
    "ordered": [
     {
      "column": "page",
      "type": "hash",
      "name": "hash",
      "vindex": {}
     }
    ]
   }
  }
 }
}

Ricardo Maraschini

@ricardomaraschini

On the vtgate logs i can see the following message:

E0606 13:41:38.266115      11 vtgate.go:1012] Execute: paramsSelectScatter: No partition found for tabletType unknown in keyspace test_keyspace, request: map[BindVariables:map[] KeyspaceShard: TabletType:
unknown Session: NotInTransaction:false Options:<nil> Sql:select * from messages]

Ricardo Maraschini

@ricardomaraschini

I managed to connect. I had to checkout the branch release-2.1 of the repo github.com/youtube/vitess and slightly change the code to also include the keyspace as a parameter when calling vitessdriver.Open(). was this expected?

this is the resulting code

https://pastebin.com/t0RX7B3q

Sugu Sougoumarane

@sougou

@ricardomaraschini that vschema looks incorrect

And congrats on getting vitess to shard :)

can you PM me your email address? I can send you a slack invite.

For building a vschema, I've made a video: https://youtu.be/71nTBafPtcM

but tablet type unknown is not related to vschema (i think)

we'll need to see where the @master info is getting lost

Sugu Sougoumarane

@sougou

@ricardomaraschini i've sent you a slack invite

Ricardo Maraschini

@ricardomaraschini

@sougou even though it seems incorrect apparently the guestbook sample app is sharding. Strange. Also, using the branch 2.1 I could connect and do all the queries normally. Even more strange :smile: I will enter on slack, thanks for the invitation

Sugu Sougoumarane

@sougou

@ricardomaraschini i think the vschema is still loading fine. the real problem is somewhere else. we'll need to troubleshoot

akash jarad

@akashjarad

Hi, Can you invite me to the slack channel please.

Sugu Sougoumarane

@sougou

@akashjarad can you send me your email address?

@akashjarad nvm found it. invite sent.

Lilrex2015

@Lilrex2015

Hi all

is this the channel for YouTube API ?

Lilrex2015

@Lilrex2015

Hello, is anyone here?

Samuel Williams

@sw7240614

Where communities thrive

People

Repo info

Activity