syncdb for mysql using engine=NDBCLUSTER

[Phang Mulianto]

Hi,

i try to run syncdb to create table in mysql cluster db, and need have engine=NDBCLUSTER in each table which want to create in the cluster.
How to add the engine=NDBCLUSTER from the syncdb command line ?

Thanks for the help.

Mulianto

[Florian Apolloner]

Hi,

this can be done as documented like for the innodb backend: https://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables

Cheers,
Florian

[Florian Apolloner]

Oh and if you don't want to create all tables in the cluster, just create with the default engine and then switch as needed.

[Phang Mulianto]

Hi Florian,

Thanks for the pointer.. nice and works like a charm..

i will prefer add the options in the settings.py as the table will growing and work for all application table including admin table.

and the next target is figure out about the database router for load balancing the sql query..

is it better to load balance by within the django or handle it using other Layer 4 load balancer ?

thanks

On Mon, Oct 17, 2011 at 12:24 AM, Florian Apolloner <f.apo...@gmail.com> wrote:

Oh and if you don't want to create all tables in the cluster, just create with the default engine and then switch as needed.

--
You received this message because you are subscribed to the Google Groups "Django users" group.

To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/YqWTj0_-_tYJ.

To post to this group, send email to django...@googlegroups.com.
To unsubscribe from this group, send email to django-users...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.