Any way to change cloud sql instance global variable values

[Abhishek Mathur]

Hi,

Is there any way to change the value of global  variables for my cloud sql instance?
I want to change specifically the value of variable "lower_case_table_names" to 1.

Thanks,
Abhishek

[Abhishek Mathur]

I think the SUPER privilege has not been granted to us on our cloud sql instance.
Is it possible that if we provide you with our instance name, then you will turn this variable on for us?

--Thanks
Abhishek

[Tony Tseng]

Hi Abhishek,

You should be able to set global variables. What's the error that you're seeing?

[Abhishek Mathur]

Hi Tony,

When I am trying to set global variable 'lower_case_table_names' , I am getting "Variable 'lower_case_table_names' is a read only variable".

--Abhishek

[Tony Tseng]

It's not a privilege issue. That particular system variable cannot be set dynamically according to http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_lower_case_table_names.

[Abhishek Mathur]

So what could be the solution, given that my local mysql server has
lower_case_table_names variable set to 1, setting this variable
resolved my case sensitivity problem with hibernate locally and I need
same database to be imported to my cloud-sql instance so that same
application could work without giving any case-sensitivity problem on
app-engine with cloud-sql?
The only solution I could think of right now is to somehow get a
cloud-sql instance with 'lower_case_table_names' set to 1.
Please suggest.

--Thanks,
Abhishek

[Timofey Koolin]

You can give your tables names in the correct case?

2011/11/22 Abhishek Mathur <abhi...@moruba.com>

--
Blog: www.rekby.ru

[Tony Tseng]

Hi Abhishek,

Unfortunately cloud sql does not support user-specified startup options at this point.

[Abhishek Mathur]

What if I create a new instance, give its name to you guys to set  just one variable value for me? Is it possible?

-- Abhishek

[Tony Tseng]

Sorry. This feature is not currently supported.

[Sudhakar Raja]

Hi Tony,
Why cannot this be set for all the instances universally? Case
insensitivity will help us in migrating from Oracle (which supports
case insensitivity). This will not affect anyone so why not provide
this to all instances universally. We have to make a lot of changes to
our code just because of this and I am sure there are others who will
face similar issue.

Also I am unable to create logical partitions in the instance. I was
told this was possible but it seems not.

Thanks

On Nov 23, 6:52 am, Tony Tseng <t...@google.com> wrote:
> Sorry. This feature is not currently supported.
>

[Rob Clevenger]

Hi,

Since MySQL defaults to case sensitivity, we use that default.  We're looking at ways of offering the ability to offer some configuration changes on a per instance basis, but it's not something we offer today.

Thanks,

Rob

[Sudhakar Raja]

Hi Rob,
Thanks for your reply.

I have set a deadline for my team that when Google SQL comes out of Preview, we should be on Cloud SQL. I have 2 options
1. Make tons of changes to my code (unnecessary as you are looking for ways to allow us make the changes to the config)
2. You guys make this SMALL change to all  instances which will benefit all today who are testing also. I am sure there are others who are testing who have similar issue. This you can do while you figure out a way solve the problem long term.
3. Don't do any testing, wait for you guys to figure out how to solve this show stopper issue for all of us having this problem.

Also can you please look into partitions and if that is possible in Google C SQL?

Please suggest a direction for us. Sorry for the trouble but I hope you will appreciate the problem we are in as we look to be one of the first adopter of this.

Thanks